About this Dataset

State Medicaid And CHIP-test

All states (including the District of Columbia) are required to provide data to The Centers for Medicare & Medicaid Services (CMS) on a range of Medicaid and Children’s Health Insurance Program (CHIP) indicators related to key application, eligibility, enrollment and call center processes. These data reflect enrollment activity for all populations receiving comprehensive Medicaid and CHIP benefits in all states, as well as state program performance.
States submit this data via the Performance Indicator dataset. Further information about this dataset is available at: https://www.medicaid.gov/medicaid/national-medicaid-chip-program-information/medicaid-chip-enrollment-data/performance-indicator-technical-assistance/index.html.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-08-30T20:05:24.684005
Tags: child-enrollment

Tables

Table 1

@usgov.hhs_gov_state_medicaid_and_chip_test_4933f.table_1

590.75 kB
9,792 rows
44 columns

CREATE TABLE table_1 (
  "state_abbreviation" VARCHAR,
  "state_name" VARCHAR,
  "reporting_period" BIGINT,
  "state_expanded_medicaid" VARCHAR,
  "preliminary_or_updated" VARCHAR,
  "final_report" VARCHAR,
  "new_applications_submitted_to_medicaid_and_chip_agencies" DOUBLE,
  "new_applications_submitted_to_medicaid_and_chip_agenci_c83d6010" VARCHAR  -- New Applications Submitted To Medicaid And CHIP Agencies - Footnotes,
  "applications_for_financial_assistance_submitted_to_the_9dbe30d8" DOUBLE  -- Applications For Financial Assistance Submitted To The State Based Marketplace,
  "applications_for_financial_assistance_submitted_to_the_b38de148" VARCHAR  -- Applications For Financial Assistance Submitted To The State Based Marketplace - Footnotes,
  "total_applications_for_financial_assistance_submitted__765a0bfe" DOUBLE  -- Total Applications For Financial Assistance Submitted At State Level,
  "total_applications_for_financial_assistance_submitted__af362b0d" VARCHAR  -- Total Applications For Financial Assistance Submitted At State Level - Footnotes,
  "individuals_determined_eligible_for_medicaid_at_application" DOUBLE,
  "individuals_determined_eligible_for_medicaid_at_applic_b82cb7e2" VARCHAR  -- Individuals Determined Eligible For Medicaid At Application - Footnotes,
  "individuals_determined_eligible_for_chip_at_application" DOUBLE,
  "individuals_determined_eligible_for_chip_at_applicatio_111c135d" VARCHAR  -- Individuals Determined Eligible For CHIP At Application - Footnotes,
  "total_medicaid_and_chip_determinations" DOUBLE,
  "total_medicaid_and_chip_determinations_footnotes" VARCHAR  -- Total Medicaid And CHIP Determinations - Footnotes,
  "medicaid_and_chip_child_enrollment" DOUBLE,
  "medicaid_and_chip_child_enrollment_footnotes" VARCHAR  -- Medicaid And CHIP Child Enrollment - Footnotes,
  "total_medicaid_and_chip_enrollment" DOUBLE,
  "total_medicaid_and_chip_enrollment_footnotes" VARCHAR  -- Total Medicaid And CHIP Enrollment - Footnotes,
  "total_medicaid_enrollment" DOUBLE,
  "total_medicaid_enrollment_footnotes" VARCHAR  -- Total Medicaid Enrollment - Footnotes,
  "total_chip_enrollment" DOUBLE,
  "total_chip_enrollment_footnotes" VARCHAR  -- Total CHIP Enrollment - Footnotes,
  "total_adult_medicaid_enrollment" DOUBLE,
  "total_adult_medicaid_enrollment_footnotes" VARCHAR  -- Total Adult Medicaid Enrollment - Footnotes,
  "total_medicaid_and_chip_determinations_processed_in_le_028359a6" DOUBLE  -- Total Medicaid And CHIP Determinations Processed In Less Than 24 Hours,
  "total_medicaid_and_chip_determinations_processed_in_le_24d23b5f" VARCHAR  -- Total Medicaid And CHIP Determinations Processed In Less Than 24 Hours - Footnotes,
  "total_medicaid_and_chip_determinations_processed_betwe_479dc6ad" DOUBLE  -- Total Medicaid And CHIP Determinations Processed Between 24 Hours And 7 Days,
  "total_medicaid_and_chip_determinations_processed_betwe_cd6caba6" VARCHAR  -- Total Medicaid And CHIP Determinations Processed Between 24 Hours And 7 Days - Footnotes,
  "total_medicaid_and_chip_determinations_processed_betwe_a75a2185" DOUBLE  -- Total Medicaid And CHIP Determinations Processed Between 8 Days And 30 Days,
  "total_medicaid_and_chip_determinations_processed_betwe_bf7cedc0" VARCHAR  -- Total Medicaid And CHIP Determinations Processed Between 8 Days And 30 Days - Footnotes,
  "total_medicaid_and_chip_determinations_processed_betwe_dc9af9f9" DOUBLE  -- Total Medicaid And CHIP Determinations Processed Between 31 Days And 45 Days,
  "total_medicaid_and_chip_determinations_processed_betwe_4c205e0b" VARCHAR  -- Total Medicaid And CHIP Determinations Processed Between 31 Days And 45 Days - Footnotes,
  "total_medicaid_and_chip_determinations_processed_in_mo_22fcc2c7" DOUBLE  -- Total Medicaid And CHIP Determinations Processed In More Than 45 Days,
  "total_medicaid_and_chip_determinations_processed_in_mo_2eb31ed8" VARCHAR  -- Total Medicaid And CHIP Determinations Processed In More Than 45 Days - Footnotes,
  "total_call_center_volume_number_of_calls" DOUBLE  -- Total Call Center Volume (Number Of Calls),
  "total_call_center_volume_number_of_calls_footnotes" VARCHAR  -- Total Call Center Volume (Number Of Calls) - Footnotes,
  "average_call_center_wait_time_minutes" DOUBLE  -- Average Call Center Wait Time (Minutes),
  "average_call_center_wait_time_minutes_footnotes" VARCHAR  -- Average Call Center Wait Time (Minutes) - Footnotes,
  "average_call_center_abandonment_rate" DOUBLE,
  "average_call_center_abandonment_rate_footnotes" VARCHAR  -- Average Call Center Abandonment Rate - Footnotes
);