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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| part_medicine_name | part_medicine_name | part_medicine_name | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| part_num | part_num | part_num | Number | SOURCE: SPL(DRUG LABEL)/FDA |
| setid | setid | setid | Text | SOURCE: SPL(DRUG LABEL)/FDA SETID of source drug label |
| ndc_labeler_code | ndc_labeler_code | ndc_labeler_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| pillbox_size | pillbox_size | pillbox_size | Number | SOURCE: SPL(DRUG LABEL)/FDA If an NLM or VA image with a ruler exists, the size as measured on that image |
| splscore | splscore | splscore | Number | SOURCE: SPL(DRUG LABEL)/FDA Score as reported by the listing firm. |
| splcolor | splcolor | splcolor | Text | SOURCE: 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_text | pillbox_color_text | pillbox_color_text | Text | SOURCE: PILLBOX/NLM |
| rxstring | rxstring | rxstring | Text | SOURCE: RXNORM/NLM |
| product_code | product_code | product_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| ndc9 | ndc9 | ndc9 | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| file_name | file_name | file_name | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| dea_schedule_code | dea_schedule_code | dea_schedule_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| dea_schedule_name | dea_schedule_name | dea_schedule_name | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| image_source | image_source | image_source | Text | SOURCE: PILLBOX/NLM |
| application_number | application_number | application_number | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| splcolor_text | splcolor_text | splcolor_text | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| spl_strength | spl_strength | spl_strength | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| source | source | source | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| ndc_product_code | ndc_product_code | ndc_product_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| marketing_act_code | marketing_act_code | marketing_act_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| dosage_form | dosage_form | dosage_form | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| document_type | document_type | document_type | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| author | author | author | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| ID | id | id | Text | SOURCE: PILLBOX/NLM Pillbox Engine-assigned unique identifier |
| created at | created_at | created_at | Calendar date | SOURCE: PILLBOX/NLM Date record was created |
| updated at | updated_at | updated_at | Calendar date | SOURCE: PILLBOX/NLM Date record was updated |
| spp | spp | spp | Text | SETID + Product Code + Part Number (uniquely identifies a pill) |
| splsize | splsize | splsize | Number | SOURCE: SPL(DRUG LABEL)/FDA Size as reported by listing firm |
| splshape | splshape | splshape | Text | SOURCE: 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_text | splshape_text | splshape_text | Text | SOURCE: 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_text | pillbox_shape_text | pillbox_shape_text | Text | SOURCE: 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_score | pillbox_score | pillbox_score | Number | SOURCE: 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. |
| splimprint | splimprint | splimprint | Text | SOURCE: SPL(DRUG LABEL)/FDA Imprint as reported by the listing firm |
| pillbox_imprint | pillbox_imprint | pillbox_imprint | Text | SOURCE: 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_ingredients | spl_ingredients | spl_ingredients | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| spl_inactive_ing | spl_inactive_ing | spl_inactive_ing | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| rxtty | rxtty | rxtty | Text | SOURCE: RXNORM/NLM |
| rxcui | rxcui | rxcui | Text | SOURCE: RXNORM/NLM |
| RxNorm Update time | rxnorm_update_time | rxnorm_update_time | Calendar date | SOURCE: PILLBOX/NLM |
| medicine_name | medicine_name | medicine_name | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| effective_time | effective_time | effective_time | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| equal_product_code | equal_product_code | equal_product_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| approval_code | approval_code | approval_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| splimage | splimage | splimage | Text | SOURCE: SPL(DRUG LABEL)/FDA OR PILLBOX/NLM |
| has_image | has_image | has_image | Text | SOURCE: PILLBOX/NLM |
| version_number | version_number | version_number | Number | SOURCE: SPL(DRUG LABEL)/FDA |
| updated | updated | updated | Text | SOURCE: PILLBOX/NLM |
| stale | stale | stale | Text | SOURCE: PILLBOX/NLM |
| Enabled? | enabled | enabled | Text | SOURCE: PILLBOX/NLM Supports Pillbox Engine |
| Pillbox Value | pillbox_value | pillbox_value | Text | SOURCE: PILLBOX/NLM |
| author_type | author_type | author_type | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| new | new | new | Text | SOURCE: PILLBOX/NLM |
| laberer_code | laberer_code | laberer_code | Text | SOURCE: SPL(DRUG LABEL)/FDA |
| epc_match | epc_match | epc_match | Text | SOURCE: PILLBOX/NLM |
Upstream Metadata