Botanical Database

Database + Site Integration currently under construction <3 Thank you!

The views below showcases the key species from the EtioMex Botanical Database highlighting plants central to the Buna, Cha/i, and Cacao processions across East Africa, South Asia, and Mesoamerica. By leveraging a relational PostgreSQL backend, we have unified the diverse global nomenclatures into a single, searchable record of the flora that drives these ancient cultural traditions.

plant_languages — A botanical database of the plants used in the buna, cacao, & cha/i processions and their name in the languages of our series.

plant_id	scientific_name	english	spanish	hindi	punjabi	amharic
4	Coffea arabica	coffee	café	kopi	kopi	buna
10	Zingiber officinale	ginger	jengibre	adrak	adrak	zinjibil
6	Aframomum corrorima	black cardamom	cardamomo negro	badi elaichi	badi elaichi	korerima
13	Piper nigrum	black pepper	pimienta negra	kali mirch	kali mirch	tiqur filfil
2	Crocus sativus	saffron	azafrán	kesar	kesar	kurkum
18	Capsicum annuum	chili pepper	chile	mirch	mirch	chili
11	Myristica fragrans	nutmeg	nuez moscada	jaiphal	jaiphal	netmega
9	Foeniculum vulgare	fennel	hinojo	saunf	saunf	insilal
3	Theobroma cacao	cacao	cacao	koko	koko	kakaw
12	Curcuma Longa	turmeric	curcuma	haldi	haldi	ird
15	Ruta graveolens	rue	ruda	sadab	sadab	tena adam
5	Cinnamomum verum	cinnamon	canela	dalchini	dalchini	kerefa
14	Rosa damascena	rose	rosa	gulab	gulab	tsigireda
7	Elettaria cardamomum	green cardamom	cardamomo verde	elaichi	elaichi	kardamom
1	Illicium verum	star anise	anís estrella	chakra phool	chakra phool	anis
8	Syzygium aromaticum	clove	clavo	laung	laung	qirnifud
17	Vanilla planifolia	vanilla	vainilla	vanila	vanila	vanila
16	Camellia sinensis	black tea	té negro	chai	chai	shai

Generated by wpDataTables

traveling_plants — the crossover plants that appear in multiple ceremonies. Cinnamon, black pepper, fennel connecting Ethiopia to Punjab to Mesoamerica. Our thesis in a query.

plant_id	scientific_name	english	spanish	amharic	ceremony_count	appears_in	regions
5	Cinnamomum verum	cinnamon	canela	kerefa	3	Cacao Ceremony · Coffee Ceremony · Masala Chai Ceremony	Ethiopian Highlands · Mesoamerica · Punjab
13	Piper nigrum	black pepper	pimienta negra	tiqur filfil	3	Assam Chai Ceremony · Cacao Ceremony · Masala Chai Ceremony	Assam · Mesoamerica · Punjab
1	Illicium verum	star anise	anís estrella	anis	2	Cacao Ceremony · Masala Chai Ceremony	Mesoamerica · Punjab
9	Foeniculum vulgare	fennel	hinojo	insilal	2	Coffee Ceremony · Masala Chai Ceremony	Ethiopian Highlands · Punjab
10	Zingiber officinale	ginger	jengibre	zinjibil	2	Assam Chai Ceremony · Masala Chai Ceremony	Assam · Punjab
16	Camellia sinensis	black tea	té negro	shai	2	Assam Chai Ceremony · Masala Chai Ceremony	Assam · Punjab

Generated by wpDataTables

ceremony_passport — full plant list per ceremony with roles and origins.

