About this Dataset

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://ftp.nlm.nih.gov/projects/pillbox/pillbox_production_images_full_202008.zip. 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.
Organization: U.S. Department of Health & Human Services
Last updated: 2021-03-16T19:45:30.903250
Tags: drug-label, medication

Tables

Table 1

@usgov.hhs_gov_pillbox_retired_2f7f9.table_1

18.48 MB
83,925 rows
55 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "enabled" BOOLEAN  -- Enabled?,
  "created_at" VARCHAR,
  "updated_at" VARCHAR,
  "spp" VARCHAR,
  "setid" VARCHAR,
  "splsize" DOUBLE,
  "pillbox_size" DOUBLE,
  "splshape" VARCHAR,
  "splshape_text" VARCHAR,
  "pillbox_shape_text" VARCHAR,
  "splscore" DOUBLE,
  "pillbox_score" DOUBLE,
  "splimprint" VARCHAR,
  "pillbox_imprint" VARCHAR,
  "splcolor" VARCHAR,
  "splcolor_text" VARCHAR,
  "pillbox_color_text" VARCHAR,
  "spl_strength" VARCHAR,
  "spl_ingredients" VARCHAR,
  "spl_inactive_ing" VARCHAR,
  "source" VARCHAR,
  "rxtty" VARCHAR,
  "rxstring" VARCHAR,
  "rxcui" DOUBLE,
  "rxnorm_update_time" VARCHAR,
  "product_code" VARCHAR,
  "part_num" BIGINT,
  "part_medicine_name" VARCHAR,
  "ndc9" VARCHAR,
  "ndc_labeler_code" BIGINT,
  "ndc_product_code" VARCHAR,
  "medicine_name" VARCHAR,
  "marketing_act_code" VARCHAR,
  "effective_time" BIGINT,
  "file_name" VARCHAR,
  "equal_product_code" VARCHAR,
  "dosage_form" VARCHAR,
  "document_type" VARCHAR,
  "dea_schedule_code" VARCHAR,
  "dea_schedule_name" VARCHAR,
  "author_type" VARCHAR,
  "author" VARCHAR,
  "approval_code" VARCHAR,
  "image_source" VARCHAR,
  "splimage" VARCHAR,
  "has_image" BOOLEAN,
  "epc_match" DOUBLE,
  "version_number" BIGINT,
  "laberer_code" VARCHAR,
  "application_number" VARCHAR,
  "updated" BOOLEAN,
  "stale" BOOLEAN,
  "new" BOOLEAN,
  "pillbox_value" BOOLEAN
);