# HHS risk adjustment transfers by issuer (summary report appendices C and D), BY2021-BY2025

`medicare_silver.fact_aca_risk_adjustment_transfer_history` · Insurer negotiated rates · status partial · 17,322 rows

The issuer tables of CMS's Summary Report on Individual and Small Group Market Risk Adjustment Transfers, published each June 30 for the prior benefit year: Appendix C (non-merged markets) and Appendix D (merged markets, MA and ME), long form, one row per issuer and amount column. program_component is state_transfer (per state market risk pool: individual non-catastrophic, individual catastrophic, small group, merged) or high_cost_risk_pool; amount_usd is signed; amount_status keeps the publisher dash as no_enrollment_in_pool.

**Grain.** One amount cell per (benefit_year, sha256_content_hash, source_appendix, sheet_name, source_row_number, source_column_number), i.e. one issuer x state x amount column of one appendix file. Measured 2026-09-25, 17,322 rows = 17,322 keys (Athena 24f71ef5).

| column | type | meaning |
|---|---|---|
| benefit_year | int |  |
| source_appendix | string |  |
| sheet_name | string |  |
| source_row_number | bigint |  |
| source_column_number | int |  |
| column_header_raw | string |  |
| hios_issuer_id | string |  |
| issuer_name | string |  |
| state_code | string |  |
| program_component | string |  |
| market_risk_pool | string |  |
| amount_usd | double |  |
| amount_raw | string |  |
| amount_status | string |  |
| ordered_header_json | string |  |
| header_sha256 | string |  |
| column_count | int |  |
| raw_values_json | string |  |
| raw_row_sha256 | string |  |
| artifact_id | string |  |
| source_file_bytes | bigint |  |
| final_source_url | string |  |
| expected_artifact_rows | bigint |  |
| publisher_modified_at | string |  |
| publisher_etag | string |  |
| report_title | string |  |
| report_url | string |  |
| report_revision_label | string |  |
| 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_aca_risk_adjustment_transfer_history WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_aca_risk_adjustment_transfer_history")` first.