About this Dataset

Performance Year Financial And Quality Results

The Shared Savings Program Performance Year Financial and Quality Results data provides Medicare Shared Savings Program (Shared Savings Program) ACO-specific quality, expenditure, benchmark, and shared savings/loss metrics, as well as summarized beneficiary and provider information for each performance year of the Shared Savings Program.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:18:28.877081
Tags: accountable-care-organizations, coordinated-care, financials, medicare, original-medicare, payment-models, value-based-care

Tables

Performance Year Financial And Quality Results : 2013-12-31

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2013_12_31

152.13 kB
220 rows
97 columns

CREATE TABLE performance_year_financial_and_quality_results_2013_12_31 (
  "aco_num" VARCHAR,
  "aco_name" VARCHAR,
  "start_date" TIMESTAMP,
  "track2" BIGINT,
  "adv_pay" BIGINT,
  "n_ab" BIGINT,
  "minsavperc" DOUBLE,
  "bnchmkminexp" DOUBLE,
  "qualscore" BIGINT,
  "abtotbnchmk" DOUBLE,
  "abtotexp" DOUBLE,
  "adv_pay_amt" DOUBLE,
  "qualperfshare" DOUBLE,
  "finalsharerate" DOUBLE,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" DOUBLE,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" DOUBLE,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" DOUBLE,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year" BIGINT,
  "n_ab_year_esrd" BIGINT,
  "n_ab_year_dis" BIGINT,
  "n_ab_year_aged_dual" BIGINT,
  "n_ab_year_aged_nondual" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_inp_other" DOUBLE,
  "adm" BIGINT,
  "adm_s_trm" BIGINT,
  "adm_l_trm" VARCHAR,
  "adm_rehab" VARCHAR,
  "adm_psych" VARCHAR,
  "readm_rate_1000" BIGINT,
  "prov_rate_1000" BIGINT,
  "p_snf_adm" BIGINT,
  "p_edv_vis" BIGINT,
  "p_edv_vis_hosp" BIGINT,
  "p_ct_vis" BIGINT,
  "p_mri_vis" BIGINT,
  "p_em_total" BIGINT,
  "p_em_pcp_vis" BIGINT,
  "p_em_sp_vis" BIGINT,
  "p_nurse_vis" VARCHAR,
  "p_fqhc_rhc_vis" VARCHAR,
  "n_cah" BIGINT,
  "n_fqhc" BIGINT,
  "n_rhc" BIGINT,
  "n_eta" BIGINT,
  "n_fac_other" BIGINT,
  "n_pcp" BIGINT,
  "n_spec" BIGINT,
  "n_np" BIGINT,
  "n_pa" BIGINT,
  "n_cns" BIGINT,
  "int_pmt" DOUBLE,
  "minlossperc" DOUBLE,
  "earnshrsavings" DOUBLE,
  "owelosses" DOUBLE,
  "per_capita_exp_all_esrd" BIGINT,
  "per_capita_exp_all_dis" BIGINT,
  "per_capita_exp_all_agdu" BIGINT,
  "per_capita_exp_all_agnd" BIGINT,
  "capann_hsp" BIGINT,
  "capann_snf" BIGINT,
  "capann_pb" BIGINT,
  "capann_ambpay" BIGINT,
  "capann_hha" BIGINT,
  "capann_dme" BIGINT,
  "chf_adm" VARCHAR,
  "copd_adm" VARCHAR,
  "pneu_adm" VARCHAR
);

Performance Year Financial And Quality Results : 2014-12-31

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2014_12_31

253.21 kB
333 rows
119 columns

