Baselight
Sign In

ACO REACH Financial And Quality Results

U.S. Department of Health & Human Services

@usgov.hhs_gov_aco_reach_financial_and_quality_results

Loading...
Loading...

About this Dataset

ACO REACH Financial And Quality Results

The Accountable Care Organization (ACO) REACH Financial and Quality Results Public Use File (PUF) details performance for the ACO REACH Model, formerly Global and Professional Direct Contracting (GPDC) Model, prior to settlement. This data includes information such as the ACOs risk arrangement, stop loss, capitation, savings rate, and quality results.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:21:09.834604
Tags: accountable-care-organizations, coordinated-care, medicare, original-medicare, payment-models, value-based-care

Tables

ACO REACH Financial And Quality Results : 2021-12-03

@usgov.hhs_gov_aco_reach_financial_and_quality_results.aco_reach_financial_and_quality_results_2021_12_03
  • 110.2 kB
  • 53 rows
  • 111 columns
Loading... 
CREATE TABLE aco_reach_financial_and_quality_results_2021_12_03 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_type" VARCHAR,
  "first_part_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,
  "discount" DOUBLE,
  "retention_withhold" DOUBLE,
  "unadj_benchmark" DOUBLE,
  "final_benchmark" DOUBLE,
  "sav_rate" DOUBLE,
  "trended_ad_baseline" DOUBLE,
  "trended_esrd_baseline" DOUBLE,
  "regional_ad_baseline" DOUBLE,
  "regional_esrd_baseline" DOUBLE,
  "hist_ad_baseline_adj" DOUBLE,
  "hist_esrd_baseline_adj" DOUBLE,
  "tot_cost_care_net" DOUBLE,
  "tot_cost_care" DOUBLE,
  "gross_savings" DOUBLE,
  "shared_savings" DOUBLE,
  "shared_savings_seq" DOUBLE,
  "cap_pmt_amt" DOUBLE,
  "epcc_pmt_amt" DOUBLE,
  "clm_pmt_amt" DOUBLE,
  "expnd_dme" DOUBLE,
  "expnd_hha" DOUBLE,
  "expnd_hsp" DOUBLE,
  "expnd_inp_all" DOUBLE,
  "expnd_opd" DOUBLE,
  "expnd_pb" DOUBLE,
  "expnd_snf" DOUBLE,
  "hist_by1_ad_pbpm" DOUBLE,
  "hist_by1_esrd_pbpm" DOUBLE,
  "hist_by2_ad_pbpm" DOUBLE,
  "hist_by2_esrd_pbpm" DOUBLE,
  "hist_by3_ad_pbpm" DOUBLE,
  "hist_by3_esrd_pbpm" DOUBLE,
  "hist_by1_ad_riskscore" DOUBLE,
  "hist_by1_esrd_riskscore" DOUBLE,
  "hist_by2_ad_riskscore" DOUBLE,
  "hist_by2_esrd_riskscore" DOUBLE,
  "hist_by3_ad_riskscore" DOUBLE,
  "hist_by3_esrd_riskscore" DOUBLE,
  "py_ad_blend_mnths" BIGINT,
  "py_esrd_blend_mnths" DOUBLE,
  "py_ad_ratebook_mnths" BIGINT,
  "py_esrd_ratebook_mnths" DOUBLE,
  "py_ad_blend_riskscore" DOUBLE,
  "py_esrd_blend_riskscore" DOUBLE,
  "py_ad_ratebook_riskscore" DOUBLE,
  "py_esrd_ratebook_riskscore" DOUBLE,
  "aligned_beneficiaries" BIGINT,
  "n_ben_age_0_64" BIGINT,
  "n_ben_age_65_74" BIGINT,
  "n_ben_age_75_84" BIGINT,
  "n_ben_age_85plus" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_female" BIGINT,
  "n_ben_sex_unknown" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" DOUBLE,
  "n_ben_race_asian" DOUBLE,
  "n_ben_race_hisp" DOUBLE,
  "n_ben_race_native" DOUBLE,
  "n_ben_race_pi" BIGINT,
  "n_ben_race_other" DOUBLE,
  "perc_dual" DOUBLE,
  "perc_lti" DOUBLE,
  "expnd_inp_s_trm" DOUBLE,
  "expnd_inp_l_trm" DOUBLE,
  "expnd_inp_rehab" DOUBLE,
  "expnd_inp_psych" DOUBLE,
  "expnd_ambupay" DOUBLE,
  "adm_s_trm_n" DOUBLE,
  "adm_l_trm_n" DOUBLE,
  "adm_rehab_n" DOUBLE,
  "adm_psych_n" DOUBLE,
  "adm_n" BIGINT,
  "p_edv_vis" DOUBLE,
  "p_edv_vis_hosp" DOUBLE,
  "p_ct_vis" DOUBLE,
  "p_mri_vis" DOUBLE,
  "p_em_pcp_vis" DOUBLE,
  "p_em_sp_vis" DOUBLE,
  "p_em_total" DOUBLE,
  "p_nurse_vis" DOUBLE,
  "p_fqhc_rhc_vis" DOUBLE,
  "p_snf_adm" DOUBLE,
  "snf_los" DOUBLE,
  "snf_payperstay" DOUBLE,
  "n_eta" BIGINT,
  "n_cah" DOUBLE,
  "n_fqhc" DOUBLE,
  "n_rhc" DOUBLE
);

