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 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).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:19:27.156951
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-08oc2

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_01fc1c8e

366.91 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_01fc1c8e (
  "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-01-06oc2

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_02de32d3

369.62 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_02de32d3 (
  "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 : 2017-01-01

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_07bdf62c

377.17 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_07bdf62c (
  "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-10oc4

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_1502d8ba

366.41 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_1502d8ba (
  "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-01-05oc1

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_1b786cf1

373.24 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_1b786cf1 (
  "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-04oc1

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_3cd64104

363.96 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_3cd64104 (
  "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-06oc3

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_464bc589

363.07 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_464bc589 (
  "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 : 2016-01-01

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_60e34b2c

378 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_60e34b2c (
  "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-01-04

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_64ed1369

372.71 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_64ed1369 (
  "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-01-02

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_6983bffd

377.51 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_6983bffd (
  "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 : 2018-01-01

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_849f0441

377.55 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_849f0441 (
  "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 : 2024-01-03oc2

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_90a637e1

364.79 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_90a637e1 (
  "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-09oc3

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_9a1e4cce

370.09 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_9a1e4cce (
  "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 : 2024-01-02oc1

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_b628e9eb

359.83 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_b628e9eb (
  "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-03

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_bb4b57d1

367.25 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_bb4b57d1 (
  "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_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_d4ee75ca

369.75 kB
3,225 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 : 2024-01-04oc3

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_d95c1ce8

360.55 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_d95c1ce8 (
  "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-07oc1

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_ece706d6

371.01 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_ece706d6 (
  "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-05oc2

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_f095204c

366.16 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_f095204c (
  "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 : 2024-01-01

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_f74d6296

364.86 kB
3,226 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_f74d6296 (
  "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-01-02

@usgov.hhs_gov_county_level_aggregate_expenditure_and_risk_sc_57646cb3.county_level_aggregate_expenditure_and_risk_score_on_a_fed08c7f

375.64 kB
3,225 rows
21 columns

CREATE TABLE county_level_aggregate_expenditure_and_risk_score_on_a_fed08c7f (
  "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
);