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.

DISCLAIMER: This information is current as of the last update. Changes to Shared Savings Program ACO information occur periodically. Each Shared Savings Program ACO has the most up-to-date information about their organization. Consider contacting the Shared Savings Program ACO for the latest information. Contact information is available in the ACO Public Use File (PUF) and the ACO Participants PUF.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-02-03T21:45:05.809289
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_60cd9.performance_year_financial_and_quality_results_2013_12_31

148.56 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_60cd9.performance_year_financial_and_quality_results_2014_12_31

247.28 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_60cd9.performance_year_financial_and_quality_results_2015_01_15

262.97 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_60cd9.performance_year_financial_and_quality_results_2016_01_15

387.55 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_60cd9.performance_year_financial_and_quality_results_2017_01_15

400.42 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_60cd9.performance_year_financial_and_quality_results_2018_01_15

448.11 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_60cd9.performance_year_financial_and_quality_results_2019_01_31

386.41 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_60cd9.performance_year_financial_and_quality_results_2019_07_01oc1

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