ACO REACH Financial And Quality Results : 2022-12-01

@usgov.hhs_gov_aco_reach_financial_and_quality_results.aco_reach_financial_and_quality_results_2022_12_01
  • 158.03 kB
  • 99 rows
  • 122 columns
Loading... 
CREATE TABLE aco_reach_financial_and_quality_results_2022_12_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_type" VARCHAR,
  "first_part_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,
  "discount" DOUBLE,
  "retention_withhold" DOUBLE,
  "unadj_benchmark" DOUBLE,
  "final_benchmark" DOUBLE,
  "sav_rate" DOUBLE,
  "trended_ad_baseline" DOUBLE,
  "trended_esrd_baseline" DOUBLE,
  "regional_ad_baseline" DOUBLE,
  "regional_esrd_baseline" DOUBLE,
  "hist_ad_baseline_adj" DOUBLE,
  "hist_esrd_baseline_adj" DOUBLE,
  "tot_cost_care_net" DOUBLE,
  "tot_cost_care" DOUBLE,
  "gross_savings" DOUBLE,
  "shared_savings" DOUBLE,
  "shared_savings_seq" DOUBLE,
  "cap_pmt_amt" DOUBLE,
  "epcc_pmt_amt" DOUBLE,
  "clm_pmt_amt" DOUBLE,
  "expnd_dme" DOUBLE,
  "expnd_hha" DOUBLE,
  "expnd_hsp" DOUBLE,
  "expnd_inp_all" DOUBLE,
  "expnd_opd" DOUBLE,
  "expnd_pb" DOUBLE,
  "expnd_snf" DOUBLE,
  "hist_by1_ad_pbpm" DOUBLE,
  "hist_by1_esrd_pbpm" DOUBLE,
  "hist_by2_ad_pbpm" DOUBLE,
  "hist_by2_esrd_pbpm" DOUBLE,
  "hist_by3_ad_pbpm" DOUBLE,
  "hist_by3_esrd_pbpm" DOUBLE,
  "hist_by1_ad_riskscore" DOUBLE,
  "hist_by1_esrd_riskscore" DOUBLE,
  "hist_by2_ad_riskscore" DOUBLE,
  "hist_by2_esrd_riskscore" DOUBLE,
  "hist_by3_ad_riskscore" DOUBLE,
  "hist_by3_esrd_riskscore" DOUBLE,
  "hist_by4_ad_riskscore" DOUBLE,
  "hist_by4_esrd_riskscore" DOUBLE,
  "py_ad_blend_mnths" BIGINT,
  "py_esrd_blend_mnths" DOUBLE,
  "py_ad_ratebook_mnths" BIGINT,
  "py_esrd_ratebook_mnths" DOUBLE,
  "py_ad_blend_riskscore" DOUBLE,
  "py_esrd_blend_riskscore" DOUBLE,
  "py_ad_ratebook_riskscore" DOUBLE,
  "py_esrd_ratebook_riskscore" DOUBLE,
  "n_eta" BIGINT,
  "n_cah" DOUBLE,
  "n_fqhc" DOUBLE,
  "n_rhc" DOUBLE,
  "n_hosp" DOUBLE,
  "n_fac_other" DOUBLE,
  "n_pcp" DOUBLE,
  "n_spec" DOUBLE,
  "n_np" DOUBLE,
  "n_pa" DOUBLE,
  "n_cns" DOUBLE,
  "qual_scr" DOUBLE,
  "acr_scr" DOUBLE,
  "uamcc_scr" DOUBLE,
  "dah_scr" DOUBLE,
  "tfu_scr" DOUBLE,
  "ssm_taci_scr" DOUBLE,
  "ssm_com_scr" DOUBLE,
  "ssm_cc_scr" DOUBLE,
  "ssm_sdm_scr" DOUBLE,
  "ssm_pr_scr" DOUBLE,
  "ssm_chos_scr" DOUBLE,
  "ssm_hpe_scr" DOUBLE,
  "ssm_spr_scr" DOUBLE,
  "bene_cnt" BIGINT,
  "n_ben_age_0_64" BIGINT,
  "n_ben_age_65_74" BIGINT,
  "n_ben_age_75_84" BIGINT,
  "n_ben_age_85plus" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_female" BIGINT,
  "n_ben_sex_unknown" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" DOUBLE,
  "n_ben_race_asian" DOUBLE,
  "n_ben_race_hisp" DOUBLE,
  "n_ben_race_native" DOUBLE,
  "n_ben_race_pi" BIGINT,
  "n_ben_race_other" DOUBLE,
  "perc_dual" DOUBLE,
  "perc_lti" DOUBLE
);

