Pillbox Master Data Lookup

$447.50 / year

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.

Complexity

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.

Date Created

2015-05-11

Last Modified

2016-05-10

Version

2016-05-10

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

National Institutes of Health, N.I.H. (2016). NIH.gov. Retrieved 23 April, 2016, from http//pillbox.nlm.nih.gov/about.html

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

NameDescriptionTypeConstraints
Record_IdUnique identification assigned to each record by the engine.integerrequired : 1 level : Nominal
Is_EnabledEnabled or notbooleanrequired : 1
Record_Creation_Date_and_TimeDate and time the record was created in the enginedatetimerequired : 1
Record_Updation_Date_and_TimeDate and time the record was last updated by the enginedatetimerequired : 1
SPP_ValueSETID-product code-part number – the three values needed to uniquely identify a product.string-
SPL_Set_IdValue supplied to FDA as part of the Structured Product Labels (SPL); Set IDstring-
SPL_SizeValue supplied to FDA as part of the Structured Product Labels (SPL); Size of the pill in millimetersnumberlevel : Ratio
Pillbox_SizeIf 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.integerlevel : Ordinal
SPL_ShapeValue supplied to FDA as part of the Structured Product Labels (SPL); The coded value describing the shape of the pillstring-
SPL_Shape_TextValue supplied to FDA as part of the Structured Product Labels (SPL); The free text value describing the shape of the pillstring-
Pillbox_Shape_TextIf 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_ScoreValue supplied to FDA as part of the Structured Product Labels; Score value for the pillintegerlevel : Ordinal
Pillbox_ScoreIf NLM has an image of the pill and the score is different from the value given by the firm, the NLM value goes here.integerlevel : Ordinal
SPL_ImprintValue supplied to FDA as part of the Structured Product Labels; Text appearing on the pillstring-
Pillbox_ImprintIf 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_ColorValue supplied to FDA as part of the Structured Product Labels; Coded value(s) for the color(s) of the pillstring-
SPL_Color_TextValue supplied to FDA as part of the Structured Product Labels; Color(s) of the pillstring-
Pillbox_Color_TextIf 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_StrengthValue supplied to FDA as part of the Structured Product Labels; Active ingredients and the dosage amountsstring-
SPL_IngredientsValue supplied to FDA as part of the Structured Product Labels; Active ingredients in the pillstring-
SPL_Inactive_IngredientsValue supplied to FDA as part of the Structured Product Labels; Inactive ingredients in the pillstring-
SourceValue supplied to FDA as part of the Structured Product Labels; Prescription, over-the-counter, homeopathic, veterinarian, remainderstring-
RXTTY_ValueRXTTY value from RxNorm API based on product codestring-
RX_String_ValueRXTSRING value from RxNorm API based on product codestring-
RX_Concept_IdRxNorm Concept Unique Identifier (CUI) value from RxNorm API based on product codeintegerlevel : Nominal
Product_CodeValue supplied to FDA as part of the Structured Product Labels; The pill’s product codestring-
Part_NumberValue 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-packintegerlevel : Ordinal
Part_Medicine_NameValue 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-packstring-
NDC_CodeValue 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-
Medicine_NameValue supplied to FDA as part of the Structured Product Labels; Name of the medicationstring-
Marketing_Act_CodeValue supplied to FDA as part of the Structured Product Labels; Marketing act code, either active or completedstring-
Effective_DateValue supplied to FDA as part of the Structured Product Labels; Date the information in the label is effectivedate-
File_NameValue supplied to FDA as part of the Structured Product Labels; Name of the xml file containing the label for the pill. Different from SetIdstring-
Equal_Product_CodeValue 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 relabelingstring-
Dosage_FormDosage formstring-
Document_TypeType of documentstring-
DEA_Schedule_CodeValue 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 scheduledstring-
DEA_Schedule_NameValue supplied to FDA as part of the Structured Product Labels; Drug Enforcement Administration, Controlled Substance Schedule name for the pill, if the pill is scheduledstring-
Author_TypeAuthor type, either labeler or legalstring-
Author_NameValue 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 productstring-
Approval_CodeApproval codestring-
Is_Epc_MatchTrue Indicates that the pill is listed as being a repackaged/relabeled version of another product.boolean-
Version_NumberVersion Numberintegerlevel : Ordinal
Is_UpdatedWhether or not the record was updatedboolean-
Is_StaleThe pill no longer has an active label. The product is no longer being actively marketed.boolean-
Is_NewThe pill was added to the database at the most recent data processboolean-
Primary_KeyPrimary key added when the engine data is imported into the production systemintegerlevel : Ordinal
SPL_Inactive_Ingredient_NewModified inactive ingredientsstring-
SPL_Color_NewCombines the SPL and Pillbox color values. This is the value searched by the Pillbox website and API.string-
SPL_Shape_NewSPL shape value except when there is a Pillbox value. This is the value searched by the Pillbox website and API.string-
SPL_Size_NewSPL size value except when there is a Pillbox value. This is the value searched by the Pillbox website and API.numberlevel : Ratio
SPL_Score_NewSPL score value except when there is a Pillbox value. This is the value searched by the Pillbox website and API.integerlevel : Ordinal
SPL_Imprint_NewCombines SPL and Pillbox imprint values. This is the value searched by the Pillbox website and API.string-
RX_String_NewComposite value created when there is no RXSTRING value returned by the RxNorm API.string-
RX_Concept_Id_NewRxNorm Concept Unique Identifier value from RxNorm API based on product codeintegerlevel : Nominal
RXTTY_Value_Newvalue from RxNorm API based on product codestring-
RX_SourceSource of information of the pillstring-
Ingredient_SourceSource of information of active ingredientstring-
Ingredients_NewComposite ingredients values create when there is no ingredients value in the SPLstring-
Inactive_Ingredient_SourceSource of information of inactive ingredientstring-
Record_IdIs_EnabledRecord_Creation_Date_and_TimeRecord_Updation_Date_and_TimeSPP_ValueSPL_Set_IdSPL_SizePillbox_SizeSPL_ShapeSPL_Shape_TextPillbox_Shape_TextSPL_ScorePillbox_ScoreSPL_ImprintPillbox_ImprintSPL_ColorSPL_Color_TextPillbox_Color_TextSPL_StrengthSPL_IngredientsSPL_Inactive_IngredientsSourceRXTTY_ValueRX_String_ValueRX_Concept_IdProduct_CodePart_NumberPart_Medicine_NameNDC_CodeMedicine_NameMarketing_Act_CodeEffective_DateFile_NameEqual_Product_CodeDosage_FormDocument_TypeDEA_Schedule_CodeDEA_Schedule_NameAuthor_TypeAuthor_NameApproval_CodeIs_Epc_MatchVersion_NumberIs_UpdatedIs_StaleIs_NewPrimary_KeySPL_Inactive_Ingredient_NewSPL_Color_NewSPL_Shape_NewSPL_Size_NewSPL_Score_NewSPL_Imprint_NewRX_String_NewRX_Concept_Id_NewRXTTY_Value_NewRX_SourceIngredient_SourceIngredients_NewInactive_Ingredient_Source
42503true2015-12-07T23:31:542016-04-06T18:56:54845694fc-54f2-4666-90ec-e2a79fc21cce-51311-862-0845694fc-54f2-4666-90ec-e2a79fc21cce7.00C48345OVAL2C48325WHITEMETHIONINE 200 mg;METHIONINE[METHIONINE];ANIMAL51311-8620513110862Ammonilactive2014-11-172d239541-9b23-4449-ac3f-12b0a895ad6a.xmlC42998LABELERVirbac AH, IncC73627false1truefalsefalse44723C48325C483457.002engineMETHIONINE[METHIONINE];
43137true2015-12-07T23:32:112016-04-06T18:58:011eb20ef6-7a56-5b3e-e054-00144ff88e88-69176-011-11eb20ef6-7a56-5b3e-e054-00144ff88e888.00C48336CAPSULEblankC48325WHITEVITAMIN D 1000 [iU];VITAMIN D[VITAMIN D];HRX69176-0111Vitamin D-3691760011Omega-3 Well Packactive2015-09-011eb20ef6-7a57-5b3e-e054-00144ff88e88.xmlC25158LABELERTMIG, Inc.C86952false1truefalsefalse21350C48325C483368.000blankengineVITAMIN D[VITAMIN D];
46335true2016-02-29T22:22:472016-04-06T19:00:094643a81d-4ca7-4e96-9786-bddae0641962-15631-0688-04643a81d-4ca7-4e96-9786-bddae06419623.00C48348ROUND1C48325WHITETIN 3 [hp_X];TIN[TIN];LACTOSE;HOMEO15631-06880156310688STANNUM METALLICUMactive2015-12-2713da4986-4f12-4124-8104-9314a171cb87.xmlC42998LABELERRxhomeo Private Limited d.b.a. Rxhomeo, IncC73614false1truefalsefalse2580LACTOSEC48325C483483.001engineTIN[TIN];engine
46299true2016-02-29T22:22:452016-04-06T19:00:5473dceba6-29ae-470b-b46d-6e208ce3cab2-15631-0509-073dceba6-29ae-470b-b46d-6e208ce3cab23.00C48348ROUND1C48325WHITEALOE 1 [hp_X];ALOE[ALOE];LACTOSE;HOMEO15631-05090156310509ALOE SOCOTRINAactive2015-12-3000c9c670-2a64-4f9a-b47e-6762d9f9e97d.xmlC42998LABELERRxhomeo Private Limited d.b.a. Rxhomeo, IncC73614false1truefalsefalse2558LACTOSEC48325C483483.001engineALOE[ALOE];engine
31535true2014-12-16T20:46:572016-04-06T18:57:152dc5420a-6f66-46b3-9cc9-e98756093471-57561-762-02dc5420a-6f66-46b3-9cc9-e987560934716.00C48345OVAL2C48328PINKUREA 13 g;UREA[UREA];ANIMAL57561-7620575610762INTRAUTERINE BOLUSactive2011-03-08fe221bbd-69e7-4160-a32c-cd06cce1f6ee.xmlC4299850577-6LABELERAgri Laboratories, Ltd.C73627false1truefalsefalse7186C48328C483456.002INTRAUTERINE BOLUS - UREA 13 gSPL_dataengineUREA[UREA];
46466true2016-02-29T22:22:502016-04-06T19:01:424b9d1c84-b277-4e8e-9882-19ca22006bbe-15631-0528-04b9d1c84-b277-4e8e-9882-19ca22006bbe3.00C48348ROUND1C48325WHITEGOLD 3 [hp_X];GOLD[GOLD];LACTOSE;HOMEO15631-05280156310528AURUM METALLICUMactive2015-12-31b4c84a39-5be8-4fcb-a39e-ba2db361748a.xmlC42998LABELERRxhomeo Private Limited d.b.a. Rxhomeo, IncC73614false1truefalsefalse4071LACTOSEC48325C483483.001engineGOLD[GOLD];engine
31790true2014-12-16T20:46:582016-04-06T18:56:106318f8ef-2870-4d58-a307-558dafd43967-58005-762-06318f8ef-2870-4d58-a307-558dafd439676.00C48345OVAL2C48328PINKUREA 13 g;UREA[UREA];ANIMAL58005-7620580050762ANTISEPSIS BOLUSactive2014-04-288c416232-6ef2-41e7-8028-c18977317950.xmlC4299850577-6LABELERSparhawk Laboratories, Inc.C73627false5truefalsefalse41834C48328C483456.002ANTISEPSIS BOLUS - UREA 13 gSPL_dataengineUREA[UREA];
44311true2015-12-07T23:32:462016-04-06T18:56:08177617c0-06bf-265e-e054-00144ff8d46c-11014-0187-0177617c0-06bf-265e-e054-00144ff8d46c13.00C48348ROUND1C48328PINKPROGESTERONE 100 mg;PROGESTERONE[PROGESTERONE];REMAIN11014-01870110140187Progestronaactive2015-06-01177617c0-06c0-265e-e054-00144ff8d46c.xmlC25158LABELERCatalent Pharma Solutions, LLCC73590false1truefalsefalse2258C48328C4834813.001enginePROGESTERONE[PROGESTERONE];
42497true2015-12-07T23:31:532016-04-06T18:57:01751825c0-ec5d-4066-9ca5-96337d083032-62250-313-0751825c0-ec5d-4066-9ca5-96337d0830328.00C48348ROUND225mg;BP;CARC48331ORANGECARPROFEN 25 mg;CARPROFEN[CARPROFEN];ANIMAL62250-3130622500313Carprofenactive2015-04-22237655a5-71e6-477b-ad02-975d6c5c0a89.xmlC42998LABELERBelcher Pharmaceuticals LLCC73583false1truefalsefalse13787C48331C483488.00225mg;BP;CARengineCARPROFEN[CARPROFEN];
46319true2016-02-29T22:22:462016-04-06T18:57:10a57d0c35-6101-4d07-97d3-113272b034c0-15631-0508-0a57d0c35-6101-4d07-97d3-113272b034c03.00C48348ROUND1C48325WHITEONION 1 [hp_X];ONION[ONION];LACTOSE;HOMEO15631-05080156310508ALLIUM CEPAactive2015-12-3006bc77d6-77ba-4911-927e-9a738aa46a9a.xmlC42998LABELERRxhomeo Private Limited d.b.a. Rxhomeo, IncC73614false1truefalsefalse23214LACTOSEC48325C483483.001engineONION[ONION];engine