About this Dataset

CHIP Applications, Eligibility Determinations, And Enrollment Data

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: 2022-04-28T23:37:01.688180
Tags: applications, child-enrollment, chip, eligibility-determinations, enrollment, medicaid

Tables

State Medicaid And CHIP Applications, Eligibility Determinations, And Enrollment Data-09012021

@usgov.hhs_gov_state_medicaid_and_chip_applications_eligibili_0a33404e.state_medicaid_and_chip_applications_eligibility_deter_147da0cd

277.54 kB
5,567 rows
26 columns

CREATE TABLE state_medicaid_and_chip_applications_eligibility_deter_147da0cd (
  "state_abbreviation" VARCHAR,
  "state_name" VARCHAR,
  "report_date" TIMESTAMP,
  "state_expanded_medicaid" VARCHAR,
  "preliminary_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
);