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

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

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 Zipcodepatient_zipcodetextThe patient’s zip code at time of discharge. Discharges that did not have an accurate New York State zip code 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.