Others titles
- Details on Inpatient Discharges
- Healthcare Discharges in New York State
- Deidentified Patient Detailed Information in Hospital Discharges
Keywords
- Hospital Inpatient Discharges
- New York Hospital Discharges
- Patient Discharges Details
- Healthcare Deidentified Dataset
- New York State Hospital Cost
- Comprehensive All Payer Data NY
- SPARCS Inpatient De-identified Data
- New York Health Information
- New York Hospital Discharges
- Health Insurance Portability
- Ambulatory Surgery Services
Hospital Inpatient Treatment Discharges 2009
This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2009.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The Statewide Planning and Research Cooperative System (SPARCS) is a comprehensive all payer data reporting system established in 1979 as a result of cooperation between the healthcare industry and government. The system was initially created to collect information on discharges from hospitals. SPARCS currently collects patient level detail on patient characteristics, diagnoses and treatments, services and charges for each hospital inpatient stay and outpatient (ambulatory surgery, emergency department, and outpatient services) visit; and each ambulatory surgery and outpatient services visit to a hospital extension clinic and diagnostic and treatment center licensed to provide ambulatory surgery services. SPARCS Inpatient De-identified dataset contains discharge level detail on patient characteristics, diagnoses, treatments, services, charges and costs. This dataset 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.
About this Dataset
Data Info
Date Created | 2013-10-02 |
---|---|
Last Modified | 2016-05-02 |
Version | 2016-05-02 |
Update Frequency |
Annual |
Temporal Coverage |
2009 |
Spatial Coverage |
United States |
Source | John Snow Labs; Data State of New York; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | Hospital Inpatient Discharges, New York Hospital Discharges, Patient Discharges Details, Healthcare Deidentified Dataset, New York State Hospital Cost, Comprehensive All Payer Data NY, SPARCS Inpatient De-identified Data, New York Health Information, New York Hospital Discharges, Health Insurance Portability, Ambulatory Surgery Services |
Other Titles | Details on Inpatient Discharges, Healthcare Discharges in New York State, Deidentified Patient Detailed Information in Hospital Discharges |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Health_Service_Area | Are of New York state where the service was provided | string | - |
County | County where hospital is located | string | - |
Operating_Certificate_Number | Certificate number for operating facility | integer | level : Nominal |
Facility_ID | Number identifier of the facility | integer | level : Nominal |
Facility_Name | Name of the hospital | string | required : 1 |
Age_Group | Age group of the patient | string | required : 1 |
Zip_Code | Three digit ZIP code | integer | level : Nominal |
Gender | Gender of the patient | string | required : 1 |
Race | Race of the patient | string | required : 1 |
Ethnicity | Ethnicity of the patient | string | required : 1 |
Length_Of_Stay | Number of days spent at the hospital. Days include 1-120+. | integer | level : Ratiorequired : 1 |
Admit_Day_Of_Week | Day of the week in which the patient was admitted | string | - |
Type_Of_Admission | Type of admission registered | string | required : 1 |
Patient_Disposition | Health professional in charge of the patient | string | - |
Discharge_Day_Of_Week | Day of the week in which the discharge was operated | string | - |
Diagnosis_Code | Code of the diagnoses | integer | level : Nominal |
Diagnosis_Description | Description of the diagnosis | string | - |
Procedure_Code | Code of the procedure followed | integer | level : Nominal |
Procedure_Description | Description of the followed procedure | string | - |
APR_DRG_Code | All patient refined (APR) diagnosis related group (DRG) code | integer | level : Nominalrequired : 1 |
APR_DRG_Description | All patient refined (APR) diagnosis related group (DRG) description | string | required : 1 |
APR_MDC_Code | All patient refined (APR) major diagnostic category (MDC) code | integer | level : Nominalrequired : 1 |
APR_MDC_Description | All patient refined (APR) major diagnostic category (MDC) description | string | required : 1 |
APR_Severity_Of_Illness_Code | All patient refined (APR) code for the severity of the illness | integer | level : Nominal |
APR_Severity_Of_Illness_Description | All patient refined (APR) code for the severity of the illness | string | - |
APR_Risk_Of_Mortality | All patient refined (APR) risk of mortality | string | - |
APR_Medical_Surgical_Description | All patient refined (APR) medical and surgical description | string | required : 1 |
Payment_Typology_1 | Indicates the source of payment for typology 1 and provides the description of the type of payment for this occurrence. | string | required : 1 |
Payment_Typology_2 | Indicates the source of payment for typology 2 and provides the description of the type of payment for this occurrence. | string | - |
Payment_Typology_3 | Indicates the source of payment for typology 3 and provides the description of the type of payment for this occurrence. | string | - |
Attending_Provider_License_Number | License number of provider attending the discharge | integer | level : Nominal |
Operating_Provider_License_Number | License number of provider operating the discharge | integer | level : Nominal |
Other_Provider_License_Number | Other license numbers of provider operating the discharge | integer | level : Nominal |
Birth_Weight | The neonate birth weight in grams; rounded to nearest 100g. | number | level : Ratio |
Is_Abortion_Edit_Indicator | Indicator of abortion | boolean | required : 1 |
Is_Emergency_Department_Indicator | Indicator of emergency | boolean | required : 1 |
Total_Charges | Total charges of the discharge | number | required : 1 |
Total_Cost | Total costs of the discharge | number | required : 1 |
Data Preview
Health Service Area | County | Operating Certificate Number | Facility ID | Facility Name | Age Group | Zip Code | Gender | Race | Ethnicity | Length Of Stay | Admit Day Of Week | Type Of Admission | Patient Disposition | Discharge Day Of Week | Diagnosis Code | Diagnosis Description | Procedure Code | Procedure Description | APR DRG Code | APR DRG Description | APR MDC Code | APR MDC Description | APR Severity Of Illness Code | APR Severity Of Illness Description | APR Risk Of Mortality | APR Medical Surgical Description | Payment Typology 1 | Payment Typology 2 | Payment Typology 3 | Attending Provider License Number | Operating Provider License Number | Other Provider License Number | Birth Weight | Is Abortion Edit Indicator | Is Emergency Department Indicator | Total Charges | Total Cost |
New York City | Manhattan | 7002054 | 1458 | New York Presbyterian Hospital - New York Weill Cornell Center | 0 to 17 | Male | White | Spanish/Hispanic | 2 | SAT | Newborn | Home or Self Care | MON | 218 | LIVEBORN | 115 | CIRCUMCISION | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 1 | Minor | Minor | Medical | Insurance Company | Self-Pay | 223563 | 236970 | 2700.0 | False | False | 4141.43 | 1685.18 | |||
New York City | Manhattan | 7002054 | 1458 | New York Presbyterian Hospital - New York Weill Cornell Center | 0 to 17 | Male | White | Spanish/Hispanic | 4 | FRI | Emergency | Cancer Center or Children's Hospital | TUE | 131 | ADULT RESPIRTRY FAILURE | 216 | RESP INTUB/MECH VENTIL | 133 | PULMONARY EDEMA & RESPIRATORY FAILURE | 4 | Diseases and Disorders of the Respiratory System | 2 | Moderate | Major | Medical | Insurance Company | Self-Pay | 210388 | 157360 | False | False | 49254.47 | 17394.94 | ||||
New York City | Manhattan | 7002054 | 1464 | New York Presbyterian Hospital - Columbia Presbyterian Center | 0 to 17 | Male | White | Spanish/Hispanic | 2 | WED | Newborn | Home or Self Care | FRI | 218 | LIVEBORN | 220 | OPHTHALM-/OT-OLOGIC DX | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 1 | Minor | Minor | Medical | Blue Cross | Self-Pay | 231804 | 231804 | 3800.0 | False | False | 4049.97 | 1818.44 | |||
Southern Tier | Tompkins | 5401001 | 977 | Cayuga Medical Center at Ithaca | 0 to 17 | Male | White | Unknown | 2 | MON | Newborn | Home or Self Care | WED | 218 | LIVEBORN | 228 | PROPHYLACTIC VAC/INOCUL | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 2 | Moderate | Minor | Medical | Blue Cross | 211165 | 216716 | 3300.0 | False | False | 1410.34 | 1024.48 | ||||
New York City | Bronx | 7000014 | 1176 | St Barnabas Hospital | 0 to 17 | Male | White | Not Span/Hispanic | 3 | THU | Emergency | Home or Self Care | SUN | 83 | EPILEPSY/CONVULSIONS | 4 | DIAGNOSTIC SPINAL TAP | 53 | SEIZURE | 1 | Diseases and Disorders of the Nervous System | 2 | Moderate | Minor | Medical | Self-Pay | 249432 | 249432 | False | True | 13697.82 | 3238.19 | |||||
New York City | Kings | 7001017 | 1302 | SUNY Downstate Medical Center at LICH | 0 to 17 | Male | White | Not Span/Hispanic | 2 | MON | Newborn | Home or Self Care | WED | 218 | LIVEBORN | 216 | RESP INTUB/MECH VENTIL | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 3 | Major | Minor | Medical | Insurance Company | Self-Pay | 212408 | 212408 | 212408.0 | 3900.0 | False | False | 7271.95 | 3856.94 | ||
New York City | Kings | 7001021 | 1306 | New York Methodist Hospital | 0 to 17 | Male | White | Not Span/Hispanic | 3 | FRI | Newborn | Home or Self Care | MON | 218 | LIVEBORN | 220 | OPHTHALM-/OT-OLOGIC DX | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 1 | Minor | Minor | Medical | Blue Cross | Self-Pay | 159197 | 159197 | 2500.0 | False | False | 5316.22 | 1549.99 | |||
New York City | Manhattan | 7002001 | 1438 | Bellevue Hospital Center | 0 to 17 | Male | White | Not Span/Hispanic | 15 | SUN | Emergency | Home or Self Care | MON | 652 | BEHAVIOR DISORDERS | 218 | PSYCHO/PSYCHI EVAL/THER | 758 | CHILDHOOD BEHAVIORAL DISORDERS | 19 | Mental Diseases and Disorders | 2 | Moderate | Minor | Medical | Blue Cross | 206616 | 206616 | False | True | 21830.49 | 16569.69 | |||||
New York City | Manhattan | 7002000 | 1437 | New York Downtown Hospital | 0 to 17 | Male | White | Not Span/Hispanic | 1 | WED | Newborn | Home or Self Care | THU | 218 | LIVEBORN | 115 | CIRCUMCISION | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 1 | Minor | Minor | Medical | Blue Cross | Self-Pay | 189487 | 189487 | 3000.0 | False | False | 1528.03 | 799.7 | |||
New York City | Manhattan | 7002000 | 1437 | New York Downtown Hospital | 0 to 17 | Male | White | Not Span/Hispanic | 2 | WED | Newborn | Home or Self Care | FRI | 218 | LIVEBORN | 115 | CIRCUMCISION | 640 | NEONATE BIRTHWT >2499G, NORMAL NEWBORN OR NEONATE W OTHER PROBLEM | 15 | Newborns and Other Neonates with Conditions Originating in the Perinatal Period | 1 | Minor | Minor | Medical | Insurance Company | Self-Pay | 189487 | 189487 | 3300.0 | False | False | 2144.32 | 1343.06 |