Others titles
- Pillbox Engine
- FDA Pillbox Master Data
- FDA Pillbox Database
- NLM Pills Identification
Keywords
- Pill ID
- Pill Identifier
- Drug Identifier
- Pill Lookup
- Identify Pills
- NLM Drug Information
- Pill Color
- FDA Color Codes
Pillbox Master Data Lookup
This dataset is the master file of the Pillbox database of the US National Library of Medicine (NLM), which contains descriptive information on the existing medication pills in the market. Values supplied by the drug companies to FDA (Food and Drug Administration) as part of the Structured Product Labels are labeled “SPL”. All other values are added by the National Library of Medicine’s (NLM) Pillbox or RxNorm datasets.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The Pillbox database was developed to aid in the identification of pills (oral solid dosage form medications). It combines images of pills with appearance and other information to enable users to visually search for and identify oral solid dosage form medications.
Once a pill has been identified, additional information is provided, including brand/generic name, ingredients and the National Drug File identification number. Links are provided to NLM (National Library of Medicine) drug information resources, such as drug labels from DailyMed and the Drug Information Portal, which searches NIH (National Institutes of Health) and FDA (Food and Drug Administration) drug information resources.
The data available here is obtained from products acquired from a licensed pharmacy or the product manufacturer. Manufacturers may alter the appearance (e.g., shape, color, size, markings) of medications over time. The same medication may have been issued with a different appearance and/or different accompanying data before or after the date NLM acquired it.
Pillbox’s source data is known to have errors and inconsistencies. Manufacturers may alter the physical appearance (imprint text on the pill, shape, color, size, scoring) of medications over time. In some cases the labeling information is not updated. The same medication may have been issued with a different appearance and/or different accompanying data before or after the date NLM acquired it.
About this Dataset
Data Info
Date Created | 2015-05-11 |
---|---|
Last Modified | 2022-05-04 |
Version | 2022-05-04 |
Update Frequency |
Annual |
Temporal Coverage |
N/A |
Spatial Coverage |
United States |
Source | John Snow Labs; United States National Library of Medicine (NLM); |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | Pill ID, Pill Identifier, Drug Identifier, Pill Lookup, Identify Pills, NLM Drug Information, Pill Color, FDA Color Codes |
Other Titles | Pillbox Engine, FDA Pillbox Master Data, FDA Pillbox Database, NLM Pills Identification |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Record_Id | Unique identification assigned to each record by the engine. | integer | level : Nominalrequired : 1 |
Is_Enabled | Enabled or not | boolean | required : 1 |
Record_Creation_Date_and_Time | Date and time the record was created in the engine | datetime | required : 1 |
Record_Updation_Date_and_Time | Date and time the record was last updated by the engine | datetime | required : 1 |
SPP_Value | SETID-product code-part number – the three values needed to uniquely identify a product. | string | - |
SPL_Set_Id | Value supplied to FDA as part of the Structured Product Labels (SPL); Set ID | string | - |
SPL_Size | Value supplied to FDA as part of the Structured Product Labels (SPL); Size of the pill in millimeters | number | level : Ratio |
Pillbox_Size | If NLM has an image of the pill and the size is different from the value given by the firm, the NLM value in millimeters goes here. | integer | level : Ordinal |
SPL_Shape | Value supplied to FDA as part of the Structured Product Labels (SPL); The coded value describing the shape of the pill | string | - |
SPL_Shape_Text | Value supplied to FDA as part of the Structured Product Labels (SPL); The free text value describing the shape of the pill | string | - |
Pillbox_Shape_Text | If NLM has an image of the pill and the shape is different from the value given by the firm, the NLM value goes here. | string | - |
SPL_Score | Value supplied to FDA as part of the Structured Product Labels; Score value for the pill | integer | level : Ordinal |
Pillbox_Score | If NLM has an image of the pill and the score is different from the value given by the firm, the NLM value goes here. | integer | level : Ordinal |
SPL_Imprint | Value supplied to FDA as part of the Structured Product Labels; Text appearing on the pill | string | - |
Pillbox_Imprint | If NLM has an image of the pill and the imprint is different from the value given by the firm, the NLM value goes here. | string | - |
SPL_Color | Value supplied to FDA as part of the Structured Product Labels; Coded value(s) for the color(s) of the pill | string | - |
SPL_Color_Text | Value supplied to FDA as part of the Structured Product Labels; Color(s) of the pill | string | - |
Pillbox_Color_Text | If NLM has an image of the pill and the color is different from the value given by the firm, the NLM value(s) goes here. | string | - |
SPL_Strength | Value supplied to FDA as part of the Structured Product Labels; Active ingredients and the dosage amounts | string | - |
SPL_Ingredients | Value supplied to FDA as part of the Structured Product Labels; Active ingredients in the pill | string | - |
SPL_Inactive_Ingredients | Value supplied to FDA as part of the Structured Product Labels; Inactive ingredients in the pill | string | - |
Source | Value supplied to FDA as part of the Structured Product Labels; Prescription, over-the-counter, homeopathic, veterinarian, remainder | string | - |
RXTTY_Value | RXTTY value from RxNorm API based on product code | string | - |
RX_String_Value | RXTSRING value from RxNorm API based on product code | string | - |
RX_Concept_Id | RxNorm Concept Unique Identifier (CUI) value from RxNorm API based on product code | integer | level : Nominal |
Product_Code | Value supplied to FDA as part of the Structured Product Labels; The pill’s product code | string | - |
RxNorm_Update_Time | The update date and time for RX Norm. | datetime | - |
Part_Number | Value supplied to FDA as part of the Structured Product Labels; If the product is delivered in parts (ex: birth control multi-packs), the part number identifying the unique pill within the multi-pack | integer | level : Ordinal |
Part_Medicine_Name | Value supplied to FDA as part of the Structured Product Labels; If the product is delivered in parts (ex: birth control multi-packs), the name identifying the unique pill within the multi-pack | string | - |
NDC_Code | Value supplied to FDA as part of the Structured Product Labels; 9-digit form of the National Drug Code (NDC) for this pill. Does not include the packaging value. | string | - |
NDC_Labeler_Code | Value supplied to FDA as part of the Structured Product Labels. First part of the digital code. | string | - |
NDC_Product_Code | Value supplied to FDA as part of the Structured Product Labels. Last part of the digital code. | string | - |
Medicine_Name | Value supplied to FDA as part of the Structured Product Labels; Name of the medication | string | - |
Marketing_Act_Code | Value supplied to FDA as part of the Structured Product Labels; Marketing act code, either active or completed | string | - |
Effective_Date | Value supplied to FDA as part of the Structured Product Labels; Date the information in the label is effective | date | - |
File_Name | Value supplied to FDA as part of the Structured Product Labels; Name of the xml file containing the label for the pill. Different from SetId | string | - |
Equal_Product_Code | Value supplied to FDA as part of the Structured Product Labels; Firms may use this value to indicate another firm’s product they are repackaging or relabeling | string | - |
Dosage_Form | Dosage form | string | - |
Document_Type | Type of document | string | - |
DEA_Schedule_Code | Value supplied to FDA as part of the Structured Product Labels; Drug Enforcement Administration (DEA), Controlled Substance Schedule code for the pill, if the pill is scheduled | string | - |
DEA_Schedule_Name | Value supplied to FDA as part of the Structured Product Labels; Drug Enforcement Administration, Controlled Substance Schedule name for the pill, if the pill is scheduled | string | - |
Author_Type | Author type, either labeler or legal | string | - |
Author_Name | Value supplied to FDA as part of the Structured Product Labels; Company submitting the labeling information for this pill to FDA. This company may be the manufacturer or a repackager/relabeler of another company’s product | string | - |
Image_Source | The source of the image. | string | - |
SPL_Image | The Structured Product Label image. | string | - |
Is_Image | Whether or not the image is there. | boolean | - |
Is_Epc_Match | True Indicates that the pill is listed as being a repackaged/relabeled version of another product. | boolean | - |
Version_Number | Version Number | integer | level : Ordinal |
Is_Updated | Whether or not the record was updated | boolean | - |
Is_Stale | The pill no longer has an active label. The product is no longer being actively marketed. | boolean | - |
Is_New | The pill was added to the database at the most recent data process | boolean | - |
Is_Pillbox_Value | Whether or not pillbox is of value. | boolean | - |
Data Preview
Record Id | Is Enabled | Record Creation Date and Time | Record Updation Date and Time | SPP Value | SPL Set Id | SPL Size | Pillbox Size | SPL Shape | SPL Shape Text | Pillbox Shape Text | SPL Score | Pillbox Score | SPL Imprint | Pillbox Imprint | SPL Color | SPL Color Text | Pillbox Color Text | SPL Strength | SPL Ingredients | SPL Inactive Ingredients | Source | RXTTY Value | RX String Value | RX Concept Id | Product Code | RxNorm Update Time | Part Number | Part Medicine Name | NDC Code | NDC Labeler Code | NDC Product Code | Medicine Name | Marketing Act Code | Effective Date | File Name | Equal Product Code | Dosage Form | Document Type | DEA Schedule Code | DEA Schedule Name | Author Type | Author Name | Approval Code | Image Source | SPL Image | Is Image | Is Epc Match | Version Number | Is Updated | Is Stale | Is New | Is Pillbox Value |
41846 | True | 2017-10-17 17:32:23 | 2020-10-02 17:14:07 | 471fa2f1-73a0-49be-89f3-d3e2cfdaeca0-0603-5892-0 | 471fa2f1-73a0-49be-89f3-d3e2cfdaeca0 | 16 | C48336 | CAPSULE | 1 | 5892;V | C48328 | PINK | TEMAZEPAM 15 mg; | TEMAZEPAM[TEMAZEPAM]; | SILICON DIOXIDE;EDETATE DISODIUM;LACTOSE MONOHYDRATE;MAGNESIUM STEARATE;CELLULOSE, MICROCRYSTALLINE;STARCH, CORN;SODIUM LAURYL SULFATE;FD&C BLUE NO. 1;FD&C RED NO. 40;GELATIN;TITANIUM DIOXIDE;BUTYL ALCOHOL; | HRX | 0603-5892 | 2020-02-10 16:21:00 | 0 | 6035892 | 603 | 5892 | Temazepam | completed | 2016-04-06 | d912ca54-6569-4e58-a8ef-620eddd03163.xml | C25158 | C48677 | CIV | LABELER | Qualitest Pharmaceuticals | C73584 | False | 5 | True | False | False | False | ||||||||||||||
8100 | True | 2017-10-17 17:29:56 | 2020-10-02 16:59:28 | 116e13c1-ac50-400f-880f-5779f0155b96-59779-074-0 | 116e13c1-ac50-400f-880f-5779f0155b96 | 10 | C48348 | ROUND | 1 | I2 | C48331 | ORANGE | IBUPROFEN 200 mg; | IBUPROFEN[IBUPROFEN]; | SILICON DIOXIDE;STARCH, CORN;CROSCARMELLOSE SODIUM;FD&C RED NO. 40;FD&C YELLOW NO. 6;FERRIC OXIDE RED;MICROCRYSTALLINE CELLULOSE;POLYETHYLENE GLYCOL, UNSPECIFIED;POLYVINYL ALCOHOL, UNSPECIFIED;STEARIC ACID;TALC;TITANIUM DIOXIDE; | HOTC | SCD | ibuprofen 200 MG Oral Tablet | 310965.0 | 59779-074 | 2020-02-10 15:07:00 | 0 | 597790074 | 59779 | 74 | ibuprofen | active | 2019-11-20 | 55de9f94-89b2-4bfb-a41d-6660ba6e7a6d.xml | C42931 | 34390-5 | LABELER | CVS Pharmacy | C73584 | False | 4 | True | False | False | False | ||||||||||||
5258 | True | 2017-10-17 17:29:44 | 2017-10-17 17:29:44 | 827ce261-307b-4398-8993-333c08e601fe-49884-129-0 | 827ce261-307b-4398-8993-333c08e601fe | 7 | C48346 | PENTAGON (5 SIDED) | 1 | 2.0 | par;129 | C48329 | GREEN | DEXAMETHASONE 6 mg; | DEXAMETHASONE[DEXAMETHASONE]; | ANHYDROUS LACTOSE;CELLULOSE, MICROCRYSTALLINE;CROSCARMELLOSE SODIUM;STEARIC ACID;MAGNESIUM STEARATE;FD&C BLUE NO. 1;D&C YELLOW NO. 10;FD&C YELLOW NO. 6; | HRX | Dexamethasone 6 MG Oral Tablet | 197583.0 | 49884-129 | 0 | 498840129 | 49884 | 129 | Dexamethasone | active | 2012-05-16 | 85a9eebb-be74-43a1-a36f-26ae4c4131aa.xml | C42998 | 34391-3 | LABELER | Par Pharmaceutical Inc. | C73584 | NLM | 498840129.0 | True | 4 | False | True | False | True | |||||||||||
21271 | True | 2017-10-17 17:30:52 | 2020-10-02 17:10:28 | f7f1c99e-1a67-4b34-b1f4-0ac38b9d8006-61480-137-0 | f7f1c99e-1a67-4b34-b1f4-0ac38b9d8006 | 11 | C48348 | ROUND | 2 | LL | C48325 | WHITE | Nickel Sulfate 1 [hp_X];Potassium Bromide 1 [hp_X];Sodium Bromide 1 [hp_X];Zinc Sulfate Anhydrous 1 [hp_X];Sulfur 1 [hp_X]; | Nickel Sulfate[NICKEL CATION];Potassium Bromide[BROMIDE ION];Sodium Bromide[BROMIDE ION];Zinc Sulfate Anhydrous[ZINC CATION];Sulfur[Sulfur]; | HOMEO | 61480-137 | 2020-02-10 16:01:00 | 0 | 614800137 | 61480 | 137 | Acunol | active | 2019-09-09 | 029eaf64-e66f-447e-9ac3-037620370f85.xml | C42998 | 34391-3 | LABELER | PLYMOUTH HEALTHCARE PRODUCTS LLC | C73614 | False | 8 | True | False | False | False | ||||||||||||||||
77050 | True | 2019-09-20 21:10:47 | 2020-10-02 17:14:51 | ecb28fcb-f0d1-4558-b460-ecabd0f6009e-62332-365-0 | ecb28fcb-f0d1-4558-b460-ecabd0f6009e | 6 | C48348 | ROUND | 1 | L;524 | C48325 | WHITE | CLONAZEPAM 0.25 mg; | CLONAZEPAM[CLONAZEPAM]; | SORBITOL;ASPARTAME;SODIUM LAURYL SULFATE;CROSPOVIDONE;MANNITOL;SILICON DIOXIDE;TALC;MAGNESIUM STEARATE; | HRX | SCD | clonazepam 0.25 MG Disintegrating Oral Tablet | 349195.0 | 62332-365 | 2020-02-10 16:25:00 | 0 | 623320365 | 62332 | 365 | CLONAZEPAM | active | 2019-07-01 | ba5120ce-ed74-40be-936d-c172805d88d1.xml | C42999 | C48677 | CIV | LABELER | Alembic Pharmaceuticals Inc. | C73584 | False | 3 | True | False | False | False | |||||||||||
76916 | True | 2019-09-20 21:10:41 | 2020-10-02 17:15:50 | 442e41da-24c2-412f-be6b-d549692943fd-70748-132-0 | 442e41da-24c2-412f-be6b-d549692943fd | 9 | C48348 | ROUND | 1 | LU;V06 | C48325 | WHITE | SILDENAFIL CITRATE 50 mg; | SILDENAFIL CITRATE[SILDENAFIL]; | ANHYDROUS DIBASIC CALCIUM PHOSPHATE;CELLULOSE, MICROCRYSTALLINE;CROSCARMELLOSE SODIUM;HYPROMELLOSE 2910 (6 MPA.S);MAGNESIUM STEARATE;POLYETHYLENE GLYCOL 400;SILICON DIOXIDE;TITANIUM DIOXIDE; | HRX | SCD | sildenafil 50 MG Oral Tablet | 312950.0 | 70748-132 | 2020-02-10 16:30:00 | 0 | 707480132 | 70748 | 132 | SILDENAFIL | active | 2019-10-01 | 17c537d9-b2e6-4d71-a481-c7c7cafdb3a2.xml | C42931 | LABELER | Lupin Pharmaceuticals, Inc. | C73584 | False | 4 | True | False | False | False | |||||||||||||
20016 | True | 2017-10-17 17:30:47 | 2020-10-02 17:12:38 | 5f0bdf9d-fa78-45e8-913a-81beff57cf34-65862-123-0 | 5f0bdf9d-fa78-45e8-913a-81beff57cf34 | 14 | C48345 | OVAL | 1 | A;73 | C48330 | YELLOW | RISPERIDONE 3 mg; | RISPERIDONE[RISPERIDONE]; | LACTOSE MONOHYDRATE;MICROCRYSTALLINE CELLULOSE;SILICON DIOXIDE;MAGNESIUM STEARATE;HYPROMELLOSE 2910 (6 MPA.S);TITANIUM DIOXIDE;POLYETHYLENE GLYCOL 400;D&C YELLOW NO. 10; | HRX | SCD | risperidone 3 MG Oral Tablet | 312832.0 | 65862-123 | 2020-02-10 16:13:00 | 0 | 658620123 | 65862 | 123 | Risperidone | active | 2018-09-24 | 5d2750a4-025a-40a1-97d2-d9447a37afbb.xml | C42931 | 34391-3 | LABELER | Aurobindo Pharma Limited | C73584 | False | 21 | True | False | False | False | ||||||||||||
67902 | True | 2019-06-27 22:45:17 | 2020-10-02 17:04:25 | 572e672e-b759-4db1-9e8f-279b1f6f3c51-50804-750-0 | 572e672e-b759-4db1-9e8f-279b1f6f3c51 | 19 | C48336 | CAPSULE | 1 | AT146 | C48333 | BLUE | IBUPROFEN 200 mg; | IBUPROFEN[IBUPROFEN]; | FD&C BLUE NO. 1;GELATIN;POLYETHYLENE GLYCOL, UNSPECIFIED;POTASSIUM HYDROXIDE;WATER;SORBITOL;SORBITAN;MEDIUM-CHAIN TRIGLYCERIDES;FD&C YELLOW NO. 6;LECITHIN, SOYBEAN; | HOTC | SCD | ibuprofen 200 MG Oral Capsule | 310964.0 | 50804-750 | 2020-02-10 15:30:00 | 0 | 508040750 | 50804 | 750 | Ibuprofen | active | 2019-11-01 | 148c7665-22d5-494c-9add-98428435f392.xml | C42954 | LABELER | Good Sense (Geiss, Destin & Dunn, Inc.) | C73584 | False | 2 | True | False | False | False | |||||||||||||
75997 | True | 2019-09-20 21:09:57 | 2020-10-02 17:12:06 | 6f17cc91-86b3-42e3-9bf2-935dd360c3eb-51672-4184-0 | 6f17cc91-86b3-42e3-9bf2-935dd360c3eb | 12 | C48348 | ROUND | 1 | T;12 | C48325 | WHITE | Iloperidone 12 mg; | Iloperidone[Iloperidone]; | silicon dioxide;crospovidone (15 MPA.S AT 5%);hypromellose, unspecified;lactose monohydrate;magnesium stearate;microcrystalline cellulose;water; | HRX | SCD | iloperidone 12 MG Oral Tablet | 848732.0 | 51672-4184 | 2020-02-10 16:10:00 | 0 | 516724184 | 51672 | 4184 | Iloperidone | active | 2019-08-02 | 6787555e-8a11-481c-b05c-179b0aedcf5c.xml | C42998 | LABELER | Taro Pharmaceuticals U.S.A., Inc. | C73584 | False | 1 | True | False | False | False | |||||||||||||
1288 | True | 2017-10-17 17:29:25 | 2017-10-17 17:29:25 | 02a23e48-f371-448b-92b2-e2d010be1886-54288-129-0 | 02a23e48-f371-448b-92b2-e2d010be1886 | 23 | C48336 | CAPSULE | 1 | RX681 | C48330;C48325 | YELLOW;WHITE | FENOPROFEN CALCIUM 200 mg; | FENOPROFEN CALCIUM[FENOPROFEN]; | CROSPOVIDONE;MAGNESIUM STEARATE;SODIUM LAURYL SULFATE;TALC;GELATIN;TITANIUM DIOXIDE;BROWN IRON OXIDE; | HRX | Fenoprofen 200 MG Oral Capsule [Fenortho] | 1799325.0 | 54288-129 | 0 | 542880129 | 54288 | 129 | FENORTHO | active | 2016-06-14 | 91b0ac5b-994c-468f-9331-542b8f92f9a8.xml | C25158 | LABELER | BPI Labs LLC | C73594 | False | 2 | False | True | False | False |