This dataset reports summary state-by-state total expenditures by program for the Medicaid Program, Medicaid Administration and CHIP programs. These state expenditures are tracked through the automated Medicaid Budget and Expenditure System/State Children's Health Insurance Program Budget and Expenditure System (MBES/CBES). For more information, visit https://medicaid.gov/medicaid/finance/state-expenditure-reporting/expenditure-reports/index.html.

Contains full API download of all available datasets on data.medicaid.gov. Program overview Data.Medicaid.gov is a public platform offering open access to a diverse range of datasets related to Medicaid and the Children’s Health Insurance Program (CHIP). It is tailored to support policymakers, researchers, and the general public by providing critical data for research, reporting, and analysis. The platform covers various topics, including state Medicaid and CHIP programs, enrollment statistics, spending trends, and quality metrics. With data presented in multiple formats, it promotes transparency, allowing users to track program performance and make informed decisions based on reliable insights.

All states (including the District of Columbia) are required to provide data to The Centers for Medicare & Medicaid Services (CMS) on a range of Medicaid and Children’s Health Insurance Program (CHIP) indicators related to key application, eligibility, enrollment and call center processes. These data reflect enrollment activity for all populations receiving comprehensive Medicaid and CHIP benefits in all states, as well as state program performance. States submit this data via the Performance Indicator dataset. Further information about this dataset is available at: https://www.medicaid.gov/medicaid/national-medicaid-chip-program-information/medicaid-chip-enrollment-data/performance-indicator-technical-assistance/index.html.

Medicaid reports the number and rate (per 1,000) of Medicaid cases and recipients.

This dataset tracks the updates made on the dataset "Center for Medicare & Medicaid Services (CMS) , Medicare Claims data" as a repository for previous versions of the data and metadata.

description:

The Environmental Scanning and Program Characteristic (ESPC) Database is in a Microsoft (MS) Access format and contains Medicaid and CHIP data, for the 50 states and District of Columbia. Specifically, the ESPC database predominantly houses information on Medicaid and CHIP program characteristics as well as selected environmental factors that are available through other publicly available databases. This database contains data from 2005 onward, and was last updated in calendar year 2013. Program characteristics include data elements such as eligibility criteria, the presence of waiver programs, managed care penetration, benefit coverage, reimbursement levels, and expenditures.

The Environmental Scanning and Program Characteristic (ESPC) Database is in a Microsoft (MS) Access format and contains Medicaid and CHIP data, for the 50 states and District of Columbia. Specifically, the ESPC database predominantly houses information on Medicaid and CHIP program characteristics as well as selected environmental factors that are available through other publicly available databases. This database contains data from 2005 onward, and was last updated in calendar year 2013. Program characteristics include data elements such as eligibility criteria, the presence of waiver programs, managed care penetration, benefit coverage, reimbursement levels, and expenditures.

The New York State Department of Health (NYS DOH) shares de-identified and aggregated metrics on the NYS Medicaid program through the Health Data NY catalog and as summary statistics on DOH website. Datasets vary by subject/scope, unit of analysis, years of data collection, and update frequency. Publicly-available datasets in the Health Data NY catalog address topics including:

• Medicaid Program Enrollment Rates and Demographics
• Health Home Quality and Utilization
• Inpatient Admissions and Emergency Room Visits
• Incentive Payments
• Inpatient Potentially Preventable Readmission (PPR) Rates
• Newborn Low Birth Weight Rates
• Pediatric and Adult Discharge Quality Indicators
• Potentially Preventable Emergency Visit (PPV) Rates
• Potentially Avoidable Antibiotic Prescribing Rates

For a fee, researchers at NYU Langone Health may acquire NYS Medicaid claims data by submitting a study proposal to the Health Evaluation and Analytics Lab (HEAL). For more information, click on the link to the NYS Medicaid Claims File under the Related Datasets section or search for the NYS Medicaid Claims File in the NYU Data Catalog.

Context

