Drug directory

Show:

Click on a table cell below to display more information about its column.

ROW_ID	PRODUCTID	PRODUCTNDC	PROPRIETARYNAME	PROPRIETARYNAMESUFFIX	NONPROPRIETARYNAME	DOSAGEFORMNAME	ROUTENAME	STARTMARKETINGDATE	ENDMARKETINGDATE	MARKETINGCATEGORYNAME	APPLICATIONNUMBER	LABELERNAME	SUBSTANCENAME	ACTIVE_NUMERATOR_STRENGTH	ACTIVE_INGRED_UNIT	PHARM_CLASSES	DEASCHEDULE	NDC_EXCLUDE_FLAG	LISTING_RECORD_CERTIFIED_THROUGH
0	0002-0800_03155cd7-d92b-480b-8a86-087659b6990f	0002-0800	Sterile Diluent	?	diluent	INJECTION, SOLUTION	SUBCUTANEOUS	19870710	?	BLA	BLA018781	Eli Lilly and Company	WATER	1	mL/mL	?	?	N	20211231.0
1	0002-1200_480fceef-6596-4478-97de-677c155506b3	0002-1200	Amyvid	?	Florbetapir F 18	INJECTION, SOLUTION	INTRAVENOUS	20120601	?	NDA	NDA202008	Eli Lilly and Company	FLORBETAPIR F-18	51	mCi/mL	Radioactive Diagnostic Agent [EPC],Positron Emitting Activity [MoA]	?	N	20211231.0
2	0002-1210_151a431b-f07b-4959-b6fa-c41ff80364c8	0002-1210	TAUVID	?	Flortaucipir F-18	INJECTION, SOLUTION	INTRAVENOUS	20200528	?	NDA	NDA212123	Eli Lilly and Company	FLORTAUCIPIR F-18	51	mCi/mL	?	?	N	20211231.0
3	0002-1433_ed8cc753-cd37-42a1-9c11-1401b40d94a5	0002-1433	Trulicity	?	Dulaglutide	INJECTION, SOLUTION	SUBCUTANEOUS	20140918	?	BLA	BLA125469	Eli Lilly and Company	DULAGLUTIDE	.75	mg/.5mL	GLP-1 Receptor Agonist [EPC],Glucagon-Like Peptide 1 [CS],Glucagon-like Peptide-1 (GLP-1) Agonists [MoA]	?	N	20211231.0
4	0002-1434_ed8cc753-cd37-42a1-9c11-1401b40d94a5	0002-1434	Trulicity	?	Dulaglutide	INJECTION, SOLUTION	SUBCUTANEOUS	20140918	?	BLA	BLA125469	Eli Lilly and Company	DULAGLUTIDE	1.5	mg/.5mL	GLP-1 Receptor Agonist [EPC],Glucagon-Like Peptide 1 [CS],Glucagon-like Peptide-1 (GLP-1) Agonists [MoA]	?	N	20211231.0
⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮
120210	99207-465_3c27c96e-5556-4f4e-9971-a3c2d75796c2	99207-465	Solodyn	?	minocycline hydrochloride	TABLET, FILM COATED, EXTENDED RELEASE	ORAL	20100927	?	NDA	NDA050808	Bausch Health US LLC	MINOCYCLINE HYDROCHLORIDE	55	mg/1	Tetracycline-class Drug [EPC],Tetracyclines [CS]	?	N	20211231.0
120211	99207-466_3c27c96e-5556-4f4e-9971-a3c2d75796c2	99207-466	Solodyn	?	minocycline hydrochloride	TABLET, FILM COATED, EXTENDED RELEASE	ORAL	20100927	?	NDA	NDA050808	Bausch Health US LLC	MINOCYCLINE HYDROCHLORIDE	80	mg/1	Tetracycline-class Drug [EPC],Tetracyclines [CS]	?	N	20211231.0
120212	99207-467_3c27c96e-5556-4f4e-9971-a3c2d75796c2	99207-467	Solodyn	?	minocycline hydrochloride	TABLET, FILM COATED, EXTENDED RELEASE	ORAL	20100927	?	NDA	NDA050808	Bausch Health US LLC	MINOCYCLINE HYDROCHLORIDE	105	mg/1	Tetracycline-class Drug [EPC],Tetracyclines [CS]	?	N	20211231.0
120213	99207-525_c62955d3-4537-414a-8b06-c8dd300d0f50	99207-525	Vanos	?	fluocinonide	CREAM	TOPICAL	20060313	?	NDA	NDA021758	Bausch Health US LLC	FLUOCINONIDE	1	mg/g	Corticosteroid [EPC],Corticosteroid Hormone Receptor Agonists [MoA]	?	N	20211231.0
120214	99207-850_e52ec481-1114-4f09-9be0-311e5eb52fa1	99207-850	Luzu	?	LULICONAZOLE	CREAM	TOPICAL	20131114	?	NDA	NDA204153	Bausch Health US, LLC	LULICONAZOLE	10	mg/g	Azole Antifungal [EPC],Azoles [CS],Cytochrome P450 2C19 Inhibitors [MoA]	?	N	20211231.0

