We're working on adding all of our packages. Stay tuned or get in touch if you don't see what you're looking for!

Disease Prioritization Data Package

This package has 16 modules. The Products Module has 7 tables. Preview the first five rows of each table or Explore the schema

Products Module

7 Tables

Describes the drug products available in different regions. Each product listing includes the brand or generic name, dosage, dose form, route of administration, codes, labeller, approval status, and marketing start and end date. For certain regions product packages are also available.

Dosage Forms

Describe the physical forms a drug product can take, according to the drug label.

id
name
short_name
definition
1
Aerosol
AER
A product that is packaged under pressure and contains therapeutically active ingredients that are released upon activation of an appropriate valve system; it is intended for topical application to the skin as well as local application into the nose (nasal aerosols), mouth (lingual aerosols), or lungs (inhalation aerosols).
2
Aerosol, foam
AER FOAM
A dosage form containing one or more active ingredients, surfactants, aqueous or nonaqueous liquids, and the propellants; if the propellant is in the internal (discontinuous) phase (i.e., of the oil-in-water type), a stable foam is discharged, and if the propellant is in the external (continuous) phase (i.e., of the water-in-oil type), a spray or a quick-breaking foam is discharged.
3
Aerosol, metered
AER MET
A pressurized dosage form consisting of metered dose valves which allow for the delivery of a uniform quantity of spray upon each activation.
4
Aerosol, powder
AER PWD
A product that is packaged under pressure and contains therapeutically active ingredients, in the form of a powder, that are released upon activation of an appropriate valve system.
5
Aerosol, spray
AER SPRAY
An aerosol product which utilizes a compressed gas as the propellant to provide the force necessary to expel the product as a wet spray; it is applicable to solutions of medicinal agents in aqueous solvents.
Want all 171 rows? Let's connect you to sales.

Dosage Forms Products

Representation of the many-to-many relationship between products and dosage_forms.

product_id
dosage_form_id
87092
145
87093
125
87094
145
87095
90
87096
145
Want all 538,617 rows? Let's connect you to sales.

Dosage Routes

Describe the routes through which a drug product can be administered, according to the drug label.

id
name
short_name
definition
effect_classification
1
Auricular (otic)
OTIC
Administration to or by way of the ear.
Topical
2
Buccal
BUCCAL
Administration directed toward the cheek, generally from within the mouth.
Enteral
3
Conjunctival
CONJUNC
Administration to the conjunctiva, the delicate membrane that lines the eyelids and covers the exposed surface of the eyeball.
Topical
4
Cutaneous
CUTAN
Administration to the skin.
Topical
5
Dental
DENTAL
Administration to a tooth or teeth.
Topical
Want all 112 rows? Let's connect you to sales.

Dosage Routes Products

Representation of the many-to-many relationship between products and dosage_routes.

product_id
dosage_route_id
87092
84
87093
70
87094
84
87095
50
87096
84
Want all 547,182 rows? Let's connect you to sales.

Ingredients

A list of the ingredients (drugs, salts) present in a product, including the active and supplemental (inactive) ingredients.

id
drug_id
salt_id
product_id
strength
strength_number
strength_unit
clinically_relevant
645767
6818
98874
10 %
10
%
1
648047
794
100652
250 mg
250
mg
1
767399
693
1449
170034
10 %
10
%
1
791635
9338
185070
50 mg
50
mg
1
791636
9338
185071
50 mg
50
mg
1
Want all 742,326 rows? Let's connect you to sales.

Labellers

Labellers describe the manufacturer, repackager, re-labeler or the named company that appears on a product label.

id
name
url
2
ADIENNE SA
3
Laboratoire Aguettant
7
E.R. Squibb & Sons, L.L.C.
8
Genentech, Inc.
12
Wyeth Pharmaceuticals Inc., a subsidiary of Pfizer Inc.
Want all 27,286 rows? Let's connect you to sales.

Products

The products table contains product information, which is linked to the ingredients table, connecting the products to drugs, salts, and relevant dosage information.

id
labeller_id
name
ndc_product_code
normalized_ndc_product_code
started_marketing_on
ended_marketing_on
dosage_form
strength_key
route
application_number
generic
otc
approved
country
dpd_id
mixture
approved_on
schedule
prescribable_name
ema_product_code
ema_ma_number
standing
standing_updated_on
standing_reason
jurisdiction_marketing_category
branded
prescription
unapproved
vaccine
allergenic
cosmetic
kit
solo
available
87092
2657
Imipramine
1989-12-31
Tablet
5b2c15cc251ae375a0eda3f8a2355b60
Oral
0
0
1
Canada
00644579
0
2010-05-26
Prescription
Imipramine HCl 75 mg Oral Tablet
good
2021-11-25
MARKETED
1
1
0
0
0
0
0
1
1
87093
2634
Fluorouracil Injection
1989-12-31
Solution
77a2c14debd6f671737f9ae66e51634a
Intravenous
0
0
1
Canada
00012882
0
2009-03-05
Prescription
Fluorouracil 5% Injection
good
2021-11-25
MARKETED
1
1
0
0
0
0
0
1
1
87094
2650
Doxycin Tab 100mg
1989-12-31
Tablet
3a4f91a0973fa728e1a7fd2537fb6add
Oral
0
0
1
Canada
00860751
0
Prescription
Doxycin 100 mg Oral Tablet
good
2021-11-25
MARKETED
1
1
0
0
0
0
0
1
1
87095
2634
Haloperidol Inj 5mg/ml USP
1989-12-31
Liquid
98fd6718623dd05603916d0e08356c17
Intramuscular
0
0
1
Canada
00808652
0
2005-09-14
Prescription
Haloperidol 0.5% Intramuscular Liquid
good
2021-11-25
MARKETED
1
1
0
0
0
0
0
1
1
87096
1808
Apo-verap Tab 80mg
1989-12-31
Tablet
f873d2e05f905760e5aca2d6349046f6
Oral
1
0
1
Canada
00782483
0
Prescription
Verapamil HCl 80 mg Oral Tablet
good
2021-11-25
MARKETED
0
1
0
0
0
0
0
1
1
Want all 535,401 rows? Let's connect you to sales.

Showing 7 of 7 tables