Icon for Socrata external plugin
Open repository in Console
Updated 8 months ago
Indexed 22 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 For more information on Pillbox's retirement visit

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"datadiscovery-nlm-nih-gov/pillbox-retired-january-28-2021-crzr-uvwg\".\"pillbox_retired_january_28_2021\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • pillbox_retired_january_28_2021
Upstream Metadata