# Medicare contract dimension

`vlada_curated.dim_contract` · Medicare Advantage, Part D, Medicaid · status live · 2,166 rows

The resolving dimension for Medicare contract_id, built because 89 catalogued assets carried the identifier and nothing defined it. Population 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. Attributes 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.** One row per Medicare contract_id — the authority for cms:contract_id.

| 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: `query_substrate` with `SELECT ... FROM vlada_curated.dim_contract WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.dim_contract")` first.