Hospital Inpatient Discharges (SPARCS De-Identified): 2017
health.data.ny.gov | Last Updated 2 Oct 2019The 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.
This dataset has the following 34 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Hospital Service Area | hospital_service_area | text | 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. | New York City Long Island Hudson Valley Capital/Adirond Western NY view top 100 |
| Hospital County | hospital_county | text | A description of the county in which the hospital is located. Blank for abortion records. | Manhattan Kings Queens Nassau Bronx view top 100 |
| Operating Certificate Number | operating_certificate_number | text | The facility Operating Certificate Number as assigned by NYS Department of Health. Blank for abortion records. | 7002054 7000006 7003004 7002053 7002024 view top 100 |
| Permanent Facility Id | permanent_facility_id | text | Permanent Facility Identifier. Blank for abortion records. | 001456 001464 000541 001458 001630 view top 100 |
| Facility Name | facility_name | text | 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. | Mount Sinai Hospital New York Presbyterian Hospital - Columbia Presbyterian Center North Shore University Hospital New York Presbyterian Hospital - New York Weill Cornell Center Long Island Jewish Medical Center view top 100 |
| Age Group | age_group | text | 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. | 70 or Older 50 to 69 30 to 49 0 to 17 18 to 29 view top 100 |
| Zip Code - 3 digits | zip_code_3_digits | text | The first three digits of the patient's zip code. | 112 104 117 100 113 view top 100 |
| Gender | gender | text | Patient gender: (M) Male, (F) Female, (U) Unknown. | F M U view top 100 |
| Race | race | text | Patient race. Black/African American, Multi, Other Race, Unknown, White. Other Race includes Native Americans and Asian/Pacific Islander. | White Other Race Black/African American Multi-racial view top 100 |
| Ethnicity | ethnicity | text | The ethnicity of the patient: Spanish/Hispanic Origin, Not of Spanish/Hispanic Origin, Multi, Unknown. | Not Span/Hispanic Spanish/Hispanic Unknown Multi-ethnic view top 100 |
| Length of Stay | length_of_stay | text | 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. | 2 3 1 4 5 view top 100 |
| Type of Admission | type_of_admission | text | A description of the manner in which the patient was admitted to the health care facility: Elective, Emergency, Newborn, Not Available, Trauma, Urgent. | Emergency Elective Newborn Urgent Trauma view top 100 |
| Patient Disposition | patient_disposition | text | The patient's destination or status upon discharge. | Home or Self Care Home w/ Home Health Services Skilled Nursing Home Left Against Medical Advice Expired view top 100 |
| Discharge Year | discharge_year | text | The year (CCYY) of discharge. | 2017 view top 100 |
| CCS Diagnosis Code | ccs_diagnosis_code | text | AHRQ Clinical Classification Software (CCS) Diagnosis Category Code. | 218 002 099 203 657 view top 100 |
| CCS Diagnosis Description | ccs_diagnosis_description | text | AHRQ Clinical Classification Software (CCS) Diagnosis Category Description | Liveborn Septicemia (except in labor) Hypertension with complications and secondary hypertension Osteoarthritis Mood disorders view top 100 |
| CCS Procedure Code | ccs_procedure_code | text | AHRQ Clinical Classification Software (CCS) ICD-9 Procedure Category Code | 000 137 231 216 134 view top 100 |
| CCS Procedure Description | ccs_procedure_description | text | AHRQ Clinical Classification Software (CCS) ICD-9 Procedure Category Description | NO PROC OT PRCS TO ASSIST DELIV OTHER THERAPEUTIC PRCS RESP INTUB/MECH VENTIL CESAREAN SECTION view top 100 |
| APR DRG Code | apr_drg_code | text | APR-DRG Classification Code | 640 560 720 540 194 view top 100 |
| APR DRG Description | apr_drg_description | text | APR-DRG Classification Code Description in Calendar Year 2017, Version 34 of the APR- DRG Grouper. | Neonate birthwt >2499g, normal newborn or neonate w other problem Vaginal delivery Septicemia & disseminated infections Cesarean delivery Heart failure view top 100 |
| APR MDC Code | apr_mdc_code | text | 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. | 05 14 15 08 04 view top 100 |
| APR MDC Description | apr_mdc_description | text | All Patient Refined Major Diagnostic Category (APR MDC) Description. | Diseases and Disorders of the Circulatory System Pregnancy, Childbirth and the Puerperium Newborns and Other Neonates with Conditions Originating in the Perinatal Period Diseases and Disorders of the Musculoskeletal System and Conn Tissue Diseases and Disorders of the Respiratory System view top 100 |
| APR Severity of Illness Code | apr_severity_of_illness_code | text | APR-DRG Severity of Illness Code: 1, 2, 3, 4 | 2 1 3 4 0 view top 100 |
| APR Severity of Illness Description | apr_severity_of_illness | text | All Patient Refined Severity of Illness (APR SOI) Description: Minor (1), Moderate (2), Major (3), Extreme (4) | Moderate Minor Major Extreme view top 100 |
| APR Risk of Mortality | apr_risk_of_mortality | text | All Patient Refined Risk of Mortality (APR ROM) Description: Minor (1), Moderate (2), Major (3), Extreme (4) | Minor Moderate Major Extreme view top 100 |
| APR Medical Surgical Description | apr_medical_surgical | text | APR-DRG specific classification of Medical, Surgical or Not Applicable | Medical Surgical Not Applicable view top 100 |
| Payment Typology 1 | payment_typology_1 | text | A description of the type of payment for this occurrence. | Medicare Medicaid Private Health Insurance Blue Cross/Blue Shield Self-Pay view top 100 |
| Payment Typology 2 | payment_typology_2 | text | A description of the type of payment for this occurrence. | Medicaid Medicare Self-Pay Private Health Insurance Blue Cross/Blue Shield view top 100 |
| Payment Typology 3 | payment_typology_3 | text | A description of the type of payment for this occurrence. | Self-Pay Medicaid Private Health Insurance Blue Cross/Blue Shield Medicare view top 100 |
| Birth Weight | birth_weight | text | The neonate birth weight in grams; rounded to nearest 100g. | 03200 03300 03400 03100 03500 view top 100 |
| Abortion Edit Indicator | abortion_edit_indicator | text | A flag to indicate if the discharge record contains any indication of abortion ("N" = No; "Y" = Yes) | N Y view top 100 |
| Emergency Department Indicator | emergency_department_indicator | text | 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”. | Y N view top 100 |
| Total Charges | total_charges | number | Total charges for the discharge | 4454.33 4376.42 3278.00 16375.42 9943.36 view top 100 |
| Total Costs | total_costs | number | Total estimated cost for the discharge | 2274.13 1486.20 2630.19 2924.19 1504.92 view top 100 |