About this Dataset

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries

The Shared Savings Program County-level Aggregate Expenditure and Risk Score Data on Assignable Beneficiaries Public Use File (PUF) for the Medicare Shared Savings Program (Shared Savings Program) provides aggregate data consisting of per capita Parts A and B FFS expenditures, average CMS-HCC prospective risk scores, average demographic risk scores and total person-years for Shared Savings Program assignable beneficiaries by Medicare enrollment type (End Stage Renal Disease (ESRD), disabled, aged/dual eligible, aged/non-dual eligible).

DISCLAIMER: This information is current as of the last update. Changes to Shared Savings Program Accountable Care Organization (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 PUF and the ACO Participants PUF.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-05-07T04:58:30.703463
Tags: accountable-care-organizations, coordinated-care, counties, financials, medicare, original-medicare, payment-models, value-based-care

Tables

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2022-12-05oc1

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_01038d1e

362.02 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_01038d1e (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2023-12-01

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_041f2ee5

358.79 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_041f2ee5 (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2021-12-18

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_09efc897

365.18 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_09efc897 (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2019-12-16

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_140a545b

369.3 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_140a545b (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2021-12-19oc1

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_26cabb99

365.11 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_26cabb99 (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2020-12-16

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_282ded37

367.79 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_282ded37 (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2022-12-06oc2

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_9011ecc6

358.21 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_9011ecc6 (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2022-12-02

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_d4ee75ca

362.47 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_d4ee75ca (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);

County-level Aggregate Expenditure And Risk Score Data On Assignable Beneficiaries : 2021-12-20oc2

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_12a7bebf.county_level_aggregate_expenditure_and_risk_score_on_a_f5125e31

362.58 KB
3225 rows
21 columns


CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_f5125e31 (
  "year" BIGINT,
  "state_name" VARCHAR,
  "county_name" VARCHAR,
  "state_id" BIGINT,
  "county_id" BIGINT,
  "per_capita_exp_esrd" VARCHAR,
  "avg_risk_score_esrd" VARCHAR,
  "avg_demog_score_esrd" VARCHAR,
  "person_years_esrd" VARCHAR,
  "per_capita_exp_dis" VARCHAR,
  "avg_risk_score_dis" VARCHAR,
  "avg_demog_score_dis" VARCHAR,
  "person_years_dis" VARCHAR,
  "per_capita_exp_agdu" VARCHAR,
  "avg_risk_score_agdu" VARCHAR,
  "avg_demog_score_agdu" VARCHAR,
  "person_years_agdu" VARCHAR,
  "per_capita_exp_agnd" VARCHAR,
  "avg_risk_score_agnd" VARCHAR,
  "avg_demog_score_agnd" VARCHAR,
  "person_years_agnd" VARCHAR
);