CMS Data Feeds Dataset
About the Dataset
The CMS Data Feeds Dataset is a comprehensive collection of all current and future CMS data feeds available on cms.data.gov. This dataset transforms each feed into a view, aligning all feed file attributes and casting them to appropriate datatypes. The views are automatically updated when new feed files arrive, and new views are included as CMS publishes new data feeds.
As of November 2025, the dataset encompasses 228 feeds and 2,791 feed files.
See the full list of feeds in the CMS Data Feeds Catalog.
🔗 Find the CMS Data Feeds Dataset on the Snowflake Marketplace.
Dataset Features
89 billion records and growing
228 feeds with automatic addition of new feeds
9,583 feed attributes
18 years of historical data
1.2 TB of data, continuously expanding
Daily updates to ensure data freshness
Automatic quality checks and active monitoring
Designed for seamless ingestion
Data Quality and Maintenance
Dataplex Consulting & Data Products prioritizes data quality through:
Automated data quality checks in all pipelines
Daily monitoring of ingestion and ETL jobs
Timely updates whenever CMS publishes new data
Rigorous processes to ensure data integrity and reliability
Business Applications
Users can leverage this dataset for various purposes, including:
Enriching or augmenting existing datasets
Analyzing published feed metrics over time
Performing segmentation analysis
Training machine learning models
Conducting geospatial analysis
Tracking healthcare trends and performance metrics
Example Use Cases
Analyze telehealth adoption trends across different states
Evaluate the financial performance of home health agencies
Track Medicare spending patterns by drug or geography
Assess hospital performance metrics and patient satisfaction scores
Monitor healthcare-associated infections across facilities
Data Structure
The dataset consists of three main components:
FEEDS: Contains metadata about each CMS data feed
FEEDS_FILES: Stores information about individual files within each feed
Feed-specific views: Separate views for each feed (e.g., PatientReported_Outcomes, Medicare_Spending)
Entity Relationship Diagram
Sample Queries
Get CMS Feeds to Table Mapping
SELECT title,
description,
references[0]::string AS cms_page_documentation,
view_name AS table_name
FROM DWV.FEEDS f;Find all Feed Views Related to Medicare
SELECT title, description, view_name
FROM dwv.feeds
WHERE array_contains('Medicare'::variant, keywords) = True;Query All 2021 File Records for Medicare Inpatient Hospitals
SELECT ff.temporal_start,
ff.temporal_end,
v.*
FROM dwv.feeds f
JOIN dwv.feeds_files ff ON f.id = ff.feed_id
JOIN dwv.Medicare_Inpatient_Hospitals__by_Geography_and_Service v ON ff.id = v.file_id
WHERE title = 'Medicare Inpatient Hospitals - by Geography and Service'
AND year(ff.temporal_start) = 2021;📊 Recent Feed File Updates
Recent CMS feed file updates (last 30 days)
11/20/2025
07/16/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/19/2025
11/01/2025
11/17/2025
01/01/2024 to 12/31/2024
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/07/2025
10/01/2025
11/05/2025
01/01/2023 to 12/31/2023
10/29/2025
01/01/2023 to 12/31/2023
10/28/2025
01/01/2023 to 12/31/2023
10/28/2025
01/01/2023 to 12/31/2023
🆕 Recently Added Feeds
Income and Asset Ownership (Added: September 2025)
What's in this data: This dataset provides comprehensive insights into the income sources, levels, asset ownership, and values among Medicare beneficiaries. It is crucial for understanding the financial status and economic challenges faced by the elderly population, allowing for better-targeted healthcare policies and financial assistance programs.
How you can use it:
Analyzing the financial health of Medicare beneficiaries to inform policy decisions.
Identifying disparities in income and asset ownership among different demographic groups.
Evaluating the impact of income levels on healthcare access and outcomes.
Example Queries:
This query retrieves the average income and asset values segmented by age groups for a specific data file.
SELECT avg(median_combined_income) AS avg_income, avg(median_home_equity) AS avg_home_equity
FROM cms_dw.dwv.income_and_asset_ownership
WHERE file_id = '02145382-c23c-5833-a8e0-a2f5306dda52'
GROUP BY __characteristicsThis query shows the distribution of home ownership percentages across different demographic characteristics.
SELECT __characteristics, avg(home_ownership) AS avg_home_ownership
FROM cms_dw.dwv.income_and_asset_ownership
WHERE file_id = '02145382-c23c-5833-a8e0-a2f5306dda52'
GROUP BY __characteristicsMonthly Prescription Drug Plan Formulary and Pharmacy Network Information - plan_data (Added: September 2025)
What's in this data: This dataset provides comprehensive monthly updates on Medicare Part D and Medicare Advantage plan formularies and pharmacy networks. It includes vital information such as premium costs, deductibles, and contract details for various plans, aiding stakeholders in understanding the landscape of prescription drug coverage.
How you can use it:
Analyze trends in Medicare Advantage plan premiums over time to identify cost increases or decreases.
Evaluate the availability of specific prescription drugs across different plans within a region to inform beneficiaries about their options.
Assess the impact of plan suppression on beneficiaries' access to healthcare services based on available formulary data.
Example Queries:
This query retrieves the average premium and deductible for Medicare Advantage plans in a specific region.
SELECT avg(premium) AS average_premium, avg(deductible) AS average_deductible
FROM cms_dw.dwv.monthly_prescription_drug_plan_formulary_and_pharmacy_network_information__plan_data
WHERE file_id = '86b6e308bc7426b56a58b91035cf3187'
AND ma_region_code = 'AL'This query lists unique plan names and their corresponding contract names that have been suppressed.
SELECT DISTINCT plan_name, contract_name
FROM cms_dw.dwv.monthly_prescription_drug_plan_formulary_and_pharmacy_network_information__plan_data
WHERE file_id = '86b6e308bc7426b56a58b91035cf3187'
AND plan_suppressed_yn = TRUEMonthly Prescription Drug Plan Formulary and Pharmacy Network Information - insulin_beneficiary_cost (Added: September 2025)
What's in this data: This dataset provides monthly Medicare Part D and Medicare Advantage plan formulary and pharmacy network data specific to insulin beneficiary costs. It includes details such as copay amounts for preferred and non-preferred insulin medications, tier levels, and days supply, which are crucial for analyzing patient out-of-pocket expenses and plan offerings.
How you can use it:
Analyze the variation in copay costs for insulin across different Medicare plans.
Identify trends in insulin pricing and availability in the pharmacy network over time.
Evaluate the impact of different tiers on patient costs for insulin medications.
Example Queries:
This query shows the distribution of insulin medications across different tiers in the formulary.
SELECT tier, count(row_id) AS count_per_tier
FROM cms_dw.dwv.monthly_prescription_drug_plan_formulary_and_pharmacy_network_information__insulin_beneficiary_cost
WHERE file_id = '3d0ad9d973c0bbf8faae4d1884ce1494'
GROUP BY tierThis query shows the total number of plans offering insulin along with their corresponding copay amounts.
SELECT count(DISTINCT plan_id) AS total_plans, avg(cast(copay_amt_nonpref_insln AS DECIMAL)) AS avg_copay_nonpref
FROM cms_dw.dwv.monthly_prescription_drug_plan_formulary_and_pharmacy_network_information__insulin_beneficiary_cost
WHERE file_id = '3d0ad9d973c0bbf8faae4d1884ce1494'📋 View the complete CMS Data Feeds Catalog
Support and Contact
For questions or assistance with the CMS Data Feeds Dataset, please contact:
Email: [email protected]
The Dataplex Consulting & Data Products team monitors ingestion and ETL jobs daily to ensure quality and timely delivery.
About Dataplex
Dataplex Consulting & Data Products offers top-notch, turnkey data products, making data easily accessible for businesses of all sizes. With over 20 years of experience serving small businesses and Fortune 500 companies, our team has gained extensive practical expertise in enhancing data management, boosting revenue, and helping companies become more data-driven.
Last updated