All Payer Potentially Preventable Emergency Visit (PPV) Rates by Patient Zip Code (SPARCS): Beginning 2011
health.data.ny.gov | Last Updated 2 Jun 2023The 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.
This dataset has the following 7 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Discharge Year | discharge_year | number | The year of both the PPV discharge and the county population used in calculation of rates. | 2013 2011 2014 2012 2020 view top 100 |
Software Version | software_version | text | 3M software version used to calculate PPV. | 2.2 1.2 1.31 2.02 1.32 view top 100 |
Patient Zipcode | patient_zipcode | text | The patient’s zip code at time of discharge. Discharges that did not have an accurate New York State zip code were excluded. | 12819 11518 12190 13655 14850 view top 100 |
Observed Rate Per 100 People | observed_rate_per_100 | number | The number of PPV discharges in the county divided by the county population, multiplied by 100. | 14.81 11.34 13.71 15.28 16.25 view top 100 |
Expected Rate Per 100 People | expected_rate_per_100 | number | The expected number of PPV discharges in the county, adjusted by age, gender and race/ethnicity divided by the county population, multiplied by 100. | 17.2 17.43 17.36 17.15 17.34 view top 100 |
Risk Adjusted Rate Per 100 People | adjusted_rate_per_100 | number | The observed PPV rate divided by the expected PPV rate, multiplied by the statewide PPV rate. | 21.46 20.15 16.87 25.13 19.14 view top 100 |
Difference in Rates | difference_in_rates | number | The difference between the observed and expected rates. | 0 -5.52 -4.66 -7.18 -6 view top 100 |