State programs

MACPAC MACStats source asset inventory

medicare_silver.macpac_macstats_source_asset·live·silver

Rows

536

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Complete 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

Key	Grain
N/A	1One row per accepted full-edition PDF, historical Excel container, or exact workbook asset.

Columns (38)

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

describe_data_source(source_fqn="medicare_silver.macpac_macstats_source_asset")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.macpac_macstats_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.macpac_macstats_source_asset")`
Raw door	Athena (read-only via query_substrate): medicare_silver.macpac_macstats_source_asset

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