About this Dataset

Medicaid Opioid Prescribing Rates - By Geography

The Medicaid Opioid Prescribing Rates by Geography dataset provides information on geographic comparisons of the number and percentage of Medicaid opioid prescriptions at the state, county, and ZIP code levels.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:19:06.420149
Tags: drugs, health-equity, medicaid, national, physicians-practitioners, states-territories

Tables

Medicaid Opioid Prescribing Rates - By Geography : 2023-01-02

@usgov.hhs_gov_medicaid_opioid_prescribing_rates_by_geography_af9e2.medicaid_opioid_prescribing_rates_by_geography_2023_01_02

8.7 MB
539,181 rows
14 columns

CREATE TABLE medicaid_opioid_prescribing_rates_by_geography_2023_01_02 (
  "year" BIGINT,
  "geo_lvl" VARCHAR,
  "geo_cd" VARCHAR,
  "geo_desc" VARCHAR,
  "plan_type" VARCHAR,
  "tot_opioid_clms" DOUBLE,
  "tot_clms" DOUBLE,
  "opioid_prscrbng_rate" DOUBLE,
  "opioid_prscrbng_rate_5y_chg" DOUBLE,
  "opioid_prscrbng_rate_1y_chg" DOUBLE,
  "la_tot_opioid_clms" DOUBLE,
  "la_opioid_prscrbng_rate" DOUBLE,
  "la_opioid_prscrbng_rate_5y_chg" DOUBLE,
  "la_opioid_prscrbng_rate_1y_chg" DOUBLE
);