Hospital Inpatient Discharges (SPARCS De-Identified): 2009
health.data.ny.gov | Last Updated 22 Mar 2018The Statewide Planning and Research Cooperative System (SPARCS) Inpatient De-identified dataset contains discharge level detail on patient characteristics, diagnoses, treatments, services, and charges. This data contains basic record level detail regarding the discharge; however the data does not contain protected health information (PHI) under Health Insurance Portability and Accountability Act (HIPAA). The health information is not individually identifiable; all data elements The Statewide Planning and Research Cooperative System (SPARCS) Inpatient De-identified dataset contains discharge level detail on patient characteristics, diagnoses, treatments, services, charges and costs. This data contains basic record level detail regarding the discharge; however the data does not contain protected health information (PHI) under Health Insurance Portability and Accountability Act (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. | New York City Southern Tier Hudson Valley Finger Lakes Long Island view top 100 |
| Hospital County | hospital_county | text | A description of the county in which the hospital is located. Blank for abortion records. | Manhattan Bronx Kings Westchester Queens 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 7002024 7000006 2951001 5151001 view top 100 |
| Facility ID | facility_id | number | Permanent Facility Identifier. Blank for abortion records. | 541 245 1 630 636 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. | North Shore University Hospital University Hospital Albany Medical Center Hospital St Josephs Hospital Health Center Crouse Hospital 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 | 0 to 17 18 to 29 30 to 49 50 to 69 70 or Older 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. | 100 103 104 105 107 view top 100 |
| Gender | gender | text | Patient gender: (M) Male, (F) Female, (U) Unknown | M F U view top 100 |
| Race | race | text | Patient race. Black/African American, 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. | Spanish/Hispanic Unknown Not Span/Hispanic 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 4 3 15 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. | Newborn Emergency Elective Urgent Not Available view top 100 |
| Patient Disposition | patient_disposition | text | The patient's destination or status upon discharge | Home or Self Care Cancer Center or Children's Hospital Short-term Hospital Home w/ Home Health Services Medicare Cert Long Term Care Hospital view top 100 |
| Discharge Year | discharge_year | text | The year (CCYY) of discharge. | 2009 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 102 101 108 002 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 CHEST PAIN CORONARY ATHEROSCLER CHF SEPTICEMIA 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 | 115 216 220 228 231 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 | CIRCUMCISION RESP INTUB/MECH VENTIL OPHTHALM-/OT-OLOGIC DX PROPHYLACTIC VAC/INOCUL OTHER THERAPEUTIC PRCS view top 100 |
| APR DRG Code | apr_drg_code | text | The APR - DRG Classification Code | 640 560 540 194 140 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 HEART FAILURE CHRONIC OBSTRUCTIVE PULMONARY DISEASE 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. | 15 04 01 19 06 view top 100 |
| APR MDC Description | apr_mdc_description | text | All Patient Refined Major Diagnostic Category (APR MDC) Description . | Newborns and Other Neonates with Conditions Originating in the Perinatal Period Diseases and Disorders of the Respiratory System Diseases and Disorders of the Nervous System Mental Diseases and Disorders Diseases and Disorders of the Digestive 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 | 1 2 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) | Minor Moderate 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 |
| Source of Payment 1 | source_of_payment_1 | text | A description of the type of payment for this occurrence. | Insurance Company Blue Cross Self-Pay Medicaid Other Federal Program view top 100 |
| Source of Payment 2 | source_of_payment_2 | text | A description of the type of payment for this occurrence. | Self-Pay Medicaid CHAMPUS Insurance Company Blue Cross view top 100 |
| Source of Payment 3 | source_of_payment_3 | text | A description of the type of payment for this occurrence. | Self-Pay Medicaid Medicare Insurance Company Blue Cross 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 | 00142987 00211283 00223008 00176106 00184409 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. | 00211283 00131959 00176106 00205608 00246749 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. | 00156880 90000163 00114784 00081732 00239114 view top 100 |
| Birth Weight | birth_weight | number | The neonate birth weight in grams; rounded to nearest 100g. | 2700 0 3800 3300 3900 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 | 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”. | N Y view top 100 |
| Total Charges | total_charges | number | Total charges for the discharge. | 30703.40 19983.10 7065.57 33707.77 view top 100 |
| Total Costs | total_costs | number | Total estimated cost for the discharge. | 9735.07 6118.69 1493.31 11055.54 view top 100 |