Medicare Provider Utilization and Payment Data

**Overview**
Information on utilization and payment data for Home health agency, Hospice, skilled nursing facitlity. Information on Inpatient Prospective Payment System (IPPS) payments, Inpatient Rehabilitation Facilities (IRFs)

**Description**
Information on Home Health Agency and Hospice providers Utilization and Payment data, Inpatient Prospective Payment System (IPPS) payments for the most frequently billed discharges, paid under Medicare based on a rate per discharge using the Medicare Severity Diagnosis Related Group (MS-DRG), list of inpatient rehabilitation facilities with data on the number of times people with Medicare who had certain medical conditions were treated in the last year. General information on the Inpatient Rehabilitation Facilities (IRFs) and information about the Inpatient Rehabilitation Facilities (IRFs) Prospective Payment System (PPS) Rate Settings and data regarding different measure codes and their corresponding scores for majority of the IRFs. Data on the spending and utilization data in the Home Health Agency PUF are aggregated to the identification number for the agency, the Home Health Resource Group (HHRG) and by state. Inforamation on the annual most frequent hospice diagnoses, the number of patients, and average length of stay. The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs. The Skilled Nursing Facility Public Use File contains information on utilization, payment (allowed amount, Medicare payment and standard payment), submitted charges, and beneficiary demographic and chronic condition indicators organized by Centres for Medicare and Medicaid Services Certification Number (6-digit provider identification number), Resource Utilization Group (RUG), and state of service.

**Benefits**
- Useful to researchers and analysts who seek to compare, understand and find useful information about the geographical variations of medicare costs and financing, utilization and beneficiaries by type of healthcare provider.
- provides to public health specialists and specialized institutions a complete view, for different categories of healthcare providers, on the supply and costs of healtcare services, covered by medicare. the fields descriptions along with the dataset description are again useful for user to quick understand the data and the dataset.

