Hospital Inpatient Discharges (SPARCS De-Identified): 2013
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 | 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. | 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 Facility Identifier , 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 | 70 or Older 30 to 49 50 to 69 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. | 147 148 OOS 140 144 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 Black/African American Other Race 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. | 8 3 2 4 1 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 | Urgent Elective Emergency Newborn Not Available view top 100 |
| Patient Disposition | patient_disposition | text | The patient's destination or status upon discharge. | Hosp Basd Medicare Approved Swing Bed Home or Self Care Short-term Hospital Home w/ Home Health Services Skilled Nursing Home 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 | 002 218 108 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) Liveborn Congestive heart failure; nonhypertensive 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 216 115 222 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 RESP INTUB/MECH VENTIL CIRCUMCISION BLOOD TRANSFUSION view top 100 |
| APR DRG Code | apr_drg_code | text | The APR-DRG Classification Code | 720 560 640 194 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 Vaginal delivery Neonate birthwt >2499g, normal newborn or neonate w other problem Heart failure 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. | 04 03 06 18 05 view top 100 |
| APR MDC Description | apr_mdc_description | text | All Patient Refined Major Diagnostic Category (APR MDC) Description. | Diseases and Disorders of the Respiratory System Ear, Nose, Mouth, Throat and Craniofacial Diseases and Disorders Diseases and Disorders of the Digestive System Infectious and Parasitic Diseases, Systemic or Unspecified Sites Diseases and Disorders of the Circulatory 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 | 3 1 2 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) | Major Minor Moderate 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) | Moderate Minor 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 Blue Cross/Blue Shield Private Health Insurance Self-Pay view top 100 |
| Payment Typology 2 | source_of_payment_2 | text | A description of the type of payment for this occurrence. | Private Health Insurance Self-Pay Medicaid Medicare 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. | Federal/State/Local/VA Self-Pay Medicaid Private Health Insurance Blue Cross/Blue Shield view top 100 |
| Attending Provider License Number | attending_provider_license_numbe | 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 00205417 00252087 00262539 00228341 view top 100 |
| Operating Provider License Number | operating_provider_license_numbe | 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 00167013 00156754 00206113 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 (i.e., consulting physician, second operating physician, nurse/midwife). Blank for abortion records. | 00149887 00215877 00230750 00249885 00237699 view top 100 |
| Birth Weight | birth_weight | text | The neonate birth weight in grams; rounded to nearest 100g. | 0000 2900 3900 2800 3300 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. | 12240.00 29526.00 20987.00 28888.00 12448.00 view top 100 |
| Total Costs | total_costs | number | 2130.27 4569.41 3916.76 4339.55 2271.83 view top 100 |