# CMS MA / Part D Landscape, EVERY edition held (Wayback originals + revisions + served copy), one partition per publisher zip

`medicare_silver.fact_ma_landscape_edition` · Medicare Advantage, Part D, Medicaid · status live · 6,066,778 rows

Sibling of fact_ma_landscape (which holds ONE edition per report_year: the copy CMS serves today, a REVISED bundle for CY2006-CY2025 with the star column re-stamped and sanctioned rows removed). This table holds every edition we have of a year side by side: the original September publication captured from the Wayback Machine (22 zips, CY2021-CY2026, bronze initial_editions/ with SHA-256), each mid-year revision, and the served copy. edition = the publisher zip stem (cy2026-landscape-202509 = the original CY2026 file of Sept 2025; cy2026-landscape-202608 = the Aug 2026 revision; cy2006-cy2025-landscape-files = the served bundle). Same columns as fact_ma_landscape plus edition; strings as published, cast on read. Use for what the market saw on Landscape day and the original-vs-revised diff; use fact_ma_landscape for the single served view.

**Grain.** One row per edition x report_year x record_family x category x plan (contract, plan, segment) as published; natural key (edition, report_year, row_seq); 24 editions, 4,034,483 landscape rows (6,066,778 incl. plan-and-premium rows) on 2026-09-08.

| 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 |  |
| edition | string |  |
| part_d_lips_cms_pays | string |  |
| part_d_low_income_beneficiary_premium | string |  |
| enrollment_capacity_limit_accepted | string |  |
| enrollment_capacity_limit_amount | string |  |

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