ceremony_name	ceremony_culture	ceremony_people	region_name	continent	scientific_name	english	spanish	amharic	use_category	use_notes	wild_origin	geography_notes
Assam Chai Ceremony	Assamese	Assamese / Northeast Indian peoples	Assam	Asia	Camellia sinensis	black tea	té negro	shai	beverage	Strong Assam CTC tea base; bold and malty, served with milk and sugar	Yunnan Province, China	Assam var. assamica is larger-leaf; Camellia sinensis var. sinensis is Chinese type; base of all chai
Assam Chai Ceremony	Assamese	Assamese / Northeast Indian peoples	Assam	Asia	Piper nigrum	black pepper	pimienta negra	tiqur filfil	spice	Black pepper occasionally added for heat in Assam chai	South Asia (India / Vietnam)	One of the oldest traded spices; foundational in chai masala and Ethiopian spice blends
Assam Chai Ceremony	Assamese	Assamese / Northeast Indian peoples	Assam	Asia	Zingiber officinale	ginger	jengibre	zinjibil	spice	Ginger is the primary spice addition in Assam chai preparation	South Asia (India / Southeast Asia)	Rhizome used fresh or dried; essential to chai and widely used in Ethiopian cooking
Cacao Ceremony	Mesoamerican	Aztec / Maya / Indigenous Mexican	Mesoamerica	Americas	Theobroma cacao	cacao	cacao	kakaw	beverage	Primary base of cacao drink; ground cacao paste mixed with water and spices	Mesoamerica (lowland tropics)	Domesticated by Olmec/Maya; wild range is Amazonian and Mesoamerican lowlands
Cacao Ceremony	Mesoamerican	Aztec / Maya / Indigenous Mexican	Mesoamerica	Americas	Piper nigrum	black pepper	pimienta negra	tiqur filfil	spice	Black pepper adds spice to traditional cacao preparations	South Asia (India / Vietnam)	One of the oldest traded spices; foundational in chai masala and Ethiopian spice blends
Cacao Ceremony	Mesoamerican	Aztec / Maya / Indigenous Mexican	Mesoamerica	Americas	Illicium verum	star anise	anís estrella	anis	spice	Star anise used in some regional cacao ceremony variants for anise flavor	Southern China / Vietnam	Primary commercial production in China and Vietnam
Cacao Ceremony	Mesoamerican	Aztec / Maya / Indigenous Mexican	Mesoamerica	Americas	Cinnamomum verum	cinnamon	canela	kerefa	spice	Ground cinnamon added to cacao for warmth and depth	Sri Lanka	True cinnamon distinct from cassia; inner bark of young shoots
Cacao Ceremony	Mesoamerican	Aztec / Maya / Indigenous Mexican	Mesoamerica	Americas	Capsicum annuum	chili pepper	chile	chili	spice	Adds heat to cacao drink; used in traditional xocolatl preparation	Mesoamerica (Mexico / Central America)	Domesticated in Mexico; used in cacao drinks; spread globally post-Columbian exchange
Cacao Ceremony	Mesoamerican	Aztec / Maya / Indigenous Mexican	Mesoamerica	Americas	Vanilla planifolia	vanilla	vainilla	vanila	spice	Flavors cacao drink; vanilla pods scraped and added to ceremonial preparation	Mesoamerica (Mexico / Central America)	Only orchid cultivated for food; essential flavor in Mesoamerican cacao preparation
Coffee Ceremony	Ethiopian / Eritrean	Oromo / Amhara / Tigrinya peoples	Ethiopian Highlands	Africa	Coffea arabica	coffee	café	buna	beverage	Three rounds brewed: abol (first), tona (second), baraka (third/blessing)	Ethiopian Highlands (Kaffa region)	Wild origin in Kaffa forest; spread via Yemen to global cultivation
Coffee Ceremony	Ethiopian / Eritrean	Oromo / Amhara / Tigrinya peoples	Ethiopian Highlands	Africa	Cinnamomum verum	cinnamon	canela	kerefa	spice	Cinnamon stick occasionally added to coffee during ceremony	Sri Lanka	True cinnamon distinct from cassia; inner bark of young shoots
Coffee Ceremony	Ethiopian / Eritrean	Oromo / Amhara / Tigrinya peoples	Ethiopian Highlands	Africa	Aframomum corrorima	black cardamom	cardamomo negro	korerima	spice	Korerima / black cardamom added to coffee grounds for flavor in some regions	Ethiopian and Eritrean Highlands	Korerima; endemic to East African highlands; distinct from Indian black cardamom
Coffee Ceremony	Ethiopian / Eritrean	Oromo / Amhara / Tigrinya peoples	Ethiopian Highlands	Africa	Foeniculum vulgare	fennel	hinojo	insilal	medicine	Fennel seeds chewed or brewed as digestive after coffee rounds	Mediterranean basin	Used as digestive in Ethiopian coffee ceremony and as mouth freshener post-chai
Coffee Ceremony	Ethiopian / Eritrean	Oromo / Amhara / Tigrinya peoples	Ethiopian Highlands	Africa	Ruta graveolens	rue	ruda	tena adam	ritual_object	Tena Adam / rue placed on tray; aromatic herb symbolizing health and blessing	Mediterranean / Southwest Asia	Tena Adam in Amharic; placed on coffee tray during Ethiopian ceremony as aromatic herb
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Camellia sinensis	black tea	té negro	shai	beverage	Black tea base; simmered with milk and masala spice blend	Yunnan Province, China	Assam var. assamica is larger-leaf; Camellia sinensis var. sinensis is Chinese type; base of all chai
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Syzygium aromaticum	clove	clavo	qirnifud	spice	Whole cloves add depth and a slight numbing warmth to chai	Maluku Islands (Indonesia)	Cloves were among the most traded spices in history; now grown widely in tropics
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Piper nigrum	black pepper	pimienta negra	tiqur filfil	spice	Cracked black pepper is traditional in authentic masala chai	South Asia (India / Vietnam)	One of the oldest traded spices; foundational in chai masala and Ethiopian spice blends
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Elettaria cardamomum	green cardamom	cardamomo verde	kardamom	spice	Green cardamom is primary spice in masala chai; crushed pods added to brew	South India / Sri Lanka	Guatemala now largest producer; key spice in both South Asian and Ethiopian cuisines
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Illicium verum	star anise	anís estrella	anis	spice	Star anise used in some regional Punjabi chai variants	Southern China / Vietnam	Primary commercial production in China and Vietnam
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Zingiber officinale	ginger	jengibre	zinjibil	spice	Fresh or dried ginger adds heat and digestion support to chai	South Asia (India / Southeast Asia)	Rhizome used fresh or dried; essential to chai and widely used in Ethiopian cooking
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Cinnamomum verum	cinnamon	canela	kerefa	spice	Cinnamon stick added to chai for sweetness and warmth	Sri Lanka	True cinnamon distinct from cassia; inner bark of young shoots
Masala Chai Ceremony	Punjabi	Punjabi / North Indian communities	Punjab	Asia	Foeniculum vulgare	fennel	hinojo	insilal	medicine	Fennel seeds used in post-meal chai variants for digestion	Mediterranean basin	Used as digestive in Ethiopian coffee ceremony and as mouth freshener post-chai

