Medicaid Inpatient Prevention Quality Indicator (PQI) Newborn Low Birth Weight Rates by County: Beginning 2012
The dataset contains the number of Medicaid Low Birth Weight newborns (numerator), the number of county 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 county (including a statewide total). The observed rate for low birth weight by resident zip code (including a statewide total) can be found here: https://health.data.ny.gov/Health/Medicaid-Inpatient-Prevention-Quality-Indicators-P/vk5f-rgqm/. 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-aapx-etcg\".\"medicaid_inpatient_prevention_quality_indicator\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.