Baselight
Sign In

Pioneer ACO Model

U.S. Department of Health & Human Services

@usgov.hhs_gov_pioneer_aco_model_8c183

Loading...
Loading...

About this Dataset

Pioneer ACO Model

The Pioneer Accountable Care Organization (ACO) Model Public Use File (PUF) provides information on ACOs participating in the model. This dataset includes information on each ACO regarding beneficiaries, financial and quality results.
Organization: U.S. Department of Health & Human Services
Last updated: 2023-05-30T02:13:00.565526
Tags: accountable-care-organizations, coordinated-care, medicare, original-medicare, payment-models, value-based-care

Tables

Pioneer ACO Model : 2012-05-11

@usgov.hhs_gov_pioneer_aco_model_8c183.pioneer_aco_model_2012_05_11
  • 47.27 KB
  • 32 rows
  • 54 columns
Loading... 

CREATE TABLE pioneer_aco_model_2012_05_11 (
  "prfm_yr" VARCHAR,
  "aco_id" VARCHAR,
  "cmmi_name" VARCHAR,
  "prvdr_ct" BIGINT,
  "prac_ct" BIGINT,
  "prof_prac_ct" BIGINT,
  "inst_prac_ct" BIGINT,
  "prof_prvdr_ct" BIGINT,
  "par_fac_ct" BIGINT,
  "pcp_prvdr_ct" BIGINT,
  "algn_count" BIGINT,
  "aged_count" BIGINT,
  "disabled_count" BIGINT,
  "esrd_count" BIGINT,
  "male_count" BIGINT,
  "female_count" BIGINT,
  "age_lt65_count" BIGINT,
  "age_6569_count" BIGINT,
  "age_7079_count" BIGINT,
  "age_ge80" BIGINT,
  "exp_tot" DOUBLE,
  "exp_nch10" DOUBLE,
  "exp_nch20" DOUBLE,
  "exp_nch30" DOUBLE,
  "exp_nch40" DOUBLE,
  "exp_nch50" DOUBLE,
  "exp_nch60" DOUBLE,
  "exp_nch71" DOUBLE,
  "exp_nch72" DOUBLE,
  "exp_nch81" DOUBLE,
  "exp_nch82" DOUBLE,
  "stlmnt_dt" BIGINT,
  "algnd_bene_ct" BIGINT,
  "algnd_bene_mnths" BIGINT,
  "aco_baseline_pbpy" DOUBLE,
  "adj_ref_baseline_pbpy" DOUBLE,
  "adj_ref_perfyear_pbpy" DOUBLE,
  "ref_pbpy_chng" DOUBLE,
  "ref_pbpy_trnd" DOUBLE,
  "aco_pbpy_trnd_cmpnt" DOUBLE,
  "aco_blnd_pbpy_incr" DOUBLE,
  "aco_bnmrk_pbpy" DOUBLE,
  "aco_perfyear_pbpy" DOUBLE,
  "gross_savings_pbpy" DOUBLE,
  "bnchmrk_expend" DOUBLE,
  "aco_perfyear_expnd" DOUBLE,
  "gross_savings" DOUBLE,
  "perfyear_qual_scre" BIGINT,
  "qlty_adj_ssl_rate" DOUBLE,
  "shared_savings" DOUBLE,
  "bnch_mthd" BIGINT,
  "awi_gpci_adj" DOUBLE,
  "risk_arngmnt" VARCHAR,
  "msr" DOUBLE
);

Pioneer ACO Model : 2013-12-01

@usgov.hhs_gov_pioneer_aco_model_8c183.pioneer_aco_model_2013_12_01
  • 44.99 KB
  • 23 rows
  • 54 columns
Loading... 

