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 2011
This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2011.
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 |
2011 |
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 or “Out of State (OOS)” zip codes. | string | - |
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 | required : 1 |
Type_Of_Admission | Type of admission registered | string | required : 1 |
Patient_Disposition | Health professional in charge of the patient | string | required : 1 |
Discharge_Day_Of_Week | Day of the week in which the discharge was operated | string | required : 1 |
Diagnosis_Code | Code of the diagnoses | integer | level : Nominalrequired : 1 |
Diagnosis_Description | Description of the diagnosis | string | required : 1 |
Procedure_Code | Code of the procedure followed | integer | level : Nominalrequired : 1 |
Procedure_Description | Description of the followed procedure | string | required : 1 |
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 : Nominalrequired : 1 |
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 |
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 30 to 49 | 121 | Female | White | Not Span/Hispanic | 1 | FRI | Emergency | Home or Self Care | SAT | 155 | OTHER GI DISORDER | 0 | NO PROC | 254 | OTHER DIGESTIVE SYSTEM DIAGNOSES | 6 | Diseases and Disorders of the Digestive System | 1 | Minor | Minor | Medical | Blue Cross/Blue Shield | Self-Pay | 236885 | False | True | 10081.39 | 2261.3 | ||||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 0 to 17 | 122 | Male | Other Race | Not Span/Hispanic | 2 | FRI | Emergency | Home or Self Care | SUN | 125 | BRONCHITIS | 0 | NO PROC | 138 | BRONCHIOLITIS & RSV PNEUMONIA | 4 | Diseases and Disorders of the Respiratory System | 2 | Moderate | Minor | Medical | Medicaid | Medicaid | Self-Pay | 146395 | False | True | 10948.8 | 3161.65 | |||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 50 to 69 | 123 | Male | White | Not Span/Hispanic | 6 | WED | Elective | Home or Self Care | TUE | 149 | BILIARY TRACT DISEASE | 98 | OT NON-OR GI THER PRCS | 284 | DISORDERS OF GALLBLADDER & BILIARY TRACT | 7 | Diseases and Disorders of the Hepatobiliary System and Pancreas | 2 | Moderate | Minor | Medical | Federal/State/Local/VA | Self-Pay | 236885 | 3676.0 | 227292.0 | False | False | 58626.62 | 20341.09 | ||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 0 to 17 | 121 | Male | White | Not Span/Hispanic | 2 | WED | Elective | Home or Self Care | FRI | 144 | ENTERITIS/ULCER COLITIS | 76 | COLONOSCOPY AND BIOPSY | 245 | INFLAMMATORY BOWEL DISEASE | 6 | Diseases and Disorders of the Digestive System | 1 | Minor | Minor | Medical | Blue Cross/Blue Shield | Self-Pay | 256106 | 147626.0 | 147626.0 | False | False | 10233.42 | 3490.49 | ||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 50 to 69 | 122 | Female | White | Not Span/Hispanic | 1 | THU | Elective | Home or Self Care | FRI | 122 | PNEUMONIA | 37 | DX BRONCHOSCOPY & BIOPS | 137 | MAJOR RESPIRATORY INFECTIONS & INFLAMMATIONS | 4 | Diseases and Disorders of the Respiratory System | 3 | Major | Minor | Medical | Medicare | Blue Cross/Blue Shield | Self-Pay | 170470 | 165946.0 | 165946.0 | False | False | 15223.54 | 3513.53 | |
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 50 to 69 | 120 | Female | White | Not Span/Hispanic | 1 | WED | Urgent | Home or Self Care | THU | 134 | OTHR UPPR RESP DISEASE | 70 | UP GASTRO ENDOSC/BIOPSY | 115 | OTHER EAR, NOSE, MOUTH,THROAT & CRANIAL/FACIAL DIAGNOSES | 3 | Ear, Nose, Mouth, Throat and Craniofacial Diseases and Disorders | 2 | Moderate | Moderate | Medical | Managed Care, Unspecified | Self-Pay | 241363 | 205269.0 | False | False | 8415.39 | 2447.79 | |||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 30 to 49 | 121 | Female | White | Not Span/Hispanic | 4 | MON | Elective | Home w/ Home Health Services | FRI | 99 | HYPERTENSION W/COMPL | 99 | OT OR GI THER PRCS | 447 | OTHER KIDNEY, URINARY TRACT & RELATED PROCEDURES | 11 | Diseases and Disorders of the Kidney and Urinary Tract | 3 | Major | Minor | Surgical | Medicare | Blue Cross/Blue Shield | Self-Pay | 253677 | 236244.0 | 201934.0 | False | False | 41454.17 | 13189.98 | |
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 30 to 49 | 123 | Male | White | Not Span/Hispanic | 2 | TUE | Elective | Home or Self Care | THU | 153 | GI HEMORRHAGE | 76 | COLONOSCOPY AND BIOPSY | 254 | OTHER DIGESTIVE SYSTEM DIAGNOSES | 6 | Diseases and Disorders of the Digestive System | 2 | Moderate | Minor | Medical | Self-Pay | 3623 | 227292.0 | False | False | 9802.42 | 3487.96 | ||||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 50 to 69 | 121 | Female | White | Not Span/Hispanic | 4 | MON | Elective | Home or Self Care | FRI | 4 | MYCOSES | 0 | NO PROC | 531 | FEMALE REPRODUCTIVE SYSTEM INFECTIONS | 13 | Diseases and Disorders of the Female Reproductive System | 2 | Moderate | Minor | Medical | Managed Care, Unspecified | Self-Pay | 236244 | 178580.0 | False | False | 19742.38 | 7335.73 | |||
Capital/Adiron | Albany | 101000 | 1 | Albany Medical Center Hospital | 18 to 29 | 121 | Female | White | Not Span/Hispanic | 14 | MON | Elective | Home or Self Care | MON | 56 | CYSTIC FIBROSIS | 54 | OT VASC CATH; NOT HEART | 131 | CYSTIC FIBROSIS - PULMONARY DISEASE | 4 | Diseases and Disorders of the Respiratory System | 2 | Moderate | Minor | Medical | Medicare | Medicaid | Self-Pay | 244974 | 228282.0 | 165946.0 | False | False | 51922.23 | 22664.35 |