Dataset: Monthly Enrollment - Test

About this Dataset

Monthly Enrollment - 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-05-25T07:41:17.860889
Tags: child-enrollment

Tables

Table 1

@usgov.hhs_gov_monthly_enrollment_test.table_1

547.83 KB
9384 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,
  "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
);