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.

Log in to download
Complexity

Get The Data

For getting access to data download links please read and accept the end-user license agreement.
Your Data License
  • Research
    Non-Commercial, Share-Alike, Attribution Free Forever
  • Commercial
    Commercial Use, Remix & Adapt, White Label Log in to download

John Snow Labs Standard End User License Agreement

Last updated:January 20, 2021

This Data Library End User License Agreement (“EULA”) applies to academic researchers, educators, and students using any product of John Snow Labs in John Snow Labs’ Data Library as defined below (hereinafter referred to “you”). This EULA is between you and John Snow Labs Inc., a Delaware corporation (“John Snow Labs”, “we” or “us”).

By downloading and/or using (as applicable) Data Library of John Snow Labs (as defined below), you automatically agree to be bound by, and use it in compliance with, this EULA. This EULA, together with additional terms and conditions and/or policies referenced herein or located on https://www.johnsnowlabs.com and/or conveyed to you by John Snow Labs, is a legally binding contract between you and John Snow Labs.

PLEASE READ THIS EULA CAREFULLY BEFORE DOWNLOADING OR USING DATA LIBRARY.

We may make changes to this EULA from time to time. When we do so, we will revise the “last updated” date given above. The then-current version of this EULA will supersede all earlier versions. You agree that your continued use of Data Library after such changes have been published to our EULA will constitute your acceptance of such revised EULA.

Definitions

“Data Library” means a data library provided by John Snow Labs and located at https://www.johnsnowlabs.com/marketplace/;

“Website” means https://www.johnsnowlabs.com being owned and operated by John Snow Labs.

Important Notice

By downloading and using any product from the Data Library, you acknowledge that the use of Data Library can be subject to the restrictions and controls imposed by United States export regulations.

You represent and warrant that you do not intend to use Data Library for any purpose prohibited by United States export regulations, including, without limitation, terrorism, cyber-attacks, cyber-crimes, money-laundering, industrial espionage, or nuclear, chemical or biological weapons proliferation. Further, you represent and warrant that you are not listed as a denied party on any list governing United States exports.

Eligibility

Our Data Library can be used by an individual.

In the event you have entered into a separate written agreement with John Snow Labs regarding Data Library that contemplates terms that are inconsistent with this EULA, the written agreement shall control and this EULA will not apply to you to the extent inconsistent with such written agreement, or, if such written agreement is contemplated to be in lieu of this EULA, then this EULA shall not apply at all

License Granted

Subject to your compliance with this EULA, as well as any other applicable policies, John Snow Labs grants you non-exclusive, non-transferable, revocable, license to download, access to, modify, and use of, Data Library worldwide (subject to applicable export laws) during the term of this EULA (as described below) under the following conditions:

  • The license can be used solely for research, private study and personal use of Data Library for unlimited period, or unless terminated under this EULA.were made;
  • This license is personal to you and is limited by all terms and conditions set forth in this EULA;
  • The license is granted as a non-commercial, attribution, share-alike and no-derivate-work license as more detailed below;
  • Under the attribution license, you must give the appropriate name of the creator and a copyright notice of John Snow Labs, provide link to this license and indicate if changes
  • Under the share-alike license, you can distribute modified works only under a license identical to this EULA;
  • Under the no-derivate-work license, you can perform only verbatim copies of Data Library, not derivate works or remixes based on it;
  • If the license is used for academic research purpose, the publication shall be made under the open-access, open-source and open-data license.

You can download any dataset from the Data Library from the Website.

Except for your pre-existing rights and this license granted to you, we and our licensors retain all rights, titles and interests in and to our Data Library, all related intellectual property rights, including trademarks (whether registered or pending), domain and business names. Our Data Library is protected by applicable intellectual property laws, including United States copyright law and international treaties.

John Snow Labs is entitled to revoke the license granted at any time at its sole discretion.

License Restrictions

You will be deemed to have taken any action that you permit, assist or facilitate any person or entity to take related to this EULA, your content or use of Data Library. You are responsible for end users’ use of your content and Data Library. You will ensure that all end users comply with your obligations under this EULA and that the terms of your agreement with each end user are consistent with this EULA. If you become aware of any violation of your obligations under this EULA caused by an end user, you will immediately suspend access to your content and Data Library by such end user.

License Restrictions

You will access or use our Data Library solely via John Snow Labs’ Data Library.

