Medicare Advantage, Part D, Medicaid

MA State/County Penetration over the reconciled parse, with Pending rows, blank cells and combined territory figures marked

medicare_semantic.vw_ma_state_county_penetration_v4·live·semantic_view

Rows

709,490

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare eligibles, MA enrollees and MA penetration per county and month from CMS's MA State/County Penetration files, the v3 projection over the reconciled parse-revision-2 table medicare_silver.ma_state_county_penetration_v2: codes padded (MASCP-1), blank Enrolled coded not_reported (MASCP-3), CMS's Pending State / Pending County Designation rows in every month (MASCP-2: +1,990 rows 2008-2016) with pending_designation set by the parser from CMS's labels, the 2016-02 Bedford City penetration recovered (36.0), and the figure CMS prints once on every county of a combined territory group flagged with eligibles_counts_once / enrolled_counts_once (MASCP-4). get_ma_penetration, get_market_share and get_county_view read this view from 2026-10-05.

Grain

Key	Grain
N/A	1One row per (fipsst, fipscnty, state_name, report_month); 2709,490 rows over 220 months 2008-06..2026-09, 2,202 Pending rows, 0 duplicate keys. 3Every row of vw_ma_state_county_penetration_v3 is here with equal values (707,500 joined, 0 differences except the 2016-02 Bedford City penetration; 4Athena 0a9416a2, 1c79d799).

Columns (34)

Column	Type	Meaning
`fipsst`	string
`fipscnty`	string
`report_month`	date
`state_name`	string
`county_name`	string
`fips`	string
`ssast`	string
`ssacnty`	string
`ssa`	string
`eligibles`	int
`enrolled`	int
`enrolled_lower_bound`	int
`enrolled_upper_bound`	int
`penetration`	double
`suppression_reason_code`	string
`suppression_reason_code_legacy`	string
`codes_padded_by_view`	boolean
`pending_designation`	boolean
`combined_county_group`	varchar(21)
`eligibles_repeated_across_group`	boolean
`enrolled_repeated_across_group`	boolean
`figures_repeated_across_group`	boolean
`penetration_is_group_figure`	boolean
`eligibles_counts_once`	boolean
`enrolled_counts_once`	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

Query it

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

Item	Value
Typed tools that read it	get_county_view, get_market_share
Identity key	`fips`
Join	`how_to_join(source_fqn="medicare_semantic.vw_ma_state_county_penetration_v4")`
Raw door	Tools: get_ma_penetration, get_market_share, get_county_view; Athena: medicare_semantic.vw_ma_state_county_penetration_v4 (pin report_month)
Note	Versioned view (Data Tracker, PR 3183, over the wave-1A reload; defects MASCP-1..4). Never overwritten; vw_ma_state_county_penetration_v3 stays live as the rollback.

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