Prevention Quality Indicator (PQI) Composite Measure Rates by County, 2008-2015

Rate per 100,000; rates are adjusted for age and sex.

PQI measures are used to monitor performance over time or across regions and populations using patient data found in a typical hospital discharge abstract. PQI measures can be used to summarize quality across multiple indicators, improve ability to detect differences, identify important domains and drivers of quality, prioritize action for quality improvement, make current decisions about future and unknown health care needs.

Overall Composite (PQI #90) is comprised of: all PQI measures within the Chronic and Acute Composites.

Chronic Composite (PQI #92) is comprised of: PQI #01 Diabetes Short-Term Complications Admission Rate, PQI #03 Diabetes Long-Term Complications Admission Rate, PQI #05 Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults Admission Rate, PQI #07 Hypertension Admission Rate, PQI #08 Congestive Heart Failure (CHF) Admission Rate, PQI #13 Angina without Procedure Admission Rate, PQI #14 Uncontrolled Diabetes Admission Rate, PQI #15 Asthma in Younger Adults Admission Rate, PQI #16 Rate of Lower-Extremity Amputation Among Patients With Diabetes,

Acute Composite (PQI #91) is comprised of: PQI #10 Dehydration Admission Rate, PQI #11 Bacterial Pneumonia Admission Rate, and PQI #12 Urinary Tract Infection Admission Rate.

NOTE: PQI Version Change in 2012. Previous numbers for 2012 have been overwritten. Trends may not be accurate between 2011 and 2012.

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 \"opendata-maryland-gov/prevention-quality-indicator-pqi-composite-measure-8i54-c2wb\".\"prevention_quality_indicator_pqi_composite_measure\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.