**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**
- [HCRIS Hospice Cost Report 1999-2014](https://www.johnsnowlabs.com/marketplace/hcris-hospice-cost-report-1999-2014)
- This dataset Healthcare Cost Report Information System (HCRIS) contains cost and statistical data for free-standing Hospice providers. The dataset includes only the most precise version of each cost report from 1999 to 2014.
- [HCRIS Hospice Cost Report 1999-2022](https://www.johnsnowlabs.com/marketplace/hcris-hospice-cost-report-1999-2022)
- This dataset Healthcare Cost Report Information System (HCRIS) contains cost and statistical data for free-standing Hospice providers. The dataset includes only the most precise version of each cost report from 1999 to 2022.
- [Home Health Agency Utilization and Payment Data 2013](https://www.johnsnowlabs.com/marketplace/home-health-agency-utilization-and-payment-data-2013)
- The Home Health Agency Utilization and Payment data 2013 presents information on services provided to Medicare beneficiaries by home health agencies. The Home Health Agency PUF includes data for providers that had a valid identification number and submitted a Medicare Part A institutional claim during the 2013 calendar year. To protect the privacy of Medicare beneficiaries, any aggregated records which are derived from 10 or fewer beneficiaries are excluded.
- [Home Health Agency Utilization and Payment Data 2014](https://www.johnsnowlabs.com/marketplace/home-health-agency-utilization-and-payment-data-2014)
- The Home Health Agency Utilization and Payment data 2014 presents information on services provided to Medicare beneficiaries by home health agencies. The Home Health Agency PUF includes data for providers that had a valid identification number and submitted a Medicare Part A institutional claim during the 2014 calendar year. To protect the privacy of Medicare beneficiaries, any aggregated records which are derived from 10 or fewer beneficiaries are excluded.
- [Home Health Agency Utilization and Payment Data 2015](https://www.johnsnowlabs.com/marketplace/home-health-agency-utilization-and-payment-data-2015)
- The Home Health Agency Utilization and Payment Data 2015 presents information on services provided to Medicare beneficiaries by home health agencies. The dataset includes data for providers that had a valid identification number and submitted a Medicare Part A institutional claim during the 2015 calendar year. To protect the privacy of Medicare beneficiaries, any aggregated records which are derived from 10 or fewer beneficiaries are excluded.
- [Home Health Agency Utilization and Payment Data 2016](https://www.johnsnowlabs.com/marketplace/home-health-agency-utilization-and-payment-data-2016)
- The Home Health Agency Utilization and Payment Data 2016 presents information on services provided to Medicare beneficiaries by home health agencies. The dataset includes data for providers that had a valid identification number and submitted a Medicare Part A institutional claim during the 2015 calendar year. To protect the privacy of Medicare beneficiaries, any aggregated records which are derived from 10 or fewer beneficiaries are excluded.
- [Hospice Providers Utilization and Payment Data 2014](https://www.johnsnowlabs.com/marketplace/hospice-providers-utilization-and-payment-data-2014)
- The Hospice providers utilization and payment data 2014 provides information on services provided to Medicare beneficiaries by hospice providers. The Hospice PUF contains information on utilization, payment (Medicare payment and standard payment), submitted charges, primary diagnoses, sites of service, and hospice beneficiary demographics organized by CMS Certification Number (6-digit provider identification number), and state.
- [Inpatient Prospective Payment System Top 100 DRGS 2013](https://www.johnsnowlabs.com/marketplace/inpatient-prospective-payment-system-top-100-drgs-2013)
- The dataset provided here include hospital-specific charges for the more than 3,000 U.S. hospitals that receive Medicare Inpatient Prospective Payment System (IPPS) payments for the top 100 most frequently billed discharges, paid under Medicare based on a rate per discharge using the Medicare Severity Diagnosis Related Group (MS-DRG) for Fiscal Year (FY) 2013. These DRGs represent more than 7 million discharges or 60 percent of total Medicare IPPS discharges.
- [Inpatient Rehabilitation Facility Conditions](https://www.johnsnowlabs.com/marketplace/inpatient-rehabilitation-facility-conditions)
- This dataset includes the list of inpatient rehabilitation facilities with data on the number of times people with Medicare who had certain medical conditions were treated in the last year.
- [Inpatient Rehabilitation Facility General Information](https://www.johnsnowlabs.com/marketplace/inpatient-rehabilitation-facility-general-information)
- This dataset shows characteristics of the Inpatient Rehabilitation Facilities (IRFs) that are shown on Inpatient Rehabilitation Facility Compare. It includes a list of IRFs with information such as address, phone number, ownership data and more. This dataset also shows the information about Centers for Medicare & Medicaid Services (CMS) Regions where each of the IRFs are located.
- [Inpatient Rehabilitation Facility PPS Rate Settings 2017](https://www.johnsnowlabs.com/marketplace/inpatient-rehabilitation-facility-pps-rate-settings-2017)
- This dataset contains the information about the Inpatient Rehabilitation Facilities (IRFs) Prospective Payment System (PPS) Rate Settings for fiscal year 2017. This file contains data for each of the 1,133 inpatient rehabilitation facilities used to estimate the policy updates in the final inpatient rehabilitation prospective payment system regulation.
- [Inpatient Rehabilitation Facility Provider Data](https://www.johnsnowlabs.com/marketplace/inpatient-rehabilitation-facility-provider-data)
- This dataset shows characteristics of the Inpatient Rehabilitation Facilities (IRFs) that are shown on Inpatient Rehabilitation Facility Compare. It includes a list of IRFs with information such as address, phone number, state, city and county data with the information about Centers for Medicare & Medicaid Services (CMS) Regions where each of the IRFs are located. This dataset also contains data regarding different measure codes and their corresponding scores for majority of the IRFs.
- [Medicare HHRG Aggregate Table 2013](https://www.johnsnowlabs.com/marketplace/medicare-hhrg-aggregate-table-2013)
- The dataset “HHRG Aggregate Table” contains information on utilization, Medicare payment, and submitted charges organized by HHRG.
- [Medicare HHRG Aggregate Table By State 2013](https://www.johnsnowlabs.com/marketplace/medicare-hhrg-aggregate-table-by-state-2013)
- The “HHRG by State Aggregate Table” contains information on utilization, Medicare payment, and submitted charges organized by HHRG by state.
- [Medicare Hospice Cost Report 1999-2009](https://www.johnsnowlabs.com/marketplace/medicare-hospice-cost-report-1999-2009)
- This dataset shows the top 20 hospice diagnoses, the number of patients, and average length of stay for calendar years 1999 to 2009.
- [Medicare Part D Prescriber Utilization and Payment Data 2013](https://www.johnsnowlabs.com/marketplace/medicare-part-d-prescriber-utilization-and-payment-data-2013)
- The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan for the year 2013. The Part D Prescriber PUF is organized by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs.
- [Medicare Part D Prescriber Utilization and Payment Data 2014](https://www.johnsnowlabs.com/marketplace/medicare-part-d-prescriber-utilization-and-payment-data-2014)
- The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan for the year 2014. The Part D Prescriber PUF is organized by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs.
- [Medicare Part D Prescriber Utilization and Payment Data 2015](https://www.johnsnowlabs.com/marketplace/medicare-part-d-prescriber-utilization-and-payment-data-2015)
- The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan for the year 2015. The Part D Prescriber PUF is organized by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs.
- [Medicare Part D Prescriber Utilization and Payment Data 2016](https://www.johnsnowlabs.com/marketplace/medicare-part-d-prescriber-utilization-and-payment-data-2016)
- The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan for the year 2016. The Part D Prescriber PUF is organized by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs.
- [Medicare Part D Prescriber Utilization and Payment Data 2017](https://www.johnsnowlabs.com/marketplace/medicare-part-d-prescriber-utilization-and-payment-data-2017)
- The Medicare Part D Prescriber Public Use File provides information on prescription drug events (PDEs) incurred by Medicare beneficiaries with a Part D prescription drug plan for the year 2017. The Part D Prescriber PUF is organized by National Provider Identifier (NPI) and drug name and contains information on drug utilization (claim counts and day supply) and total drug costs.
- [POA Exempt Add Codes](https://www.johnsnowlabs.com/marketplace/poa-exempt-add-codes)
- This dataset shows the list of codes added to the Present on Admission (POA) exempt list from 2016 to 2022 by the Centers for Medicare and Medicaid Services (CMS). Present On Admission is defined as present at the time the order for inpatient admission occurs — conditions that develop during an outpatient encounter, including emergency department, observation, or outpatient surgery, are considered POA.
- [POA Exempt Codes](https://www.johnsnowlabs.com/marketplace/poa-exempt-codes)
- This dataset shows the list of ICD-10-CM code that is exempt from the Present on Admission (POA) reporting from 2016 to 2022 by the Centers for Medicare and Medicaid Services (CMS). Present On Admission is defined as present at the time the order for inpatient admission occurs — conditions that develop during an outpatient encounter, including emergency department, observation, or outpatient surgery, are considered POA.
- [POA Exempt Delete Codes](https://www.johnsnowlabs.com/marketplace/poa-exempt-delete-codes)
- This dataset shows the list of ICD-10-CM code that is deleted from the Present on Admission (POA) reporting from 2016 to 2022 by the Centers for Medicare and Medicaid Services (CMS). Present On Admission is defined as present at the time the order for inpatient admission occurs — conditions that develop during an outpatient encounter, including emergency department, observation, or outpatient surgery, are considered POA.
- [POA Exempt Revise Codes](https://www.johnsnowlabs.com/marketplace/poa-exempt-revise-codes)
- This dataset shows the list of ICD-10-CM code that is revised from the Present on Admission (POA) reporting from 2017 to 2020 by the Centers for Medicare and Medicaid Services (CMS). Present On Admission is defined as present at the time the order for inpatient admission occurs — conditions that develop during an outpatient encounter, including emergency department, observation, or outpatient surgery, are considered POA.
- [Skilled Nursing Facility Utilization and Payment Data 2013](https://www.johnsnowlabs.com/marketplace/skilled-nursing-facility-utilization-and-payment-data-2013)
- This dataset provides information on services provided to Medicare beneficiaries residing in skilled nursing facilities. The Skilled Nursing Facility Public Use File contains information on utilization, payment, submitted charges, and beneficiary demographic and chronic condition indicators organized by Centres for Medicare and Medicaid Services Certification Number (6-digit provider identification number), Resource Utilization Group (RUG), and state of service.
- [Skilled Nursing Facility Utilization and Payment Data 2014](https://www.johnsnowlabs.com/marketplace/skilled-nursing-facility-utilization-and-payment-data-2014)
- The Skilled Nursing Facility Utilization and Payment data 2014 provides information on services provided to Medicare beneficiaries residing in skilled nursing facilities. The Skilled Nursing Facility Public Use File contains information on utilization, payment, submitted charges, and beneficiary demographic and chronic condition indicators organized by Centers for Medicare and Medicaid Services (CMS) Certification Number, Resource Utilization Group (RUG), and state of service.
- [Skilled Nursing Facility Utilization and Payment Data 2015](https://www.johnsnowlabs.com/marketplace/skilled-nursing-facility-utilization-and-payment-data-2015)
- This dataset provides information on services provided to Medicare beneficiaries residing in skilled nursing facilities. The Skilled Nursing Facility Public Use File contains information on utilization, payment (allowed amount, Medicare payment and standard payment), submitted charges, and beneficiary demographic and chronic condition indicators organized by Centers for Medicare and Medicaid Services (CMS) Certification Number, Resource Utilization Group (RUG), and state of service.
- [Skilled Nursing Facility Utilization and Payment Data 2016](https://www.johnsnowlabs.com/marketplace/skilled-nursing-facility-utilization-and-payment-data-2016)
- This dataset provides information on services provided to Medicare beneficiaries residing in skilled nursing facilities. The Skilled Nursing Facility Public Use File contains information on utilization, payment (allowed amount, Medicare payment and standard payment), submitted charges, and beneficiary demographic and chronic condition indicators organized by Centers for Medicare and Medicaid Services (CMS) Certification Number, Resource Utilization Group (RUG), and state of service.

**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]).