Dataset: State Drug Utilization Data 2007

About this Dataset

State Drug Utilization Data 2007

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:33:47.033094
Tags: drug-utilization, medicaid-reimbursements, pharmacy

Tables

Table 1

@usgov.hhs_gov_state_drug_utilization_data_2007_babb1.table_1

39 MB
2140935 rows
15 columns


CREATE TABLE table_1 (
  "utilization_type" VARCHAR,
  "state" VARCHAR,
  "ndc" VARCHAR,
  "labeler_code" BIGINT,
  "product_code" BIGINT,
  "package_size" BIGINT,
  "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
);