CREATE TABLE pioneer_aco_model_2013_12_01 (
  "prfm_yr" VARCHAR,
  "aco_id" VARCHAR,
  "cmmi_name" VARCHAR,
  "prvdr_ct" BIGINT,
  "prac_ct" BIGINT,
  "prof_prac_ct" BIGINT,
  "inst_prac_ct" BIGINT,
  "prof_prvdr_ct" BIGINT,
  "par_fac_ct" BIGINT,
  "pcp_prvdr_ct" BIGINT,
  "algn_count" BIGINT,
  "aged_count" BIGINT,
  "disabled_count" BIGINT,
  "esrd_count" BIGINT,
  "male_count" BIGINT,
  "female_count" BIGINT,
  "age_lt65_count" BIGINT,
  "age_6569_count" BIGINT,
  "age_7079_count" BIGINT,
  "age_ge80" BIGINT,
  "exp_tot" DOUBLE,
  "exp_nch10" DOUBLE,
  "exp_nch20" DOUBLE,
  "exp_nch30" DOUBLE,
  "exp_nch40" DOUBLE,
  "exp_nch50" DOUBLE,
  "exp_nch60" DOUBLE,
  "exp_nch71" DOUBLE,
  "exp_nch72" DOUBLE,
  "exp_nch81" DOUBLE,
  "exp_nch82" DOUBLE,
  "stlmnt_dt" BIGINT,
  "algnd_bene_ct" BIGINT,
  "algnd_bene_mnths" BIGINT,
  "aco_baseline_pbpy" DOUBLE,
  "adj_ref_baseline_pbpy" DOUBLE,
  "adj_ref_perfyear_pbpy" DOUBLE,
  "ref_pbpy_chng" DOUBLE,
  "ref_pbpy_trnd" DOUBLE,
  "aco_pbpy_trnd_cmpnt" DOUBLE,
  "aco_blnd_pbpy_incr" DOUBLE,
  "aco_bnmrk_pbpy" DOUBLE,
  "aco_perfyear_pbpy" DOUBLE,
  "gross_savings_pbpy" DOUBLE,
  "bnchmrk_expend" DOUBLE,
  "aco_perfyear_expnd" DOUBLE,
  "gross_savings" DOUBLE,
  "perfyear_qual_scre" DOUBLE,
  "qlty_adj_ssl_rate" DOUBLE,
  "shared_savings" DOUBLE,
  "bnch_mthd" BIGINT,
  "awi_gpci_adj" DOUBLE,
  "risk_arngmnt" VARCHAR,
  "msr" DOUBLE
);

Pioneer ACO Model : 2014-12-01

@usgov.hhs_gov_pioneer_aco_model_8c183.pioneer_aco_model_2014_12_01
  • 43.93 KB
  • 20 rows
  • 54 columns
Loading... 

CREATE TABLE pioneer_aco_model_2014_12_01 (
  "prfm_yr" VARCHAR,
  "aco_id" VARCHAR,
  "cmmi_name" VARCHAR,
  "prvdr_ct" BIGINT,
  "prac_ct" BIGINT,
  "prof_prac_ct" BIGINT,
  "inst_prac_ct" BIGINT,
  "prof_prvdr_ct" BIGINT,
  "par_fac_ct" BIGINT,
  "pcp_prvdr_ct" BIGINT,
  "algn_count" BIGINT,
  "aged_count" BIGINT,
  "disabled_count" BIGINT,
  "esrd_count" BIGINT,
  "male_count" BIGINT,
  "female_count" BIGINT,
  "age_lt65_count" BIGINT,
  "age_6569_count" BIGINT,
  "age_7079_count" BIGINT,
  "age_ge80" BIGINT,
  "exp_tot" DOUBLE,
  "exp_nch10" DOUBLE,
  "exp_nch20" DOUBLE,
  "exp_nch30" DOUBLE,
  "exp_nch40" DOUBLE,
  "exp_nch50" DOUBLE,
  "exp_nch60" DOUBLE,
  "exp_nch71" DOUBLE,
  "exp_nch72" DOUBLE,
  "exp_nch81" DOUBLE,
  "exp_nch82" DOUBLE,
  "stlmnt_dt" BIGINT,
  "algnd_bene_ct" BIGINT,
  "algnd_bene_mnths" BIGINT,
  "aco_baseline_pbpy" DOUBLE,
  "adj_ref_baseline_pbpy" DOUBLE,
  "adj_ref_perfyear_pbpy" DOUBLE,
  "ref_pbpy_chng" DOUBLE,
  "ref_pbpy_trnd" DOUBLE,
  "aco_pbpy_trnd_cmpnt" DOUBLE,
  "aco_blnd_pbpy_incr" DOUBLE,
  "aco_bnmrk_pbpy" DOUBLE,
  "aco_perfyear_pbpy" DOUBLE,
  "gross_savings_pbpy" DOUBLE,
  "bnchmrk_expend" DOUBLE,
  "aco_perfyear_expnd" DOUBLE,
  "gross_savings" DOUBLE,
  "perfyear_qual_scre" DOUBLE,
  "qlty_adj_ssl_rate" DOUBLE,
  "shared_savings" DOUBLE,
  "bnch_mthd" BIGINT,
  "awi_gpci_adj" DOUBLE,
  "risk_arngmnt" VARCHAR,
  "msr" DOUBLE
);

