Medicare Advantage, Part D, Medicaid

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

medicare_silver.fact_ma_landscape_edition·live·silver

Rows

6,066,778

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Sibling 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).
2This 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).
3Same columns as fact_ma_landscape plus edition; strings as published, cast on read.
4Use for what the market saw on Landscape day and the original-vs-revised diff; use fact_ma_landscape for the single served view.

Grain

Key	Grain
N/A	1One 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); 224 editions, 4,034,483 landscape rows (6,066,778 incl. plan-and-premium rows) on 2026-09-08.

Columns (80)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id,plan_id,segment_id`
Join	`how_to_join(source_fqn="medicare_silver.fact_ma_landscape_edition")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_ma_landscape_edition
Company names	`org_marketing_name` `org_name` `parent_org_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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