Healthcare Financial and Patient Data for Industry Professionals. The Way You Need It. Now.

Custom Reports from National Medicare Data

Custom Reports from National Medicare Data

The Health Data Store provides custom reports and analysis of Medicare data from hospitals and other healthcare providers across all 50 states. Reports are customized based on the criteria relevant to your needs, and data can be broken down by the providers, geographic areas, diagnosis and procedure codes, financial metrics, and many other variables that you need to analyze.

Browse the list of available Medicare data files below and contact us for a custom report.

MedPAR File

The Centers for Medicare and Medicaid Services (CMS) collects and releases data for all U.S. hospital inpatient stays for Medicare beneficiaries. These data are released annually in the CMS Medicare Provider Analysis and Review (MedPAR) file. Each record in the MedPAR file represents an inpatient stay during the calendar year of the file and has information on diagnosis, procedure, charge, payment, provider and patient for the claim. Some useful data elements include: Patient age group, sex and race Hospital provider number Length of stay 5 categories of accommodation charges Up to 9 diagnosis (ICD-9-CM) codes Up to 6 surgical procedure codes Charge and payment data All hospitals receiving funds from Medicare must submit their data to CMS. In the most recent year available over 6,000 hospitals had data reported in the MedPAR file. RPC holds these files from 2006 to 2014. Data Applications We can provide custom reports, graphs and maps using this data file and combining it with other health care and demographic files. The tabulations and analysis RPC offers based on MedPAR data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the MedPAR data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Suppression The MedPAR data is only specific to state-of-origin level for patients. In addition, patient age is reported by categories rather than exact age, and admission and discharge dates are reported as quarters. Data Use Restrictions Because of data use restrictions, RPC cannot sell access to the raw data, but can provide a wide array of tabulations and descriptive statistics using the MedPAR file. RPC cannot release data with a cell size of less than 11, and must suppress patient age, date of admission and discharge data elements. Read More

Medicare Cost Reports

The Centers for Medicare and Medicaid Services (CMS) collects data from every hospital receiving Medicare reimbursement. The resulting Cost Report data includes financial, descriptive and operational data on each provider, and is loaded into HCRIS, a structured database each quarter. CMS updates the HCRIS database quarterly, and the Health Data Store has the most recent update and historical data back to 1995. Some useful data elements include: Provider cost to charge ratios Total inpatient Medicare days Total Medicare observation days Services offered by provider (including laboratory, rehabilitation, outpatient and psychiatric services) Costs broken down by cost centers Detailed financial reports Medicare reimbursement amounts Number of hospital interns and residents Average hospital hourly wage Costs related to uncompensated care Reporting facilities In the most recent quarter released, there are records for nearly 9,000 hospitals. Data Applications The tabulations and analysis RPC offers based on HCRIS hospital data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the HCRIS hospital data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Use Restrictions This file has no data use restrictions. Read More

Standard Analytical Files

The Centers for Medicare and Medicaid Services (CMS) collects data from all hospitals that provide services to Medicare beneficiaries on an ongoing basis through its fiscal intermediaries, and compiles the data for each calendar year. One of the resulting datasets, the Standard Analytical File, has data organized at the claim level and includes basic information about the beneficiary and services performed for the beneficiary’s claim. CMS updates this file annually, and the Health Data Store has the most recent update and historical data. Some useful data elements include: Beneficiary state of residence Hospital where service was provided Beneficiary race Beneficiary sex ICD-9-CM principle diagnosis code Claim diagnosis by DRG code Claim payment amount Charge amounts by component Patient discharge status Admission date Disproportionate share payment amounts Reporting Hospitals All hospitals seeking Medicare reimbursement for inpatient claims must submit SAF data to CMS. In 2013, there were over 6,000 reporting hospitals. Data Applications The tabulations and analysis RPC offers based on CMS SAF data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the CMS SAF data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Use Restrictions CMS does not allow any data to be distributed that may make it possible for an individual beneficiary to be identified. To that end, no tabulations using the SAF data that include fewer than 11 beneficiaries may be produced from the data. Read More

Other Medicare Data

We maintain access to other Medicare data files and have the ability to order more from the Centers for Medicare and Medicaid Services. These files can be used to identify detailed facility information for healthcare providers, study Medicare patient demographics, analyze provider charges, and other purposes. Click below for descriptions of the file layouts for these datasets or contact us for a custom report. Provider of Services Medicare Denominator File Physician and Supplier File Read More

For More Information

  • This field is for validation purposes and should be left unchanged.