About this Dataset

State Drug Utilization Data 2017

Drug utilization data are reported by states for covered outpatient drugs that are paid for by state Medicaid agencies since the start of the Medicaid Drug Rebate Program. The data includes state, drug name, National Drug Code, number of prescriptions and dollars reimbursed. Data descriptions are available on Medicaid.gov: https://www.medicaid.gov/medicaid/prescription-drugs/state-drug-utilization-data/state-drug-utilization-data-faq/index.html
Organization: U.S. Department of Health & Human Services
Last updated: 2024-06-27T14:44:49.349777
Tags: drug-utilization, medicaid-reimbursements, pharmacy

Tables

Table 1

@usgov.hhs_gov_state_drug_utilization_data_2017_384fe.table_1

99.15 MB
4,789,471 rows
15 columns

CREATE TABLE table_1 (
  "utilization_type" VARCHAR,
  "state" VARCHAR,
  "ndc" VARCHAR,
  "labeler_code" BIGINT,
  "product_code" BIGINT,
  "package_size" VARCHAR,
  "year" BIGINT,
  "quarter" BIGINT,
  "suppression_used" BOOLEAN,
  "product_name" VARCHAR,
  "units_reimbursed" DOUBLE,
  "number_of_prescriptions" DOUBLE,
  "total_amount_reimbursed" DOUBLE,
  "medicaid_amount_reimbursed" DOUBLE,
  "non_medicaid_amount_reimbursed" DOUBLE
);