# MACPAC MACStats source asset inventory

`medicare_silver.macpac_macstats_source_asset` · State programs · status live · 536 rows

Complete public MACStats inventory across 19 official editions from March 2011 through February 2026, retaining 19 full PDFs, 18 historical Excel containers, 456 exact archived workbook members, 43 current workbooks, document hashes, parse disposition, publication vintage, and content-addressed Bronze lineage.

**Grain.** One row per accepted full-edition PDF, historical Excel container, or exact workbook asset.

| column | type | meaning |
|---|---|---|
| corpus_snapshot_date | date |  |
| asset_id | string |  |
| edition_id | string |  |
| edition_year | int |  |
| publication_date | date |  |
| publication_family | string |  |
| document_role | string |  |
| exhibit_number | string |  |
| title | string |  |
| publisher_page_url | string |  |
| original_source_url | string |  |
| acquisition_url | string |  |
| container_asset_id | string |  |
| container_member | string |  |
| publisher_filename | string |  |
| actual_format | string |  |
| byte_count | bigint |  |
| document_sha256 | 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.macpac_macstats_source_asset WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.macpac_macstats_source_asset")` first.