Potentially Preventable Emergency Visit Rates by New York Patient County, 2011 Onward

Potentially Preventable Visit (PPV) rates for New York emergency departments, calculated using 3M Health Information Systems software and SPARCS data. The dataset includes observed, expected, and risk-adjusted rates per 100 people, broken down by patient county and zip code from 2011 onward. Rates were derived from Statewide Planning and Research Cooperative System (SPARCS) inpatient and outpatient records combined with Claritas population data.

Use Cases

• Analyze geographic disparities in healthcare access by comparing Observed Rate Per 100 People and Expected Rate Per 100 People across different Patient County Name values.
• Model trends in preventable emergency care over time using Discharge Year and Risk Adjusted Rate Per 100 People.
• Identify counties with significant gaps in ambulatory care coordination by calculating the Difference in Rates between observed and expected PPV metrics.
• Assess the impact of software methodology changes on reported rates by filtering records based on the Software Version column.

Strengths

• Provides three standardized rate calculations (Observed, Expected, Risk Adjusted) for consistent comparison.
• Offers geographic granularity at both county and zip code levels for spatial analysis.
• Contains data spanning multiple years, beginning in 2011, enabling longitudinal study.
• Rates are calculated using a recognized methodology from 3M Health Information Systems and official SPARCS data.

Limitations

• Row count is unknown, which may limit suitability assessment for large-scale modeling.
• Description metadata is limited; actual data quality and completeness require manual inspection after download.

Provenance

Source

health.data.ny.gov, using data from the Statewide Planning and Research Cooperative System (SPARCS).

Collection Method

Rates calculated from SPARCS inpatient/outpatient data and Claritas population information using 3M Health Information Systems software.

Time Range

Beginning 2011.

Freshness

Last updated 2026-02-11 19:56:14; freshness should be verified.

Geography

New York State, by patient county and zip code.