About this Dataset

Medicaid Managed Care

The Medicaid Managed Care dataset uses CMS' state Transformed Medicaid Statistical Information System (T-MSIS) data for Arizona, Michigan, Nevada, and New Mexico to identify various metrics for managed care plans within each state. These metrics are designed to allow users to compare plans in each state across different specialty areas (currently Pediatric Dental, Behavioral Health, and Prenatal OB/GYN). This dataset does not include all available data in T-MSIS but utilized a subset to calculate the individual metrics identified.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:20:33.320634
Tags: counties, health-care-use-payments, health-equity, medicaid, states-territories

Tables

Medicaid Managed Care : 2023-12-01

@usgov.hhs_gov_medicaid_managed_care_edfff.medicaid_managed_care_2023_12_01

357.96 kB
19,398 rows
12 columns

CREATE TABLE medicaid_managed_care_2023_12_01 (
  "state" VARCHAR,
  "county" VARCHAR,
  "mco_name" VARCHAR,
  "service_category" VARCHAR,
  "number_of_active_patients" VARCHAR,
  "number_of_eligible_mco_patients" VARCHAR,
  "number_of_providers" BIGINT,
  "percent_of_eligible_patients_receiving_services" DOUBLE,
  "number_of_services_per_active_patient" DOUBLE,
  "number_of_active_patients_per_provider" VARCHAR,
  "calendar_year" BIGINT,
  "plan_category" VARCHAR
);

Medicaid Managed Care : 2024-10-01

@usgov.hhs_gov_medicaid_managed_care_edfff.medicaid_managed_care_2024_10_01

369.88 kB
19,559 rows
12 columns

CREATE TABLE medicaid_managed_care_2024_10_01 (
  "state" VARCHAR,
  "county" VARCHAR,
  "mco_name" VARCHAR,
  "service_category" VARCHAR,
  "number_of_active_patients" VARCHAR,
  "number_of_eligible_mco_patients" VARCHAR,
  "number_of_providers" BIGINT,
  "percent_of_eligible_patients_receiving_services" DOUBLE,
  "number_of_services_per_active_patient" DOUBLE,
  "number_of_active_patients_per_provider" VARCHAR,
  "calendar_year" BIGINT,
  "plan_category" VARCHAR
);