All Payer Potentially Preventable Emergency Visit (PPV) Rates by Patient County (SPARCS): Beginning 2011 | Last Updated 2 Jun 2023

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

Tags: quality-safety-costs, strategic initiatives, sparcs, dsrip, ppv, potentially preventable visits, efficiency, all payer, outpatient, emergency

This dataset has the following 7 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Discharge Yeardischarge_yearnumberThe year of both the PPV discharge and the county population used in calculation of rates.
Software Versionsoftware_versiontext3M software version used to calculate PPV.
Patient County Namepatient_county_nametextThe patient’s county of residence at time of discharge. Discharges that did not have an accurate New York State county were excluded.
Observed Rate Per 100 Peopleobserved_rate_per_100numberThe number of PPV discharges in the county divided by the county population, multiplied by 100.
Expected Rate Per 100 Peopleexpected_rate_per_100numberThe expected number of PPV discharges in the county, adjusted by age, gender and race/ethnicity divided by the county population, multiplied by 100.
Risk Adjusted Rate Per 100 Peopleadjusted_rate_per_100numberThe observed PPV rate divided by the expected PPV rate, multiplied by the statewide PPV rate.
Difference in Ratesdifference_in_ratesnumberThe difference between the observed and expected rates.