CREATE TABLE performance_year_financial_and_quality_results_2014_12_31 (
  "aco_num" VARCHAR,
  "aco_state" VARCHAR,
  "start_date" TIMESTAMP,
  "track1" BIGINT,
  "track2" BIGINT,
  "adv_pay" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "earnsaveloss" BIGINT,
  "qualscore" VARCHAR,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" DOUBLE,
  "finalsharerate" DOUBLE,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" BIGINT,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" BIGINT,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" DOUBLE,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" DOUBLE,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" BIGINT,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_inp_other" BIGINT,
  "adm" BIGINT,
  "adm_s_trm" BIGINT,
  "adm_l_trm" VARCHAR,
  "adm_rehab" VARCHAR,
  "adm_psych" VARCHAR,
  "readm_rate_1000" BIGINT,
  "prov_rate_1000" BIGINT,
  "p_snf_adm" VARCHAR,
  "p_edv_vis" BIGINT,
  "p_edv_vis_hosp" BIGINT,
  "p_ct_vis" BIGINT,
  "p_mri_vis" BIGINT,
  "p_em_total" BIGINT,
  "p_em_pcp_vis" BIGINT,
  "p_em_sp_vis" BIGINT,
  "p_nurse_vis" BIGINT,
  "p_fqhc_rhc_vis" BIGINT,
  "n_cah" BIGINT,
  "n_fqhc" BIGINT,
  "n_rhc" BIGINT,
  "n_eta" BIGINT,
  "n_fac_other" BIGINT,
  "n_pcp" BIGINT,
  "n_spec" BIGINT
);

Performance Year Financial And Quality Results : 2015-01-15

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2015_01_15

269.28 kB
392 rows
119 columns

CREATE TABLE performance_year_financial_and_quality_results_2015_01_15 (
  "aco_num" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "adv_pay" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "earnsaveloss" BIGINT,
  "qualscore" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" BIGINT,
  "finalsharerate" DOUBLE,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" BIGINT,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" VARCHAR,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" DOUBLE,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" VARCHAR,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" BIGINT,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" BIGINT,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_hsp" BIGINT,
  "capann_snf" VARCHAR,
  "capann_inp_other" BIGINT,
  "capann_opd" BIGINT,
  "capann_pb" BIGINT,
  "capann_ambpay" BIGINT,
  "capann_hha" BIGINT,
  "capann_dme" BIGINT,
  "adm" BIGINT,
  "adm_s_trm" VARCHAR,
  "adm_l_trm" VARCHAR,
  "adm_rehab" VARCHAR,
  "adm_psych" VARCHAR,
  "chf_adm" VARCHAR,
  "copd_adm" VARCHAR,
  "pneu_adm" VARCHAR,
  "readm_rate_1000" BIGINT,
  "prov_rate_1000" BIGINT,
  "p_snf_adm" VARCHAR,
  "p_edv_vis" BIGINT,
  "p_edv_vis_hosp" BIGINT,
  "p_ct_vis" BIGINT
);

Performance Year Financial And Quality Results : 2016-01-15

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2016_01_15

396.86 kB
432 rows
164 columns

CREATE TABLE performance_year_financial_and_quality_results_2016_01_15 (
  "aco_num" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "initial_track_1" BIGINT,
  "initial_track_2" BIGINT,
  "initial_track_3" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "earnsaveloss" BIGINT,
  "met_qps" BIGINT,
  "qualscore" DOUBLE,
  "prior_sav_adj" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" DOUBLE,
  "finalsharerate" DOUBLE,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" BIGINT,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" DOUBLE,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" BIGINT,
  "n_ab_year_dis_py" BIGINT,
  "n_ab_year_aged_dual_py" BIGINT,
  "n_ab_year_aged_nondual_py" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_hsp" BIGINT,
  "capann_snf" BIGINT,
  "capann_inp_other" BIGINT,
  "capann_opd" BIGINT,
  "capann_pb" BIGINT,
  "capann_ambpay" BIGINT,
  "capann_hha" BIGINT,
  "capann_dme" BIGINT,
  "adm" BIGINT
);

Performance Year Financial And Quality Results : 2017-01-15

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2017_01_15

410.03 kB
472 rows
164 columns

