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

`medicare_silver.fact_ma_mlr_v2` · Medicare Advantage, Part D, Medicaid · status live · 4,984 rows

The 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); 2018-2022 carry only adjusted MLR and remittance. Strings; cast on read. get_mlr reads this table from 2026-10-05.

**Grain.** One row per contract_year x contract among is_current rows; 4,984 rows over 10 contract years, the served table's rows one for one (Athena 0f0e7cdc).

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