About this Dataset

Dr. Duke's Phytochemical And Ethnobotanical Databases

Of interest to pharmaceutical, nutritional, and biomedical researchers, as well as individuals and companies involved with alternative therapies and and herbal products, this database is one of the world's leading repositories of ethnobotanical data, evolving out of the extensive compilations by the former Chief of USDA's Economic Botany Laboratory in the Agricultural Research Service in Beltsville, Maryland, in particular his popular Handbook of phytochemical constituents of GRAS herbs and other economic plants (CRC Press, Boca Raton, FL, 1992). In addition to Duke's own publications, the database documents phytochemical information and quantitative data collected over many years through research results presented at meetings and symposia, and findings from the published scientific literature.

The current Phytochemical and Ethnobotanical databases facilitate plant, chemical, bioactivity, and ethnobotany searches. A large number of plants and their chemical profiles are covered, and data are structured to support browsing and searching in several user-focused ways. For example, users can

get a list of chemicals and activities for a specific plant of interest, using either its scientific or common name
download a list of chemicals and their known activities in PDF or spreadsheet form
find plants with chemicals known for a specific biological activity
display a list of chemicals with their LD toxicity data
find plants with potential cancer-preventing activity
display a list of plants for a given ethnobotanical use
find out which plants have the highest levels of a specific chemical

References to the supporting scientific publications are provided for each specific result.

Resources in this dataset:

Resource Title: Duke-Source-CSV.zip.

File Name: Duke-Source-CSV.zip

Resource Description: Dr. Duke's Phytochemistry and Ethnobotany - raw database tables for archival purposes.

Visit https://phytochem.nal.usda.gov/phytochem/search for the interactive web version of the database.

Resource Title: Data Dictionary (preliminary).

File Name: DrDukesDatabaseDataDictionary-prelim.csv

Resource Description: This Data Dictionary describes the columns for each table. [Note that this is in progress and some variables are yet to be defined or are unused in the current implementation. Please send comments/suggestions to nal-adc-curator@ars.usda.gov ]
Organization: Department of Agriculture
Last updated: 2024-03-30T11:28:39.829180
Tags: ars, data-gov, nal-ksd, online-database

Tables

DrDukesDatabaseDataDictionary-prelim

@usgov.usda_gov_dr_dukes_phytochemical_and_ethnobotanical_dat_c20e3a51.drdukesdatabasedatadictionary_prelim

14.36 kB
342 rows
15 columns

CREATE TABLE drdukesdatabasedatadictionary_prelim (
  "table" VARCHAR,
  "recordcount" DOUBLE,
  "column" VARCHAR,
  "attributes" VARCHAR,
  "required" VARCHAR,
  "type" VARCHAR,
  "size" DOUBLE,
  "format" VARCHAR,
  "definition_notes" VARCHAR,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14
);