# CMS MA / Part D Landscape, every era CY2006-CY2027, stamped

`medicare_silver.fact_ma_landscape` · Medicare Advantage, Part D, Medicaid · status live · 1,684,158 rows

The CMS Landscape files re-collected through the provenance envelope on 2026-09-07: 38 header signatures across three publisher eras (2006 premium-only; 2007-2024 per-category files; CY2025+ one combined file) resolved by exact header contracts (pipelines/medicare/silver/ma_landscape_contracts.yaml); every row carries source_url, sha256_content_hash, asserted_at. Filter record_family = 'landscape' AND is_current for the plan roster; record_family = 'plan_premium' holds the plan-and-premium files. Column mapping stress-tested (docs/knowledge/recollection/landscape-stress-test-2026-09-06.md); the 2010 MA 'MOOP $3,400' column is the Yes/No flag moop_at_or_below_3400_flag, not an amount.

**Grain.** One row per report_year x record_family x category x plan (contract, plan, segment) as published; natural key (report_year, row_seq); 1,684,158 landscape rows + plan-and-premium rows; 78 year x category partitions on 2026-09-07.

| column | type | meaning |
|---|---|---|
| report_year | int |  |
| row_seq | bigint |  |
| record_family | string |  |
| category | string |  |
| contract_id | string |  |
| plan_id | string |  |
| segment_id | string |  |
| source_member | string |  |
| source_member_sha256 | string |  |
| state | string |  |
| county | string |  |
| org_name | string |  |
| plan_name | string |  |
| plan_type | string |  |
| snp_indicator | string |  |
| benefit_type | string |  |
| consolidated_premium | string |  |
| part_c_premium | string |  |
| part_d_premium | string |  |
| part_d_deductible | string |  |
| moop_in_network | string |  |
| overall_star_rating | string |  |
| part_d_star | string |  |
| gap_coverage | string |  |
| sanctioned | string |  |
| state_name | string |  |
| us_territory | string |  |
| org_marketing_name | string |  |
| parent_org_name | string |  |
| contract_name | string |  |
| organization_type | string |  |
| snp_type | string |  |
| snp_institutional_type | string |  |
| snp_institutional_category | string |  |
| dsnp_integration_status | string |  |
| dsnp_aip_identifier | string |  |
| csnp_condition_type | string |  |
| zero_dollar_cost_sharing_dsnp | string |  |
| drug_benefit_category | string |  |
| benefit_type_detail | string |  |
| part_d_coverage_indicator | string |  |
| national_pdp | string |  |
| de_minimis_participant | string |  |
| part_d_basic_premium_at_or_below_benchmark | string |  |
| zero_premium_with_full_lis | string |  |
| lis_auto_enrollment | string |  |
| tier_without_deductible | string |  |
| increased_initial_coverage_limit | string |  |
| part_d_basic_premium | string |  |
| part_d_supplemental_premium | string |  |
| part_d_oop_threshold | string |  |
| lips_amount | string |  |
| part_c_star | string |  |
| ma_region_code | string |  |
| ma_region | string |  |
| pdp_region_code | string |  |
| pdp_region | string |  |
| mmp_start_date | string |  |
| demo_type | string |  |
| moop_at_or_below_3400_flag | string |  |
| 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 |  |
| source_id | string |  |
| is_current | boolean |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |
| vintage_tag | string |  |
| drug_source_version_id | string |  |
| part_d_lips_cms_pays | string |  |
| part_d_low_income_beneficiary_premium | string |  |
| enrollment_capacity_limit_accepted | string |  |
| enrollment_capacity_limit_amount | string |  |
| part_d_premium_obligation_75pct_assistance | string |  |
| part_d_premium_obligation_50pct_assistance | string |  |
| part_d_premium_obligation_25pct_assistance | string |  |
| gap_coverage_type | string |  |
| state_code | string |  |
| lis_auto_enrollment_all_eras | string |  |
| drug_benefit_category_all_eras | string |  |
| drug_benefit_type_all_eras | string |  |

Tools that read it: get_county_view, get_landscape, get_landscape_benefit_change, get_landscape_exits, get_network_breadth, get_network_groups, get_network_system_change, get_pbp_benefit, get_plan_network

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.fact_ma_landscape WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_ma_landscape")` first.