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

562.14 KB
9588 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,
  "applications_for_financial_assistance_submitted_to_the_9dbe30d8" DOUBLE,
  "applications_for_financial_assistance_submitted_to_the_b38de148" VARCHAR,
  "total_applications_for_financial_assistance_submitted__765a0bfe" DOUBLE,
  "total_applications_for_financial_assistance_submitted__af362b0d" VARCHAR,
  "individuals_determined_eligible_for_medicaid_at_application" DOUBLE,
  "individuals_determined_eligible_for_medicaid_at_applic_b82cb7e2" VARCHAR,
  "individuals_determined_eligible_for_chip_at_application" DOUBLE,
  "individuals_determined_eligible_for_chip_at_applicatio_111c135d" VARCHAR,
  "total_medicaid_and_chip_determinations" DOUBLE,
  "total_medicaid_and_chip_determinations_footnotes" VARCHAR,
  "medicaid_and_chip_child_enrollment" DOUBLE,
  "medicaid_and_chip_child_enrollment_footnotes" VARCHAR,
  "total_medicaid_and_chip_enrollment" DOUBLE,
  "total_medicaid_and_chip_enrollment_footnotes" VARCHAR,
  "total_medicaid_enrollment" DOUBLE,
  "total_medicaid_enrollment_footnotes" VARCHAR,
  "total_chip_enrollment" DOUBLE,
  "total_chip_enrollment_footnotes" VARCHAR,
  "total_adult_medicaid_enrollment" DOUBLE,
  "total_adult_medicaid_enrollment_footnotes" VARCHAR,
  "total_medicaid_and_chip_determinations_processed_in_le_028359a6" DOUBLE,
  "total_medicaid_and_chip_determinations_processed_in_le_24d23b5f" VARCHAR,
  "total_medicaid_and_chip_determinations_processed_betwe_479dc6ad" DOUBLE,
  "total_medicaid_and_chip_determinations_processed_betwe_cd6caba6" VARCHAR,
  "total_medicaid_and_chip_determinations_processed_betwe_a75a2185" DOUBLE,
  "total_medicaid_and_chip_determinations_processed_betwe_bf7cedc0" VARCHAR,
  "total_medicaid_and_chip_determinations_processed_betwe_dc9af9f9" DOUBLE,
  "total_medicaid_and_chip_determinations_processed_betwe_4c205e0b" VARCHAR,
  "total_medicaid_and_chip_determinations_processed_in_mo_22fcc2c7" DOUBLE,
  "total_medicaid_and_chip_determinations_processed_in_mo_2eb31ed8" VARCHAR,
  "total_call_center_volume_number_of_calls" DOUBLE,
  "total_call_center_volume_number_of_calls_footnotes" VARCHAR,
  "average_call_center_wait_time_minutes" DOUBLE,
  "average_call_center_wait_time_minutes_footnotes" VARCHAR,
  "average_call_center_abandonment_rate" DOUBLE,
  "average_call_center_abandonment_rate_footnotes" VARCHAR
);