Medicare Advantage, Part D, Medicaid

CMS MA / Part D Medical Loss Ratio public-use files CY2014-CY2023, loader revision 2 (every report line)

medicare_silver.fact_ma_mlr_v2·live·silver

Rows

4,984

Columns

119

History

N/A

Card

nocolumns only

Typed tools

What it is

1The MLR public-use files re-parsed from the held bytes with loader revision 2: every revision-1 column unchanged plus the 39 MLR report lines revision 1 never mapped (sequestration, premium reductions, risk corridor, reserves, incentive pools, fraud reduction and recoveries, the 2014-2017 Worksheet 2 lines, base credibility factor). detail_available = 'true' marks the wide years (2014-2017, 2023);
22018-2022 carry only adjusted MLR and remittance.
3Strings; cast on read. get_mlr reads this table from 2026-10-05.

Grain

Key	Grain
N/A	1One row per contract_year x contract among is_current rows; 24,984 rows over 10 contract years, the served table's rows one for one (Athena 0f0e7cdc).

Columns (119)

Column	Type	Meaning
`contract_year`	int
`contract_id`	string
`source_member`	string
`source_member_sha256`	string
`organization_name`	string
`adjusted_mlr`	string
`remittance_amount`	string
`detail_available`	string
`total_revenue`	string
`ma_plan_payments`	string
`part_d_direct_subsidy`	string
`part_d_reinsurance_subsidy`	string
`part_d_lipsa`	string
`total_claims`	string
`claims_incurred`	string
`claims_parts_a_b`	string
`claims_supplemental`	string
`claims_part_d_drugs`	string
`lics_amount`	string
`dir_amount`	string
`supp_dental`	string
`supp_vision`	string
`supp_hearing`	string
`supp_transportation`	string
`supp_fitness`	string
`supp_otc`	string
`supp_meals`	string
`total_taxes_and_fees`	string
`total_qi_expenses`	string
`total_non_claims_costs`	string
`member_months`	string
`mlr_numerator`	string
`mlr_denominator`	string
`credibility_member_months`	string
`unadjusted_mlr`	string
`credibility_adjustment`	string
`mlr_standard`	string
`is_credible`	string
`beneficiary_premium_ma`	string
`beneficiary_premium_part_d`	string
`broker_commissions`	string
`direct_sales_salaries`	string
`cost_containment`	string
`other_g_and_a`	string
`qi_improve_health_outcomes`	string
`qi_prevent_readmission`	string
`qi_patient_safety`	string
`qi_wellness`	string
`qi_health_it`	string
`qi_mtm`	string
`qi_fraud_reduction`	string
`supp_worldwide`	string
`supp_remote_access`	string
`supp_foot_care`	string
`supp_acupuncture`	string
`supp_chiropractic`	string
`supp_pers`	string
`supp_health_education`	string
`supp_smoking_cessation`	string
`supp_ssbci`	string
`supp_out_of_network`	string
`supp_other_primarily_health`	string
`tax_federal_income`	string
`tax_state_premium`	string
`tax_state_income`	string
`ma_sequestration_adjustment`	string
`part_d_sequestration_adjustment`	string
`ma_rebate_part_b_premium_reduction`	string
`ma_rebate_part_d_premium_reduction`	string
`msa_enrollee_deposit`	string
`part_d_risk_corridor`	string
`supp_other_non_primarily_health`	string
`claims_liability_reserves`	string
`incentive_pools_paid`	string
`incentive_pools_accrued`	string
`contingent_benefit_reserves`	string
`claims_ma_rebate_part_b_premium_reduction`	string
`claims_msa_enrollee_deposit`	string
`fraud_reduction_expense_total`	string
`fraud_recoveries`	string
`part_d_claims_included`	string
`tax_other_federal`	string
`tax_community_benefit`	string
`regulatory_fees`	string
`aca_9010_fee`	string
`qi_icd10`	string
`other_claims_adjustment_expenses`	string
`taxes_not_excluded_from_revenue`	string
`regulatory_fines_penalties`	string
`non_claims_community_benefit`	string
`icd10_implementation_expenses`	string
`egwp_allocation_method`	string
`egwp_allocation_pct`	string
`ws2_claims`	string
`ws2_qi_expenses`	string
`ws2_revenue`	string
`ws2_taxes_and_fees`	string
`credibility_table`	string
`base_credibility_factor`	string
`msa_deductible_factor`	string
`ws2_credibility_adjustment_4_2`	string
`subject_to_remittance`	string
`ws2_adjusted_mlr_5_3`	string
`ws2_mlr_denominator_5_4`	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

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`contract_id`
Join	`how_to_join(source_fqn="medicare_silver.fact_ma_mlr_v2")`
Raw door	Tool: get_mlr; Athena: medicare_silver.fact_ma_mlr_v2 (WHERE is_current; pin contract_year)
Company names	`organization_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Wave-1A reload (Data Tracker, docs/data-tracker/RELOAD-PLAN-WAVE1A-MA-LOADERS-2026-10-01.md, defects MLR-1..3). Versioned, never overwritten; the legacy card stays live as the rollback.

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