State programs

States W1 Coverage map: state_coverage_block_v1

medicare_silver.state_coverage_block_v1·partial·silver

Rows

330,720

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State product W1 (Coverage map) of the States lane: coverage by source (employer, Medicare, Medicaid, Marketplace, uninsured) by county and age band, from Census tables.
2One row per state x county x estimate year x coverage block x age band; members over population_universe is the share. additive_to_population = false blocks overlap (dual coverage) and must not be summed.
310 state(s): CA FL GA IL MI NC NY OH PA TX.

Grain

Key	Grain
N/A	1Coverage by source (employer, Medicare, Medicaid, Marketplace, uninsured) by county and age band, from Census tables. 2330,720 rows (Athena, 2026-10-29). 3Period 2019 to 2024 (estimate_year).

Columns (16)

Column	Type	Meaning
`state_code`	string
`county_fips`	string
`estimate_year`	int
`coverage_block`	string
`age_band`	string
`members`	int
`population_universe`	string
`source_sha256`	string
`source_url`	string
`locator`	string
`source_cell_ids`	string
`additive_to_population`	boolean
`canonical_entity_id`	string
`canonical_parent_id`	string
`parent_status`	string
`row_key`	string

Query it

describe_data_source(source_fqn="medicare_silver.state_coverage_block_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.state_coverage_block_v1 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_silver.state_coverage_block_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.state_coverage_block_v1 (filter state_code)

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