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

Practice Areas

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. Read More

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

Texas Hospital Data

The Health Data Store maintains access to data collected by the State of Texas for all Texas hospital discharges and outpatient visits, including patients with commercial insurance, government payors, and other insurance programs. This comprehensive data set allows analysis of payor mix, service mix, and other detailed metrics that are not possible using single payor source data. Browse the list of available Texas hospital data files below and contact us for a custom report. Read More

THCIC Inpatient Discharge Data

The Texas Department of State Health Services collects and releases information on Texas inpatient hospital discharges and outpatient visits on a quarterly basis. There are now records for over 3 million discharges and 12 million visits annually. The DSHS files hold patient-level data for individual inpatient and outpatient hospital stays and include data on diagnoses, procedures, charges, and patient demographics. RPC holds these files from 1999 to the most recently released quarter. Some useful data elements include: Patient gender Patient age group Admission source Patient county and zip code Two payment sources 25 diagnosis codes (IC-D-9) 25 surgical procedure codes Reporting Hospitals There are approximately 600 hospitals in the state of Texas. DSHS collects data from all state licensed hospitals except for those that do not seek insurance payment or government reimbursement, and those that meet the following statutory criteria for rural exemption: hospitals located in a county with a population of less than 35,000, or hospitals located in an area that the Census Bureau does not define as urbanized, which have fewer than 100 licensed beds; and are not a state owned hospital or owned by an entity that owns or manages one or more other hospitals. Data Applications The tabulations and analysis RPC offers based on DSHS data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the DSHS data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Suppression To protect patient identity, the Texas Hospital Discharge data suppresses certain fields in instances where their inclusion may jeopardize patient anonymity, and also suppress physician identities. The last two digits of patient zip codes that have less than 30 discharges are also masked. 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 Texas Hospital Discharge data. Read More

THCIC Hospital Outpatient and ASC Data

The Texas Department of State Health Services collects and releases information on Texas inpatient hospital discharges and outpatient visits on a quarterly basis. There are now records for over 3 million discharges and 12 million visits annually. The DSHS files hold patient-level data for individual inpatient and outpatient hospital stays and include data on diagnoses, procedures, charges, and patient demographics. RPC holds these files from 1999 to the most recently released quarter. Some useful data elements include: Patient gender Patient age group Admission source Patient county and zip code Two payment sources 25 diagnosis codes (IC-D-9) 25 surgical procedure codes Reporting Hospitals There are approximately 600 hospitals in the state of Texas. DSHS collects data from all state licensed hospitals except for those that do not seek insurance payment or government reimbursement, and those that meet the following statutory criteria for rural exemption: hospitals located in a county with a population of less than 35,000, or hospitals located in an area that the Census Bureau does not define as urbanized, which have fewer than 100 licensed beds; and are not a state owned hospital or owned by an entity that owns or manages one or more other hospitals. Data Applications The tabulations and analysis RPC offers based on DSHS data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the DSHS data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Suppression To protect patient identity, the Texas Hospital Discharge data suppresses certain fields in instances where their inclusion may jeopardize patient anonymity, and also suppress physician identities. The last two digits of patient zip codes that have less than 30 discharges are also masked. 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 Texas Hospital Discharge data. Read More

Florida Hospital Data

The Health Data Store maintains access to data collected by the State of Florida for all Florida hospital discharges, outpatient visits, and emergency room visits, including patients with commercial insurance, government payors, and other insurance programs. This comprehensive data set allows analysis of payor mix, service mix, and other detailed metrics that are not possible using single payor source data. Browse the list of available Florida hospital data files below and contact us for a custom report. Read More

AHCA Inpatient Discharge Data

The Agency for Health Care Administration collects inpatient discharge, outpatient and ambulatory, and emergency room data from acute, short-term psychiatric, long-term psychiatric and comprehensive rehabilitation hospitals in Florida. The data are updated on a quarterly basis, and there are approximately 2.5 million records per year. Each record in the dataset corresponds to an individual inpatient hospital, outpatient, or ER visit. The file has patient-level data and includes information on patient demographics, diagnosis and procedure codes, attending physician, operating or performing physicians, and total gross charges. Some useful data elements include: Patient zip code Patient sex and race Up to 31 diagnosis codes Up to 31 diagnosis present on admission indicators Up to 31 procedure codes Charges by 22 revenue centers Discharge status Principal payer AHCA releases the inpatient data once 75% of the reporting facilities have certified the accuracy of their data, which is usually accomplished by 130 days after the end of a reporting period. All of the data are typically verified within 180 days of the end of the reporting period, meaning the data set is more complete two months after the initial version is released by AHCA. Discharge data from comprehensive rehabilitation hospitals are certified upon submission. RPC has hospital data from 2005 to the most recently released complete quarter. Reporting Hospitals Florida has approximately 300 hospitals. AHCA collects data on acute care, short-term psychiatric, long-term psychiatric and comprehensive rehabilitation facilities. State operated hospitals, federal hospitals, and Shriner’s hospitals are not required to report inpatient data to AHCA. Data Applications The tabulations and analysis RPC offers based on AHCA inpatient hospital data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the AHCA data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Suppression In order to protect patient anonymity, AHCA masks certain data elements before providing the collected utilization data. Patient birth dates are converted to ages, patient discharge dates are reported as calendar quarters, and procedure dates are reported as number of days to procedures. In addition, patient IDs and social security numbers are not reported. Data Use Restrictions Due to confidentiality agreements, the Health Data Store can only release tabulations and analyses based on the AHCA Florida Hospital Inpatient Discharge Data, and not the raw data itself. Read More

