All Payer Opioid-Related Facility Visits in New York State: Beginning 2010 (SPARCS)

health.data.ny.gov | Last Updated 2 Jan 2018

<b>Note: This dataset is no longer being updated. For continued updates related to this information, please visit: https://www.health.ny.gov/statistics/opioid/#i_one.</b> This dataset is a summary of inpatient discharges and outpatient visit data for opioid-related diagnosis. The data reflects selected diagnosis codes that include a range of poisonings by opiates, opium, heroin, methadone, and other related narcotics. Please refer to the data dictionary in the “About” section for information on the current data available.

Tags: sparcs, opioid, hospital, facility, discharge, visit, inpatient, outpatient, opioid list, community health and chronic disease, consumer resources

This dataset has the following 32 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
YearyearnumberDischarge or Visit Year
Patient County Codepatient_county_codenumberSPARCS Patient County Code
Patient County Namepatient_county_nametextPatient County Code Description
Rural/Urbanrural_urbantextClassification of Urban or Rural County, with state total
PayerpayertextClassification of Payer Type: Medicaid, Medicare, Commercial, Other, or Unknown
ER Opioider_opioidnumberNumber of Emergency Room Visits with Opioid Code
ER Visitser_visitsnumberTotal Number of Emergency Room Visits
ER Rate Per 1000er_rateper1000numberEmergency Room Visits with Opioid Code / Total Number of Emergency Room Visits * 1000
Inpatient ER Opioidip_er_opioidnumberNumber of Inpatient Discharges Admitted through Emergency Room with Opioid Code
Inpatient ER Dischargesip_er_dischargesnumberTotal Number of Inpatient Discharges Admitted through Emergency Room
Inpatient ER Rate Per 1000ip_er_rateper1000numberNumber of Inpatient Discharges Admitted through Emergency Room with Opioid Code / Total Number of Inpatient Discharges Admitted through Emergency Room * 1000
Inpatient Non ER Opioidip_non_er_opioidnumberNumber of Inpatient Discharges Not Admitted through Emergency Room with Opioid Code
Inpatient Non ER Dischargesip_non_er_dischargesnumberTotal Number of Inpatient Discharges Not Admitted through Emergency Room
Inpatient Non ER Rate Per 1000ip_non_er_rateper1000numberNumber of Inpatient Discharges Not Admitted through Emergency Room with Opioid Code / Total Number of Inpatient Discharges Not Admitted through Emergency Room * 1000
Inpatient Total Opioidip_total_opioidnumberTotal Inpatient Discharges with Opioid Code (Sum of Through Emergency Room and Not Through Emergency Room)
Inpatient Total Dischargesip_total_dischargesnumberTotal Inpatient Discharges (Sum of Through Emergency Room and Not Through Emergency Room)
Inpatient Total Rate Per 1000ip_total_rateper1000numberTotal Inpatient Discharges with Opioid Code / Total Inpatient Discharges * 1000
ER Inpatient Total Opioider_ip_total_opioidnumberTotal Emergency Room and Total Inpatient Discharges with Opioid Code
ER Inpatient Total Dischargeser_ip_total_dischargesnumberTotal Emergency Room and Total Inpatient Discharges
ER Inpatient Total Rate Per 1000er_ip_total_rateper1000numberTotal Emergency Room and Total Inpatient Discharges with Opioid Code / Total Emergency Room and Total Inpatient Discharges * 1000
Opioid Ambulatory Surgery Visitsas_opioidnumberTotal Ambulatory Surgery Visits with Opioid Code
Ambulatory Surgery Visitsas_visitsnumberTotal Ambulatory Surgery Visits
Ambulatory Surgery Rate Per 1000as_rateper1000numberTotal Ambulatory Surgery Visits with Opioid Code / Total Ambulatory Surgery Visits * 1000
Outpatient Opioidos_opioidnumberAll Other Outpatient with Opioid Code
Outpatient Visitsos_visitsnumberTotal All Other Outpatient
Outpatient Rate Per 1000os_rateper1000numberAll Other Outpatient with Opioid Code / Total All Other Outpatient * 1000
Other Outpatient Total Opioidop_total_opioidnumberAmbulatory Surgery Opioid Visits + Outpatient Opioid Visits
Other Outpatient Total Dischargesop_total_visitsnumberAmbulatory Surgery Visits + Outpatient Visits
Other Outpatient Total Rate Per 1000op_total_rate_per1000number(Ambulatory Surgery Opioid Visits + Outpatient Opioid Visits) / (Ambulatory Surgery Visits + Outpatient Visits ) * 1000
Overall Opioidoverall_opioidnumberGrand Total All Opioid Visits (Emergency Room + Inpatient + Ambulatory Surgery + Outpatient)
Overall Dischargesoveralldischarges_ratesnumberGrand Total SPARCS Discharges or Visits
Overall Rate Per 1000overall_rateper1000numberGrand Total Opioid Visits / Grand Total Discharges or Visits * 1000