Hospital Inpatient Discharges (SPARCS De-Identified): 2016

health.data.ny.gov | Last Updated 15 Nov 2018

The Statewide Planning and Research Cooperative System (SPARCS) Inpatient De-identified File contains discharge level detail on patient characteristics, diagnoses, treatments, services, and charges. This data file contains basic record level detail for the discharge. The de-identified data file does not contain data that is protected health information (PHI) under HIPAA. The health information is not individually identifiable; all data elements considered identifiable have been redacted. For example, the direct identifiers regarding a date have the day and month portion of the date removed.

Tags: sparcs, hospital, discharge, inpatient, charge transparency, consumer resources, id removed

This dataset has the following 38 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Health Service Areahealth_service_areatextType is Char. Length is 15. A description of the Health Service Area (HSA) in which the hospital is located. Blank for abortion records. Capital/Adirondack, Central NY, Finger Lakes, Hudson Valley, Long Island, New York City, Southern Tier, Western NY.
Hospital Countyhospital_countytextType is Char. Length is 11. A description of the county in which the hospital is located. Blank for abortion records.
Operating Certificate Numberoperating_certificate_numbertextType is Char. Length is 8. The facility Operating Certificate Number as assigned by NYS Department of Health. Blank for abortion records.
Facility Idfacility_idnumberType is Num. Length is 6. Permanent Facility Identifier. Blank for abortion records.
Facility Namefacility_nametextType is Char. Length is 70. The name of the facility where services were performed based on the Permanent Facility Identifier (PFI), as maintained by the NYSDOH Division of Health Facility Planning. For abortion records ‘Abortion Record – Facility Name Redacted’ appears.
Age Groupage_grouptextType is Char. Length is 11. Age in years at time of discharge. Grouped into the following age groups: 0 to 17, 18 to 29, 30 to 49, 50 to 69, and 70 or Older.
Zip Code - 3 digitszip_code_3_digitstextType is Char. Length is 3. The first three digits of the patient's zip code. Blank for: - population size less than 20,000 - abortion records, or - cell size less than 10 on population classification strata. “OOS” are Out of State zip codes
GendergendertextType is Char. Length is 1. Patient gender: (M) Male, (F) Female, (U) Unknown.
Raceracetext
EthnicityethnicitytextType is Char. Length is 32. Patient race. Black/African American, Multi, Other Race, Unknown, White. Other Race includes Native Americans and Asian/Pacific Islander.
Length of Staylength_of_staytextType is Char. Length is 5. The total number of patient days at an acute level and/or other than acute care level (excluding leave of absence days) (Discharge Date - Admission Date) + 1. Length of Stay greater than or equal to 120 days has been aggregated to 120+ days.
Type of Admissiontype_of_admissiontextType is Char. Length is 15. A description of the manner in which the patient was admitted to the health care facility: Elective, Emergency, Newborn, Not Available, Trauma, Urgent.
Patient Dispositionpatient_dispositiontextType is Char. Length is 37. The patient's destination or status upon discharge.
Discharge Yeardischarge_yearnumberType is Char. Length is 4. The year (CCYY) of discharge.
CCS Diagnosis Codeccs_diagnosis_codenumberType is Char. Length is 3. AHRQ Clinical Classification Software (CCS) Diagnosis Category Code. More information on the CCS system may be found at the direct link: http://www.hcup-us.ahrq.gov/toolssoftware/ccs/ccs.jsp
CCS Diagnosis Descriptionccs_diagnosis_descriptiontextType is Char. Length is 450. AHRQ Clinical Classification Software (CCS) Diagnosis Category Description. More information on the CCS system may be found at the direct link: http://www.hcup-us.ahrq.gov/toolssoftware/ccs/ccs.jsp
CCS Procedure Codeccs_procedure_codenumberType is Char. Length is 3. AHRQ Clinical Classification Software (CCS) ICD-9 Procedure Category Code. More information on the CCS system may be found at the direct link: http://www.hcup-us.ahrq.gov/toolssoftware/ccs/ccs.jsp
CCS Procedure Descriptionccs_procedure_descriptiontextType is Char. Length is 450. AHRQ Clinical Classification Software (CCS) ICD-9 Procedure Category Description. More information on the CCS system may be found at the direct link: http://www.hcup-us.ahrq.gov/toolssoftware/ccs/ccs.jsp
APR DRG Codeapr_drg_codenumberType is Char. Length is 3. The APR-DRG Classification Code
APR DRG Descriptionapr_drg_descriptiontextType is Char. Length is 89. The APR-DRG Classification Code Description In Calendar Year 2011, Version 28 of the APR-DRG Grouper. http://www.health.ny.gov/statistics/sparcs/sysdoc/appy.htm
APR MDC Codeapr_mdc_codenumberType is Char. Length is 2. All Patient Refined Major Diagnostic Category (APR MDC) Code. APR-DRG Codes 001-006 and 950-956 may group to more than one MDC Code. All other APR DRGs group to one MDC category.
APR MDC Descriptionapr_mdc_descriptiontextType is Char. Length is 200. All Patient Refined Major Diagnostic Category (APR MDC) Description.
APR Severity of Illness Codeapr_severity_of_illness_codenumberType is Char. Length is 1. The APR-DRG Severity of Illness Code: 1, 2, 3, 4
APR Severity of Illness Descriptionapr_severity_of_illness_descriptiontextType is Char. Length is 8. All Patient Refined Severity of Illness (APR SOI) Description. Minor (1), Moderate (2), Major (3) , Extreme (4).
APR Risk of Mortalityapr_risk_of_mortalitytextType is Char. Length is 8. All Patient Refined Risk of Mortality (APR ROM). Minor (1), Moderate (2), Major (3) , Extreme (4).
APR Medical Surgical Descriptionapr_medical_surgical_descriptiontextType is Char. Length is 14. The APR-DRG specific classification of Medical, Surgical or Not Applicable.
Payment Typology 1payment_typology_1textType is Char. Length is 25. A description of the type of payment for this occurrence.
Payment Typology 2payment_typology_2textType is Char. Length is 25. A description of the type of payment for this occurrence.
Payment Typology 3payment_typology_3textType is Char. Length is 25. A description of the type of payment for this occurrence.
Attending Provider License Numberattending_provider_license_numbernumberType is Char. Length is 8. The professional license number, issued by the New York State Department of Education, used to identify the physician or other health care professional primarily responsible for the care of the patient. Blank for abortion records.
Operating Provider License Numberoperating_provider_license_numbernumberType is Char. Length is 8. The professional license number, issued by the New York State Department of Education, used to identify the physician or other health care professional who performed the principal procedure. Blank for abortion records.
Other Provider License Numberother_provider_license_numbernumberType is Char. Length is 8. The professional license number, issued by the New York State Department of Education, used to identify the physician or other health care professional (other than the Attending Physician or Operating Physician) who was involved in the patient's care or treatment (e.g., consulting physician, second operating physician, nurse/midwife). Blank for abortion records.
Birth Weightbirth_weightnumberType is Char. Length is 4. The neonate birth weight in grams; rounded to nearest 100g.
Abortion Edit Indicatorabortion_edit_indicatortextType is Char. Length is 1. A flag to indicate if the discharge record contains any indication of abortion ("N" = No; "Y" = Yes).
Emergency Department Indicatoremergency_department_indicatortextType is Char. Length is 1. The Emergency Department Indicator is set based on the submitted revenue codes. If the record contained an Emergency Department revenue code of 045X, the indicator is set to "Y", otherwise it will be “N”.
Total Chargestotal_chargesnumberTotal charges for the discharge
Total Coststotal_costsnumberTotal estimated costs for the discharge.
Ratio of Total Costs to Total Chargesratio_of_total_costs_to_total_chargesnumber