Except as otherwise explicitly provided in this EULA or as may be expressly permitted by applicable law, you will not, and will not permit or authorize any third party to:

  1. you cannot reproduce, translate, enhance, decompile, disassemble, reverse engineer or create derivative works of Data Library or its technological features or measures;
  2. you cannot rent, lease, sell, resell, loan, distribute, or sublicense access to any of Data Library;
  3. you cannot circumvent or disable any security or technological features or measures of Data Library;
  4. you cannot use our intellectual property rights without our express prior written authorization or in violation of this EULA;
  5. you cannot use Data Library with an intent to build a competitive product or service, or copy or substantially copy any ideas, features, functions, organization, structure, application program interface, graphics, or user interface of Data Library;
  6. you cannot copy, distribute, or resell any of the information; audio, visual, and audiovisual works, or other content made available on Data Library (collectively, “Content”) or compile or collect any Content as part of a database or other work;
  7. you cannot use any automated tool (e.g., robots, spiders) to access or use Data Library, or to store, copy, modify, distribute, or resell any Content;
  8. you cannot circumvent or disable any rights management, usage rules, or other security features of Data Library;
  9. you cannot use Data Library in a manner that overburdens, or that threatens the integrity, performance, or availability of, Data Library; or
  10. you cannot remove, alter, or obscure any proprietary notices (including copyright and trademark notices) on any portion of Data Library or any Content.

If you breach any of this EULA, the above license will terminate automatically.

Fees and Taxes

This license is for non-commercial use. If you wish to use our Data Library for commercial use, please contact us at support@JohnSnowLabs.com.

Support and Updates

Under this EULA, support services are excluded.

From time to time John Snow Labs can perform updates to our software. If available, such updates may include bug fixes, new features and/or enhancements. You are solely responsible for deploying such updates at your own risk and liability.

Term and Termination

This EULA will become effective as of the date of your order of Data Library and shall be in effect until terminated.

John Snow Labs may suspend or terminate your right to use Data Library, if you or your end user’s use of Data Library:

  1. is in breach of this EULA;
  2. poses a security risk to Data Library;
  3. could adversely impact our systems, Data Library or other customers;
  4. could subject us, our affiliates, or any third party to liability; or
  5. could be fraudulent.

We may also suspend or terminate your right to use Data Library, if you have ceased to operate in the ordinary course, made an assignment for the benefit of creditors or similar disposition of your assets, or become the subject of any bankruptcy, reorganization, liquidation, dissolution or similar proceeding.

You will cease use of Data Library during any period of suspension, or upon termination of this EULA.

All provisions which by their nature are intended to survive termination shall survive termination of this EULA.

Access to Data Library

We do not provide you with the equipment to access Data Library. You are responsible for all fees charged by third parties related to your access and use of Data Library (e.g., charges by Internet service providers).

You are responsible for monitoring your use of Data Library, including payment of all fees and/or taxes related to such access and use. You agree that John Snow Labs is permitted to request and you hereby consent to provide John Snow Labs information related to your use of Data Library for auditing purposes.

You also certify that you are legally permitted to use Data Library, and take full responsibility for the selection and use of Data Library. This EULA is void where prohibited by law, and the right to use Data Library is revoked in such jurisdictions. John Snow Labs makes no claim that Data Library may be lawfully used outside of the United States. If you use Data Library from outside of the United States, you do so at your own risk and you are responsible for compliance with the laws of jurisdiction.

Privacy Policy

We may collect, store and receive personal and other information about you through our Products. Our collection and use of this information is governed by our Privacy Policy available at https://www.JohnSnowLabs.com/privacy/ which may be amended from time to time.

Links and Third Party Content

Data Library may display, or contain links to, third party products, services, and websites. Any opinions, advice, statements, services, offers, or other information that constitutes part of the content expressed, authored, or made available by other users or other third parties, or which is accessible through or may be located using Data Library (collectively, “Third Party Content”) are those of the respective authors or producers and not of us or our shareholders, directors, officers, employees, agents, or representatives.

We do not control Third Party Content and do not guarantee the accuracy, integrity or quality of such Third Party Content. We are not responsible for the performance of, we do not endorse, and we are not responsible or liable for, any Third Party Content or any information or materials advertised in any Third Party Content. By using Data Library, you may be exposed to content that is offensive, indecent, or objectionable. We are not responsible or liable, directly or indirectly, for any damage or loss caused to you by your use of or reliance on any goods, services, or information available on or through any third party service or Third Party Content. It is your responsibility to evaluate the information, opinion, advice, or other content available on and through our Products.

Proprietary Rights

John Snow Labs will not obtain any rights under this EULA from you (or your licensors) to your content.

Data Library is and remains the exclusive property of John Snow Labs and its licensors. Except for the access and use rights expressly set forth in this EULA, no license or other rights in or to Data Library or John Snow Labs trademark(s) and other intellectual property rights therein, are granted to you, and all such licenses and rights are expressly reserved. You will not remove, alter, or obscure any proprietary notices (including copyright and trademark notices) on any portion of Data Library or any Content.

Trademarks

“John Snow Labs,” the John Snow Labs logo, and any other product, business or service name or slogan, whether registered or pending, displayed on Data Library are trademarks of John Snow Labs, Inc. or its suppliers or licensors, and may not be copied, imitated or used, in whole or in part, without the prior written permission of John Snow Labs or the applicable trademark holder. You may not use any metatags or any other “hidden text” utilizing “John Snow Labs” or any other name, trademark or product, business or service name of John Snow Labs without our prior written permission. In addition, the look and feel of Data Library, including all page headers, custom graphics, button icons and scripts, is the service mark, trademark and/or trade dress of John Snow Labs may not be copied, imitated or used, in whole or in part, without our prior written permission. All other trademarks, pending trademarks, registered trademarks, product names and company names or logos mentioned in Data Library are the property of John Snow Labs Inc. and/or their respective owners. Reference to any products, services, processes or other information, by trade name, trademark, manufacturer, supplier, or otherwise does not constitute or imply endorsement, sponsorship, or recommendation thereof by us.