CREATE TABLE performance_year_financial_and_quality_results_2017_01_15 (
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "initial_track_1" BIGINT,
  "initial_track_2" BIGINT,
  "initial_track_3" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "earnsaveloss" BIGINT,
  "met_qps" BIGINT,
  "qualscore" DOUBLE,
  "prior_sav_adj" DOUBLE,
  "regtrndupdt" BIGINT,
  "posregadj" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" DOUBLE,
  "finalsharerate" DOUBLE,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" VARCHAR,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" VARCHAR,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" VARCHAR,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" VARCHAR,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" VARCHAR,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" VARCHAR,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_hsp" BIGINT,
  "capann_snf" BIGINT,
  "capann_inp_other" BIGINT,
  "capann_opd" BIGINT,
  "capann_pb" BIGINT,
  "capann_ambpay" BIGINT,
  "capann_hha" BIGINT
);

Performance Year Financial And Quality Results : 2018-01-15

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2018_01_15

458.86 kB
548 rows
172 columns

CREATE TABLE performance_year_financial_and_quality_results_2018_01_15 (
  "chf_adm" BIGINT,
  "copd_adm" VARCHAR,
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "initial_track_1" BIGINT,
  "initial_track_2" BIGINT,
  "initial_track_3" BIGINT,
  "initial_track_1_plus" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "current_track_1_plus" BIGINT,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "qualscore" DOUBLE,
  "recvdmean" BIGINT,
  "prior_sav_adj" DOUBLE,
  "regtrndupdt" BIGINT,
  "posregadj" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" DOUBLE,
  "finalsharerate" DOUBLE,
  "revlosslimit" BIGINT,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" BIGINT,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" BIGINT,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" DOUBLE,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" DOUBLE,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" BIGINT,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT
);

Performance Year Financial And Quality Results : 2019-01-31

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2019_01_31

395.68 kB
475 rows
175 columns

CREATE TABLE performance_year_financial_and_quality_results_2019_01_31 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "participation_six_months" BIGINT,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "initial_track_1" BIGINT,
  "initial_track_2" BIGINT,
  "initial_track_3" BIGINT,
  "initial_track_1_plus" BIGINT,
  "initial_basic_a" BIGINT,
  "initial_basic_b" BIGINT,
  "initial_basic_c" BIGINT,
  "initial_basic_d" BIGINT,
  "initial_basic_e" BIGINT,
  "initial_enhanced" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "current_track_1_plus" BIGINT,
  "current_basic_a" BIGINT,
  "current_basic_b" BIGINT,
  "current_basic_c" BIGINT,
  "current_basic_d" BIGINT,
  "current_basic_e" BIGINT,
  "current_enhanced" BIGINT,
  "risk_model" VARCHAR,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" BIGINT,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "qualscore" DOUBLE,
  "recvdmean" BIGINT,
  "prior_sav_adj" DOUBLE,
  "regtrndupdt" BIGINT,
  "posregadj" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" DOUBLE,
  "finalsharerate" DOUBLE,
  "revlosslimit" BIGINT,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" BIGINT,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" BIGINT,
  "n_ben_age_0_64" BIGINT,
  "n_ben_age_65_74" BIGINT
);

Performance Year Financial And Quality Results : 2019-07-01oc1

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2019_07_01oc1

252.65 kB
205 rows
175 columns

