Vlada Stars measure spine, one row per Star measure identity per rating year 2015 to 2027, with that year's code and cut points

What it is

1. 1The one place a Star measure keeps its identity across rating years.
2. 2CMS reuses measure codes (for RY2026, 27 of the 33 Part C codes moved;
3. 3C14 has named five different measures since 2015).
4. 4Each row carries that year's measure_id, measure_name, part_type, domain, weight, direction (that year's flag) and direction_latest (the identity's current direction), methodology_version and era, is_new_this_year and is_retired, prior_year_measure_id and next_year_measure_id, cmit_number where CMS gives one, and the cut points for stars 2 to 5 as star_k_threshold with star_k_op (RY2026 Controlling Blood Pressure: star_4_threshold 80, op >=), with ladder_direction and cutpoint_epoch.
5. 5Built by tools/ma_brain/stars_measure_spine_publish.py; checked cell for cell against an independent derivation with 0 differences; seven invariants pass, including that the direction flag agrees with CMS's own cut point ladder in every year.
6. 6Tools: get_stars, get_stars_cutpoints.

Grain

Columns (47)

Query it

describe_data_source(source_fqn="medicare_semantic.dim_stars_measure_identity_v7")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.dim_stars_measure_identity_v7 WHERE <filter> LIMIT 100")