This database follows FAIR principles — Findable, Accessible, Interoperable, Reusable. All data below is free to download and reuse via file export or the public API.
Base URL: http://223.31.159.20/api
/species/<species_name>
Returns all composition records for one species as JSON.
curl "http://223.31.159.20/api/species/Abies%20alba"
/family/<family_name>
Returns all composition records for one plant family as JSON.
/compound/<compound_name>
Returns all records containing a given compound, across species.
/plantpart/<part_name>
Returns all records for a given plant part (e.g. leaf, root, flower).
/download/csv/<species_name>
Downloads a CSV file of one species' composition data.
/download/excel/<species_name>
Downloads an Excel (.xlsx) file of one species' composition data.
/search?q=<term>
Search species/genus by partial name match, returns JSON.
/download/csv?q=<term>
Bulk CSV export for all species/genera matching the search term.
/download/sql
Full database dump (all 13 tables, structure + data) as a .sql file. Limited to 3 requests/hour per IP.
/download/sql/<table_name>
Single-table SQL dump. Valid tables:
bibliography, chemicalgroup, compoundactivity, compounddata, expcondition, expmethodology, infocdata, infopdata, location, plantdata, plantfamily, planthabit, plantpart
Rate limits apply per IP address (roughly 15–30 requests/minute on data endpoints, lower on full SQL dumps).
Documentation generated 2026-07-28.
The Academic License is free and available for researchers who meet the following criteria:
Thank you for your patience and continued support of the EssOilDB database. When using EssOilDB datasets for academic research, please cite EssOilDB in any resulting publications — see the Cite Us page.