Medicaid Inpatient Prevention Quality Indicator (PQI) Newborn Low Birth Weight Rate by Patient Zip Code: Beginning 2012

The dataset contains the number of Medicaid Low Birth Weight newborns (numerator), the number of zip code Medicaid newborns (denominator), and observed rate for Agency for Healthcare Research and Quality Prevention Quality Indicator 9 (PQI 9) – Newborn Low Birth Weight Rate for Medicaid enrollees beginning in 2012.

The 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.

The observed rate for Low Birth Weight is presented by resident zip code (including a statewide

total). The observed rate for low birth weight by resident county: code (including a statewide total) can be found here: https://health.data.ny.gov/Health/Medicaid-Inpatient-Prevention-Quality-Indicators-P/aapx-etcg. For more information, check out: http://www.health.ny.gov/health_care/medicaid/. The "About" tab contains additional details concerning this dataset.

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/medicaid-inpatient-prevention-quality-indicator-vk5f-rgqm\".\"medicaid_inpatient_prevention_quality_indicator\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.