health-data-ny-gov/all-payer-potentially-preventable-emergency-visit-f8ue-xzy3
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 10 months ago
Indexed 1 month ago

All Payer Potentially Preventable Emergency Visit (PPV) Rates by Patient County (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.

The rates were calculated using Statewide Planning and Research Cooperative System (SPARCS) inpatient and outpatient data and Claritas population information.

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

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-f8ue-xzy3\".\"all_payer_potentially_preventable_emergency_visit\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • all_payer_potentially_preventable_emergency_visit
     
     
     
     
     
Upstream Metadata