Medicaid Potentially Preventable Emergency Visit (PPV) Rates by Patient County: Beginning 2011

The dataset contains Potentially Preventable Visit (PPV) observed, expected, and risk-adjusted rates for Medicaid beneficiaries by patient county 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.

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-cr7a-34ka\".\"medicaid_potentially_preventable_emergency_visit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.