Medicare Advantage, Part D, Medicaid
SNP HEDIS measure rates (plan x indicator), 2019-2025
medicare_silver.snp_hedis_measures·live·silverRows
211,299
Columns
21
History
N/A
Card
nocolumns only
Typed tools
0
What it is
- 1The HEDIS rate per SNP plan, measure and indicator, with confidence limits and (where published) numerator, denominator and eligible population.
- 22025: 38,961 rows;
- 3Care for Older Adults medication review (200737_20) averages 84.23 over 676 D-SNP plans.
Grain
| Key | Grain |
|---|---|
| N/A |
|
Columns (21)
| Column | Type | Meaning |
|---|---|---|
contract_id | string | |
plan_id | string | |
measure_code | string | |
indicator_key | string | |
rate | double | |
rate_raw | string | |
lcl | double | |
ucl | double | |
denominator | double | |
numerator | double | |
eligible_population | 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_silver.snp_hedis_measures") # the card, live query_substrate(sql="SELECT * FROM medicare_silver.snp_hedis_measures WHERE <filter> LIMIT 100")
| Item | Value |
|---|---|
| Typed tools that read it | none; raw SQL |
| Identity key | contract_id,plan_id,measure_code,indicator_key,report_year |
| Join | how_to_join(source_fqn="medicare_silver.snp_hedis_measures") |
| Raw door | Athena (read-only via query_substrate): medicare_silver.snp_hedis_measures |
| 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_measures.md · every page in one file: /llms-full.txt