About this Dataset

Drug Manufacturer Contacts

Drug Manufacturer Contact Information contains Optional Effective Date, Termination Date (if applicable), and Legal, Invoice and Technical Contact information for each drug company participating in the Medicaid Drug Rebate Program. For more information see: https://www.medicaid.gov/medicaid/prescription-drugs/medicaid-drug-rebate-program/index.html
Organization: U.S. Department of Health & Human Services
Last updated: 2025-11-18T14:55:27.034808
Tags: drug-manufacturer-contacts

Tables

Table 1

@usgov.hhs_gov_drug_manufacturer_contacts_49f9d.table_1

173.63 kB
846 rows
36 columns

CREATE TABLE table_1 (
  "labeler_code" BIGINT,
  "labeler_name" VARCHAR,
  "optional_eff_date" BIGINT  -- Optional Eff. Date,
  "termination_date" DOUBLE,
  "legal_contact_name" VARCHAR,
  "legal_corporation" VARCHAR,
  "legal_address_1" VARCHAR  -- Legal Address #1,
  "legal_address_2" VARCHAR  -- Legal Address #2,
  "legal_address_3" VARCHAR  -- Legal Address #3,
  "legal_city" VARCHAR,
  "legal_state" VARCHAR,
  "legal_zip" BIGINT,
  "legal_phone" DOUBLE,
  "legal_email" VARCHAR,
  "invoice_contact" VARCHAR,
  "invoice_corp" VARCHAR  -- Invoice Corp.,
  "invoice_address_1" VARCHAR,
  "invoice_address_2" VARCHAR,
  "invoice_address_3" VARCHAR,
  "invoice_city" VARCHAR,
  "invoice_state" VARCHAR,
  "invoice_zip" BIGINT,
  "invoice_phone" DOUBLE,
  "invoice_email" VARCHAR,
  "technical_name" VARCHAR,
  "technical_corp" VARCHAR  -- Technical Corp.,
  "technical_address_1" VARCHAR,
  "technical_address_2" VARCHAR,
  "technical_address_3" VARCHAR,
  "technical_city" VARCHAR,
  "technical_state" VARCHAR,
  "technical_zip" BIGINT,
  "technical_phone" DOUBLE,
  "technical_email" VARCHAR,
  "active_indicator" BIGINT,
  "filler" VARCHAR
);