Generated by wpDataTables

botanical_family_tree — groups by plant family. Zingiberaceae alone connects all three traditions.

family_name	species_count	species_english	ceremonies_present_in	regions_connected	region_count
Zingiberaceae	3	black cardamom · ginger · green cardamom	Assam Chai Ceremony · Coffee Ceremony · Masala Chai Ceremony	Assam · Ethiopian Highlands · Punjab	3
Piperaceae	1	black pepper	Assam Chai Ceremony · Cacao Ceremony · Masala Chai Ceremony	Assam · Mesoamerica · Punjab	3
Lauraceae	1	cinnamon	Cacao Ceremony · Coffee Ceremony · Masala Chai Ceremony	Ethiopian Highlands · Mesoamerica · Punjab	3
Apiaceae	1	fennel	Coffee Ceremony · Masala Chai Ceremony	Ethiopian Highlands · Punjab	2
Schisandraceae	1	star anise	Cacao Ceremony · Masala Chai Ceremony	Mesoamerica · Punjab	2
Theaceae	1	black tea	Assam Chai Ceremony · Masala Chai Ceremony	Assam · Punjab	2
Rubiaceae	1	coffee	Coffee Ceremony	Ethiopian Highlands	1
Rutaceae	1	rue	Coffee Ceremony	Ethiopian Highlands	1
Malvaceae	1	cacao	Cacao Ceremony	Mesoamerica	1
Solanaceae	1	chili pepper	Cacao Ceremony	Mesoamerica	1
Orchidaceae	1	vanilla	Cacao Ceremony	Mesoamerica	1
Myrtaceae	1	clove	Masala Chai Ceremony	Punjab	1