CREATE TABLE performance_year_financial_and_quality_results_2019_07_01oc1 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "participation_six_months" BIGINT,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "initial_track_1" BIGINT,
  "initial_track_2" BIGINT,
  "initial_track_3" BIGINT,
  "initial_track_1_plus" BIGINT,
  "initial_basic_a" BIGINT,
  "initial_basic_b" BIGINT,
  "initial_basic_c" BIGINT,
  "initial_basic_d" BIGINT,
  "initial_basic_e" BIGINT,
  "initial_enhanced" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "current_track_1_plus" BIGINT,
  "current_basic_a" BIGINT,
  "current_basic_b" BIGINT,
  "current_basic_c" BIGINT,
  "current_basic_d" BIGINT,
  "current_basic_e" BIGINT,
  "current_enhanced" BIGINT,
  "risk_model" VARCHAR,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" VARCHAR,
  "minsavperc" VARCHAR,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "qualscore" DOUBLE,
  "recvdmean" BIGINT,
  "prior_sav_adj" VARCHAR,
  "regtrndupdt" BIGINT,
  "posregadj" BIGINT,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "qualperfshare" VARCHAR,
  "finalsharerate" VARCHAR,
  "revlosslimit" BIGINT,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" BIGINT,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" BIGINT,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" BIGINT,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" BIGINT,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" DOUBLE,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" DOUBLE,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" DOUBLE,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" DOUBLE,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" BIGINT,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" BIGINT,
  "n_ab_year_dis_py" BIGINT,
  "n_ab_year_aged_dual_py" BIGINT,
  "n_ab_year_aged_nondual_py" BIGINT,
  "n_ben_age_0_64" BIGINT,
  "n_ben_age_65_74" BIGINT
);

Performance Year Financial And Quality Results : 2020-01-01

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2020_01_01

371.38 kB
513 rows
162 columns

CREATE TABLE performance_year_financial_and_quality_results_2020_01_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "current_track_1_plus" BIGINT,
  "current_basic_a" BIGINT,
  "current_basic_b" BIGINT,
  "current_basic_c" BIGINT,
  "current_basic_d" BIGINT,
  "current_basic_e" BIGINT,
  "current_enhanced" BIGINT,
  "risk_model" VARCHAR,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "qualscore" DOUBLE,
  "posregadj" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "finalsharerate" DOUBLE,
  "revlosslimit" BIGINT,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" BIGINT,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_hsp" BIGINT
);

Performance Year Financial And Quality Results : 2021-01-04

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2021_01_04

398.46 kB
475 rows
171 columns

CREATE TABLE performance_year_financial_and_quality_results_2021_01_04 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "aco_state" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "initial_start_date" TIMESTAMP,
  "current_start_date" TIMESTAMP,
  "current_track_1" BIGINT,
  "current_track_2" BIGINT,
  "current_track_3" BIGINT,
  "current_track_1_plus" BIGINT,
  "current_basic_a" BIGINT,
  "current_basic_b" BIGINT,
  "current_basic_c" BIGINT,
  "current_basic_d" BIGINT,
  "current_basic_e" BIGINT,
  "current_enhanced" BIGINT,
  "risk_model" VARCHAR,
  "assign_type" VARCHAR,
  "adv_pay" BIGINT,
  "aim" BIGINT,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" VARCHAR,
  "minsavperc" VARCHAR,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "report_wi" BIGINT,
  "report_ecqm" BIGINT,
  "report_cqm" BIGINT,
  "report_inc" BIGINT,
  "qualscore" VARCHAR,
  "recvd30p" BIGINT,
  "posregadj" DOUBLE,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "adv_pay_amt" DOUBLE,
  "adv_pay_recoup" DOUBLE,
  "maxsharerate" VARCHAR,
  "finalsharerate" VARCHAR,
  "revlosslimit" BIGINT,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" VARCHAR,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" 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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR
);

Performance Year Financial And Quality Results : 2022-02-01

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2022_02_01

402.45 kB
482 rows
164 columns

CREATE TABLE performance_year_financial_and_quality_results_2022_02_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track" VARCHAR,
  "risk_model" VARCHAR,
  "assign_type" VARCHAR,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" VARCHAR,
  "minsavperc" VARCHAR,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "impact_mid_year_termination" BIGINT,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "met_30pctl" BIGINT,
  "met_incentive" BIGINT,
  "met_firstyear" BIGINT,
  "report_wi" BIGINT,
  "report_ecqm_cqm" BIGINT,
  "report_inc" BIGINT,
  "qualscore" VARCHAR,
  "recvd30p" BIGINT,
  "posregadj" BIGINT,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "finalsharerate" VARCHAR,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" VARCHAR,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" BIGINT,
  "n_ben_va_only" VARCHAR,
  "n_ben_cba_only" VARCHAR,
  "n_ben_cba_and_va" VARCHAR,
  "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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "n_ben_race_unknown" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR,
  "capann_inp_psych" VARCHAR,
  "capann_hsp" BIGINT,
  "capann_snf" BIGINT,
  "capann_opd" BIGINT
);

