Medicaid Potentially Preventable Emergency Visit (PPV) Rates by Zip Code: Beginning 2011

The dataset contains Potentially Preventable Visit (PPV) observed, expected, and risk-adjusted rates for Medicaid beneficiaries by zip code beginning in 2011.

The Potentially Preventable Visits (PPV) obtained from software created by 3M Health Information Systems are emergency visits that may result from a lack of adequate access to care or ambulatory care coordination. These ambulatory sensitive conditions could be reduced or eliminated with adequate patient monitoring and follow up.

The rates were calculated using Medicaid inpatient and outpatient data for the numerator and Medicaid enrollment in the county or zip code for the denominator.

The observed, expected and risk adjusted rates for PPV are presented by either resident county (including a statewide total) or resident zip code (including a statewide total). 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-potentially-preventable-emergency-visit-kwwn-88rp\".\"medicaid_potentially_preventable_emergency_visit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.