This public dataset was created by the Centers for Medicare & Medicaid Services. The data summarize counts of enrollees who are dually-eligible for both Medicare and Medicaid program, including those in Medicare Savings Programs. “Duals” represent 20 percent of all Medicare beneficiaries, yet they account for 34 percent of all spending by the program, according to the Commonwealth Fund . As a representation of this high-needs, high-cost population, these data offer a view of regions ripe for more intensive care coordination that can address complex social and clinical needs. In addition to the high cost savings opportunity to deliver upstream clinical interventions, this population represents the county-by-county volume of patients who are eligible for both state level (Medicaid) and federal level (Medicare) reimbursements and potential funding streams to address unmet social needs across various programs, waivers, and other projects. The dataset includes eligibility type and enrollment by quarter, at both the state and county level. These data represent monthly snapshots submitted by states to the CMS, which are inherently lower than ever-enrolled counts (which include persons enrolled at any time during a calendar year.) For more information on dually eligible beneficiaries

Querying BigQuery tables

You can use the BigQuery Python client library to query tables in this dataset in Kernels. Note that methods available in Kernels are limited to querying data. Tables are at bigquery-public-data.sdoh_cms_dual_eligible_enrollment.

Sample Query

In what counties in Michigan has the number of dual-eligible individuals increased the most from 2015 to 2018? Find the counties in Michigan which have experienced the largest increase of dual enrollment households

duals_Jan_2015 AS ( SELECT Public_Total AS duals_2015, County_Name, FIPS FROM bigquery-public-data.sdoh_cms_dual_eligible_enrollment.dual_eligible_enrollment_by_county_and_program WHERE State_Abbr = "MI" AND Date = '2015-12-01' ),

duals_increase AS ( SELECT d18.FIPS, d18.County_Name, d15.duals_2015, d18.duals_2018, (d18.duals_2018 - d15.duals_2015) AS total_duals_diff FROM duals_Jan_2018 d18 JOIN duals_Jan_2015 d15 ON d18.FIPS = d15.FIPS )

SELECT * FROM duals_increase WHERE total_duals_diff IS NOT NULL ORDER BY total_duals_diff DESC

All states (including the District of Columbia) provide data to the Centers for Medicare & Medicaid Services (CMS) on a range of Medicaid and Children’s Health Insurance Program (CHIP) eligibility and enrollment metrics. These data reflect state-reported information on Medicaid and CHIP eligibility renewals initiated and scheduled for completion during the reporting period. In addition to reporting the outcomes of renewals at the end of each reporting period, states also provide an update on renewals that were reported pending as of the end of a reporting period. For more information on these data, see Sections II and III of the Eligibility Processing Data Report specifications.
Notes:
Georgia reported data for individuals who continue to be eligible following a change in circumstances and were granted a new 12-month eligibility period during the reporting period, along with data on individuals due for renewal in the month.
North Carolina reports renewal outcomes for only initiated renewals scheduled for completion in the report month, and as such, the data do not reflect renewals that should have been completed in the reporting period that the state was unable to initiate by the end of the report month.

NCHS has linked data from various surveys with Medicare program enrollment and health care utilization and expenditure data from the Centers for Medicare & Medicaid Services (CMS). Linkage of the NCHS survey participants with the CMS Medicare data provides the opportunity to study changes in health status, health care utilization and costs, and prescription drug use among Medicare enrollees. Medicare is the federal health insurance program for people who are 65 or older, certain younger people with disabilities, and people with End-Stage Renal Disease.

United States HIC: All Ages: PG: Govt: Medicaid data was reported at 62,492.000 Person th in 2017. This records an increase from the previous number of 62,303.000 Person th for 2016. United States HIC: All Ages: PG: Govt: Medicaid data is updated yearly, averaging 42,830.746 Person th from Mar 1999 (Median) to 2017, with 19 observations. The data reached an all-time high of 62,492.000 Person th in 2017 and a record low of 27,353.084 Person th in 1999. United States HIC: All Ages: PG: Govt: Medicaid data remains active status in CEIC and is reported by US Census Bureau. The data is categorized under Global Database’s United States – Table US.G083: Health Insurance Coverage.

The All CMS Data Feeds dataset is an expansive resource offering access to 118 unique report feeds, providing in-depth insights into various aspects of the U.S. healthcare system. With over 25.8 billion rows of data meticulously collected since 2007, this dataset is invaluable for healthcare professionals, analysts, researchers, and businesses seeking to understand and analyze healthcare trends, performance metrics, and demographic shifts over time. The dataset is updated monthly, ensuring that users always have access to the most current and relevant data available.

