Medicare Advantage, Part D, Medicaid

MedPAC annual Data Book page evidence

medicare_silver.medpac_databook_page·live·silver

Rows

5,091

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Layout-preserving page evidence for all 5,091 pages in the 24 accepted annual MedPAC Data Books from 2003 through 2026, retaining page text, section and exhibit detection, page hash, extraction eligibility, source URL, and content-addressed Bronze lineage.

Grain

Key	Grain
N/A	1One physical PDF page per accepted annual edition and source asset.

Columns (34)

Column	Type	Meaning
`corpus_snapshot_date`	date
`asset_id`	string
`edition_year`	int
`document_role`	string
`page_number`	int
`section_number`	int
`exhibit_type`	string
`exhibit_number`	string
`exhibit_title`	string
`page_text`	string
`page_text_sha256`	string
`word_count`	int
`extraction_method`	string
`publisher_source_url`	string
`document_sha256`	string
`semantic_row_sha256`	string
`is_current_edition`	boolean
`quality_flags`	string
`is_analytics_eligible`	boolean
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`observed_period,asset_id,page_number`
Join	`how_to_join(source_fqn="medicare_silver.medpac_databook_page")`
Raw door	Athena (read-only via query_substrate): medicare_silver.medpac_databook_page

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