Medicare Advantage, Part D, Medicaid

MedPAC annual Data Book source asset inventory

medicare_silver.medpac_databook_source_asset·live·silver

Rows

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Complete recoverable public inventory for MedPAC's annual Health Care Spending and the Medicare Program Data Book, covering 24 annual PDFs from 2003 through 2026 and 19 selectively published supporting workbooks from 2024 through 2026, with edition, section, archive/live provenance, document hash, parse disposition, and exact Bronze lineage.

Grain

Key	Grain
N/A	1One row per accepted annual full-report PDF or publisher-supplied section workbook.

Columns (35)

Column	Type	Meaning
`corpus_snapshot_date`	date
`asset_id`	string
`edition_year`	int
`publication_family`	string
`document_role`	string
`section_number`	int
`title`	string
`publisher_page_url`	string
`original_source_url`	string
`acquisition_url`	string
`publisher_filename`	string
`actual_format`	string
`byte_count`	bigint
`document_sha256`	string
`archive_timestamp`	string
`source_availability`	string
`parse_disposition`	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_source_asset")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medpac_databook_source_asset WHERE <filter> LIMIT 100")

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

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