Dataset Overview:

118 Report Feeds: - The dataset includes a wide array of report feeds, each providing unique insights into different dimensions of healthcare. These topics range from Medicare and Medicaid service metrics, patient demographics, provider information, financial data, and much more. The breadth of information ensures that users can find relevant data for nearly any healthcare-related analysis. - As CMS releases new report feeds, they are automatically added to this dataset, keeping it current and expanding its utility for users.

25.8 Billion Rows of Data:

• With over 25.8 billion rows of data, this dataset provides a comprehensive view of the U.S. healthcare system. This extensive volume of data allows for granular analysis, enabling users to uncover insights that might be missed in smaller datasets. The data is also meticulously cleaned and aligned, ensuring accuracy and ease of use.

Historical Data Since 2007: - The dataset spans from 2007 to the present, offering a rich historical perspective that is essential for tracking long-term trends and changes in healthcare delivery, policy impacts, and patient outcomes. This historical data is particularly valuable for conducting longitudinal studies and evaluating the effects of various healthcare interventions over time.

Monthly Updates:

• To ensure that users have access to the most current information, the dataset is updated monthly. These updates include new reports as well as revisions to existing data, making the dataset a continuously evolving resource that stays relevant and accurate.

Data Sourced from CMS:

• The data in this dataset is sourced directly from the Centers for Medicare & Medicaid Services (CMS). After collection, the data is meticulously cleaned and its attributes are aligned, ensuring consistency, accuracy, and ease of use for any application. Furthermore, any new updates or releases from CMS are automatically integrated into the dataset, keeping it comprehensive and current.

Use Cases:

Market Analysis:

• The dataset is ideal for market analysts who need to understand the dynamics of the healthcare industry. The extensive historical data allows for detailed segmentation and analysis, helping users identify trends, market shifts, and growth opportunities. The comprehensive nature of the data enables users to perform in-depth analyses of specific market segments, making it a valuable tool for strategic decision-making.

Healthcare Research:

• Researchers will find the All CMS Data Feeds dataset to be a robust foundation for academic and commercial research. The historical data, combined with the breadth of coverage across various healthcare metrics, supports rigorous, in-depth analysis. Researchers can explore the effects of healthcare policies, study patient outcomes, analyze provider performance, and more, all within a single, comprehensive dataset.

Performance Tracking:

• Healthcare providers and organizations can use the dataset to track performance metrics over time. By comparing data across different periods, organizations can identify areas for improvement, monitor the effectiveness of initiatives, and ensure compliance with regulatory standards. The dataset provides the detailed, reliable data needed to track and analyze key performance indicators.

Compliance and Regulatory Reporting:

• The dataset is also an essential tool for compliance officers and those involved in regulatory reporting. With detailed data on provider performance, patient outcomes, and healthcare utilization, the dataset helps organizations meet regulatory requirements, prepare for audits, and ensure adherence to best practices. The accuracy and comprehensiveness of the data make it a trusted resource for regulatory compliance.

Data Quality and Reliability:

The All CMS Data Feeds dataset is designed with a strong emphasis on data quality and reliability. Each row of data is meticulously cleaned and aligned, ensuring that it is both accurate and consistent. This attention to detail makes the dataset a trusted resource for high-stakes applications, where data quality is critical.

Integration and Usability:

Ease of Integration:

• The dataset is provided in a CSV format, which is widely compatible with most data analysis tools and platforms. This ensures that users can easily integrate the data into their existing wo...

United States Health Insurance: Claims Per Member Per Month: Medicaid data was reported at 398.000 USD in 2023. This records an increase from the previous number of 375.000 USD for 2022. United States Health Insurance: Claims Per Member Per Month: Medicaid data is updated yearly, averaging 291.000 USD from Dec 2007 (Median) to 2023, with 17 observations. The data reached an all-time high of 398.000 USD in 2023 and a record low of 182.340 USD in 2007. United States Health Insurance: Claims Per Member Per Month: Medicaid data remains active status in CEIC and is reported by National Association of Insurance Commissioners. The data is categorized under Global Database’s United States – Table US.RG022: Health Insurance: Operations by Lines of Business.

This dataset represents the number of Medicaid eligible individuals receiving the various Medicaid services over time.