Pioneer ACO Model : 2015-12-01

@usgov.hhs_gov_pioneer_aco_model_8c183.pioneer_aco_model_2015_12_01
  • 48.46 KB
  • 12 rows
  • 62 columns
Loading... 

CREATE TABLE pioneer_aco_model_2015_12_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "perf_yr" BIGINT,
  "pbp_election" VARCHAR,
  "bene_ct" BIGINT,
  "mnth_py" BIGINT,
  "bnmrk_expnd" DOUBLE,
  "perf_yr_expnd" DOUBLE,
  "gross_savings" DOUBLE,
  "shared_savings" DOUBLE,
  "qual_scre" DOUBLE,
  "mnth_ad_by1" BIGINT,
  "expnd_ad_by1" DOUBLE,
  "risk_scre_ad_by1" DOUBLE,
  "mnth_ad_by2" BIGINT,
  "expnd_ad_by2" DOUBLE,
  "risk_scre_ad_by2" DOUBLE,
  "mnth_ad_by3" BIGINT,
  "expnd_ad_by3" DOUBLE,
  "risk_scre_ad_by3" DOUBLE,
  "bnmrk_ad" DOUBLE,
  "risk_scre_ad_py" DOUBLE,
  "mnth_an_by1" BIGINT,
  "expnd_an_by1" DOUBLE,
  "risk_scre_an_by1" DOUBLE,
  "mnth_an_by2" BIGINT,
  "expnd_an_by2" DOUBLE,
  "risk_scre_an_by2" DOUBLE,
  "mnth_an_by3" BIGINT,
  "expnd_an_by3" DOUBLE,
  "risk_scre_an_by3" DOUBLE,
  "bnmrk_an" DOUBLE,
  "risk_scre_an_py" DOUBLE,
  "mnth_disa_by1" BIGINT,
  "expnd_disa_by1" DOUBLE,
  "risk_scre_disa_by1" DOUBLE,
  "mnth_disa_by2" BIGINT,
  "expnd_disa_by2" DOUBLE,
  "risk_scre_disa_by2" DOUBLE,
  "mnth_disa_by3" BIGINT,
  "expnd_disa_by3" DOUBLE,
  "risk_scre_disa_by3" DOUBLE,
  "bnmrk_disa" DOUBLE,
  "risk_scre_disa_py" DOUBLE,
  "mnth_esrd_by1" BIGINT,
  "expnd_esrd_by1" DOUBLE,
  "risk_scre_esrd_by1" DOUBLE,
  "mnth_esrd_by2" BIGINT,
  "expnd_esrd_by2" DOUBLE,
  "risk_scre_esrd_by2" DOUBLE,
  "mnth_esrd_by3" BIGINT,
  "expnd_esrd_by3" DOUBLE,
  "risk_scre_esrd_by3" DOUBLE,
  "bnmrk_esrd" DOUBLE,
  "risk_scre_esrd_py" DOUBLE,
  "expnd_hha" DOUBLE,
  "expnd_snf" DOUBLE,
  "expnd_outp" DOUBLE,
  "expnd_hosp" DOUBLE,
  "expnd_inp" DOUBLE,
  "expnd_prof" DOUBLE,
  "expnd_dme" DOUBLE
);

