REACH ACOs
U.S. Department of Health & Human Services
@usgov.hhs_gov_reach_acos
U.S. Department of Health & Human Services
@usgov.hhs_gov_reach_acos
The REACH Accountable Care Organizations (ACOs) dataset provides overview information on REACH ACOs including their name, number of years in the program, and contact information of key personnel.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:26:03.384677
Tags: accountable-care-organizations, coordinated-care, medicare, original-medicare, payment-models, value-based-care
CREATE TABLE reach_acos_2021_04_28 (
"aco_id" VARCHAR,
"aco_name" VARCHAR,
"aco_type" VARCHAR,
"model_start_year" BIGINT,
"perf_year" BIGINT,
"risk_arrangement" VARCHAR,
"stop_loss_election" VARCHAR,
"capitation_arrangement" VARCHAR,
"enhanced_pcc_election" VARCHAR,
"apo_election" VARCHAR,
"alignment_plus" VARCHAR,
"telehealth_waiver" VARCHAR,
"pdhv_waiver" VARCHAR,
"snf_waiver" VARCHAR,
"cmhv_waiver" VARCHAR,
"homeboundhh_waiver" VARCHAR,
"hospicecc_waiver" VARCHAR,
"aco_address" VARCHAR,
"aco_public_reporting_website" VARCHAR,
"aco_exec_name" VARCHAR,
"aco_exec_email" VARCHAR,
"aco_exec_phone" VARCHAR,
"aco_public_contact_name" VARCHAR,
"aco_public_contact_email" DOUBLE,
"aco_public_contact_phone" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR
);CREATE TABLE reach_acos_2022_12_01 (
"entity_id" VARCHAR,
"performance_year" VARCHAR,
"agreement_start_date_cohort" VARCHAR -- Agreement Start Date(Cohort),
"entity_legal_business_name" VARCHAR,
"entity_type" VARCHAR,
"agreement_option" VARCHAR,
"service_areas" VARCHAR,
"street_address" VARCHAR,
"apt_suite" VARCHAR,
"city" VARCHAR,
"state_territory" VARCHAR,
"zip_code" BIGINT,
"zip_code_4" DOUBLE,
"website" VARCHAR,
"phone" VARCHAR,
"alignment_frequency" VARCHAR,
"payment_mechanism" VARCHAR,
"stop_loss_selected" VARCHAR,
"enhanced_pcc" VARCHAR -- Enhanced PCC%,
"care_management_home_visit" VARCHAR,
"chronic_disease_management_reward_bei" VARCHAR -- Chronic Disease Management Reward(BEI),
"concurrent_care_for_hospice_beneficiaries" VARCHAR,
"cost_sharing_for_part_b_services_bei" VARCHAR -- Cost Sharing For Part B Services(BEI),
"home_health_homebound_waiver" VARCHAR,
"nurse_practitioner_services" VARCHAR,
"post_discharge_home_visit" VARCHAR,
"skilled_nursing_facility_snf_3_day_stay_waiver" VARCHAR -- Skilled Nursing Facility(SNF) 3-Day Stay Waiver,
"telehealth" VARCHAR,
"provisional_reconciliation" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR,
"aco_executive_name_1" VARCHAR,
"aco_executive_phone_1" VARCHAR,
"aco_executive_email_1" VARCHAR,
"aco_executive_name_2" VARCHAR,
"aco_executive_phone_2" VARCHAR,
"aco_executive_email_2" VARCHAR,
"aco_executive_name_3" VARCHAR,
"aco_executive_phone_3" VARCHAR,
"aco_executive_email_3" VARCHAR
);CREATE TABLE reach_acos_2023_01_01 (
"entity_id" VARCHAR,
"performance_year" VARCHAR,
"agreement_start_date_cohort" VARCHAR -- Agreement Start Date(Cohort),
"entity_legal_business_name" VARCHAR,
"entity_type" VARCHAR,
"agreement_option" VARCHAR,
"service_areas" VARCHAR,
"street_address" VARCHAR,
"apt_suite" VARCHAR,
"city" VARCHAR,
"state_territory" VARCHAR,
"zip_code" BIGINT,
"zip_code_4" DOUBLE,
"website" VARCHAR,
"phone" VARCHAR,
"alignment_frequency" VARCHAR,
"payment_mechanism" VARCHAR,
"stop_loss_selected" VARCHAR,
"enhanced_pcc" VARCHAR -- Enhanced PCC%,
"care_management_home_visit" VARCHAR,
"chronic_disease_management_reward_bei" VARCHAR -- Chronic Disease Management Reward(BEI),
"concurrent_care_for_hospice_beneficiaries" VARCHAR,
"cost_sharing_for_part_b_services_bei" VARCHAR -- Cost Sharing For Part B Services(BEI),
"home_health_homebound_waiver" VARCHAR,
"nurse_practitioner_services" VARCHAR,
"post_discharge_home_visit" VARCHAR,
"skilled_nursing_facility_snf_3_day_stay_waiver" VARCHAR -- Skilled Nursing Facility(SNF) 3-Day Stay Waiver,
"telehealth" VARCHAR,
"provisional_reconciliation" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR,
"aco_executive_name_1" VARCHAR,
"aco_executive_phone_1" VARCHAR,
"aco_executive_email_1" VARCHAR,
"aco_executive_name_2" VARCHAR,
"aco_executive_phone_2" VARCHAR,
"aco_executive_email_2" VARCHAR,
"aco_executive_name_3" VARCHAR,
"aco_executive_phone_3" VARCHAR,
"aco_executive_email_3" VARCHAR
);CREATE TABLE reach_acos_2024_01_01 (
"entity_id" VARCHAR,
"performance_year" VARCHAR,
"agreement_start_date_cohort" VARCHAR -- Agreement Start Date(Cohort),
"entity_legal_business_name" VARCHAR,
"entity_type" VARCHAR,
"agreement_option" VARCHAR,
"service_areas" VARCHAR,
"street_address" VARCHAR,
"apt_suite" VARCHAR,
"city" VARCHAR,
"state_territory" VARCHAR,
"zip_code" BIGINT,
"zip_code_4" DOUBLE,
"website" VARCHAR,
"phone" VARCHAR,
"alignment_frequency" VARCHAR,
"payment_mechanism" VARCHAR,
"stop_loss_selected" VARCHAR,
"enhanced_pcc" VARCHAR -- Enhanced PCC%,
"cardiac_and_pulmonary_rehabilitation" VARCHAR,
"care_management_home_visit" VARCHAR,
"chronic_disease_management_reward_bei" VARCHAR -- Chronic Disease Management Reward(BEI),
"concurrent_care_for_hospice_beneficiaries" VARCHAR,
"cost_sharing_for_part_b_services_bei" VARCHAR -- Cost Sharing For Part B Services(BEI),
"diabetic_shoes" VARCHAR,
"home_health_homebound_waiver" VARCHAR,
"home_infusion_therapy" VARCHAR,
"hospice_care_certification" VARCHAR,
"medical_nutrition_therapy" VARCHAR,
"post_discharge_home_visit" VARCHAR,
"skilled_nursing_facility_snf_3_day_stay_waiver" VARCHAR -- Skilled Nursing Facility(SNF) 3-Day Stay Waiver,
"telehealth" VARCHAR,
"provisional_reconciliation" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR,
"aco_executive_name_1" VARCHAR,
"aco_executive_phone_1" VARCHAR,
"aco_executive_email_1" VARCHAR,
"aco_executive_name_2" VARCHAR,
"aco_executive_phone_2" VARCHAR,
"aco_executive_email_2" VARCHAR,
"aco_executive_name_3" VARCHAR,
"aco_executive_phone_3" VARCHAR,
"aco_executive_email_3" VARCHAR
);CREATE TABLE reach_acos_2025_03_11 (
"entity_id" VARCHAR,
"performance_year" VARCHAR,
"agreement_start_date_cohort" VARCHAR -- Agreement Start Date(Cohort),
"entity_legal_business_name" VARCHAR,
"entity_type" VARCHAR,
"agreement_option" VARCHAR,
"service_areas" VARCHAR,
"street_address" VARCHAR,
"apt_suite" VARCHAR,
"city" VARCHAR,
"state_territory" VARCHAR,
"zip_code" BIGINT,
"zip_code_4" DOUBLE,
"website" VARCHAR,
"phone" VARCHAR,
"alignment_frequency" VARCHAR,
"payment_mechanism" VARCHAR,
"stop_loss_selected" VARCHAR,
"enhanced_pcc" VARCHAR -- Enhanced PCC%,
"cardiac_and_pulmonary_rehabilitation" VARCHAR,
"care_management_home_visit" VARCHAR,
"chronic_disease_management_reward_bei" VARCHAR -- Chronic Disease Management Reward(BEI),
"concurrent_care_for_hospice_beneficiaries" VARCHAR,
"cost_sharing_for_part_b_services_bei" VARCHAR -- Cost Sharing For Part B Services(BEI),
"diabetic_shoes" VARCHAR,
"home_health_homebound_waiver" VARCHAR,
"home_infusion_therapy" VARCHAR,
"hospice_care_certification" VARCHAR,
"medical_nutrition_therapy" VARCHAR,
"post_discharge_home_visit" VARCHAR,
"skilled_nursing_facility_snf_3_day_stay_waiver" VARCHAR -- Skilled Nursing Facility(SNF) 3-Day Stay Waiver,
"telehealth" VARCHAR,
"provisional_reconciliation" VARCHAR,
"aco_compliance_contact_name" VARCHAR,
"aco_medical_director_name" VARCHAR,
"aco_executive_name_1" VARCHAR,
"aco_executive_phone_1" VARCHAR,
"aco_executive_email_1" VARCHAR,
"aco_executive_name_2" VARCHAR,
"aco_executive_phone_2" VARCHAR,
"aco_executive_email_2" VARCHAR,
"aco_executive_name_3" VARCHAR,
"aco_executive_phone_3" VARCHAR,
"aco_executive_email_3" VARCHAR
);Anyone who has the link will be able to view this.