Medicare Advantage, Part D, Medicaid

PDP State/County Penetration, 2008-2026

medicare_silver.pdp_state_county_penetration·live·silver

Rows

712,768

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1For every county and month: Medicare eligibles, stand-alone PDP enrollment and PDP penetration, the PDP twin of MA State/County Penetration (same columns, identical eligibles).
22026-09: 3,188 rows, 69,511,516 eligibles, 25,021,800 PDP enrollees.

Grain

Key	Grain
N/A	1One row per (fipsst, fipscnty, report_month).

Columns (24)

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`fipsst,fipscnty,report_month`
Join	`how_to_join(source_fqn="medicare_silver.pdp_state_county_penetration")`
Raw door	Athena (read-only via query_substrate): medicare_silver.pdp_state_county_penetration
Note	Register source cms_pdp_state_county_penetration (w3, serve raw). RAW; same shape as the MA twin already served. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 712,768 rows, 221 months, 0 duplicate keys, eligibles and enrolled sums equal the publisher every month; Athena 1ce22253, 90ef644a, 879d43c0). Cell reconciliation PASS 2008-05, 2017-01, 2019-10, 2026-09. Unlike the MA twin (defect MASCP-1), codes are zero-padded in every month. Registered 2026-09-30.

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