uses
Data source: Native American Ethnobotany Database · About: NAEB
1 row where rawsource = "Rogers, Dilwyn J, 1980, Lakota Names and Traditional Uses of Native Plants by Sicangu (Brule) People in the Rosebud Area, South Dakota, St. Francis, SD. Rosebud Educational Scoiety, page 38" and use_subcategory = 19
This data as json, CSV (advanced)
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
20138 | Liatris punctata Hook. 2166 | Lakota 125 | r80 108 | 38 | Food 1 | Dietary Aid 19 | Roots pulverized and eaten to improve the appetite. | Rogers, Dilwyn J, 1980, Lakota Names and Traditional Uses of Native Plants by Sicangu (Brule) People in the Rosebud Area, South Dakota, St. Francis, SD. Rosebud Educational Scoiety, 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) );