Medicare Advantage, Part D, Medicaid

MA HEDIS contract service area, documented names

medicare_semantic.vw_hedis_service_area_v2·live·semantic_view·Medicare Advantage HEDIS Quality

Rows

2,453,366

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The counties in each MA contract's service area per HEDIS report year, from the HEDIS PUF service_area sheet, under CMS's documented names: ssa_state_county_code (SA-0030), fips_state_county_code (SA-0040, ANSI/FIPS INCITS 31-2009), fips_state_code (first two digits of SA-0040), state_code (SA-0050), county_name_raw (SA-0060), eghp_only_county (SA-0070: 1 = the county serves only Employer Group Health Plan members).

Grain

Key	Grain
N/A	1One row per (report_year, contract_id, ssa_state_county_code, fips_state_county_code, eghp_only_county): 0 duplicate groups in every year (Athena 2e4d240e, ccba7dde). 22,453,366 rows 2019, 2021-2025.

Columns (17)

Column	Type	Meaning
`contract_id`	string
`ssa_state_county_code`	string
`fips_state_county_code`	string
`fips_state_code`	string
`state_code`	string
`county_name_raw`	string
`eghp_only_county`	int
`report_year`	int
`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_hedis_service_area_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hedis_service_area_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_hedis_service_area_v2")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hedis_service_area_v2
Note	Documented-name view (HEDIS-fix lane 2026-09-29); supersedes the column names and key of medicare_silver.hedis_service_area. Versioned, never overwritten.

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