Hospital Inpatient Discharges (SPARCS De-Identified): 2013
health.data.ny.gov | Last Updated 13 Sep 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 |
|---|---|---|---|---|
| Health 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 Western NY Capital/Adirond 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 7002024 7003004 1401014 view top 100 |
| Facility ID | facility_id | number | Permanent Facility Identifier. Blank for abortion records. | 1456 541 1464 1458 1305 view top 100 |
| Facility Name | facility_name | text | The name of the facility where services were performed based on the Facility Identifier , as maintained by the NYSDOH Division of Health Facility Planning. For abortion records ‘Abortion Record – Facility Name Redacted’ appears. | Mount Sinai Hospital North Shore University Hospital New York Presbyterian Hospital - Columbia Presbyterian Center New York Presbyterian Hospital - New York Weill Cornell Center Maimonides 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. 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. | 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 Unknown view top 100 |
| Ethnicity | ethnicity | text | Patient ethnicity. The ethnicity of the patient: Spanish/Hispanic Origin, Not of Spanish/Hispanic Origin, Multi, Unknown. | Not Span/Hispanic Spanish/Hispanic Unknown 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. Length of Stay greater than or equal to 120 days has been aggregated to 120+ days. | 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 Expired Left Against Medical Advice view top 100 |
| Discharge Year | discharge_year | text | The year (CCYY) of discharge. | 2013 view top 100 |
| CCS Diagnosis Code | ccs_diagnosis_code | text | 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 | 218 002 657 108 203 view top 100 |
| CCS Diagnosis Description | ccs_diagnosis_description | text | 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 | Liveborn Septicemia (except in labor) Mood disorders Congestive heart failure; nonhypertensive Osteoarthritis view top 100 |
| CCS Procedure Code | ccs_procedure_code | text | 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 | 000 231 228 134 137 view top 100 |
| CCS Procedure Description | ccs_procedure_description | text | 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 | NO PROC OTHER THERAPEUTIC PRCS PROPHYLACTIC VAC/INOCUL CESAREAN SECTION OT PRCS TO ASSIST DELIV view top 100 |
| APR DRG Code | apr_drg_code | text | The APR-DRG Classification Code | 640 560 540 720 194 view top 100 |
| APR DRG Description | apr_drg_description | text | 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 | Neonate birthwt >2499g, normal newborn or neonate w other problem Vaginal delivery Cesarean delivery Septicemia & disseminated infections 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 06 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 Digestive System Diseases and Disorders of the Respiratory System view top 100 |
| APR Severity of Illness Code | apr_severity_of_illness_code | text | The 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_descript | 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). Minor (1), Moderate (2), Major (3) , Extreme (4) | Minor Moderate Major Extreme view top 100 |
| APR Medical Surgical Description | apr_medical_surgical_description | text | The APR-DRG specific classification of Medical, Surgical or Not Applicable. | Medical Surgical Not Applicable view top 100 |
| Payment Typology 1 | source_of_payment_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 | source_of_payment_2 | text | A description of the type of payment for this occurrence. | Medicaid Self-Pay Medicare Private Health Insurance Blue Cross/Blue Shield view top 100 |
| Payment Typology 3 | source_of_payment_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. | 0000 3200 3300 3400 3100 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 | 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”. | Y N view top 100 |
| Total Charges | total_charges | number | Total charges for the discharge. | 4825.00 8189.94 3707.20 4285.44 1905.44 view top 100 |
| Total Costs | total_costs | number | Type is Char. Length is 12. Total estimated costs for the discharge. | 751.38 718.10 1017.56 2102.45 934.81 view top 100 |