Testnewdataset10302025

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
);