All Payer Potentially Preventable Emergency Visit (PPV) Rates by Patient County (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. 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).
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. | 2019 2018 2011 2012 2016 view top 100 |
Software Version | software_version | text | 3M software version used to calculate PPV. | 2.2 1.2 2.02 1.31 1.32 view top 100 |
Patient County Name | patient_county_name | text | The patient’s county of residence at time of discharge. Discharges that did not have an accurate New York State county were excluded. | Jefferson Broome Steuben Columbia New York 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. | 13 18.83 22.88 23.87 24.46 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. | 20.27 20.53 19.34 18.71 18.52 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. | 29.86 30.81 25.28 23.47 23.98 view top 100 |
Difference in Rates | difference_in_rates | number | The difference between the observed and expected rates. | 0 -0.06 -0.85 -0.26 -0.65 view top 100 |