State programs

District of Columbia Medicaid monthly enrollment report history

medicare_silver.dc_medicaid_enrollment_history_observation·live·silver

Rows

53,274

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Source-native DHCF Medicaid and Alliance monthly report observations from 121 known official PDFs as of October 24, 2026.
2Later reports can revise earlier months; a preferred-report flag marks the source selection without discarding older rows.

Grain

Key	Grain
N/A	1One official report edition × observation month × printed section × plan/program row; all report revisions retained.

Columns (37)

Column	Type	Meaning
`state_code`	string
`occurrence_id`	string
`document_sha256`	string
`publication_date`	date
`report_period`	date
`observation_period`	date
`measurement_basis`	string
`section_name_raw`	string
`dimension_1_raw`	string
`plan_name_raw`	string
`source_plan_identity_id`	string
`program_class`	string
`row_type`	string
`row_role`	string
`reported_value`	bigint
`value_status`	string
`evidence_source_url`	string
`evidence_content_sha256`	string
`source_locator`	string
`semantic_row_sha256`	string
`period_revision_rank`	int
`is_preferred_period_snapshot`	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.dc_medicaid_enrollment_history_observation")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.dc_medicaid_enrollment_history_observation WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`semantic_row_sha256`
Join	`how_to_join(source_fqn="medicare_silver.dc_medicaid_enrollment_history_observation")`
Raw door	Internal Athena/Glue source table only; no independent customer raw-row entitlement. Customer ledger and parent routes have separate governed acceptance.
Note	The October 24 source edition retains all 49,816 August rows and adds 3,458 observations from seven additional report PDFs. It has 9,827 preferred rows. Bundle SHA-256 8611f691cc98019e3b5dce5956dedda7414c322d87ea0147d785cce0d7de8b23; identical replay left the snapshot and Bronze version unchanged.

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