Baselight

State Drug Utilization Data 2023

U.S. Department of Health & Human Services

@usgov.hhs_gov_state_drug_utilization_data_2023

Table 1
@usgov.hhs_gov_state_drug_utilization_data_2023.table_1

SDUD2023.csv

  • 100.77 MB
  • 5261246 rows
  • 15 columns
utilization_type

Utilization Type

state

State

ndc

NDC

labeler_code

Labeler Code

product_code

Product Code

package_size

Package Size

year

Year

quarter

Quarter

suppression_used

Suppression Used

product_name

Product Name

units_reimbursed

Units Reimbursed

number_of_prescriptions

Number Of Prescriptions

total_amount_reimbursed

Total Amount Reimbursed

medicaid_amount_reimbursed

Medicaid Amount Reimbursed

non_medicaid_amount_reimbursed

Non Medicaid Amount Reimbursed

FFSUAK2143380214338020234TRULICITY 242121108458.54106175.552282.99
FFSUAK2143480214348020234TRULICITY 386192173430.95164814.548616.41
FFSUAK2143611214361120234EMGALITY P282818655.6618655.66
FFSUAK214450921445920234trueTALTZ AUTO
FFSUAK2144511214451120234TALTZ AUTO3632239510.1239510.1
FFSUAK2144527214452720234trueTALTZ AUTO
FFSUAK2145780214578020234MOUNJARO 844241557.2239763.71793.52
FFSUAK2146080214608020234MOUNJARO 522625614.4523759.551854.9
FFSUAK2147180214718020234MOUNJARO 864142215.5439442.42773.14
FFSUAK2148480214848020234MOUNJARO 1507473305.8670455.82850.06

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

Share link

Anyone who has the link will be able to view this.