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 indicators related to key application, eligibility, and enrollment processes within the state Medicaid and Children’s Health Insurance Programs (CHIP). These data reflect enrollment activity for all populations receiving comprehensive Medicaid and CHIP benefits in all states, as well as state program performance.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-02T14:16:11.471616
Tags: child-enrollment, eligibility-determinations

Tables

State Medicaid And CHIP Test

@usgov.hhs_gov_state_medicaid_and_chip_test.state_medicaid_and_chip_test

575.63 kB
9,588 rows
44 columns

CREATE TABLE state_medicaid_and_chip_test (
  "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
);