Hospital Inpatient Discharges (SPARCS De-Identified): 2014
health.data.ny.gov | Last Updated 7 Jun 2018The 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 37 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Health Service Area | health_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. | Western NY Capital/Adiron Finger Lakes Central NY Southern Tier view top 100 |
| Hospital County | hospital_county | text | A description of the county in which the hospital is located. Blank for abortion records. | Cattaraugus Chautauqua Erie Niagara Albany 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. | 1401014 7000001 7000006 7001016 7001019 view top 100 |
| Facility ID | facility_id | number | Permanent Facility Identifier. Blank for abortion records. | 1169 1304 1305 1306 1438 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. | Montefiore Medical Center - Henry & Lucy Moses Div NYU Lutheran Medical Center Maimonides Medical Center NewYork-Presbyterian Brooklyn Methodist Hospital Bellevue Hospital 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. | 30 to 49 50 to 69 18 to 29 70 or Older 0 to 17 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. | 147 148 140 141 142 view top 100 |
| Gender | gender | text | Patient gender: (M) Male, (F) Female, (U) Unknown. | F M U view top 100 |
| Race | race | text | Black/African American, Multi, Other Race, Unknown, White. Other Race includes Native Americans and Asian/Pacific Islander. | White Black/African American Other Race Multi-racial 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 Unknown Spanish/Hispanic 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. Length of Stay greater than or equal to 120 days has been aggregated to 120+ days. | 8 3 1 5 4 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. | Elective Urgent Emergency Newborn Not Available view top 100 |
| Patient Disposition | patient_disposition | text | The patient's destination or status upon discharge. | Home or Self Care Short-term Hospital Skilled Nursing Home Hosp Basd Medicare Approved Swing Bed Home w/ Home Health Services view top 100 |
| Discharge Year | discharge_year | text | The year (CCYY) of discharge. | 2014 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 | 002 108 218 657 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 | Septicemia (except in labor) Congestive heart failure; nonhypertensive Liveborn Mood disorders 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 134 228 137 115 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 CESAREAN SECTION PROPHYLACTIC VAC/INOCUL OT PRCS TO ASSIST DELIV CIRCUMCISION view top 100 |
| APR DRG Code | apr_drg_code | text | The APR-DRG Classification Code | 720 194 640 560 540 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 | Septicemia & disseminated infections Heart failure Neonate birthwt >2499g, normal newborn or neonate w other problem Vaginal delivery Cesarean delivery 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. | 09 06 10 03 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 Skin, Subcutaneous Tissue and Breast Diseases and Disorders of the Digestive System Endocrine, Nutritional and Metabolic Diseases and Disorders Ear, Nose, Mouth, Throat and Craniofacial Diseases and Disorders 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_description | 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 Major Moderate 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. | Self-Pay Blue Cross/Blue Shield Medicare Medicaid Federal/State/Local/VA view top 100 |
| Payment Typology 2 | source_of_payment_2 | text | A description of the type of payment for this occurrence. | Medicaid Blue Cross/Blue Shield Private Health Insurance Medicare Federal/State/Local/VA view top 100 |
| Payment Typology 3 | source_of_payment_3 | text | A description of the type of payment for this occurrence. | Private Health Insurance Medicaid Self-Pay Medicare Blue Cross/Blue Shield view top 100 |
| Attending Provider License Number | attending_provider_license_number | text | 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. | 00241612 00261548 00262539 00269291 00215921 view top 100 |
| Operating Provider License Number | operating_provider_license_number | text | 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. | 00256522 00209036 00155210 00251497 00167013 view top 100 |
| Other Provider License Number | other_provider_license_number | text | 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. | 00145418 00181309 00157138 00221604 00249885 view top 100 |
| Birth Weight | birth_weight | text | The neonate birth weight in grams; rounded to nearest 100g. | 0000 3000 3200 2900 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. | 10074.00 21252.00 11673.00 16722.00 11637.00 view top 100 |
| Total Costs | total_costs | number | Total estimated costs for the discharge. | 1607.85 3005.89 2089.97 2054.79 1990.53 view top 100 |