Medicare Advantage, Part D, Medicaid

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

medicare_silver.fact_ma_mlr·live·silver·Medicare Advantage Plan Payments

Rows

4,984

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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;
22018-2022 carry only adjusted MLR and remittance.
3Strings; cast on read.

Grain

Key	Grain
N/A	1One row per contract_year x contract; 24,984 rows over 10 contract years on 2026-09-07.

Columns (80)

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

describe_data_source(source_fqn="medicare_silver.fact_ma_mlr")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_ma_mlr 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")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_ma_mlr
Company names	`organization_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	New source captured end-to-end (PRs

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