Disease Prioritization Data Package
This package has 16 modules. The Products Concepts Module has 7 tables. Preview the first five rows of each table or Explore the schema
Products Concepts Module
7 Tables
Each Product Concept describes a distinct group of features common to one or more drug products. Product Concepts are organized in a hierarchy and enables grouping products in various ways, such as by ingredients, brand, and dosage route/strength.
Product Concept Children
Represents the hierarchical relationships between product concepts. For any parent and child pair, the child has all the same attributes as the parent, with one additional attribute being set. For instance, a child may add route information to the information provided by the parent.
parent_id | child_id |
|---|---|
0 | 1 |
0 | 2 |
1 | 3 |
2 | 3 |
0 | 4 |
Want all 1,853,485 rows? Let's connect you to sales.
product_concept_id | drug_id | salt_id | amount | per | units |
|---|---|---|---|---|---|
150979 | 35 | 1159 | |||
150980 | 35 | 1159 | 0.1 | 1.0 | mg |
150981 | 35 | 1159 | |||
150982 | 35 | 1159 | 0.1 | 1.0 | mg |
150983 | 35 | 1159 |
Want all 1,731,542 rows? Let's connect you to sales.
product_concept_id | product_id |
|---|---|
17318 | 87092 |
17319 | 87092 |
17322 | 87092 |
17323 | 87092 |
17326 | 87092 |
Want all 6,526,704 rows? Let's connect you to sales.
revocation_id | concept_id |
|---|---|
18654 | 384160 |
18654 | 384161 |
18654 | 384162 |
18654 | 384163 |
18654 | 384164 |
Want all 19,844 rows? Let's connect you to sales.
id | revoked_at | historical_data |
|---|---|---|
18654 | 2018-07-09 | {"name":"Pramoxine hydrochloride / Zinc acetate","rxnorm_ids":[],"ingredients":[{"drug":{"name":"Pramocaine","drugbank_id":"DB09345"},"exact_ingredient":{"name":"Pramoxine hydrochloride","drugbank_id":"DBSALT001353"}},{"drug":{"name":"Zinc","drugbank_id":"DB01593"}}]} |
18656 | 2018-07-09 | {"name":"Pramoxine hydrochloride 10 mg / Zinc acetate 1 mg /mL","rxnorm_ids":[],"ingredients":[{"drug":{"name":"Pramocaine","drugbank_id":"DB09345"},"exact_ingredient":{"name":"Pramoxine hydrochloride","drugbank_id":"DBSALT001353"},"strength":{"amount":"10.0","units":"mg/mL","per":"1.0"}},{"drug":{"name":"Zinc","drugbank_id":"DB01593"},"strength":{"amount":"1.0","units":"mg/mL","per":"1.0"}}]} |
18658 | 2018-07-09 | {"name":"Pramoxine hydrochloride / Zinc acetate Topical","route":"Topical","rxnorm_ids":[],"ingredients":[{"drug":{"name":"Pramocaine","drugbank_id":"DB09345"},"exact_ingredient":{"name":"Pramoxine hydrochloride","drugbank_id":"DBSALT001353"}},{"drug":{"name":"Zinc","drugbank_id":"DB01593"}}]} |
18660 | 2018-07-09 | {"name":"Pramoxine hydrochloride 10 mg / Zinc acetate 1 mg /mL Topical","route":"Topical","rxnorm_ids":[],"ingredients":[{"drug":{"name":"Zinc","drugbank_id":"DB01593"},"strength":{"amount":"1.0","units":"mg/mL","per":"1.0"}},{"drug":{"name":"Pramocaine","drugbank_id":"DB09345"},"exact_ingredient":{"name":"Pramoxine hydrochloride","drugbank_id":"DBSALT001353"},"strength":{"amount":"10.0","units":"mg/mL","per":"1.0"}}]} |
18662 | 2018-07-09 | {"name":"Pramoxine hydrochloride / Zinc acetate Lotion","form":"Lotion","rxnorm_ids":[],"ingredients":[{"drug":{"name":"Pramocaine","drugbank_id":"DB09345"},"exact_ingredient":{"name":"Pramoxine hydrochloride","drugbank_id":"DBSALT001353"}},{"drug":{"name":"Zinc","drugbank_id":"DB01593"}}]} |
Want all 4,095 rows? Let's connect you to sales.
product_concept_id | rxcui | title |
|---|---|---|
0 | 4493 | fluoxetine |
1 | 227224 | fluoxetine hydrochloride |
4 | 1160836 | fluoxetine Oral Product |
8 | 1160837 | fluoxetine Pill |
12 | 378618 | fluoxetine Delayed Release Oral Capsule |
Want all 87,021 rows? Let's connect you to sales.
id | drugbank_id | title | level | standing | ingredient_key | exact_ingredient_key | strength_key | brand | dosage_form | route | available_in_canada | available_in_us | available_in_eu | available_in_colombia | available_in_turkey | available_in_italy | available_in_malaysia | available_in_austria | available_in_indonesia | available_in_thailand | available_in_singapore |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | DBPC0000000 | Fluoxetine | 1 | 0 | ef575e8837d065a1683c022d2077d342 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
1 | DBPC0000001 | Fluoxetine hydrochloride | 2 | 0 | ef575e8837d065a1683c022d2077d342 | 50a954317bda182cfa443e73e1cc7c2e | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | ||||
2 | DBPC0000002 | Fluoxetine 90 mg | 2 | 0 | ef575e8837d065a1683c022d2077d342 | 8f05a0d8f8bd7b74913e2a11829f1d77 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||
3 | DBPC0000003 | Fluoxetine hydrochloride 90 mg | 3 | 0 | ef575e8837d065a1683c022d2077d342 | 50a954317bda182cfa443e73e1cc7c2e | 8f05a0d8f8bd7b74913e2a11829f1d77 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||
4 | DBPC0000004 | Fluoxetine Oral | 2 | 0 | ef575e8837d065a1683c022d2077d342 | Oral | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
Want all 793,830 rows? Let's connect you to sales.
Showing 7 of 7 tables