State programs

CMS Medicaid and CHIP monthly-enrollment source asset inventory

medicare_silver.cms_medicaid_chip_enrollment_source_asset·live·silver

Rows

204

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Complete physical source inventory for the accepted monthly state Medicaid and CHIP applications, eligibility, and enrollment family, retaining the current CSV and metadata, the official report-history page, 80 historical PDFs, 48 ZIP containers, 48 workbook members, 24 retained PDF members, document hashes, parse disposition, and content-addressed Bronze lineage.

Grain

Key	Grain
N/A	1One row per governed current portal asset, official historical report PDF or ZIP container, or exact expanded archive member.

Columns (31)

Column	Type	Meaning
`asset_id`	string
`source_family`	string
`document_role`	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
`parse_disposition`	string
`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.cms_medicaid_chip_enrollment_source_asset")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.cms_medicaid_chip_enrollment_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.cms_medicaid_chip_enrollment_source_asset")`
Raw door	Athena (read-only via query_substrate): medicare_silver.cms_medicaid_chip_enrollment_source_asset

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