Insurer negotiated rates

CMS rate review site (ratereview.healthcare.gov): ACA individual and small-group rate filings, requested and final average rate change, PY2019-2027

medicare_silver.fact_urr_submission_history·live·silver

Rows

11,095

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's public summary of every ACA single-risk-pool rate filing, captured from the site's public JSON service: the issuer's requested average rate change, the final change once the state or CMS finishes review, the range across the filing's products, review status and determination, and links to the redacted actuarial memorandum and the consumer justification narrative.
2The only national source of next year's requested changes before the URR PUF posts, and of FINAL changes per filing (the PUF carries filed changes only).
3Rates are percent points.

Grain

Key	Grain
N/A	1One row per element of one capture bundle: record_type 'submission' (one filing: issuer x state x market x effective date x review period) or 'product' (one product in a filing; captured for PY2026-2027 only). 2Never add the two. 311,095 rows: 7,372 submissions PY2019-2027 + 3,723 products (PY2026 2,156, PY2027 1,567), one capture per plan year, all taken 2026-10-26 (Athena 178ad67a, 2026-10-26).

Key

Grain

N/A

1One row per element of one capture bundle: record_type 'submission' (one filing: issuer x state x market x effective date x review period) or 'product' (one product in a filing; captured for PY2026-2027 only).
2Never add the two.
311,095 rows: 7,372 submissions PY2019-2027 + 3,723 products (PY2026 2,156, PY2027 1,567), one capture per plan year, all taken 2026-10-26 (Athena 178ad67a, 2026-10-26).

Columns (54)

Column	Type	Meaning
`plan_year`	int
`record_type`	string
`capture_line`	bigint
`element_index`	int
`state_code`	string
`submission_id`	bigint
`issuer_hios_id`	string
`issuer_name`	string
`market`	string
`effective_date`	date
`review_period`	string
`review_status`	string
`review_status_code`	string
`final_determination`	string
`current_status_date`	date
`rate_change_requested_pct`	double
`rate_change_final_pct`	double
`rate_change_range_min_pct`	double
`rate_change_range_max_pct`	double
`product_count`	int
`includes_exchange_plan_flag`	int
`product_id`	string
`product_name`	string
`actuarial_memo_url`	string
`consumer_justification_url`	string
`reviewer_comments`	string
`request_url`	string
`fetched_at`	string
`response_sha256`	string
`raw_record_json`	string
`raw_record_sha256`	string
`artifact_id`	string
`source_bundle_bytes`	bigint
`bundle_responses`	bigint
`expected_artifact_rows`	bigint
`capture_started_at`	string
`requested_zero_placeholder`	int
`response_meta_json`	string
`content_fingerprint`	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_urr_submission_history")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_urr_submission_history WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,sha256_content_hash,record_type,capture_line,element_index`
Join	`how_to_join(source_fqn="medicare_silver.fact_urr_submission_history")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_urr_submission_history (filter plan_year and record_type; newest capture = max(capture_started_at) per plan_year; never filter is_current)
Company names	`issuer_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-10-26 under register w4 (cms_urr_ratereview_submissions), door RAW, World W4 (PR claude/urr-register, stacked on #4295). History-only: listed in vlada/query/versioned_tables.json history_only, so the door never injects is_current (as versioned it would inject WHERE is_current and return no rows). Join to fact_rate_review_puf_history measured: Annual (state, HIOS issuer, market) site pairs found in the PUF WKSH1 2024 Individual 348/348, Small Group 405/405; 2025 337/339, 331/331; 2026 344/344, 317/317 (Athena 758f78f9). Newest capture SQL: capture_started_at = (SELECT max(capture_started_at) FROM medicare_silver.fact_urr_submission_history WHERE plan_year = <year>).

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