Medicare Advantage, Part D, Medicaid
SNP HEDIS service area (plan x county), 2019-2025
medicare_silver.snp_hedis_service_area·live·silverRows
124,273
Columns
17
History
N/A
Card
nocolumns only
Typed tools
0
What it is
- 1The counties each SNP plan served in the HEDIS year, with SSA and ANSI (FIPS) county codes and the employer-only flag.
- 22025: 31,292 rows.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (17)
| Column | Type | Meaning |
|---|---|---|
contract_id | string | |
plan_id | string | |
ssa_code | string | |
ansi_code | string | |
state_code | string | |
county_name_raw | string | |
eghp_only | string | |
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_silver.snp_hedis_service_area") # the card, live query_substrate(sql="SELECT * FROM medicare_silver.snp_hedis_service_area WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | none; raw SQL |
| Identity key | contract_id,plan_id,ssa_code,ansi_code,report_year |
| Join | how_to_join(source_fqn="medicare_silver.snp_hedis_service_area") |
| Raw door | Athena (read-only via query_substrate): medicare_silver.snp_hedis_service_area |
| Note | Register source cms_snp_hedis_puf (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30 for all four tables: general 4,936, service area 124,273, measures 211,299, RAU 52,668 rows; 0 duplicate keys; Athena d363fb91, fcad559b, 4404b749, 0a8f9699). Cell reconciliation PASS on 2019, 2021, 2024 and 2025 including the documentation-code check (every General-00xx code read against that year's PUF documentation). Registered 2026-09-30. |
This page as markdown: /docs-md/data/medicare_silver_snp_hedis_service_area.md · every page in one file: /llms-full.txt