Insurer negotiated rates

CCIIO Unified Rate Review PUF (URRT Part I) - filings, plans and rating-area factors, PY2024-PY2026

medicare_silver.fact_rate_review_puf_history·partial·silver

Rows

285,554

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The Part I Unified Rate Review Template data CMS publishes for every single-risk-pool rate filing, individual and small group, on and off exchange, 50 states and DC.
2Worksheet I per filing (issuer, market, effective date, filing cycle and status), Worksheet II per plan (cumulative proposed rate change as last filed and as first filed, current enrollment, projected member months, review determination), Worksheet III per rating-area factor.
3Lossless: the ordered header and raw values of every row are kept beside the typed columns.

Grain

Key	Grain
N/A	1One publisher CSV row per (plan_year, sha256_content_hash, worksheet, source_row_number); 2WKSH1 is one row per filing, WKSH2 one row per plan, WKSH3 one row per issuer x market x rating area. 3Measured 2026-09-25, 285,554 rows = 285,554 keys (Athena 942ed2c8).

Columns (53)

Column	Type	Meaning
`plan_year`	int
`worksheet`	string
`source_row_number`	bigint
`filing_id`	string
`hios_issuer_id`	string
`issuer_name`	string
`state_code`	string
`market`	string
`effective_date`	date
`filing_cycle`	string
`filing_status`	string
`plan_id`	string
`product_id`	string
`plan_category`	string
`on_exchange`	boolean
`review_determination`	string
`rate_change_cumulative`	double
`rate_change_cumulative_initial`	double
`current_enrollment`	double
`projected_member_months`	double
`rating_area_id`	string
`rating_area_factor`	double
`source_encoding`	string
`ordered_header_json`	string
`header_sha256`	string
`column_count`	int
`raw_values_json`	string
`raw_row_sha256`	string
`artifact_id`	string
`source_zip_bytes`	bigint
`final_source_url`	string
`archive_member`	string
`archive_member_sha256`	string
`archive_member_bytes`	bigint
`archive_inventory_json`	string
`expected_artifact_rows`	bigint
`publisher_modified_at`	string
`publisher_etag`	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

describe_data_source(source_fqn="medicare_silver.fact_rate_review_puf_history")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_rate_review_puf_history WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,sha256_content_hash,worksheet,source_row_number`
Join	`how_to_join(source_fqn="medicare_silver.fact_rate_review_puf_history")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_rate_review_puf_history
Company names	`issuer_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-09-25 (Data Tracker states program, lane B) under register w4 cms_cciio_rate_review_puf (the Lane G draft from #2746, uncommented after the medicare-fleet load). Door RAW, Data Tracker KPI MKT-14. Rates are fractions. History-only: listed in vlada/query/versioned_tables.json history_only so the door never injects is_current.

This page as markdown: /docs-md/data/medicare_silver_fact_rate_review_puf_history.md · every page in one file: /llms-full.txt