Medicare Advantage, Part D, Medicaid

MA rate notices CY2000-2027: every printed number with its verbatim line

medicare_silver.ma_rate_notice_value·live·silver

Rows

209,398

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every number printed in CMS's MA rate notices and fact sheets since CY2000, with its page, row label, column header, table caption, verbatim source line and whether a second PDF engine re-found it (engine2_confirmed).
2Raw print: it includes years, page and section numbers; filter by table_caption and row_label, never sum it.
3The curated figures are cms_ma_rate_notices.

Grain

Key	Grain
N/A	1One row per printed number: (sha256_content_hash, page, line_index, token_index).

Columns (21)

Column	Type	Meaning
`rate_year`	int
`stage`	string
`sha256_content_hash`	string
`page`	int
`line_index`	int
`token_index`	int
`row_label`	string
`column_header`	string
`table_caption`	string
`section_heading`	string
`value_text`	string
`value_num`	double
`value_unit`	string
`footnote`	string
`x0`	double
`source_line`	string
`engine2_confirmed`	boolean
`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_value")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_rate_notice_value WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`sha256_content_hash,page,line_index,token_index`
Join	`how_to_join(source_fqn="medicare_silver.ma_rate_notice_value")`
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_value.md · every page in one file: /llms-full.txt