Pioneer ACO Model : 2016-12-01

@usgov.hhs_gov_pioneer_aco_model_8c183.pioneer_aco_model_2016_12_01
  • 46.44 KB
  • 8 rows
  • 62 columns
Loading... 

CREATE TABLE pioneer_aco_model_2016_12_01 (
  "aco_id" VARCHAR,
  "aco_name" VARCHAR,
  "perf_yr" BIGINT,
  "pbp_election" VARCHAR,
  "bene_ct" BIGINT,
  "mnth_py" BIGINT,
  "bnmrk_expnd" DOUBLE,
  "perf_yr_expnd" DOUBLE,
  "gross_savings" DOUBLE,
  "shared_savings" DOUBLE,
  "qual_scre" DOUBLE,
  "mnth_ad_by1" BIGINT,
  "expnd_ad_by1" DOUBLE,
  "risk_scre_ad_by1" DOUBLE,
  "mnth_ad_by2" BIGINT,
  "expnd_ad_by2" DOUBLE,
  "risk_scre_ad_by2" DOUBLE,
  "mnth_ad_by3" BIGINT,
  "expnd_ad_by3" DOUBLE,
  "risk_scre_ad_by3" DOUBLE,
  "bnmrk_ad" DOUBLE,
  "risk_scre_ad_py" DOUBLE,
  "mnth_an_by1" BIGINT,
  "expnd_an_by1" DOUBLE,
  "risk_scre_an_by1" DOUBLE,
  "mnth_an_by2" BIGINT,
  "expnd_an_by2" DOUBLE,
  "risk_scre_an_by2" DOUBLE,
  "mnth_an_by3" BIGINT,
  "expnd_an_by3" DOUBLE,
  "risk_scre_an_by3" DOUBLE,
  "bnmrk_an" DOUBLE,
  "risk_scre_an_py" DOUBLE,
  "mnth_disa_by1" BIGINT,
  "expnd_disa_by1" DOUBLE,
  "risk_scre_disa_by1" DOUBLE,
  "mnth_disa_by2" BIGINT,
  "expnd_disa_by2" DOUBLE,
  "risk_scre_disa_by2" DOUBLE,
  "mnth_disa_by3" BIGINT,
  "expnd_disa_by3" DOUBLE,
  "risk_scre_disa_by3" DOUBLE,
  "bnmrk_disa" DOUBLE,
  "risk_scre_disa_py" DOUBLE,
  "mnth_esrd_by1" BIGINT,
  "expnd_esrd_by1" DOUBLE,
  "risk_scre_esrd_by1" DOUBLE,
  "mnth_esrd_by2" BIGINT,
  "expnd_esrd_by2" DOUBLE,
  "risk_scre_esrd_by2" DOUBLE,
  "mnth_esrd_by3" BIGINT,
  "expnd_esrd_by3" DOUBLE,
  "risk_scre_esrd_by3" DOUBLE,
  "bnmrk_esrd" DOUBLE,
  "risk_scre_esrd_py" DOUBLE,
  "expnd_hha" DOUBLE,
  "expnd_snf" DOUBLE,
  "expnd_outp" DOUBLE,
  "expnd_hosp" DOUBLE,
  "expnd_inp" DOUBLE,
  "expnd_prof" DOUBLE,
  "expnd_dme" DOUBLE
);

Share link

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