health-data-ny-gov/hospital-inpatient-prevention-quality-indicators-vh2s-8wb2
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 year ago
Indexed 6 hours ago

Hospital Inpatient Prevention Quality Indicators (PDI) for Pediatric Discharges by Patient County (SPARCS): Beginning 2009

The dataset contains observed, expected, and risk-adjusted rates for the Agency for Healthcare Research and Quality Pediatric Quality Indicators – Pediatric (AHRQ PDI) beginning in 2009.

The AHRQ PDIs 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. Both the Urinary Tract Infection and Gastroenteritis PDIs include admissions for patients aged 3 months through 17 years. The asthma PDI includes admissions for patients aged 2 through 17 years. Eligible admissions for the Diabetes Short-term Complications PDI includes admissions for patients aged 6 through 17 years.

The rates were calculated using Statewide Planning and Research Cooperative System (SPARCS) inpatient data and Claritas population information.

The observed, expected, risk-adjusted rates, and difference in rates, for each AHRQ PDI are presented by resident county (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-vh2s-8wb2\".\"hospital_inpatient_prevention_quality_indicators\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • hospital_inpatient_prevention_quality_indicators
     
     
     
     
     
Upstream Metadata