Medicare Advantage, Part D, Medicaid

MA State/County Penetration, county codes at their documented width

medicare_semantic.vw_ma_state_county_penetration_v2·live·semantic_view

Rows

707,500

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, with FIPSST / SSAST padded to 2 digits, FIPSCNTY / SSACNTY to 3, and FIPS / SSA rebuilt as the concatenated state + county codes the publisher's readme defines (Read_Me_SC_Penetration_MA_YYYY.txt).
2CMS printed the codes without leading zeros in 2025-01, 2025-02, 2025-03 and 2026-08; every other month is unchanged. codes_padded_by_view marks the rows the view changed.

Grain

Key	Grain
N/A	1One row per (fipsst, fipscnty, report_month); the rows of medicare_silver.ma_state_county_penetration (707,500 over 220 months, view minus table = 0 and 0 duplicate (fips, report_month); 2Athena 8614613f-53f9-495e-966d-95afcc5eb49c).

Columns (25)

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
`codes_padded_by_view`	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_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_ma_state_county_penetration_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`fips`
Join	`how_to_join(source_fqn="medicare_semantic.vw_ma_state_county_penetration_v2")`
Raw door	Tool: get_market_share; Athena: medicare_semantic.vw_ma_state_county_penetration_v2 (pin report_month)
Note	Versioned view (Data Tracker served-defect lane, 2026-09-30, defect MASCP-1); supersedes the code columns of medicare_silver.ma_state_county_penetration. The MA runner pads from its next load (parser fix in the same PR). Record docs/reference/source-audit/source-mastery/records/medicare_ma_state_county_penetration.json.

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