Disclaimer of Warranties

YOUR USE OF DATA LIBRARY IS AT YOUR SOLE RISK. THE PRODUCTS AND CONTENT EACH ARE PROVIDED ON AN “AS IS” AND “AS AVAILABLE” BASIS. WE AND OUR SUPPLIERS AND LICENSORS EXPRESSLY DISCLAIM ALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE, AND NON-INFRINGEMENT. WE DO NOT GUARANTEE THE ACCURACY, COMPLETENESS, OR USEFULNESS OF THE PRODUCTS OR ANY CONTENT, AND YOU RELY ON THE PRODUCTS AND CONTENT AT YOUR OWN RISK. ANY MATERIAL THAT YOU ACCESS OR OBTAIN THROUGH OUR PRODUCTS IS DONE AT YOUR OWN DISCRETION AND RISK AND YOU WILL BE SOLELY RESPONSIBLE FOR ANY DAMAGE TO YOUR COMPUTER OR LOSS OF DATA THAT RESULTS FROM THE DOWNLOAD OF ANY MATERIAL THROUGH OUR PRODUCTS. NO ADVICE OR INFORMATION, WHETHER ORAL OR WRITTEN, OBTAINED BY YOU FROM US OR THROUGH OR FROM OUR PRODUCTS WILL CREATE ANY WARRANTY NOT EXPRESSLY STATED IN THIS EULA. SOME STATES MAY PROHIBIT A DISCLAIMER OF WARRANTIES AND YOU MAY HAVE OTHER RIGHTS THAT VARY FROM STATE TO STATE.

Limitation of Liability

WE AND OUR SUPPLIERS AND LICENSORS WILL NOT BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, CONSEQUENTIAL, OR EXEMPLARY DAMAGES, INCLUDING BUT NOT LIMITED TO, DAMAGES FOR LOSS OF PROFITS, GOODWILL, USE, DATA, OR OTHER INTANGIBLE LOSSES (EVEN IF WE HAVE BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), RESULTING FROM YOUR USE OF OUR PRODUCTS AND CONTENT. UNDER NO CIRCUMSTANCES WILL THE TOTAL LIABILITY OF US AND OUR SUPPLIERS AND LICENSORS OF ALL KINDS ARISING OUT OF OR RELATED TO YOUR USE OF THE PRODUCTS AND CONTENT (INCLUDING BUT NOT LIMITED TO WARRANTY CLAIMS), REGARDLESS OF THE FORUM AND REGARDLESS OF WHETHER ANY ACTION OR CLAIM IS BASED ON CONTRACT, TORT, OR OTHERWISE, EXCEED THE AMOUNTS, IF ANY, THAT YOU HAVE PAID FOR YOUR USE OF THE PRODUCTS AND CONTENT. BECAUSE SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES, THE ABOVE LIMITATION MAY NOT APPLY TO YOU.

Indemnity

To the full extent permitted by applicable law, you shall defend, indemnify and hold harmless John Snow Labs, its affiliates and its licensors, and each of their respective employees, officers, directors, and representatives from and against any claims, damages, losses, liabilities, costs, and expenses (including reasonable attorney’s fees) arising out of or relating to any third party claim concerning: (a) your use of Data Library; (b) breach of this EULA or violation of applicable law by you; (c) any content or the combination of such content with other software, content or processes, including any claim involving alleged infringement or misappropriation of third-party rights by such content or combination; or (d) breach of any obligation or duty you owe to a third party.

Legal Notices

Enforcement of this EULA will be governed by the laws of the State of Delaware, excluding its conflict and choice of law principles. The exclusive jurisdiction and venue for any claims arising out of or related to this EULA or your use of Data Library will lie in the state and federal courts located in Sussex County, within the State of Delaware, and you irrevocably agree to submit to the jurisdiction of such courts. Our failure to enforce any right or provision in this EULA will not constitute a waiver of such right or provision unless acknowledged and agreed by us in writing. In the event that a court of competent jurisdiction finds any provision of this EULA to be illegal, invalid, or unenforceable, the remaining provisions will remain in full force and effect.

Notifications

We may use your contact information to notify you if we have any legitimate interest or if we need to notify you on any important information related to your use of Data Library. We will not send you newsletters unless you expressly consented to such notifications.

Contacting Us

If you have any questions or concerns about Data Library or this EULA, you may contact us by email at support@JohnSnowLabs.com.

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

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

Data Fields

Name Description Type Constraints
Record_IdUnique identification assigned to each record by the engine.integerrequired : 1level : 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-

Data Preview

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