uses
Data source: Native American Ethnobotany Database · About: NAEB
4 rows where species = 3727
This data as json, CSV (advanced)
Suggested facets: source, use_category, rawsource
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
38330 | Solanum sp. 3727 | Comanche 48 | cj40 147 | 524 | Drug 2 | Tonic 69 | Decoction of root taken as a general tonic. | Carlson, Gustav G. and Volney H. Jones, 1940, Some Notes on Uses of Plants by the Comanche Indians, Papers of the Michigan Academy of Science, Arts and Letters 25:517-542, page 524 |
38331 | Solanum sp. 3727 | Comanche 48 | cj40 147 | 524 | Drug 2 | Tuberculosis Remedy 49 | Decoction of root taken for tuberculosis. | Carlson, Gustav G. and Volney H. Jones, 1940, Some Notes on Uses of Plants by the Comanche Indians, Papers of the Michigan Academy of Science, Arts and Letters 25:517-542, page 524 |
38332 | Solanum sp. 3727 | Costanoan 50 | b84 16 | 253 | Dye 5 | Blue 55 | Fruits used to prepare a permanent blue dye for tattooing. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 253 |
38333 | Solanum sp. 3727 | Isleta 101 | j31 76 | 43 | Drug 2 | Heart Medicine 104 | Infusion of leaves taken for heart trouble. | Jones, Volney H., 1931, The Ethnobotany of the Isleta Indians, University of New Mexico, M.A. Thesis, page 43 |
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) );