Hospital Inpatient Discharges (SPARCS De-Identified): 2012

health.data.ny.gov | Last Updated 14 Jul 2017

The Statewide Planning and Research Cooperative System (SPARCS) Inpatient De-Identified dataset contains discharge level detail on patient characteristics, diagnoses, treatments, services, and charges. This data contains basic record level detail regarding the discharge; however, the data does not contain protected health information (PHI) under Health Insurance Portability and Accountability Act (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, quality, id removed

This dataset has the following 37 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Health Service Areahospital_service_areatextA 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_countytextA description of the county in which the hospital is located. Blank for abortion records.
Operating Certificate Numberoperating_certificate_numbertextThe facility Operating Certificate Number as assigned by NYS Department of Health. Blank for abortion records.
Facility IDfacility_idnumberPermanent Facility Identifier. Blank for abortion records.
Facility Namefacility_nametextThe 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_grouptextAge 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.
GendergendertextPatient gender: (M) Male, (F) Female, (U) Unknown
RaceracetextPatient race. Black/African American, Multi, Other Race, Unknown, White. Other Race includes Native Americans and Asian/Pacific Islander.
EthnicityethnicitytextPatient ethnicity. The ethnicity of the patient: Spanish/Hispanic Origin, Not of Spanish/Hispanic Origin, Multi, Unknown.
Length of Staylength_of_staytextThe 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_admissiontextA description of the manner in which the patient was admitted to the health care facility: Elective, Emergency, Newborn, Not Available, Trauma, Urgent.
Patient Dispositionpatient_dispositiontextThe patient's destination or status upon discharge.
Discharge Yeardischarge_yeartextThe year (CCYY) of discharge.
CCS Diagnosis Codeccs_diagnosis_codetextAHRQ 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_descriptiontextAHRQ 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_codetextAHRQ 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_descriptiontextAHRQ 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_codetextThe APR - DRG Classification Code
APR DRG Descriptionapr_drg_descriptiontextThe 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_codetextAll 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_descriptiontextAll Patient Refined Major Diagnostic Category (APR MDC) Description.
APR Severity of Illness Codeapr_severity_of_illness_codetextThe APR-DRG Severity of Illness Code: 1, 2, 3, 4
APR Severity of Illness Descriptionapr_severity_of_illness_descriptiontextAll Patient Refined Severity of Illness (APR SOI) Description. Minor (1), Moderate (2), Major (3) , Extreme (4).
APR Risk of Mortalityapr_risk_of_mortalitytextAll Patient Refined Risk of Mortality (APR ROM). Minor (1), Moderate (2), Major (3) , Extreme (4).
APR Medical Surgical Descriptionapr_medical_surgical_descriptiontextThe APR-DRG specific classification of Medical, Surgical or Not Applicable.
Payment Typology 1source_of_payment_1textA description of the type of payment for this occurrence.
Payment Typology 2source_of_payment_2textA description of the type of payment for this occurrence.
Payment Typology 3source_of_payment_3textA description of the type of payment for this occurrence.
Attending Provider License Numberattending_provider_license_numbertextThe 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_numbertextThe 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_numbertextThe 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_weighttextThe neonate birth weight in grams; rounded to nearest 100g.
Abortion Edit Indicatorabortion_edit_indicatortextA flag to indicate if the discharge record contains any indication of abortion ("N" = No; "Y" = Yes).
Emergency Department Indicatoremergency_department_indicatortextThe 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_chargesmoneyTotal charges for the discharge.
Total Coststotal_costsmoneyTotal estimated costs for the discharge.