sbm-january-2024-release.xlsx

sbm-january-2024-release.xlsx

주의! 엑셀 파일의 첫 행이 컬럼명이 아니거나, 시트가 1개 이상입니다.

테이블 미리보기 준비 중...

전체 화면 보기

항목
파일명 sbm-january-2024-release.xlsx
파일 포맷 XLSX
설명 sbm-january-2024-release.xlsx
데이터셋 설명

Metrics from individual Marketplaces during the current reporting period. The report includes data for the states using State-based Marketplaces (SBMs) that use their own eligibility and enrollment platforms

Source: State-based Marketplace (SBM) operational data submitted to CMS. Each monthly reporting period occurs during the first through last day of the reported month. For April, Idaho’s reporting period was from February 1, 2023 to April 30, 2023. April data include the following SBMs: Connecticut, Idaho, Kentucky, Maine, Maryland, Massachusetts, Minnesota, Nevada, New Jersey, New Mexico, Pennsylvania, Vermont, and Washington. May data include the previous SBMs and the following new SBMs: Colorado, District of Columbia, New York, and Rhode Island. June data include the previous SBMs and the following new SBM: California. The following data through October include all previous SBMs. Some SBMs did not receive applicable applications during certain reporting period months. Some SBMs may revise data from a prior month and thus these data may not align with data previously reported.


Notes:

  1. This table represents consumers whose Medicaid/CHIP coverage was denied or terminated following renewal and 1) whose applications were processed by an SBM through an integrated Medicaid, CHIP, and Marketplace eligibility system or 2) whose applications/information was sent by a state Medicaid or CHIP agency to an SBM through an account transfer process. Consumers who submitted applications to an SBM that can be matched to a Medicaid/CHIP record are also included. See the ""Data Sources and Metrics Definition Overview"" at http://www.medicaid.gov for a full description of the differences between the SBM operating systems and resulting data metrics, measure definitions, and general data limitations. As of the September 2023 report, this table was updated to differentiate between SBMs with an integrated Medicaid, CHIP, and Marketplace eligibility system and those with an account transfer process to better represent the percentage of QHP selections in relation to applicable consumers received and processed by the relevant SBM. State-specific variations are: - Maine’s data and Nevada’s April and May data report all applications with Medicaid/CHIP denials or terminations, not only those part of the annual renewal process. - Connecticut, Massachusetts, and Washington also report applications with consumers determined ineligible for Medicaid/CHIP due to procedural reasons. - Minnesota and New York report on eligibility and enrollment for their Basic Health Programs. - Idaho’s April data on consumers eligible for a QHP with financial assistance does not depict a direct correlation to consumers with a QHP selection. - Pennsylvania conducts automatic QHP eligibility determinations for Marketplace plans for some account transfers. As of the December 2023 report, Pennsylvania revised its data to report those consumers in the account transfer and application metrics. - Only SBMs with an automatic plan assignment process have and report automatic QHP selections. These SBMs make automatic plan assignments into a QHP for a subset of individuals and provide a notification of options regarding active selection of an alternative plan and/or, if applicable, making the first month’s premium payment.
  2. SBMs report on all applicable applications received and not on the Medicaid-defined cohorts of individuals whose renewal is due in a given month. The data in this table are not cumulative and counts unique Marketplace activities during the reporting period month in which the relevant activity occurs. As such, activities by any one consumer may be included across reporting months. For example, a consumer who submits an application and receives a determination of QHP eligibility may be counted in one month but his/her plan selection could be counted in a later month. Thus, the percentages do not nec
url 파일 다운로드 (안 되면 원본 페이지에서 다운 받으세요)
원본 페이지 https://catalog.data.gov/dataset/state-based-marketplace-sbm-medicaid-unwinding-report-88f6f
버전 2024-02-14
파일 크기50 KB
행 수 190
컬럼 수27


import pandas as pd

df = pd.read_excel('sbm-january-2024-release.xlsx', header=1)

컬럼 타입 샘플
Unnamed: 0 string 7b
State-based Marketplace (SBM) Medicaid Unwinding Report string State
Unnamed: 2 string Metric
Unnamed: 3 string April 2023: Count
Unnamed: 4 string April 2023: Percentage (Applications) a
Unnamed: 5 string April 2023: Percentage (Account Transfers) b
Unnamed: 6 string May 2023: Count
Unnamed: 7 string May 2023: Percentage (Applications) a
Unnamed: 8 string May 2023: Percentage (Account Transfers) b
Unnamed: 9 string June 2023: Count
Unnamed: 10 string June 2023: Percentage (Applications) a
Unnamed: 11 string June 2023: Percentage (Account Transfers) b
Unnamed: 12 string July 2023: Count
Unnamed: 13 string July 2023: Percentage (Applications) a
Unnamed: 14 string July 2023: Percentage (Account Transfers) b
Unnamed: 15 string August 2023: Count
Unnamed: 16 string August 2023: Percentage (Applications) a
Unnamed: 17 string August 2023: Percentage (Account Transfers) b
Unnamed: 18 string September 2023: Count
Unnamed: 19 string September 2023: Percentage (Applications) a
Unnamed: 20 string September 2023: Percentage (Account Transfers) b
Unnamed: 21 string October 2023: Count
Unnamed: 22 string October 2023: Percentage (Applications) a
Unnamed: 23 string October 2023: Percentage (Account Transfers) b
Unnamed: 24 string Total: Count
Unnamed: 25 string Total: Percentage (Applications) a
Unnamed: 26 string Total: Percentage (Account Transfers) b

항목
생성일시 2024-02-20T22:07:38.490789
아이디 e890b9de-2c6f-43c9-9ff4-5a0597bc1b7b
key 5a99544f-e480-4d63-ba99-d974c993011e
메타데이터 수정일시 2024-02-29T06:22:22.777548
MIME 타입 application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
데이터셋 아이디 0020e988-9e9c-4c16-90d8-2a8a89cfe834
상태 active
url https://download.medicaid.gov/data/sbm-january-2024-release.xlsx