datadiscovery-nlm-nih-gov/pillbox-retired-january-28-2021-crzr-uvwg
Icon for Socrata external plugin
 
Preview
  • pillbox_retired_january_28_2021
     
 
Readme
Updated 22 days ago
Indexed 2 hours ago

Pillbox (retired January 28, 2021)

This resource was retired on January 28, 2021 and is no longer updated. These data remain available to support research and development efforts. Pillbox's final image library is available at https://www.nlm.nih.gov/databases/download/pill_image.html. For more information on Pillbox's retirement visit https://www.nlm.nih.gov/pubs/techbull/ja20/ja20_pillbox_discontinue.html.

Pillbox contains metadata for oral solid dosage form medications, derived from FDA drug labeling, including physical characteristics, active and inactive ingredients, National Drug Codes, information about firms marketing those products, selected information from RxNorm, and links to images provided by the National Library of Medicine.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
part_medicine_namepart_medicine_namepart_medicine_nameTextSOURCE: SPL(DRUG LABEL)/FDA
part_numpart_numpart_numNumberSOURCE: SPL(DRUG LABEL)/FDA
setidsetidsetidTextSOURCE: SPL(DRUG LABEL)/FDA SETID of source drug label
ndc_labeler_codendc_labeler_codendc_labeler_codeTextSOURCE: SPL(DRUG LABEL)/FDA
pillbox_sizepillbox_sizepillbox_sizeNumberSOURCE: SPL(DRUG LABEL)/FDA If an NLM or VA image with a ruler exists, the size as measured on that image
splscoresplscoresplscoreNumberSOURCE: SPL(DRUG LABEL)/FDA Score as reported by the listing firm.
splcolorsplcolorsplcolorTextSOURCE: SPL(DRUG LABEL)/FDA Color as reported by the listing firm. Colors are limited to those specified in SPL Guidance. https://www.fda.gov/industry/structured-product-labeling-resources/spl-color
pillbox_color_textpillbox_color_textpillbox_color_textTextSOURCE: PILLBOX/NLM
rxstringrxstringrxstringTextSOURCE: RXNORM/NLM
product_codeproduct_codeproduct_codeTextSOURCE: SPL(DRUG LABEL)/FDA
ndc9ndc9ndc9TextSOURCE: SPL(DRUG LABEL)/FDA
file_namefile_namefile_nameTextSOURCE: SPL(DRUG LABEL)/FDA
dea_schedule_codedea_schedule_codedea_schedule_codeTextSOURCE: SPL(DRUG LABEL)/FDA
dea_schedule_namedea_schedule_namedea_schedule_nameTextSOURCE: SPL(DRUG LABEL)/FDA
image_sourceimage_sourceimage_sourceTextSOURCE: PILLBOX/NLM
application_numberapplication_numberapplication_numberTextSOURCE: SPL(DRUG LABEL)/FDA
splcolor_textsplcolor_textsplcolor_textTextSOURCE: SPL(DRUG LABEL)/FDA
spl_strengthspl_strengthspl_strengthTextSOURCE: SPL(DRUG LABEL)/FDA
sourcesourcesourceTextSOURCE: SPL(DRUG LABEL)/FDA
ndc_product_codendc_product_codendc_product_codeTextSOURCE: SPL(DRUG LABEL)/FDA
marketing_act_codemarketing_act_codemarketing_act_codeTextSOURCE: SPL(DRUG LABEL)/FDA
dosage_formdosage_formdosage_formTextSOURCE: SPL(DRUG LABEL)/FDA
document_typedocument_typedocument_typeTextSOURCE: SPL(DRUG LABEL)/FDA
authorauthorauthorTextSOURCE: SPL(DRUG LABEL)/FDA
IDididTextSOURCE: PILLBOX/NLM Pillbox Engine-assigned unique identifier
created atcreated_atcreated_atCalendar dateSOURCE: PILLBOX/NLM Date record was created
updated atupdated_atupdated_atCalendar dateSOURCE: PILLBOX/NLM Date record was updated
sppsppsppTextSETID + Product Code + Part Number (uniquely identifies a pill)
splsizesplsizesplsizeNumberSOURCE: SPL(DRUG LABEL)/FDA Size as reported by listing firm
splshapesplshapesplshapeTextSOURCE: SPL(DRUG LABEL)/FDA Shape as reported by the listing firm. Coded value from https://www.fda.gov/industry/structured-product-labeling-resources/spl-shape
splshape_textsplshape_textsplshape_textTextSOURCE: SPL(DRUG LABEL)/FDA Shape as reported by the listing firm. Text value from https://www.fda.gov/industry/structured-product-labeling-resources/spl-shape
pillbox_shape_textpillbox_shape_textpillbox_shape_textTextSOURCE: PILLBOX/NLM If an image exists and splshape/shape_text do not match the shape of the pill in the image, NLM adds a shape value (in text format using the FDA SPL/splshape terms) to improve search. https://www.fda.gov/industry/structured-product-labeling-resources/spl-shape
pillbox_scorepillbox_scorepillbox_scoreNumberSOURCE: PILLBOX/NLM If an image exists and splscore does not match the score value of the pill in the image, NLM adds a score value to improve search.
splimprintsplimprintsplimprintTextSOURCE: SPL(DRUG LABEL)/FDA Imprint as reported by the listing firm
pillbox_imprintpillbox_imprintpillbox_imprintTextSOURCE: PILLBOX/NLM If an image exists and the imprint text does not match splimprint, NLM adds the imprint presented on the image to improve the search experience. For a small number of pills, the imprint has changed. In those situations, NLM will include the previous imprint text.
spl_ingredientsspl_ingredientsspl_ingredientsTextSOURCE: SPL(DRUG LABEL)/FDA
spl_inactive_ingspl_inactive_ingspl_inactive_ingTextSOURCE: SPL(DRUG LABEL)/FDA
rxttyrxttyrxttyTextSOURCE: RXNORM/NLM
rxcuirxcuirxcuiTextSOURCE: RXNORM/NLM
RxNorm Update timerxnorm_update_timerxnorm_update_timeCalendar dateSOURCE: PILLBOX/NLM
medicine_namemedicine_namemedicine_nameTextSOURCE: SPL(DRUG LABEL)/FDA
effective_timeeffective_timeeffective_timeTextSOURCE: SPL(DRUG LABEL)/FDA
equal_product_codeequal_product_codeequal_product_codeTextSOURCE: SPL(DRUG LABEL)/FDA
approval_codeapproval_codeapproval_codeTextSOURCE: SPL(DRUG LABEL)/FDA
splimagesplimagesplimageTextSOURCE: SPL(DRUG LABEL)/FDA OR PILLBOX/NLM
has_imagehas_imagehas_imageTextSOURCE: PILLBOX/NLM
version_numberversion_numberversion_numberNumberSOURCE: SPL(DRUG LABEL)/FDA
updatedupdatedupdatedTextSOURCE: PILLBOX/NLM
stalestalestaleTextSOURCE: PILLBOX/NLM
Enabled?enabledenabledTextSOURCE: PILLBOX/NLM Supports Pillbox Engine
Pillbox Valuepillbox_valuepillbox_valueTextSOURCE: PILLBOX/NLM
author_typeauthor_typeauthor_typeTextSOURCE: SPL(DRUG LABEL)/FDA
newnewnewTextSOURCE: PILLBOX/NLM
laberer_codelaberer_codelaberer_codeTextSOURCE: SPL(DRUG LABEL)/FDA
epc_matchepc_matchepc_matchTextSOURCE: PILLBOX/NLM
Upstream Metadata