Performance Year Financial And Quality Results : 2023-10-01

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2023_10_01

394.38 kB
453 rows
168 columns

CREATE TABLE performance_year_financial_and_quality_results_2023_10_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track" VARCHAR,
  "risk_model" VARCHAR,
  "assign_type" VARCHAR,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" VARCHAR,
  "minsavperc" VARCHAR,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" DOUBLE,
  "impact_mid_year_termination" BIGINT,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "met_altqps" VARCHAR,
  "met_30pctl" BIGINT,
  "met_incentive" BIGINT,
  "met_firstyear" BIGINT,
  "report_wi" BIGINT,
  "report_ecqm_cqm" BIGINT,
  "report_inc" BIGINT,
  "qualscore" VARCHAR,
  "recvd30p" BIGINT,
  "posregadj" BIGINT,
  "updatedbnchmk" BIGINT,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "finalsharerate" VARCHAR,
  "finallossrate" VARCHAR,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" VARCHAR,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" BIGINT,
  "n_ab_year_dual_py" BIGINT,
  "n_ab_year_nondual_py" BIGINT,
  "n_ben_va_only" VARCHAR,
  "n_ben_cba_only" VARCHAR,
  "n_ben_cba_and_va" VARCHAR,
  "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_female" BIGINT,
  "n_ben_male" BIGINT,
  "n_ben_race_white" BIGINT,
  "n_ben_race_black" VARCHAR,
  "n_ben_race_asian" VARCHAR,
  "n_ben_race_hisp" VARCHAR,
  "n_ben_race_native" VARCHAR,
  "n_ben_race_other" VARCHAR,
  "n_ben_race_unknown" VARCHAR,
  "capann_inp_all" BIGINT,
  "capann_inp_s_trm" BIGINT,
  "capann_inp_l_trm" VARCHAR,
  "capann_inp_rehab" VARCHAR
);

Performance Year Financial And Quality Results : 2024-01-02

@usgov.hhs_gov_performance_year_financial_and_quality_results_601a7.performance_year_financial_and_quality_results_2024_01_02

436.76 kB
476 rows
189 columns