120215 rows ✕ 20 columns.

`ROW_ID`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 6.01e+04 ± 3.47e+04
Median ± IQR: 60107 ± 60106
Min ; Max: 0 ; 120214

`PRODUCTID`

ObjectDType

Null values: 0 (0.0%)
Unique values: 120215 (100.0%)

Most frequent values

0002-2236_ed8cc753-cd37-42a1-9c11-1401b40d94a5

99207-850_e52ec481-1114-4f09-9be0-311e5eb52fa1

0002-0800_03155cd7-d92b-480b-8a86-087659b6990f

0002-1200_480fceef-6596-4478-97de-677c155506b3

0002-1210_151a431b-f07b-4959-b6fa-c41ff80364c8

0002-1433_ed8cc753-cd37-42a1-9c11-1401b40d94a5

0002-1434_ed8cc753-cd37-42a1-9c11-1401b40d94a5

99207-171_aba483fc-ef62-46ae-8246-6074df482099

99207-172_aba483fc-ef62-46ae-8246-6074df482099

99207-173_aba483fc-ef62-46ae-8246-6074df482099

List:

['0002-2236_ed8cc753-cd37-42a1-9c11-1401b40d94a5', '99207-850_e52ec481-1114-4f09-9be0-311e5eb52fa1', '0002-0800_03155cd7-d92b-480b-8a86-087659b6990f', '0002-1200_480fceef-6596-4478-97de-677c155506b3', '0002-1210_151a431b-f07b-4959-b6fa-c41ff80364c8', '0002-1433_ed8cc753-cd37-42a1-9c11-1401b40d94a5', '0002-1434_ed8cc753-cd37-42a1-9c11-1401b40d94a5', '99207-171_aba483fc-ef62-46ae-8246-6074df482099', '99207-172_aba483fc-ef62-46ae-8246-6074df482099', '99207-173_aba483fc-ef62-46ae-8246-6074df482099']

`PRODUCTNDC`

ObjectDType

Null values: 0 (0.0%)
Unique values: 117896 (98.1%)

Most frequent values

54365-400

72766-002

72728-002

78888-080

75772-420

70483-001

75674-425

76943-081

75323-180

70424-003

List:

['54365-400', '72766-002', '72728-002', '78888-080', '75772-420', '70483-001', '75674-425', '76943-081', '75323-180', '70424-003']

`PROPRIETARYNAME`

ObjectDType

Null values: 0 (0.0%)
Unique values: 45020 (37.4%)

Most frequent values

Hand Sanitizer

Ibuprofen

Oxygen

HAND SANITIZER

Gabapentin

Allergy Relief

Aripiprazole

Amoxicillin

Levothyroxine Sodium

Lamotrigine

List:

['Hand Sanitizer', 'Ibuprofen', 'Oxygen', 'HAND SANITIZER', 'Gabapentin', 'Allergy Relief', 'Aripiprazole', 'Amoxicillin', 'Levothyroxine Sodium', 'Lamotrigine']

`PROPRIETARYNAMESUFFIX`

ObjectDType

Null values: 0 (0.0%)
Unique values: 4570 (3.8%)

Most frequent values

Maximum Strength

Extra Strength

Extended-Release

Regular Strength

Childrens

XR

ER

Nighttime

List:

['?', 'Maximum Strength', 'Extra Strength', '01', 'Extended-Release', 'Regular Strength', 'Childrens', 'XR', 'ER', 'Nighttime']

`NONPROPRIETARYNAME`

ObjectDType

Null values: 2 (< 0.1%)
Unique values: 19307 (16.1%)

Most frequent values

ALCOHOL

Alcohol

Ethyl Alcohol

Isopropyl Alcohol

Benzalkonium Chloride

Ibuprofen

BENZALKONIUM CHLORIDE

Acetaminophen

Menthol

Hand Sanitizer

List:

['ALCOHOL', 'Alcohol', 'Ethyl Alcohol', 'Isopropyl Alcohol', 'Benzalkonium Chloride', 'Ibuprofen', 'BENZALKONIUM CHLORIDE', 'Acetaminophen', 'Menthol', 'Hand Sanitizer']

`DOSAGEFORMNAME`

ObjectDType

Null values: 0 (0.0%)
Unique values: 139 (0.1%)

Most frequent values

TABLET

LIQUID

GEL

TABLET, FILM COATED

CREAM

SOLUTION

CAPSULE

INJECTION, SOLUTION

PELLET

LOTION

List:

['TABLET', 'LIQUID', 'GEL', 'TABLET, FILM COATED', 'CREAM', 'SOLUTION', 'CAPSULE', 'INJECTION, SOLUTION', 'PELLET', 'LOTION']

`ROUTENAME`

ObjectDType

Null values: 0 (0.0%)
Unique values: 193 (0.2%)

Most frequent values

ORAL

TOPICAL

INTRAVENOUS

SUBCUTANEOUS

RESPIRATORY (INHALATION)

INTRADERMAL; PERCUTANEOUS; SUBCUTANEOUS

OPHTHALMIC

DENTAL

INTRAMUSCULAR; INTRAVENOUS

List:

['ORAL', 'TOPICAL', 'INTRAVENOUS', '?', 'SUBCUTANEOUS', 'RESPIRATORY (INHALATION)', 'INTRADERMAL; PERCUTANEOUS; SUBCUTANEOUS', 'OPHTHALMIC', 'DENTAL', 'INTRAMUSCULAR; INTRAVENOUS']

`STARTMARKETINGDATE`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 2.01e+07 ± 1.14e+05
Median ± IQR: 20161031 ± 80881
Min ; Max: 19000101 ; 20201216

`ENDMARKETINGDATE`

ObjectDType

Null values: 0 (0.0%)
Unique values: 677 (0.6%)

Most frequent values

20201231.0

20211231.0

20211230.0

20210331.0

20210228.0

20221230.0

20210531.0

20210430.0

20210131.0

List:

['?', '20201231.0', '20211231.0', '20211230.0', '20210331.0', '20210228.0', '20221230.0', '20210531.0', '20210430.0', '20210131.0']

`MARKETINGCATEGORYNAME`

ObjectDType

Null values: 0 (0.0%)
Unique values: 10 (< 0.1%)

Most frequent values

ANDA

OTC MONOGRAPH NOT FINAL

OTC MONOGRAPH FINAL

UNAPPROVED HOMEOPATHIC

NDA

BLA

UNAPPROVED DRUG OTHER

NDA AUTHORIZED GENERIC

UNAPPROVED MEDICAL GAS

UNAPPROVED DRUG FOR USE IN DRUG SHORTAGE

List:

['ANDA', 'OTC MONOGRAPH NOT FINAL', 'OTC MONOGRAPH FINAL', 'UNAPPROVED HOMEOPATHIC', 'NDA', 'BLA', 'UNAPPROVED DRUG OTHER', 'NDA AUTHORIZED GENERIC', 'UNAPPROVED MEDICAL GAS', 'UNAPPROVED DRUG FOR USE IN DRUG SHORTAGE']

`APPLICATIONNUMBER`

ObjectDType

Null values: 0 (0.0%)
Unique values: 11257 (9.4%)

Most frequent values

part333A

part352

part333E

part341

part348

part343

part334

part347

BLA101833

List:

['part333A', '?', 'part352', 'part333E', 'part341', 'part348', 'part343', 'part334', 'part347', 'BLA101833']

`LABELERNAME`

ObjectDType

Null values: 0 (0.0%)
Unique values: 13388 (11.1%)

Most frequent values

Bryant Ranch Prepack

Boiron

REMEDYREPACK INC.

A-S Medication Solutions

Washington Homeopathic Products

Proficient Rx LP

NuCare Pharmaceuticals,Inc.

Greer Laboratories, Inc.

ALK-Abello, Inc.

Uriel Pharmacy Inc.

List:

['Bryant Ranch Prepack', 'Boiron', 'REMEDYREPACK INC.', 'A-S Medication Solutions', 'Washington Homeopathic Products', 'Proficient Rx LP', 'NuCare Pharmaceuticals,Inc.', 'Greer Laboratories, Inc.', 'ALK-Abello, Inc.', 'Uriel Pharmacy Inc.']

`SUBSTANCENAME`

ObjectDType

Null values: 0 (0.0%)
Unique values: 9730 (8.1%)

