# MedPAC annual Data Book source asset inventory

`medicare_silver.medpac_databook_source_asset` · Medicare Advantage, Part D, Medicaid · status live · 43 rows

Complete 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.** One row per accepted annual full-report PDF or publisher-supplied section workbook.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.medpac_databook_source_asset WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.medpac_databook_source_asset")` first.