# CMS MA / Part D Medical Loss Ratio public-use files CY2014-CY2023, stamped

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

The MLR public-use files re-collected through the provenance envelope on 2026-09-07 (identical row counts and spot values to the legacy ma_mlr). detail_available = 'true' marks the wide years (2014-2017, 2023) where every MLR report line is published; 2018-2022 carry only adjusted MLR and remittance. Strings; cast on read.

**Grain.** One row per contract_year x contract; 4,984 rows over 10 contract years on 2026-09-07.

| 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 |  |
| 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 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_ma_mlr")` first.