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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datadiscovery-nlm-nih-gov/pillbox-retired-january-28-2021-crzr-uvwg\".\"pillbox_retired_january_28_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.