All Payer Potentially Preventable Emergency Visit (PPV) Rates by Patient Zip Code (SPARCS): Beginning 2011

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

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/all-payer-potentially-preventable-emergency-visit-gu5u-nze7\".\"all_payer_potentially_preventable_emergency_visit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.