> For the complete documentation index, see [llms.txt](https://docs.dataplex-consulting.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-inpatient-hospitals-by-provider.md). # Medicare Inpatient Hospitals - by Provider Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md) › Medicare Dataplex delivers this CMS feed as the analysis-ready table `DWV.MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER` on Snowflake and Databricks — 22 annual reporting periods (2013–2024) aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it. ## Key facts | | | | ------------------ | ------------------------------------------------------- | | **Snowflake** | `DWV.MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER` | | **Databricks** | `cms_dwv.medicare_inpatient_hospitals__by_provider` | | **Coverage** | Jan 2013 – Dec 2024 (12 of 12 annual reporting periods) | | **Rows** | 1,877,420 (total across all reporting periods) | | **Cadence** | Annual | | **Update pattern** | Time-partitioned — each file adds one reporting year | | **CMS published** | 2026-04-23 | | **Loaded** | 2026-04-23 | | **Columns** | 78 data + 6 lineage | | **Identifiers** | CCN · FIPS codes | | **File versions** | 22 | | **License** | CMS public data — U.S. Government work | | **Platforms** | Snowflake Marketplace · Databricks Delta Sharing | Included in the CMS Data Feeds Dataset — [start a free trial on Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset). {% hint style="success" %} **Current** — CMS last published this feed on 2026-04-23. Coverage is complete through the 2024 reporting year. Next CMS release expected \~Apr 2027. {% endhint %} {% hint style="info" %} **Time-partitioned feed** — each file version covers one reporting year, so history is additive. Query the full table for all years; filter on the reporting period columns for a single period. Do **not** filter to the latest file only — that would return just the 2024 reporting year. {% endhint %} ## Sample queries {% tabs %} {% tab title="Snowflake" %} ```sql -- Each file version covers one reporting period — history is additive SELECT * FROM DWV.MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER LIMIT 100; ``` {% endtab %} {% tab title="Databricks" %} ```sql -- Each file version covers one reporting period — history is additive SELECT * FROM cms_dwv.medicare_inpatient_hospitals__by_provider LIMIT 100; ``` {% endtab %} {% endtabs %} ## About this feed > The Medicare Inpatient Hospitals by Provider dataset provides information on inpatient discharges for Original Medicare Part A beneficiaries by IPPS hospitals. It includes information on the use, payment, and hospital charges for more than 3,000 U.S. hospitals that received IPPS payments. The data are organized by hospital. > > — *Source: CMS feed metadata* **Keywords:** Medicare, Original Medicare, Hospitals & Facilities, Inpatient, Health Care Use & Payments, Health Equity **Theme:** Medicare ## Coverage timeline 2013–2024 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data) 12 of 12 annual reporting periods present — no gaps. ## Release history | Reporting period | CMS published | Loaded | Latest file | | ----------------------- | ------------- | ---------- | ----------- | | 2024-01-01 – 2024-12-31 | 2026-04-23 | 2026-04-23 | ✓ | | 2023-01-01 – 2023-12-31 | 2025-05-22 | 2025-05-22 | | | 2022-01-01 – 2022-12-31 | 2024-06-04 | 2024-06-07 | | | 2022-01-01 – 2022-12-31 | 2024-06-04 | 2024-06-07 | | | 2021-01-01 – 2021-12-31 | 2023-05-24 | 2023-08-29 | | | 2021-01-01 – 2021-12-31 | 2023-05-10 | 2023-08-29 | | | 2020-01-01 – 2020-12-31 | 2023-05-10 | 2023-08-29 | | | 2020-01-01 – 2020-12-31 | 2023-05-10 | 2023-08-29 | | | 2019-01-01 – 2019-12-31 | 2023-05-10 | 2023-08-29 | | | 2019-01-01 – 2019-12-31 | 2023-05-10 | 2023-08-29 | |
Show 12 earlier file versions | Reporting period | CMS published | Loaded | Latest file | | ----------------------- | ------------- | ---------- | ----------- | | 2018-01-01 – 2018-12-31 | 2023-05-10 | 2023-08-29 | | | 2018-01-01 – 2018-12-31 | 2023-05-10 | 2023-08-29 | | | 2017-01-01 – 2017-12-31 | 2023-05-10 | 2023-08-29 | | | 2017-01-01 – 2017-12-31 | 2023-05-10 | 2023-08-29 | | | 2016-01-01 – 2016-12-31 | 2023-05-10 | 2023-08-29 | | | 2016-01-01 – 2016-12-31 | 2023-05-10 | 2023-08-29 | | | 2015-01-01 – 2015-12-31 | 2023-05-10 | 2023-08-29 | | | 2015-01-01 – 2015-12-31 | 2023-05-10 | 2023-08-29 | | | 2014-01-01 – 2014-12-31 | 2023-05-10 | 2023-08-29 | | | 2014-01-01 – 2014-12-31 | 2023-05-10 | 2023-08-29 | | | 2013-01-01 – 2013-12-31 | 2023-05-10 | 2023-08-29 | | | 2013-01-01 – 2013-12-31 | 2023-05-10 | 2023-08-29 | |
## Data dictionary
📋 78 data columns + 6 lineage columns **Data columns** | Column | Type | Description | | ---------------------------------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `RNDRNG_PRVDR_CCN` | NUMBER | | | `RNDRNG_PRVDR_ORG_NAME` | TEXT | | | `RNDRNG_PRVDR_ST` | TEXT | | | `RNDRNG_PRVDR_CITY` | TEXT | | | `RNDRNG_PRVDR_ZIP5` | TEXT | | | `RNDRNG_PRVDR_STATE_ABRVTN` | TEXT | | | `RNDRNG_PRVDR_STATE_FIPS` | NUMBER | | | `RNDRNG_PRVDR_RUCA` | NUMBER | | | `RNDRNG_PRVDR_RUCA_DESC` | TEXT | | | `TOT_BENES` | NUMBER | Total Medicare beneficiaries receiving services from the provider. | | `TOT_SUBMTD_CVRD_CHRG` | NUMBER | The total submitted charge of all provider services covered by Medicare. | | `TOT_PYMT_AMT` | NUMBER | The total payments to providers for the DRG including the MS-DRG amount, teaching, disproportionate share, capital, and outlier payments for all cases. | | `TOT_MDCR_PYMT_AMT` | NUMBER | The total amount that Medicare pays to the provider for Medicare's share of the MS-DRG. | | `TOT_DSCHRGS` | NUMBER | The number of discharges billed by the provider for inpatient hospital services. | | `TOT_CVRD_DAYS` | NUMBER | The total number of days of care, per provider, which were covered in full or in part by Hospital Insurance (HI) Medicare benefits. | | `TOT_DAYS` | NUMBER | The accumulated count of days, per provider, during which inpatient hospital services were furnished to a person eligible for Part A benefits under Medicare. | | `BENE_AVG_AGE` | NUMBER | The average age of Medicare enrollees who used a covered health care or medical service from the provider. | | `BENE_AGE_LT_65_CNT` | NUMBER | Number of beneficiaries under the age of 65. | | `BENE_AGE_65_74_CNT` | NUMBER | Number of beneficiaries between the ages of 65 and 74. | | `BENE_AGE_75_84_CNT` | NUMBER | Number of beneficiaries between the ages of 75 and 84. | | `BENE_AGE_GT_84_CNT` | NUMBER | Number of beneficiaries over the age of 84. | | `BENE_FEML_CNT` | NUMBER | Number of female beneficiaries. | | `BENE_MALE_CNT` | NUMBER | Number of male beneficiaries. | | `BENE_RACE_WHT_CNT` | NUMBER | Number of non-Hispanic white beneficiaries. | | `BENE_RACE_BLACK_CNT` | NUMBER | Number of non-Hispanic black or African American beneficiaries. | | `BENE_RACE_API_CNT` | NUMBER | Number of Asian Pacific Islander beneficiaries. | | `BENE_RACE_HSPNC_CNT` | NUMBER | Number of Hispanic beneficiaries. | | `BENE_RACE_NATIND_CNT` | NUMBER | Number of American Indian or Alaska Native beneficiaries. | | `BENE_RACE_OTHR_CNT` | NUMBER | Number of beneficiaries with race not elsewhere classified. | | `BENE_DUAL_CNT` | NUMBER | Number of Medicare beneficiaries qualified to receive Medicare and Medicaid benefits. | | `BENE_NDUAL_CNT` | NUMBER | Number of Medicare beneficiaries qualified to receive Medicare only benefits. | | `BENE_CC_BH_ADHD_OTHCD_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for ADHD and other conduct disorders. | | `BENE_CC_BH_ALCOHOL_DRUG_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithms for alcohol use disorder and/or drug use disorder. | | `BENE_CC_BH_TOBACCO_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for tobacco use disorders. | | `BENE_CC_BH_ALZ_NONALZDEM_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithms for Alzheimer's disease and/or non-Alzheimer's dementia. | | `BENE_CC_BH_ANXIETY_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for anxiety disorders. | | `BENE_CC_BH_BIPOLAR_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for bipolar disorders. | | `BENE_CC_BH_MOOD_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for depression and other depressive mood disorders. | | `BENE_CC_BH_DEPRESS_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for major depressive affective disorders. | | `BENE_CC_BH_PD_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for personality disorders. | | `BENE_CC_BH_PTSD_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for post-traumatic stress disorders. | | `BENE_CC_BH_SCHIZO_OTHPSY_V1_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for schizophrenia and other psychotic disorders. | | `BENE_CC_PH_ASTHMA_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithms for asthma. | | `BENE_CC_PH_AFIB_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for atrial fibrillation/flutter. | | `BENE_CC_PH_CANCER6_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithms for six cancer types. | | `BENE_CC_PH_CKD_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithms for chronic kidney disease. | | `BENE_CC_PH_COPD_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for COPD. | | `BENE_CC_PH_DIABETES_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for diabetes. | | `BENE_CC_PH_HF_NONIHD_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for heart failure/non-ischemic heart disease. | | `BENE_CC_PH_HYPERLIPIDEMIA_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for hyperlipidemia. | | `BENE_CC_PH_HYPERTENSION_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for hypertension. | | `BENE_CC_PH_ISCHEMICHEART_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for ischemic heart disease. | | `BENE_CC_PH_OSTEOPOROSIS_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for osteoporosis. | | `BENE_CC_PH_PARKINSON_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for Parkinson's disease/secondary parkinsonism. | | `BENE_CC_PH_ARTHRITIS_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for rheumatoid arthritis/osteoarthritis. | | `BENE_CC_PH_STROKE_TIA_V2_PCT` | NUMBER | Percent of beneficiaries meeting the CCW chronic condition algorithm for stroke/transient ischemic attack. | | `BENE_AVG_RISK_SCRE` | NUMBER | Average Hierarchical Condition Category (HCC) risk score of beneficiaries. | | `DRG_CD` | NUMBER | | | `DRG_DESC` | TEXT | | | `AVG_SUBMTD_CVRD_CHRG` | NUMBER | | | `AVG_TOT_PYMT_AMT` | NUMBER | | | `AVG_MDCR_PYMT_AMT` | NUMBER | | | `BENE_CC_AF_PCT` | NUMBER | | | `BENE_CC_ALZHMR_PCT` | NUMBER | | | `BENE_CC_ASTHMA_PCT` | NUMBER | | | `BENE_CC_CNCR_PCT` | NUMBER | | | `BENE_CC_CHF_PCT` | NUMBER | | | `BENE_CC_CKD_PCT` | NUMBER | | | `BENE_CC_COPD_PCT` | NUMBER | | | `BENE_CC_DPRSSN_PCT` | NUMBER | | | `BENE_CC_DBTS_PCT` | NUMBER | | | `BENE_CC_HYPLPDMA_PCT` | NUMBER | | | `BENE_CC_HYPRTNSN_PCT` | NUMBER | | | `BENE_CC_IHD_PCT` | NUMBER | | | `BENE_CC_OPO_PCT` | NUMBER | | | `BENE_CC_RAOA_PCT` | NUMBER | | | `BENE_CC_SZ_PCT` | NUMBER | | | `BENE_CC_STROK_PCT` | NUMBER | | **Lineage columns** (present on every feed table) | Column | Type | Description | | -------------- | -------------- | -------------------------------------------- | | `ROW_ID` | TEXT | Unique row ID for this table (PK) | | `FILE_ID` | TEXT | Source file — joins to `FEEDS_FILES.ID` (FK) | | `FILE_FEED_ID` | TEXT | Parent feed — joins to `FEEDS.ID` (FK) | | `FILE_NAME` | TEXT | Source file name as published by CMS | | `ROWNUM` | NUMBER | Row number within the source file | | `CREATED_AT` | TIMESTAMP\_NTZ | Timestamp when the record was loaded |
## Row-level lineage Every row in this table traces to the exact CMS source file that produced it. The `FILE_ID` column joins to the `FEEDS_FILES` catalog table, and `FILE_FEED_ID` joins to the `FEEDS` master table: ```mermaid erDiagram FEEDS ||--o{ FEEDS_FILES : "ID = FEED_ID" FEEDS ||--o{ MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER : "ID = FILE_FEED_ID" FEEDS_FILES ||--o{ MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER : "ID = FILE_ID" FEEDS { text ID PK text TITLE text VIEW_NAME text ACCURAL_PERIODICITY } FEEDS_FILES { text ID PK text FEED_ID FK date TEMPORAL_START date TEMPORAL_END date CMS_FEED_MODIFIED number IS_LATEST } MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER { text ROW_ID PK text FILE_ID FK text FILE_FEED_ID FK number RNDRNG_PRVDR_CCN text RNDRNG_PRVDR_ORG_NAME text RNDRNG_PRVDR_ST text RNDRNG_PRVDR_CITY number remaining_74_data_columns } ``` Trace any row back to its source file and reporting period: ```sql SELECT d.RNDRNG_PRVDR_CCN, d.RNDRNG_PRVDR_ORG_NAME, d.RNDRNG_PRVDR_ST, ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED FROM DWV.MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER d JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID; ``` ## Source & provenance Published by the **Centers for Medicare & Medicaid Services** (bureau 009:38). * [Official CMS data dictionary](https://data.cms.gov/resources/medicare-inpatient-hospitals-by-provider-data-dictionary) * [Medicare Inpatient Hospitals Methodology](https://data.cms.gov/resources/medicare-inpatient-hospitals-methodology) ## Frequently asked questions ### How often is Medicare Inpatient Hospitals - by Provider updated? Annually. CMS last published this feed on 2026-04-23, and Dataplex loaded it to the warehouse the same day. New releases are added automatically when CMS publishes them. ### What years does Medicare Inpatient Hospitals - by Provider cover? 2013 through 2024 — 12 annual reporting periods with no gaps. Each reporting year arrives as its own file version, and all years remain queryable side by side. ### How many records are in Medicare Inpatient Hospitals - by Provider? 1,877,420 rows across all 22 reporting periods. Because this feed is time-partitioned, the full table total is the meaningful count — no deduplication needed. ### How do I get Medicare Inpatient Hospitals - by Provider data? It's included in the CMS Data Feeds Dataset on the [Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) (free trial available) and via [Databricks Delta Sharing](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00). Once mounted, query `DWV.MEDICARE_INPATIENT_HOSPITALS__BY_PROVIDER` directly — no pipeline setup required. ## Related feeds {% content-ref url="/pages/dZ5a1Et93c7pLvaH9tnH" %} [Medicare Post-Acute Care & Hospice - by Geography and Provider](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-post-acute-care-hospice-by-geography-and-provider.md) {% endcontent-ref %} {% content-ref url="/pages/Xkl8SCGO1DkQlwkfPSPN" %} [Medicare Inpatient Hospitals - by Provider and Service](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-inpatient-hospitals-by-provider-and-service.md) {% endcontent-ref %} {% content-ref url="/pages/T4w8Iold4mu27PCDN72G" %} [Medicare Inpatient Hospitals - by Geography and Service](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-inpatient-hospitals-by-geography-and-service.md) {% endcontent-ref %} {% content-ref url="/pages/vSHuyZ1yd8hv11QUlJFL" %} [Medicare Post-Acute Care and Hospice - by Geography & Provider](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-post-acute-care-and-hospice-by-geography-provider.md) {% endcontent-ref %} {% content-ref url="/pages/JIweaKlMmPFgOCJAFYXv" %} [Medicare Post-Acute Care Utilization - Long-Term Care Hospital by Geography and Provider](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-post-acute-care-utilization-long-term-care-hospital-by-geography-and-provider.md) {% endcontent-ref %} ## Get this feed 1. [Start a free trial on Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZT1Z125KDH/dataplex-consulting-data-products-cms-data-feeds-dataset) or purchase via [Databricks](https://checkout.dataplex-consulting.com/b/3cIdR2e1J59Sh2w7pWbQY00) 2. Mount the share — the database and `DWV` schema appear in your account immediately 3. Run the [sample query](#sample-queries) above — no ETL, no pipeline maintenance Questions about this feed? Contact us at . *** Part of the [CMS Data Feeds Dataset](/data-catalog/cms-data-feeds-dataset.md) — 280+ feeds · 245B+ records · updated daily. [Back to the full catalog →](/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog.md#medicare-inpatient-hospitals-by-provider) --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.dataplex-consulting.com/data-catalog/cms-data-feeds-dataset/cms-data-feeds-catalog/medicare-inpatient-hospitals-by-provider.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.