Most frequent values

ALCOHOL

BENZALKONIUM CHLORIDE

ISOPROPYL ALCOHOL

IBUPROFEN

ACETAMINOPHEN

SALICYLIC ACID

MENTHOL

SODIUM FLUORIDE

DIPHENHYDRAMINE HYDROCHLORIDE

List:

['ALCOHOL', 'BENZALKONIUM CHLORIDE', '?', 'ISOPROPYL ALCOHOL', 'IBUPROFEN', 'ACETAMINOPHEN', 'SALICYLIC ACID', 'MENTHOL', 'SODIUM FLUORIDE', 'DIPHENHYDRAMINE HYDROCHLORIDE']

`ACTIVE_NUMERATOR_STRENGTH`

ObjectDType

Null values: 0 (0.0%)
Unique values: 10205 (8.5%)

Most frequent values

List:

['10', '70', '30', '1', '100', '75', '5', '20', '50', '80']

`ACTIVE_INGRED_UNIT`

ObjectDType

Null values: 0 (0.0%)
Unique values: 2928 (2.4%)

Most frequent values

mg/1

mL/100mL

mg/mL

mg/1; mg/1

g/100g

mg/g

g/100mL

g/mL

mL/mL

List:

['mg/1', 'mL/100mL', 'mg/mL', 'mg/1; mg/1', 'g/100g', 'mg/g', 'g/100mL', '?', 'g/mL', 'mL/mL']

`PHARM_CLASSES`

ObjectDType

Null values: 0 (0.0%)
Unique values: 1320 (1.1%)

Most frequent values

Corticosteroid [EPC],Corticosteroid Hormone Receptor Agonists [MoA]

Atypical Antipsychotic [EPC]

Cyclooxygenase Inhibitors [MoA],Anti-Inflammatory Agents, Non-Steroidal [CS],Nonsteroidal Anti-inflammatory Drug [EPC]

Full Opioid Agonists [MoA],Opioid Agonist [EPC]

Non-Standardized Pollen Allergenic Extract [EPC],Increased Histamine Release [PE],Cell-mediated Immunity [PE],Increased IgG Production [PE],Pollen [CS],Allergens [CS]

Adrenergic beta-Antagonists [MoA],beta-Adrenergic Blocker [EPC]

HMG-CoA Reductase Inhibitor [EPC],Hydroxymethylglutaryl-CoA Reductase Inhibitors [MoA]

Serotonin Reuptake Inhibitor [EPC],Serotonin Uptake Inhibitors [MoA]

Benzodiazepine [EPC],Benzodiazepines [CS]

List:

['?', 'Corticosteroid [EPC],Corticosteroid Hormone Receptor Agonists [MoA]', 'Atypical Antipsychotic [EPC]', 'Cyclooxygenase Inhibitors [MoA],Anti-Inflammatory Agents, Non-Steroidal [CS],Nonsteroidal Anti-inflammatory Drug [EPC]', 'Full Opioid Agonists [MoA],Opioid Agonist [EPC]', 'Non-Standardized Pollen Allergenic Extract [EPC],Increased Histamine Release [PE],Cell-mediated Immunity [PE],Increased IgG Production [PE],Pollen [CS],Allergens [CS]', 'Adrenergic beta-Antagonists [MoA],beta-Adrenergic Blocker [EPC]', 'HMG-CoA Reductase Inhibitor [EPC],Hydroxymethylglutaryl-CoA Reductase Inhibitors [MoA]', 'Serotonin Reuptake Inhibitor [EPC],Serotonin Uptake Inhibitors [MoA]', 'Benzodiazepine [EPC],Benzodiazepines [CS]']

`DEASCHEDULE`

ObjectDType

Null values: 0 (0.0%)
Unique values: 5 (< 0.1%)

Most frequent values

CII

CIV

CIII

CV

List:

['?', 'CII', 'CIV', 'CIII', 'CV']

`NDC_EXCLUDE_FLAG`

ObjectDType

Null values: 0 (0.0%)

Constant value:

`LISTING_RECORD_CERTIFIED_THROUGH`

ObjectDType

Null values: 0 (0.0%)
Unique values: 3 (< 0.1%)

Most frequent values

20211231.0

20201231.0

List:

['20211231.0', '20201231.0', '?']

No columns match the selected filter: . You can change the column filter in the dropdown menu above.

The table below shows the strength of association between the most similar columns in the dataframe. Cramér's V statistic is a number between 0 and 1. When it is close to 1 the columns are strongly associated — they contain similar information. In this case, one of them may be redundant and for some models (such as linear models) it might be beneficial to remove it.

