2020 Managed Care Programs By State

CREATE TABLE table_1 (
  "features" VARCHAR,
  "program_type" VARCHAR,
  "statewide_or_region_specific" VARCHAR  -- Statewide Or Region-specific?,
  "federal_operating_authority" VARCHAR,
  "program_start_date" TIMESTAMP,
  "waiver_expiration_date_if_applicable" VARCHAR  -- Waiver Expiration Date (if Applicable),
  "if_the_program_ended_in_2020_indicate_the_end_date" VARCHAR  -- If The Program Ended In 2020, Indicate The End Date,
  "populations_enrolled_low_income_adults_not_covered_und_a9c3caa7" VARCHAR  -- Populations Enrolled: Low-income Adults Not Covered Under ACA Section VIII (excludes Pregnant Women And People With Disabilities),
  "populations_enrolled_low_income_adults_covered_under_a_e511fc36" VARCHAR  -- Populations Enrolled: Low-income Adults Covered Under ACA Section VIII (excludes Pregnant Women And People With Disabilities),
  "populations_enrolled_aged_blind_or_disabled_children_or_adults" VARCHAR  -- Populations Enrolled: Aged, Blind Or Disabled Children Or Adults,
  "populations_enrolled_non_disabled_children_excludes_ch_c24d2960" VARCHAR  -- Populations Enrolled: Non-Disabled Children (excludes Children In Foster Care Or Receiving Adoption Assistance),
  "populations_enrolled_individuals_receiving_limited_ben_641f34d0" VARCHAR  -- Populations Enrolled: Individuals Receiving Limited Benefits (excludes Partial Duals),
  "populations_enrolled_full_duals" VARCHAR  -- Populations Enrolled: Full Duals,
  "populations_enrolled_children_with_special_health_care_needs" VARCHAR  -- Populations Enrolled: Children With Special Health Care Needs,
  "populations_enrolled_native_american_alaskan_natives" VARCHAR  -- Populations Enrolled: Native American/Alaskan Natives,
  "populations_enrolled_foster_care_and_adoption_assistan_54000bb1" VARCHAR  -- Populations Enrolled: Foster Care And Adoption Assistance Children,
  "populations_enrolled_enrollment_choice_period" VARCHAR  -- Populations Enrolled: Enrollment Choice Period,
  "populations_enrolled_enrollment_broker_name_if_applicable" VARCHAR  -- Populations Enrolled: Enrollment Broker Name (if Applicable),
  "populations_enrolled_notes_on_enrollment_choice_period" VARCHAR  -- Populations Enrolled: Notes On Enrollment Choice Period,
  "benefits_covered_inpatient_hospital_physical_health" VARCHAR  -- Benefits Covered: Inpatient Hospital Physical Health,
  "benefits_covered_inpatient_hospital_behavioral_health__ac3432fc" VARCHAR  -- Benefits Covered: Inpatient Hospital Behavioral Health (MH And/or SUD),
  "benefits_covered_outpatient_hospital_physical_health" VARCHAR  -- Benefits Covered: Outpatient Hospital Physical Health,
  "benefits_covered_outpatient_hospital_behavioral_health_a7224562" VARCHAR  -- Benefits Covered: Outpatient Hospital Behavioral Health (MH And/or SUD),
  "benefits_covered_partial_hospitalization" VARCHAR  -- Benefits Covered: Partial Hospitalization,
  "benefits_covered_physician" VARCHAR  -- Benefits Covered: Physician,
  "benefits_covered_nurse_practitioner" VARCHAR  -- Benefits Covered: Nurse Practitioner,
  "benefits_covered_rural_health_clinics_and_fqhcs" VARCHAR  -- Benefits Covered: Rural Health Clinics And FQHCs,
  "benefits_covered_clinic_services" VARCHAR  -- Benefits Covered: Clinic Services,
  "benefits_covered_lab_and_x_ray" VARCHAR  -- Benefits Covered: Lab And X-ray,
  "benefits_covered_prescription_drugs" VARCHAR  -- Benefits Covered: Prescription Drugs,
  "benefits_covered_prosthetic_devices" VARCHAR  -- Benefits Covered: Prosthetic Devices,
  "benefits_covered_epsdt" VARCHAR  -- Benefits Covered: EPSDT,
  "benefits_covered_case_management" VARCHAR  -- Benefits Covered: Case Management,
  "benefits_covered_ssa_section_1945_authorized_health_home" VARCHAR  -- Benefits Covered: SSA Section 1945-authorized Health Home,
  "benefits_covered_home_health_services_services_in_home" VARCHAR  -- Benefits Covered: Home Health Services (services In Home),
  "benefits_covered_family_planning" VARCHAR  -- Benefits Covered: Family Planning,
  "benefits_covered_dental_services_medical_surgical" VARCHAR  -- Benefits Covered: Dental Services (medical/surgical),
  "benefits_covered_dental_preventative_or_corrective" VARCHAR  -- Benefits Covered: Dental (preventative Or Corrective),
  "benefits_covered_personal_care_state_plan_option" VARCHAR  -- Benefits Covered: Personal Care (state Plan Option),
  "benefits_covered_hcbs_waiver_services" VARCHAR  -- Benefits Covered: HCBS Waiver Services,
  "benefits_covered_private_duty_nursing" VARCHAR  -- Benefits Covered: Private Duty Nursing,
  "benefits_covered_icf_idd" VARCHAR  -- Benefits Covered: ICF-IDD,
  "benefits_covered_nursing_facility_services" VARCHAR  -- Benefits Covered: Nursing Facility Services,
  "benefits_covered_hospice_care" VARCHAR  -- Benefits Covered: Hospice Care,
  "benefits_covered_non_emergency_medical_transportation" VARCHAR  -- Benefits Covered: Non-Emergency Medical Transportation,
  "benefits_covered_institution_for_mental_disease_inpati_173bf22f" VARCHAR  -- Benefits Covered: Institution For Mental Disease Inpatient Treatment For People Ages 21-64 Defined By 42 CFR 438.6(e) As An 'in Lieu Of' Benefit,
  "benefits_covered_other_e_g_nurse_midwife_services_free_8cdd8730" VARCHAR  -- Benefits Covered: Other (e.g., Nurse Midwife Services, Freestanding Birth Centers, Podiatry, Etc.),
  "quality_assurance_and_improvement_hedis_data_required" VARCHAR  -- Quality Assurance And Improvement: HEDIS Data Required?,
  "quality_assurance_and_improvement_cahps_data_required" VARCHAR  -- Quality Assurance And Improvement: CAHPS Data Required?,
  "quality_assurance_and_improvement_accreditation_required" VARCHAR  -- Quality Assurance And Improvement: Accreditation Required?,
  "quality_assurance_and_improvement_accrediting_organization" VARCHAR  -- Quality Assurance And Improvement: Accrediting Organization,
  "quality_assurance_and_improvement_eqro_contractor_name_4cfef99d" VARCHAR  -- Quality Assurance And Improvement: EQRO Contractor Name (if Applicable),
  "performance_incentives_payment_bonuses_differentials_t_7801f53e" VARCHAR  -- Performance Incentives: Payment Bonuses/differentials To Reward Plans,
  "performance_incentives_preferential_auto_enrollment_to_8c0fea09" VARCHAR  -- Performance Incentives: Preferential Auto-enrollment To Reward Plans,
  "performance_incentives_public_reports_comparing_plan_p_3d75e22e" VARCHAR  -- Performance Incentives: Public Reports Comparing Plan Performance On Key Metrics,
  "performance_incentives_withholds_tied_to_performance_metrics" VARCHAR  -- Performance Incentives: Withholds Tied To Performance Metrics,
  "performance_incentives_mcos_phps_required_or_encourage_ab3dfb9f" VARCHAR  -- Performance Incentives: MCOs/PHPs Required Or Encouraged To Pay Providers For Value/quality Outcomes,
  "participating_plans_plans_in_program" VARCHAR  -- Participating Plans: Plans In Program,
  "notes_program_notes" VARCHAR  -- Notes: Program Notes,
  "state" VARCHAR
);