2016-2019. This dataset is a de-identified summary table of prevalence rates for vision and eye health data indicators from the Medicaid Analytic eXtract (MAX) data. Medicaid MAX are a set of de-identified person-level data files with information on Medicaid eligibility, service utilization, diagnoses, and payments. The MAX data contain a convenience sample of claims processed by Medicaid and Children’s Health Insurance Program (CHIP) fee for service and managed care plans. Not all states are included in MAX in all years, and as of November 2019, 2014 data is the latest available. Prevalence estimates are stratified by all available combinations of age group, gender, and state. Detailed information on VEHSS Medicare analyses can be found on the VEHSS Medicaid MAX webpage (cdc.gov/visionhealth/vehss/data/claims/medicaid.html). Information on available Medicare claims data can be found on the ResDac website (www.resdac.org). The VEHSS Medicaid MAX dataset was last updated May 2023.

United States HIC: 25 to 34 Yrs: PG: Govt: Medicaid data was reported at 7,095.000 Person th in 2016. This records an increase from the previous number of 6,789.600 Person th for 2015. United States HIC: 25 to 34 Yrs: PG: Govt: Medicaid data is updated yearly, averaging 3,619.145 Person th from Mar 1999 (Median) to 2016, with 18 observations. The data reached an all-time high of 7,095.000 Person th in 2016 and a record low of 2,258.680 Person th in 2000. United States HIC: 25 to 34 Yrs: PG: Govt: Medicaid data remains active status in CEIC and is reported by US Census Bureau. The data is categorized under Global Database’s USA – Table US.G082: Health Insurance Coverage.

This data set includes monthly counts and rates (per 1,000 beneficiaries) of behavioral health services, including emergency department services, inpatient services, intensive outpatient/partial hospitalizations, outpatient services, or services delivered through telehealth, provided to Medicaid and CHIP beneficiaries, by state. Users can filter by either mental health disorder or substance use disorder.

These metrics are based on data in the T-MSIS Analytic Files (TAF). Some states have serious data quality issues for one or more months, making the data unusable for calculating behavioral health services measures. To assess data quality, analysts adapted measures featured in the DQ Atlas. Data for a state and month are considered unusable if at least one of the following topics meets the DQ Atlas threshold for unusable: Total Medicaid and CHIP Enrollment, Claims Volume - IP, Claims Volume - OT, Diagnosis Code - IP, Diagnosis Code - OT. Please refer to the DQ Atlas at http://medicaid.gov/dq-atlas for more information about data quality assessment methods. Cells with a value of “DQ” indicate that data were suppressed due to unusable data.

Some cells have a value of “DS”. This indicates that data were suppressed for confidentiality reasons because the group included fewer than 11 beneficiaries.

This dataset tracks the updates made on the dataset "Medicaid CHIP ESPC Database" as a repository for previous versions of the data and metadata.

United States Health Insurance: Enrollment: Medicaid data was reported at 54.000 USD mn in 2023. This records a decrease from the previous number of 61.000 USD mn for 2022. United States Health Insurance: Enrollment: Medicaid data is updated yearly, averaging 38.000 USD mn from Dec 2007 (Median) to 2023, with 17 observations. The data reached an all-time high of 61.000 USD mn in 2022 and a record low of 15.000 USD mn in 2007. United States Health Insurance: Enrollment: Medicaid data remains active status in CEIC and is reported by National Association of Insurance Commissioners. The data is categorized under Global Database’s United States – Table US.RG022: Health Insurance: Operations by Lines of Business.

United States Health Insurance: Net Earned Premium: Medicaid data was reported at 319.001 USD bn in 2023. This records an increase from the previous number of 310.410 USD bn for 2022. United States Health Insurance: Net Earned Premium: Medicaid data is updated yearly, averaging 148.609 USD bn from Dec 2007 (Median) to 2023, with 17 observations. The data reached an all-time high of 319.001 USD bn in 2023 and a record low of 37.216 USD bn in 2007. United States Health Insurance: Net Earned Premium: Medicaid data remains active status in CEIC and is reported by National Association of Insurance Commissioners. The data is categorized under Global Database’s United States – Table US.RG022: Health Insurance: Operations by Lines of Business.