uses
Data source: Native American Ethnobotany Database · About: NAEB
3 rows where tribe = 139 and use_subcategory = 97
This data as json, CSV (advanced)
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
12829 | Echinacea angustifolia var. angustifolia 1349 | Meskwaki 139 | smith28 21 | 212 | Drug 2 | Anticonvulsive 97 | Compound containing root used for stomach cramps and fits. | Smith, Huron H., 1928, Ethnobotany of the Meskwaki Indians, Bulletin of the Public Museum of the City of Milwaukee 4:175-326, page 212 |
22095 | Maianthemum racemosum ssp. racemosum 2381 | Meskwaki 139 | smith28 21 | 230231 | Drug 2 | Anticonvulsive 97 | Smudge of root used in cases of a fit, to bring back to normal. | Smith, Huron H., 1928, Ethnobotany of the Meskwaki Indians, Bulletin of the Public Museum of the City of Milwaukee 4:175-326, page 230231 |
43001 | Veronicastrum virginicum (L.) Farw. 4127 | Meskwaki 139 | smith28 21 | 247 | Drug 2 | Anticonvulsive 97 | Root used for fits and constipation. | Smith, Huron H., 1928, Ethnobotany of the Meskwaki Indians, Bulletin of the Public Museum of the City of Milwaukee 4:175-326, page 247 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE uses ( id INTEGER PRIMARY KEY NOT NULL, species INTEGER NOT NULL, tribe INTEGER NOT NULL, source INTEGER NOT NULL, pageno TEXT NOT NULL, use_category INTEGER, use_subcategory INTEGER, notes TEXT, rawsource TEXT NOT NULL, FOREIGN KEY(use_category) REFERENCES use_categories(id), FOREIGN KEY(use_subcategory) REFERENCES use_subcategories(id), FOREIGN KEY(tribe) REFERENCES tribes(id), FOREIGN KEY(species) REFERENCES species(id), FOREIGN KEY(source) REFERENCES sources(id) );