AHCA Hospital Outpatient Data

The Agency for Health Care Administration collects inpatient discharge, outpatient and ambulatory, and emergency room data from acute, short-term psychiatric, long-term psychiatric and comprehensive rehabilitation hospitals in Florida. The data are updated on a quarterly basis, and there are approximately 2.5 million records per year. Each record in the dataset corresponds to an individual inpatient hospital, outpatient, or ER visit. The file has patient-level data and includes information on patient demographics, diagnosis and procedure codes, attending physician, operating or performing physicians, and total gross charges. Some useful data elements include: Patient zip code Patient sex and race Up to 31 diagnosis codes Up to 31 diagnosis present on admission indicators Up to 31 procedure codes Charges by 22 revenue centers Discharge status Principal payer AHCA releases the inpatient data once 75% of the reporting facilities have certified the accuracy of their data, which is usually accomplished by 130 days after the end of a reporting period. All of the data are typically verified within 180 days of the end of the reporting period, meaning the data set is more complete two months after the initial version is released by AHCA. Discharge data from comprehensive rehabilitation hospitals are certified upon submission. RPC has hospital data from 2005 to the most recently released complete quarter. Reporting Hospitals Florida has approximately 300 hospitals. AHCA collects data on acute care, short-term psychiatric, long-term psychiatric and comprehensive rehabilitation facilities. State operated hospitals, federal hospitals, and Shriner’s hospitals are not required to report inpatient data to AHCA. Data Applications The tabulations and analysis RPC offers based on AHCA inpatient hospital data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the AHCA data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Suppression In order to protect patient anonymity, AHCA masks certain data elements before providing the collected utilization data. Patient birth dates are converted to ages, patient discharge dates are reported as calendar quarters, and procedure dates are reported as number of days to procedures. In addition, patient IDs and social security numbers are not reported. Data Use Restrictions Due to confidentiality agreements, the Health Data Store can only release tabulations and analyses based on the AHCA Florida Hospital Inpatient Discharge Data, and not the raw data itself. Read More

AHCA Hospital Emergency Room Data

The Agency for Health Care Administration collects inpatient discharge, outpatient and ambulatory, and emergency room data from acute, short-term psychiatric, long-term psychiatric and comprehensive rehabilitation hospitals in Florida. The data are updated on a quarterly basis, and there are approximately 2.5 million records per year. Each record in the dataset corresponds to an individual inpatient hospital, outpatient, or ER visit. The file has patient-level data and includes information on patient demographics, diagnosis and procedure codes, attending physician, operating or performing physicians, and total gross charges. Some useful data elements include: Patient zip code Patient sex and race Up to 31 diagnosis codes Up to 31 diagnosis present on admission indicators Up to 31 procedure codes Charges by 22 revenue centers Discharge status Principal payer AHCA releases the inpatient data once 75% of the reporting facilities have certified the accuracy of their data, which is usually accomplished by 130 days after the end of a reporting period. All of the data are typically verified within 180 days of the end of the reporting period, meaning the data set is more complete two months after the initial version is released by AHCA. Discharge data from comprehensive rehabilitation hospitals are certified upon submission. RPC has hospital data from 2005 to the most recently released complete quarter. Reporting Hospitals Florida has approximately 300 hospitals. AHCA collects data on acute care, short-term psychiatric, long-term psychiatric and comprehensive rehabilitation facilities. State operated hospitals, federal hospitals, and Shriner’s hospitals are not required to report inpatient data to AHCA. Data Applications The tabulations and analysis RPC offers based on AHCA inpatient hospital data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the AHCA data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. Data Suppression In order to protect patient anonymity, AHCA masks certain data elements before providing the collected utilization data. Patient birth dates are converted to ages, patient discharge dates are reported as calendar quarters, and procedure dates are reported as number of days to procedures. In addition, patient IDs and social security numbers are not reported. Data Use Restrictions Due to confidentiality agreements, the Health Data Store can only release tabulations and analyses based on the AHCA Florida Hospital Inpatient Discharge Data, and not the raw data itself. Read More

For More Information

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