State programs

CMS monthly state Medicaid and CHIP enrollment operations

medicare_silver.cms_medicaid_chip_enrollment_monthly_state·live·silver

Rows

11,118

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Source-faithful monthly state applications, eligibility determinations, enrollment, application-processing, and call-center measures from the current CMS portal distribution, retaining preliminary and updated revisions, final-report status, exact metric footnotes, latest-revision flags, semantic row hashes, and Bronze lineage.

Grain

Key	Grain
N/A	1One state or District of Columbia row per reporting period and publisher preliminary or updated/final revision.

Columns (66)

Column	Type	Meaning
`source_row_number`	int
`reporting_period`	int
`reporting_year`	int
`reporting_month`	int
`reporting_period_date`	date
`state_abbreviation`	string
`state_name`	string
`state_expanded_medicaid`	string
`report_revision`	string
`final_report`	string
`is_final_report`	boolean
`is_latest_revision`	boolean
`new_applications_submitted_to_medicaid_and_chip_agencies`	bigint
`applications_for_financial_assistance_submitted_to_the_state_based_marketplace`	bigint
`total_applications_for_financial_assistance_submitted_at_state_level`	bigint
`individuals_determined_eligible_for_medicaid_at_application`	bigint
`individuals_determined_eligible_for_chip_at_application`	bigint
`total_medicaid_and_chip_determinations`	bigint
`medicaid_and_chip_child_enrollment`	bigint
`total_medicaid_and_chip_enrollment`	bigint
`total_medicaid_enrollment`	bigint
`total_chip_enrollment`	bigint
`total_medicaid_adult_enrollment`	bigint
`total_medicaid_and_chip_determinations_processed_in_less_than_24_hours`	bigint
`total_medicaid_and_chip_determinations_processed_between_24_hours_and_7_days`	bigint
`total_medicaid_and_chip_determinations_processed_between_8_days_and_30_days`	bigint
`total_medicaid_and_chip_determinations_processed_between_31_days_and_45_days`	bigint
`total_medicaid_and_chip_determinations_processed_in_more_than_45_days`	bigint
`total_call_center_volume`	bigint
`average_call_center_wait_time`	bigint
`average_call_center_abandonment_rate`	double
`new_applications_submitted_to_medicaid_and_chip_agencies_footnotes`	string
`applications_for_financial_assistance_submitted_to_the_state_based_marketplace_footnotes`	string
`total_applications_for_financial_assistance_submitted_at_state_level_footnotes`	string
`individuals_determined_eligible_for_medicaid_at_application_footnotes`	string
`individuals_determined_eligible_for_chip_at_application_footnotes`	string
`total_medicaid_and_chip_determinations_footnotes`	string
`medicaid_and_chip_child_enrollment_footnotes`	string
`total_medicaid_and_chip_enrollment_footnotes`	string
`total_medicaid_enrollment_footnotes`	string
`total_chip_enrollment_footnotes`	string
`total_medicaid_adult_enrollment_footnotes`	string
`total_medicaid_and_chip_determinations_processed_in_less_than_24_hours_footnotes`	string
`total_medicaid_and_chip_determinations_processed_between_24_hours_and_7_days_footnotes`	string
`total_medicaid_and_chip_determinations_processed_between_8_days_and_30_days_footnotes`	string
`total_medicaid_and_chip_determinations_processed_between_31_days_and_45_days_footnotes`	string
`total_medicaid_and_chip_determinations_processed_in_more_than_45_days_footnotes`	string
`total_call_center_volume_footnotes`	string
`average_call_center_wait_time_footnotes`	string
`average_call_center_abandonment_rate_footnotes`	string
`semantic_row_sha256`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

describe_data_source(source_fqn="medicare_silver.cms_medicaid_chip_enrollment_monthly_state")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.cms_medicaid_chip_enrollment_monthly_state WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	get_medicaid_mco_enrollment
Identity key	`observed_period,state_abbreviation,report_revision,final_report`
Join	`how_to_join(source_fqn="medicare_silver.cms_medicaid_chip_enrollment_monthly_state")`
Raw door	Athena (read-only via query_substrate): medicare_silver.cms_medicaid_chip_enrollment_monthly_state

This page as markdown: /docs-md/data/medicare_silver_cms_medicaid_chip_enrollment_monthly_state.md · every page in one file: /llms-full.txt