Hospital Compare Inpatient Discharges

**Overview**
This data package contains the New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs from 2009 to 2016.

**Description**
This data package contains the Hospital Inpatient Treatment Discharges was initially created to collect information on discharges from hospitals. Statewide Planning and Research Cooperative System (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. It 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. The 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 hospital. It currently collects outpatient services visit to a hospital extension clinic and diagnostic and treatment center licensed to provide ambulatory surgery services.

**Benefits**
- Useful for medical care and ambulatory surgical services diagnoses services, patients, outpatient services and hospitals. hospital compare inpatient discharges database is available on health.data.ny.gov website in raw form, whereas a john snow labs (jsl) customer gets it in a clean and normalized form ready to use in one place and create his own custom reports. easy to comprehend for the customers who are unfamiliar with the medical terminologies as all abbreviated terms are replaced with full form, unlike hospital compare inpatient discharges original datasets which are full of abbreviations.

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Hospital Inpatient Treatment Discharges 2009](https://www.johnsnowlabs.com/marketplace/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.
- [Hospital Inpatient Treatment Discharges 2010](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2010)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2010.
- [Hospital Inpatient Treatment Discharges 2011](https://www.johnsnowlabs.com/marketplace/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.
- [Hospital Inpatient Treatment Discharges 2012](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2012)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2012.
- [Hospital Inpatient Treatment Discharges 2013](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2013)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2013.
- [Hospital Inpatient Treatment Discharges 2014](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2014)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2014.
- [Hospital Inpatient Treatment Discharges 2015](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2015)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2015.
- [Hospital Inpatient Treatment Discharges 2016](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2016)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges and costs for the year 2016.
- [Hospital Inpatient Treatment Discharges 2017](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2017)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2017.
- [Hospital Inpatient Treatment Discharges 2018](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2018)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2018.
- [Hospital Inpatient Treatment Discharges 2019](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2019)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2019.
- [Hospital Inpatient Treatment Discharges 2020](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2020)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2020.
- [Hospital Inpatient Treatment Discharges 2021](https://www.johnsnowlabs.com/marketplace/hospital-inpatient-treatment-discharges-2021)
- This dataset includes New York State level information on discharge details on patient characteristics, diagnoses, treatments, services, charges, and costs for the year 2021.

**Data Engineering Overview**
**We deliver high-quality data**
- Each dataset goes through 3 levels of quality review
- 2 Manual reviews are done by domain experts
- Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
- Data is normalized into one unified type system
- All dates, unites, codes, currencies look the same
- All null values are normalized to the same value
- All dataset and field names are SQL and Hive compliant
- Data and Metadata
- Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
- Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
- Data Updates
- Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

**Our data is curated and enriched by domain experts**

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:
- Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
- Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
- Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
- The data is always kept up to date – even when the source requires manual effort to get updates
- Support for data subscribers is provided directly by the domain experts who curated the data sets
- Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).