CREATE TABLE performance_year_financial_and_quality_results_2024_01_02 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "agree_type" VARCHAR,
  "agreement_period_num" BIGINT,
  "current_start_date" TIMESTAMP,
  "current_track" VARCHAR,
  "risk_model" VARCHAR,
  "assign_type" VARCHAR,
  "snf_waiver" BIGINT,
  "n_ab" BIGINT,
  "sav_rate" DOUBLE,
  "minsavperc" DOUBLE,
  "bnchmkminexp" BIGINT,
  "gensaveloss" BIGINT,
  "disadj" VARCHAR,
  "impact_mid_year_termination" BIGINT,
  "earnsaveloss" BIGINT,
  "disaffqual" BIGINT,
  "met_qps" BIGINT,
  "met_altqps" VARCHAR,
  "met_40pctl" BIGINT,
  "met_incentive" BIGINT,
  "met_firstyear" BIGINT,
  "report_wi" BIGINT,
  "report_ecqm_cqm_medicarecqm" BIGINT,
  "met_ssp_quality_reporting_requirements" BIGINT,
  "qualscore" DOUBLE,
  "recvd40p" BIGINT,
  "aip" BIGINT,
  "aipbalance" VARCHAR,
  "aiprecoup" VARCHAR,
  "aipowe" VARCHAR,
  "regadj" BIGINT,
  "priorsavadj" VARCHAR,
  "finaladjcat" VARCHAR,
  "updatedbnchmk" BIGINT,
  "guardrail" VARCHAR,
  "histbnchmk" BIGINT,
  "abtotbnchmk" BIGINT,
  "abtotexp" BIGINT,
  "finalsharerate" DOUBLE,
  "reducedss" BIGINT,
  "finallossrate" VARCHAR,
  "rev_exp_cat" VARCHAR,
  "per_capita_exp_all_esrd_by1" VARCHAR,
  "per_capita_exp_all_dis_by1" BIGINT,
  "per_capita_exp_all_agdu_by1" BIGINT,
  "per_capita_exp_all_agnd_by1" BIGINT,
  "per_capita_exp_all_esrd_by2" VARCHAR,
  "per_capita_exp_all_dis_by2" BIGINT,
  "per_capita_exp_all_agdu_by2" BIGINT,
  "per_capita_exp_all_agnd_by2" BIGINT,
  "per_capita_exp_all_esrd_by3" VARCHAR,
  "per_capita_exp_all_dis_by3" BIGINT,
  "per_capita_exp_all_agdu_by3" BIGINT,
  "per_capita_exp_all_agnd_by3" BIGINT,
  "per_capita_exp_all_esrd_py" VARCHAR,
  "per_capita_exp_all_dis_py" BIGINT,
  "per_capita_exp_all_agdu_py" BIGINT,
  "per_capita_exp_all_agnd_py" BIGINT,
  "per_capita_exp_total_py" BIGINT,
  "cms_hcc_riskscore_esrd_by1" VARCHAR,
  "cms_hcc_riskscore_dis_by1" DOUBLE,
  "cms_hcc_riskscore_agdu_by1" DOUBLE,
  "cms_hcc_riskscore_agnd_by1" DOUBLE,
  "cms_hcc_riskscore_esrd_by2" VARCHAR,
  "cms_hcc_riskscore_dis_by2" DOUBLE,
  "cms_hcc_riskscore_agdu_by2" DOUBLE,
  "cms_hcc_riskscore_agnd_by2" DOUBLE,
  "cms_hcc_riskscore_esrd_by3" VARCHAR,
  "cms_hcc_riskscore_dis_by3" DOUBLE,
  "cms_hcc_riskscore_agdu_by3" DOUBLE,
  "cms_hcc_riskscore_agnd_by3" DOUBLE,
  "cms_hcc_riskscore_esrd_py" VARCHAR,
  "cms_hcc_riskscore_dis_py" DOUBLE,
  "cms_hcc_riskscore_agdu_py" DOUBLE,
  "cms_hcc_riskscore_agnd_py" DOUBLE,
  "demog_riskscore_esrd_py" VARCHAR,
  "demog_riskscore_dis_py" DOUBLE,
  "demog_riskscore_agdu_py" DOUBLE,
  "demog_riskscore_agnd_py" DOUBLE,
  "demog_riskscore_esrd_by3" VARCHAR,
  "demog_riskscore_dis_by3" DOUBLE,
  "demog_riskscore_agdu_by3" DOUBLE,
  "demog_riskscore_agnd_by3" DOUBLE,
  "rr_weight_esrd_py" VARCHAR,
  "rr_weight_dis_py" DOUBLE,
  "rr_weight_agdu_py" DOUBLE,
  "rr_weight_agnd_py" DOUBLE,
  "n_ab_year_esrd_by3" VARCHAR,
  "n_ab_year_dis_by3" BIGINT,
  "n_ab_year_aged_dual_by3" BIGINT,
  "n_ab_year_aged_nondual_by3" BIGINT,
  "n_ab_year_py" BIGINT,
  "n_ab_year_esrd_py" VARCHAR,
  "n_ab_year_dis_py" VARCHAR,
  "n_ab_year_aged_dual_py" VARCHAR,
  "n_ab_year_aged_nondual_py" VARCHAR,
  "n_ab_year_dual_py" BIGINT,
  "n_ab_year_nondual_py" BIGINT
);