# MSSP ACO performance year financial and quality results, PY2013-PY2024

`medicare_silver.fact_mssp_aco_performance_cell` · Medicare Advantage, Part D, Medicaid · status live · 878,574 rows

Every Shared Savings Program ACO's annual reconciliation as CMS published it, one row per cell: assigned beneficiaries, benchmark and actual expenditures, savings rate, earned shared savings or losses, quality score, risk scores and per-capita spending by enrollment type. PY2024: 476 ACOs, $4.12B earned shared savings, 10.3M assigned beneficiaries.

**Grain.** One row per ACO per published column per publisher_version (cell grain); is_current marks the served version.

| column | type | meaning |
|---|---|---|
| publisher_version | string |  |
| performance_year | int |  |
| performance_period | string |  |
| aco_id | string |  |
| aco_id_scheme | string |  |
| aco_name | string |  |
| source_row_number | int |  |
| field_order | int |  |
| field_name | string |  |
| field_variable | string |  |
| field_mapping | string |  |
| field_term | string |  |
| dictionary_id | string |  |
| value_kind | string |  |
| value_text | string |  |
| value_status | string |  |
| value_numeric | double |  |
| value_date | date |  |
| rate_scale | string |  |
| value_rate_pct | double |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_mssp_aco_performance_cell WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_mssp_aco_performance_cell")` first.