Name: MLR Summary Reports
Creator: US Government
License: http://www.usa.gov/publicdomain/label/1.0/

About this Dataset

MLR Summary Reports

The MLR Summary Reports provide plan-specific MLRs for Medicaid managed care programs. The MLR summary report data include MLRs for MCOs, PIHPs, and PAHPs submitted by states under 42 CFR § 438.74.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-02-03T21:57:00.603676
Tags: medicaid

Tables

MLR Summary Reports

@usgov.hhs_gov_mlr_summary_reports.mlr_summary_reports

85.25 kB
1,719 rows
14 columns

CREATE TABLE mlr_summary_reports (
  "state" VARCHAR,
  "program_name" VARCHAR,
  "program_type" VARCHAR,
  "eligibility_group" VARCHAR,
  "if_other_describe_eligibility_group" VARCHAR  -- If Other, Describe Eligibility Group,
  "mco_pihp_or_pahp_name" VARCHAR  -- MCO, PIHP, Or PAHP Name,
  "mlr_reporting_period_start_date" TIMESTAMP,
  "mlr_reporting_period_end_date" TIMESTAMP,
  "report_year" BIGINT,
  "n__mlr_numerator" VARCHAR  -- MLR Numerator,
  "n__mlr_denominator" VARCHAR  -- MLR Denominator,
  "state_reported_member_months" BIGINT,
  "adjusted_mlr" VARCHAR,
  "n__remittance_dollar_amount_for_mlr_reporting_period" VARCHAR  -- Remittance Dollar Amount For MLR Reporting Period
);