Medicare Advantage, Part D, Medicaid

MA rate notices CY2000-2027: documents, every printed number, curated figures

medicare_silver.ma_rate_notice_figure·live·silver

Rows

697

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's Early Preview, Advance Notice, Rate Announcement and fact sheets for every rate year since 2000, loaded as data: the payment impact table, the risk score trend, growth percentages, normalization factors, the coding adjustment, and every other number with its verbatim line.

Grain

Key	Grain
N/A	1Figures: one row per (rate_year, stage, figure_key, qualifier, source_stage). 2Values: one row per printed number (sha256_content_hash, page, line_index, token_index). 3Documents: one row per pinned file.

Columns (21)

Column	Type	Meaning
`rate_year`	int
`stage`	string
`figure_key`	string
`qualifier`	string
`value_num`	double
`value_text`	string
`value_unit`	string
`footnote`	string
`label_as_printed`	string
`includes_risk_score_trend`	boolean
`source_stage`	string
`sha256_content_hash`	string
`page`	int
`line_index`	int
`token_index`	int
`source_line`	string
`extraction_rule`	string
`source_url`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`parser_artifact_hash`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,stage,figure_key,qualifier,source_stage`
Join	`how_to_join(source_fqn="medicare_silver.ma_rate_notice_figure")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_rate_notice_figure, ma_rate_notice_value, ma_rate_notice_document

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