Insurer negotiated rates

States K3 Rate review cycle + state rules: marketplace_state_rate_decision_v1

medicare_silver.marketplace_state_rate_decision_v1·partial·silver

Rows

16,001

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Marketplace product K3 (Rate review cycle + state rules) of the States lane: state rate review decisions and each state's filing calendar and rules. marketplace_state_rate_decision_v1: one row per state x plan year x market x issuer decision; requested_pct_num and approved_pct_num are percents; statewide_bool rows are the state's average, never add them to issuer rows. marketplace_state_calendar_rule_v1: one row per state x plan year x calendar item (kind, item, value_raw, effective_date_d).
251 state(s): AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC SD TN TX UT VA VT WA WI WV WY.

Grain

Key	Grain
N/A	1State rate review decisions and each state's filing calendar and rules. 216,001 rows (Athena, 2026-10-29). 3Period 2013 to 2027 (plan_year_int).

Columns (31)

Column	Type	Meaning
`state_code`	string
`layer`	string
`plan_year`	string
`market`	string
`issuer_name_raw`	string
`hios_issuer_id`	string
`requested_pct`	string
`approved_pct`	string
`average_basis_raw`	string
`decision_date`	string
`decision_kind`	string
`statewide`	string
`document_url`	string
`document_sha256`	string
`locator`	string
`issuer_id`	string
`issuer_id_type`	string
`requested_basis_raw`	string
`value_status`	string
`plan_year_int`	int
`segment`	string
`requested_pct_num`	double
`approved_pct_num`	double
`decision_date_d`	date
`decision_date_precision`	string
`statewide_bool`	boolean
`contract_issues`	string
`source_file`	string
`source_file_git_blob`	string
`source_row_number`	int
`row_key`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_silver.marketplace_state_rate_decision_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.marketplace_state_rate_decision_v1 (filter state_code)
Company names	`issuer_name_raw` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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