Generated by wpDataTables

spice_road_map — wild origin vs current global range with history. The journeys!

scientific_name	english	spanish	amharic	wild_origin	current_range	geography_notes	origin_region	origin_continent	now_used_in	history_notes
Aframomum corrorima	black cardamom	cardamomo negro	korerima	Ethiopian and Eritrean Highlands	East Africa (Ethiopia, Eritrea, Uganda)	Korerima; endemic to East African highlands; distinct from Indian black cardamom	Ethiopian Highlands	Africa	Coffee Ceremony	Endemic to Ethiopian and Eritrean highlands. Called korerima or false cardamom. Central to Ethiopian coffee ceremony and spice blend berbere. Distinct from Indian cardamom species; shares family Zingiberaceae.
Coffea arabica	coffee	café	buna	Ethiopian Highlands (Kaffa region)	Ethiopia, Yemen, tropical Americas, Southeast Asia	Wild origin in Kaffa forest; spread via Yemen to global cultivation	Ethiopian Highlands	Africa	Coffee Ceremony	Wild origin in Kaffa forests of Ethiopia. Oromo people chewed coffee berries before brewing. Spread to Yemen ~15th century where first brewing culture developed. Reached Europe via Ottoman trade routes in 17th century.
Capsicum annuum	chili pepper	chile	chili	Mesoamerica (Mexico / Central America)	Americas, global cultivation in tropics and subtropics	Domesticated in Mexico; used in cacao drinks; spread globally post-Columbian exchange	Mesoamerica	Americas	Cacao Ceremony	Domesticated in Mexico ~6000 BCE. Central to Aztec and Maya cuisine and cacao preparations. Spread globally via Columbian exchange. Now one of the most widely used spices in world cuisine; essential to Ethiopian berbere spice blend.
Theobroma cacao	cacao	cacao	kakaw	Mesoamerica (lowland tropics)	Tropical Americas, West Africa, Southeast Asia	Domesticated by Olmec/Maya; wild range is Amazonian and Mesoamerican lowlands	Mesoamerica	Americas	Cacao Ceremony	Domesticated by Olmec civilization ~1500 BCE. Maya and Aztec used cacao as currency and in sacred ceremonies. Word chocolate derives from Nahuatl xocolatl. Introduced to Europe in 16th century via Spanish colonizers.
Vanilla planifolia	vanilla	vainilla	vanila	Mesoamerica (Mexico / Central America)	Tropical Americas, cultivated in Madagascar, Indonesia, Tahiti	Only orchid cultivated for food; essential flavor in Mesoamerican cacao preparation	Mesoamerica	Americas	Cacao Ceremony	Native to Mexico (Totonac people were first cultivators). Used by Aztec to flavor chocolate. Introduced to Europe by Spanish. Only orchid cultivated for food. Mexico lost monopoly in 19th century; Madagascar and Indonesia now largest producers.
Camellia sinensis	black tea	té negro	shai	Yunnan Province, China	East Asia, South Asia (Assam / Darjeeling), Southeast Asia	Assam var. assamica is larger-leaf; Camellia sinensis var. sinensis is Chinese type; base of all chai	Southeast Asia	Asia	Assam Chai Ceremony · Masala Chai Ceremony	Native to Yunnan, China. Two main varieties: sinensis (Chinese) and assamica (Assam). Tea spread via Silk Road and British colonial trade. Assam variety discovered/developed in 19th century by British East India Company to break Chinese tea monopoly.
Cinnamomum verum	cinnamon	canela	kerefa	Sri Lanka	South and Southeast Asia, Caribbean, cultivated globally	True cinnamon distinct from cassia; inner bark of young shoots	South Asia	Asia	Cacao Ceremony · Coffee Ceremony · Masala Chai Ceremony	True cinnamon native to Sri Lanka. Among the most prized spices in ancient Mediterranean trade. Distinguished from cassia (Cinnamomum cassia) by thinner bark and sweeter flavor. Portuguese colonized Sri Lanka partly to control cinnamon trade.
Elettaria cardamomum	green cardamom	cardamomo verde	kardamom	South India / Sri Lanka	South Asia, Southeast Asia, cultivated globally	Guatemala now largest producer; key spice in both South Asian and Ethiopian cuisines	South Asia	Asia	Masala Chai Ceremony	Native to South India and Sri Lanka. Known as queen of spices. Traded along ancient Silk Road. Guatemala is now the largest producer globally. Essential in South Asian chai and in Ethiopian coffee ceremony as a crossover spice.
Illicium verum	star anise	anís estrella	anis	Southern China / Vietnam	East Asia, Southeast Asia, cultivated globally	Primary commercial production in China and Vietnam	Southeast Asia	Asia	Cacao Ceremony · Masala Chai Ceremony	Native to southern China and Vietnam. Used in Chinese five-spice powder. Introduced to Europe in the 17th century. Distinct from European anise but with similar flavor profile due to shared anethole compound.
Piper nigrum	black pepper	pimienta negra	tiqur filfil	South Asia (India / Vietnam)	Pantropical; India, Vietnam, Brazil are top producers	One of the oldest traded spices; foundational in chai masala and Ethiopian spice blends	South Asia	Asia	Assam Chai Ceremony · Cacao Ceremony · Masala Chai Ceremony	Native to South India (Kerala / Malabar coast). Called king of spices. Primary driver of spice trade between Asia and Europe. Used since at least 2000 BCE. Foundational ingredient in masala chai and many Ethiopian spice blends.
Syzygium aromaticum	clove	clavo	qirnifud	Maluku Islands (Indonesia)	Southeast Asia, cultivated in Zanzibar, Madagascar, India	Cloves were among the most traded spices in history; now grown widely in tropics	Southeast Asia	Asia	Masala Chai Ceremony	Native to Maluku Islands (Spice Islands) in Indonesia. Among the most valuable spices in medieval European trade. Portuguese, Dutch, and British colonial powers fought over clove monopoly. Zanzibar became major producer under British influence.
Zingiber officinale	ginger	jengibre	zinjibil	South Asia (India / Southeast Asia)	Pantropical cultivation; South Asia, East Africa, Caribbean	Rhizome used fresh or dried; essential to chai and widely used in Ethiopian cooking	South Asia	Asia	Assam Chai Ceremony · Masala Chai Ceremony	Originated in South Asia. Traded since antiquity; mentioned in ancient Sanskrit, Chinese, and Greek texts. One of the first spices to reach Europe via Silk Road. Now grown throughout tropics. Most important spice in chai after cardamom.
Foeniculum vulgare	fennel	hinojo	insilal	Mediterranean basin	Europe, Middle East, South Asia, naturalized globally	Used as digestive in Ethiopian coffee ceremony and as mouth freshener post-chai	Mediterranean	Europe / Asia	Coffee Ceremony · Masala Chai Ceremony	Native to Mediterranean. Used in ancient Egyptian, Greek, and Roman medicine. Spread to South Asia and Ethiopia via trade routes. In Ethiopian coffee ceremony fennel seeds placed on tray and chewed as digestive between coffee rounds.
Ruta graveolens	rue	ruda	tena adam	Mediterranean / Southwest Asia	Mediterranean, Middle East, naturalized in Americas and Africa	Tena Adam in Amharic; placed on coffee tray during Ethiopian ceremony as aromatic herb	Mediterranean	Europe / Asia	Coffee Ceremony	Native to Mediterranean and Southwest Asia. Known as herb of grace. Called Tena Adam (health of Adam) in Amharic. Central to Ethiopian coffee ceremony where sprigs are placed on the serving tray as aromatic and symbolic herb of blessing and health.