Column 1	Column 2	Cramér's V
PRODUCTID	PRODUCTNDC	0.882
ENDMARKETINGDATE	LISTING_RECORD_CERTIFIED_THROUGH	0.707
NONPROPRIETARYNAME	SUBSTANCENAME	0.674
MARKETINGCATEGORYNAME	APPLICATIONNUMBER	0.525
ROUTENAME	ACTIVE_INGRED_UNIT	0.474
SUBSTANCENAME	ACTIVE_INGRED_UNIT	0.446
ROUTENAME	MARKETINGCATEGORYNAME	0.420
APPLICATIONNUMBER	SUBSTANCENAME	0.394
DOSAGEFORMNAME	MARKETINGCATEGORYNAME	0.391
ROUTENAME	SUBSTANCENAME	0.390
MARKETINGCATEGORYNAME	ACTIVE_INGRED_UNIT	0.372
PHARM_CLASSES	DEASCHEDULE	0.366
DOSAGEFORMNAME	ROUTENAME	0.364
MARKETINGCATEGORYNAME	PHARM_CLASSES	0.354
DOSAGEFORMNAME	APPLICATIONNUMBER	0.352
ROUTENAME	LABELERNAME	0.348
DOSAGEFORMNAME	ACTIVE_INGRED_UNIT	0.348
APPLICATIONNUMBER	ACTIVE_INGRED_UNIT	0.331
NONPROPRIETARYNAME	APPLICATIONNUMBER	0.322
ROW_ID	LABELERNAME	0.304

Drug directory

ROW_ID

PRODUCTID

PRODUCTNDC

PROPRIETARYNAME

PROPRIETARYNAMESUFFIX

NONPROPRIETARYNAME

DOSAGEFORMNAME

ROUTENAME

STARTMARKETINGDATE

ENDMARKETINGDATE

MARKETINGCATEGORYNAME

APPLICATIONNUMBER

LABELERNAME

SUBSTANCENAME

ACTIVE_NUMERATOR_STRENGTH

ACTIVE_INGRED_UNIT

PHARM_CLASSES

DEASCHEDULE

NDC_EXCLUDE_FLAG

LISTING_RECORD_CERTIFIED_THROUGH

Constant columns

ROW_ID

PRODUCTID

PRODUCTNDC

PROPRIETARYNAME

PROPRIETARYNAMESUFFIX

NONPROPRIETARYNAME

DOSAGEFORMNAME

ROUTENAME

STARTMARKETINGDATE

ENDMARKETINGDATE

MARKETINGCATEGORYNAME

APPLICATIONNUMBER

LABELERNAME

SUBSTANCENAME

ACTIVE_NUMERATOR_STRENGTH

ACTIVE_INGRED_UNIT

PHARM_CLASSES

DEASCHEDULE

NDC_EXCLUDE_FLAG

LISTING_RECORD_CERTIFIED_THROUGH

`ROW_ID`

`PRODUCTID`

`PRODUCTNDC`

`PROPRIETARYNAME`

`PROPRIETARYNAMESUFFIX`

`NONPROPRIETARYNAME`

`DOSAGEFORMNAME`

`ROUTENAME`

`STARTMARKETINGDATE`

`ENDMARKETINGDATE`

`MARKETINGCATEGORYNAME`

`APPLICATIONNUMBER`

`LABELERNAME`

`SUBSTANCENAME`

`ACTIVE_NUMERATOR_STRENGTH`

`ACTIVE_INGRED_UNIT`

`PHARM_CLASSES`

`DEASCHEDULE`

`NDC_EXCLUDE_FLAG`

`LISTING_RECORD_CERTIFIED_THROUGH`

`ROW_ID`

`PRODUCTID`

`PRODUCTNDC`

`PROPRIETARYNAME`

`PROPRIETARYNAMESUFFIX`

`NONPROPRIETARYNAME`

`DOSAGEFORMNAME`

`ROUTENAME`

`STARTMARKETINGDATE`

`ENDMARKETINGDATE`

`MARKETINGCATEGORYNAME`

`APPLICATIONNUMBER`

`LABELERNAME`

`SUBSTANCENAME`

`ACTIVE_NUMERATOR_STRENGTH`

`ACTIVE_INGRED_UNIT`

`PHARM_CLASSES`

`DEASCHEDULE`

`NDC_EXCLUDE_FLAG`

`LISTING_RECORD_CERTIFIED_THROUGH`