# CMS monthly state Medicaid and CHIP enrollment operations

`medicare_silver.cms_medicaid_chip_enrollment_monthly_state` · State programs · status live · 11,118 rows

Source-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.** One state or District of Columbia row per reporting period and publisher preliminary or updated/final revision.

| 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 |  |

Tools that read it: get_medicaid_mco_enrollment

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.cms_medicaid_chip_enrollment_monthly_state WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.cms_medicaid_chip_enrollment_monthly_state")` first.