Generated by wpDataTables

zingiberaceae_convergence — dedicated view for the ginger family specifically across all languages and ceremonies.

scientific_name	english	spanish	hindi	amharic	ceremonies	roles	origin
Aframomum corrorima	black cardamom	cardamomo negro	badi elaichi	korerima	Coffee Ceremony	spice	Ethiopian and Eritrean Highlands
Curcuma Longa	turmeric	curcuma	haldi	ird			South Asia (India)
Elettaria cardamomum	green cardamom	cardamomo verde	elaichi	kardamom	Masala Chai Ceremony	spice	South India / Sri Lanka
Zingiber officinale	ginger	jengibre	adrak	zinjibil	Assam Chai Ceremony · Masala Chai Ceremony	spice	South Asia (India / Southeast Asia)

Generated by wpDataTables

colonial_spice_routes — pulls plants whose histories involve colonial trade monopolies.

scientific_name	english	spanish	wild_origin	current_range	history_notes	history_links	now_in_ceremonies
Camellia sinensis	black tea	té negro	Yunnan Province, China	East Asia, South Asia (Assam / Darjeeling), Southeast Asia	Native to Yunnan, China. Two main varieties: sinensis (Chinese) and assamica (Assam). Tea spread via Silk Road and British colonial trade. Assam variety discovered/developed in 19th century by British East India Company to break Chinese tea monopoly.	https://en.wikipedia.org/wiki/Camellia_sinensis	Assam Chai Ceremony · Masala Chai Ceremony
Coffea arabica	coffee	café	Ethiopian Highlands (Kaffa region)	Ethiopia, Yemen, tropical Americas, Southeast Asia	Wild origin in Kaffa forests of Ethiopia. Oromo people chewed coffee berries before brewing. Spread to Yemen ~15th century where first brewing culture developed. Reached Europe via Ottoman trade routes in 17th century.	https://en.wikipedia.org/wiki/Coffea_arabica	Coffee Ceremony
Foeniculum vulgare	fennel	hinojo	Mediterranean basin	Europe, Middle East, South Asia, naturalized globally	Native to Mediterranean. Used in ancient Egyptian, Greek, and Roman medicine. Spread to South Asia and Ethiopia via trade routes. In Ethiopian coffee ceremony fennel seeds placed on tray and chewed as digestive between coffee rounds.	https://en.wikipedia.org/wiki/Fennel	Coffee Ceremony · Masala Chai Ceremony
Piper nigrum	black pepper	pimienta negra	South Asia (India / Vietnam)	Pantropical; India, Vietnam, Brazil are top producers	Native to South India (Kerala / Malabar coast). Called king of spices. Primary driver of spice trade between Asia and Europe. Used since at least 2000 BCE. Foundational ingredient in masala chai and many Ethiopian spice blends.	https://en.wikipedia.org/wiki/Black_pepper	Assam Chai Ceremony · Cacao Ceremony · Masala Chai Ceremony
Syzygium aromaticum	clove	clavo	Maluku Islands (Indonesia)	Southeast Asia, cultivated in Zanzibar, Madagascar, India	Native to Maluku Islands (Spice Islands) in Indonesia. Among the most valuable spices in medieval European trade. Portuguese, Dutch, and British colonial powers fought over clove monopoly. Zanzibar became major producer under British influence.	https://en.wikipedia.org/wiki/Clove	Masala Chai Ceremony
Vanilla planifolia	vanilla	vainilla	Mesoamerica (Mexico / Central America)	Tropical Americas, cultivated in Madagascar, Indonesia, Tahiti	Native to Mexico (Totonac people were first cultivators). Used by Aztec to flavor chocolate. Introduced to Europe by Spanish. Only orchid cultivated for food. Mexico lost monopoly in 19th century; Madagascar and Indonesia now largest producers.	https://en.wikipedia.org/wiki/Vanilla_planifolia	Cacao Ceremony

Generated by wpDataTables

About: EtioMex Botanical Database

This table represents the digital transformation of the EtioMex botanical research project. Our raw field data was migrated from Google Sheets into a standardized PostgreSQL database via Supabase to ensure long-term data integrity and scalability.

By implementing a Third Normal Form (3NF) relational schema, we are able to dynamically generate views like this one using SQL Pivot Logic. This consolidates complex research findings into a single interface, mapping scientific nomenclature against common names across five languages: English, Spanish, Hindi, Punjabi, and Amharic.

The data is integrated via a secure JSON endpoint, protected by Row Level Security (RLS) and API authentication, ensuring that this public-facing table remains a high-performance, “live” reflection of our central botanical database.

Public access to navigate the backend database environment is currently being developed. Thanks for your patience!