Medicare Advantage, Part D, Medicaid

MA county ratebook, exact cents, one state key, territory rows kept

medicare_semantic.vw_ma_county_ratebook_v3·live·semantic_view

Rows

42,218

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The county benchmark CMS publishes with each Rate Announcement, per SSA county and rate year: the rate at the 5%, 3.5% and 0% quality-bonus tiers and the ESRD rate, in exact cents (decimal(10,2)), with state_code taken from the SSA prefix so one key finds every year.
2A view over medicare_silver.ma_county_ratebook_v2 (parser 0.2.0); get_ma_county_ratebook reads it from 2026-10-05 and filters on state_code.

Grain

Key	Grain
N/A	1One row per (rate_year, ssa_county_code). 242,218 rows over rate years 2015-2027: the served table's 42,200 rows plus 18 territory-wide rows (Athena 3800cd23).

Columns (20)

Column	Type	Meaning
`rate_year`	int
`ssa_county_code`	string
`state_code`	varchar(2)
`state_name`	varchar(24)
`state_name_legacy`	string
`county_name`	string
`territory_wide_row`	boolean
`rate_5pct_bonus`	decimal(10,2)
`rate_3_5pct_bonus`	decimal(10,2)
`rate_0pct_bonus`	decimal(10,2)
`rate_esrd`	decimal(10,2)
`effective_period_start`	date
`effective_period_end`	date
`source_url`	string
`sha256_content_hash`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`parse_revision`	int
`parser_artifact_hash`	string
`cms_vintage_sequence`	int

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ssa_county_code`
Join	`how_to_join(source_fqn="medicare_semantic.vw_ma_county_ratebook_v3")`
Raw door	Tool: get_ma_county_ratebook; Athena: medicare_semantic.vw_ma_county_ratebook_v3 (pin rate_year; filter state_code)
Note	Wave-1A reload (Data Tracker, docs/data-tracker/RELOAD-PLAN-WAVE1A-MA-LOADERS-2026-10-01.md, defects RATEBOOK-1..4). Versioned, never overwritten; the legacy card stays live as the rollback.

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