Medicare Advantage, Part D, Medicaid

MedPAC Data Book supporting workbook cells

medicare_silver.medpac_databook_workbook_cell·live·silver

Rows

7,862

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Lossless cell-level evidence from all 19 publisher-supplied MedPAC Data Book supporting workbooks for 2024 through 2026, preserving raw and displayed values, formulas, number formats, merged ranges, hyperlinks, sheet identity, section identity, semantic hashes, and exact Bronze lineage.

Grain

Key	Grain
N/A	1One nonempty physical cell per accepted workbook, sheet, and coordinate.

Columns (39)

Column	Type	Meaning
`corpus_snapshot_date`	date
`asset_id`	string
`edition_year`	int
`section_number`	int
`sheet_name`	string
`sheet_index`	int
`cell_coordinate`	string
`row_number`	int
`column_number`	int
`exhibit_number`	string
`raw_value_json`	string
`displayed_value_json`	string
`formula`	string
`data_type`	string
`number_format`	string
`merged_range`	string
`hyperlink`	string
`semantic_value_text`	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_workbook_cell")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medpac_databook_workbook_cell WHERE <filter> LIMIT 100")

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

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