Medicare Advantage, Part D, Medicaid

MA rate notices CY2000-2027: the pinned documents (PDF, ZIP, HTML)

medicare_silver.ma_rate_notice_document·live·silver

Rows

124

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The register of every CMS MA rate notice file since CY2000 (Early Preview, Advance Notice, Rate Announcement, fact sheets and their ZIP attachments): stage, title, release date, source URL, SHA-256, pages, how many values were parsed and the parse scope.
2Join ma_rate_notice_value and ma_rate_notice_figure on sha256_content_hash.

Grain

Key	Grain
N/A	1One row per pinned file: (rate_year, sha256_content_hash).

Columns (18)

Column	Type	Meaning
`rate_year`	int
`stage`	string
`title`	string
`release_date`	string
`item_page_url`	string
`source_url`	string
`file_name`	string
`media_type`	string
`bytes`	int
`sha256_content_hash`	string
`last_modified`	string
`pages`	int
`values_parsed`	int
`parse_scope`	string
`bronze_uri`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`parser_artifact_hash`	string

Query it

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

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