ACO REACH Financial And Quality Results : 2023-12-01

@usgov.hhs_gov_aco_reach_financial_and_quality_results.aco_reach_financial_and_quality_results_2023_12_01
  • 193.85 kB
  • 132 rows
  • 131 columns
Loading... 
CREATE TABLE aco_reach_financial_and_quality_results_2023_12_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_type" VARCHAR,
  "first_part_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,
  "discount" DOUBLE,
  "retention_withhold" DOUBLE,
  "unadj_benchmark" DOUBLE,
  "final_benchmark" DOUBLE,
  "norm_risk_score" DOUBLE,
  "cif_cap_risk" DOUBLE,
  "heba_up_amt" DOUBLE,
  "heba_down_amt" DOUBLE,
  "heba_up_mnths" BIGINT,
  "heba_down_mnths" BIGINT,
  "sav_rate" DOUBLE,
  "trended_ad_baseline" DOUBLE,
  "trended_esrd_baseline" DOUBLE,
  "regional_ad_baseline" DOUBLE,
  "regional_esrd_baseline" DOUBLE,
  "hist_ad_baseline_adj" DOUBLE,
  "hist_esrd_baseline_adj" DOUBLE,
  "tot_cost_care_net" DOUBLE,
  "tot_cost_care" DOUBLE,
  "gross_savings" DOUBLE,
  "shared_savings" DOUBLE,
  "shared_savings_seq" DOUBLE,
  "cap_pmt_amt" DOUBLE,
  "epcc_pmt_amt" DOUBLE,
  "clm_pmt_amt" DOUBLE,
  "expnd_dme" DOUBLE,
  "expnd_hha" DOUBLE,
  "expnd_hsp" DOUBLE,
  "expnd_inp_all" DOUBLE,
  "expnd_opd" DOUBLE,
  "expnd_pb" DOUBLE,
  "expnd_snf" DOUBLE,
  "hist_by1_ad_pbpm" DOUBLE,
  "hist_by1_esrd_pbpm" DOUBLE,
  "hist_by2_ad_pbpm" DOUBLE,
  "hist_by2_esrd_pbpm" DOUBLE,
  "hist_by3_ad_pbpm" DOUBLE,
  "hist_by3_esrd_pbpm" DOUBLE,
  "hist_by1_ad_riskscore" DOUBLE,
  "hist_by1_esrd_riskscore" DOUBLE,
  "hist_by2_ad_riskscore" DOUBLE,
  "hist_by2_esrd_riskscore" DOUBLE,
  "hist_by3_ad_riskscore" DOUBLE,
  "hist_by3_esrd_riskscore" DOUBLE,
  "hist_by4_ad_riskscore" DOUBLE,
  "hist_by4_esrd_riskscore" DOUBLE,
  "py_ad_blend_mnths" DOUBLE,
  "py_esrd_blend_mnths" DOUBLE,
  "py_ad_ratebook_mnths" BIGINT,
  "py_esrd_ratebook_mnths" DOUBLE,
  "py_ad_blend_riskscore" DOUBLE,
  "py_esrd_blend_riskscore" DOUBLE,
  "py_ad_ratebook_riskscore" DOUBLE,
  "py_esrd_ratebook_riskscore" DOUBLE,
  "n_eta" BIGINT,
  "n_cah" DOUBLE,
  "n_fqhc" DOUBLE,
  "n_rhc" DOUBLE,
  "n_hosp" DOUBLE,
  "n_fac_other" DOUBLE,
  "n_pcp" DOUBLE,
  "n_spec" DOUBLE,
  "n_np" DOUBLE,
  "n_pa" DOUBLE,
  "n_cns" DOUBLE,
  "qual_scr" DOUBLE,
  "acr_scr" DOUBLE,
  "uamcc_scr" DOUBLE,
  "dah_scr" DOUBLE,
  "tfu_scr" DOUBLE,
  "ssm_taci_scr" VARCHAR,
  "ssm_com_scr" VARCHAR,
  "ssm_cc_scr" VARCHAR,
  "ssm_sdm_scr" VARCHAR,
  "ssm_pr_scr" VARCHAR,
  "ssm_chos_scr" VARCHAR,
  "ssm_hpe_scr" VARCHAR,
  "ssm_spr_scr" VARCHAR,
  "cisep_flag" VARCHAR,
  "hpp_flag" VARCHAR,
  "hdr_adjust" DOUBLE,
  "bene_cnt" BIGINT,
  "n_ben_age_0_64" BIGINT,
  "n_ben_age_65_74" BIGINT,
  "n_ben_age_75_84" BIGINT,
  "n_ben_age_85plus" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_female" BIGINT,
  "n_ben_sex_unknown" BIGINT
);

Share link

Anyone who has the link will be able to view this.