Medicare Advantage, Part D, Medicaid

Medicare contract dimension

vlada_curated.dim_contract·live·dim

Rows

2,166

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The resolving dimension for Medicare contract_id, built because 89 catalogued assets carried the identifier and nothing defined it.
2Population is the UNION of contract_id observed across seven sources (monthly contract enrollment, stars contracts, MA contract service area, plan- and county-level enrollment, landscape, SNP), because per-source counts disagree by up to 300 and no single source is authoritative.
3Attributes are LAST OBSERVED with the observation month carried alongside, so staleness is visible rather than assumed; they are not modelled per year, which would make this a slowly-changing fact and fan out every join through it.

Grain

Key	Grain
N/A	1One row per Medicare contract_id — the authority for cms:contract_id.

Columns (14)

Column	Type	Meaning
`contract_id`	string
`contract_type_code`	string
`contract_type`	varchar(39)
`organization_type`	string
`organization_name`	string
`marketing_name`	string
`parent_organization`	string
`plan_type`	string
`contract_effective_date`	date
`attributes_as_of_month`	date
`attributes_as_of_rating_year`	int
`attribute_source`	varchar(35)
`first_observed_month`	date
`last_observed_month`	date

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id`
Join	`how_to_join(source_fqn="vlada_curated.dim_contract")`
Raw door	Athena (read-only): vlada_curated.dim_contract
Company names	`organization_name` `parent_organization` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Measured 2026-08-15 at 100.0% coverage against six contract-carrying fact assets. Built by ops/scripts/build_dim_contract.py using the versioned pattern; the view repoints and nothing is dropped.

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