Hospital Inpatient Discharges (SPARCS De-Identified): 2015
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 | Type 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. | New York City Long Island Hudson Valley Capital/Adirond Western NY view top 100 |
| Hospital County | hospital_county | text | Type is Char. Length is 11. A description of the county in which the hospital is located. Blank for abortion records. | Manhattan Kings Queens Bronx Nassau view top 100 |
| Operating Certificate Number | operating_certificate_number | text | Type is Char. Length is 8. 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 | permanent_facility_id | number | Type is Num. Length is 6. Permanent Facility Identifier. Blank for abortion records. | 1456 541 1464 1458 1169 view top 100 |
| Facility Name | facility_name | text | Type 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. | Mount Sinai Hospital North Shore University Hospital New York Presbyterian Hospital - Columbia Presbyterian Center New York Presbyterian Hospital - New York Weill Cornell Center Montefiore Medical Center - Henry & Lucy Moses Div view top 100 |
| Age Group | age_group | text | Type 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. | 50 to 69 70 or Older 30 to 49 0 to 17 18 to 29 view top 100 |
| Zip Code - 3 digits | zip_code_3_digits | text | Type 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. | 112 104 117 100 113 view top 100 |
| Gender | gender | text | Type is Char. Length is 1. Patient gender: (M) Male, (F) Female, (U) Unknown. | F M U view top 100 |
| Race | race | text | Type is Char. Length is 32. 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 | Type is Char. Length is 20. Patient ethnicity. 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 | Type 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. | 2 3 1 4 5 view top 100 |
| Type of Admission | type_of_admission | text | Type 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. | Emergency Elective Newborn Urgent Trauma view top 100 |
| Patient Disposition | patient_disposition | text | Type is Char. Length is 37. 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 | number | Type is Char. Length is 4. The year (CCYY) of discharge. | 2015 view top 100 |
| CCS Diagnosis Code | ccs_diagnosis_code | number | Type 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 | 218 2 203 108 657 view top 100 |
| CCS Diagnosis Description | ccs_diagnosis_description | text | Type 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 | Liveborn Septicemia (except in labor) Osteoarthritis Congestive heart failure; nonhypertensive Mood disorders view top 100 |
| CCS Procedure Code | ccs_procedure_code | number | Type 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 | 0 231 137 228 134 view top 100 |
| CCS Procedure Description | ccs_procedure_description | text | Type 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 | NO PROC OTHER THERAPEUTIC PRCS OT PRCS TO ASSIST DELIV PROPHYLACTIC VAC/INOCUL CESAREAN SECTION view top 100 |
| APR DRG Code | apr_drg_code | number | Type is Char. Length is 3. The APR-DRG Classification Code | 640 560 720 540 194 view top 100 |
| APR DRG Description | apr_drg_description | text | Type 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 | 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 | number | Type 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. | 5 14 15 8 6 view top 100 |
| APR MDC Description | apr_mdc_description | text | Type is Char. Length is 200. 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 Digestive System view top 100 |
| APR Severity of Illness Code | apr_severity_of_illness_code | number | Type is Char. Length is 1. 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_description | text | Type is Char. Length is 8. 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 | Type is Char. Length is 8. 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 | Type is Char. Length is 14. The APR-DRG specific classification of Medical, Surgical or Not Applicable. | Medical Surgical Not Applicable view top 100 |
| Payment Typology 1 | payment_typology_1 | text | Type is Char. Length is 25. 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 | Type is Char. Length is 25. 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 | payment_typology_3 | text | Type is Char. Length is 25. 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 | number | Type is Char. Length is 4. The neonate birth weight in grams; rounded to nearest 100g. | 0 3300 3200 3400 3100 view top 100 |
| Abortion Edit Indicator | abortion_edit_indicator | text | Type is Char. Length is 1. 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 | Type 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”. | Y N view top 100 |
| Total Charges | total_charges | number | Total charges for the discharge. | 9973.90 8375.20 4285.44 4376.42 10575.90 view top 100 |
| Total Costs | total_costs | number | Total estimated costs for the discharge. | 884.38 2279.63 2102.45 2279.25 975.86 view top 100 |