VladaOmega
Sign inStart free
Medicare Advantage, Part D, Medicaid

MA county ratebook — CMS plan payment rates by county

medicare_silver.ma_county_ratebook·live·silver·Medicare Advantage County Ratebook
Rows
42,200
Columns
17
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1The county BENCHMARK — what CMS pays an MA plan per member in a county, by the county's quality-bonus tier: rate_5pct_bonus / rate_3_5pct_bonus / rate_0pct_bonus, plus rate_esrd.
  2. 2The revenue-rate INPUT for the Wolfe MA model (actual payment ~= benchmark x member risk score x rebate share).

Grain

KeyGrain
N/A
  1. 1One row per (rate_year, county) — CMS MA county benchmark rates by quality-bonus tier.
  2. 2CERTIFIED 2026-06-03.

Columns (17)

ColumnTypeMeaning
rate_yearint
ssa_county_codestring
state_namestring
county_namestring
rate_5pct_bonusfloat
rate_3_5pct_bonusfloat
rate_0pct_bonusfloat
rate_esrdfloat
effective_period_startdate
effective_period_enddate
source_urlstring
sha256_content_hashstring
bronze_publication_idstring
asserted_attimestamp
parse_revisionint
parser_artifact_hashstring
cms_vintage_sequenceint

Query it

describe_data_source(source_fqn="medicare_silver.ma_county_ratebook")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_county_ratebook WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keyssa_county_code
Joinhow_to_join(source_fqn="medicare_silver.ma_county_ratebook")
Raw doorAthena (read-only via query_substrate): medicare_silver.ma_county_ratebook
NoteCERTIFIED (product1-cert-ma-ratebook-v1). Current modern era remains served unchanged; legacy 1990-2014 bytes are secured in an exact deferred lane.

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