uses
Data source: Native American Ethnobotany Database · About: NAEB
4 rows where tribe = 20
This data as json, CSV (advanced)
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
16029 | Glycyrrhiza lepidota Pursh 1758 | Bannock 20 | m90 111 | 38 | Drug 2 | Throat Aid 123 | Root boiled into a tonic and taken for sore throat. | Murphey, Edith Van Allen, 1990, Indian Uses of Native Plants, Glenwood, Ill. Meyerbooks. Originally published in 1959, page 38 |
16030 | Glycyrrhiza lepidota Pursh 1758 | Bannock 20 | m90 111 | 38 | Drug 2 | Throat Aid 123 | Root chewed for strong throat for singing. | Murphey, Edith Van Allen, 1990, Indian Uses of Native Plants, Glenwood, Ill. Meyerbooks. Originally published in 1959, page 38 |
23320 | Monarda sp. 2509 | Bannock 20 | m90 111 | 38 | Drug 2 | Cold Remedy 21 | Infusion of seed heads taken for colds. | Murphey, Edith Van Allen, 1990, Indian Uses of Native Plants, Glenwood, Ill. Meyerbooks. Originally published in 1959, page 38 |
23321 | Monarda sp. 2509 | Bannock 20 | m90 111 | 38 | Food 1 | Appetizer 218 | Infusion of seed heads used as an appetizer. | Murphey, Edith Van Allen, 1990, Indian Uses of Native Plants, Glenwood, Ill. Meyerbooks. Originally published in 1959, page 38 |
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) );