Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Beginning 2009

Name: Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Beginning 2009
Creator: New York State Department of Health
Published: 2014-04-14T14:11:31

This dataset is one of two datasets that contain observed and expected rates for Agency for Healthcare Research and Quality Prevention Quality Indicators – Adult (AHRQ PQI) beginning in 2009. The observed rates and expected rates for each AHRQ PQI is presented by either resident county (including a statewide total) or resident zip code (including a statewide total).

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"health-data-ny-gov/hospital-inpatient-prevention-quality-indicators-5q8c-d6xq\".\"hospital_inpatient_prevention_quality_indicators\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

Preview

hospital_inpatient_prevention_quality_indicators

Left sidebar is currently unimplemented

Right sidebar is currently unimplemented

Upstream Metadata

NotesNotesThe Agency for Healthcare Research and Quality (AHRQ) Prevention Quality Indicators (PQIs) are a set of population based measures that can be used with hospital inpatient discharge data to identify ambulatory care sensitive conditions. These are conditions where 1) the need for hospitalization is potentially preventable with appropriate outpatient care, or 2) conditions that could be less severe if treated early and appropriately. All PQIs apply only to adult populations (over the age of 18 years). The rates were calculated using Statewide Planning and Research Cooperative System (SPARCS) inpatient data and Claritas population information. To calculate rates, New York State county or zip code population was used in the denominator. Rates were adjusted using age group, gender and race/ethnicity.

DisclaimersLimitationsHospital discharges that did not have an accurate New York State zip code were excluded from the zip code analysis dataset. Hospital discharges that did not have an accurate New York State county were excluded from the county analysis dataset. Due to this nuance, the statewide rates differ slightly between the zip code and county datasets.

Dataset SummaryUnitsPQI Measure / Discharges CoverageStatewideGranularityZip CodeTime PeriodRates are based on hospital inpatient discharges and county or zip code population for each calendar year starting with 2009.OrganizationNew York State Department of HealthDataset OwnerBureau of Health Care AnalyticsData FrequencyMonthly Office/DivisionCenter for Applied Research and EvaluationPosting FrequencyYearly

Dataset InformationAgencyHealth, Department of

Additional ResourcesSee Alsohttp://www.qualityindicators.ahrq.gov/Modules/pqi_resources.aspx

About

Hospital Inpatient Prevention Quality Indicators (PQI) for Adult Discharges by Zip Code (SPARCS): Beginning 2009

1 year ago (updated)

11 months ago (indexed)

Topics