uses
Data source: Native American Ethnobotany Database · About: NAEB
60 rows where source = 131
This data as json, CSV (advanced)
Suggested facets: use_category
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
517 | Acer macrophyllum Pursh 26 | Skagit, Upper 242 | t89 131 | 42 | Other 3 | Containers 32 | Leaves used to cover food cooking in pits. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
2576 | Alnus rubra Bong. 172 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Sap used for food. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 | |
2577 | Alnus rubra Bong. 172 | Skagit, Upper 242 | t89 131 | 42 | Other 3 | Cooking Tools 33 | Wood used to make canned food dishes, spoons and platters. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
2578 | Alnus rubra Bong. 172 | Skagit, Upper 242 | t89 131 | 42 | Other 3 | Fuel 37 | Wood used as fuel for smoking salmon. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
3084 | Amelanchier alnifolia var. semiintegrifolia (Hook.) C.L. Hitchc. 207 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Berries mashed and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
3085 | Amelanchier alnifolia var. semiintegrifolia (Hook.) C.L. Hitchc. 207 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
4655 | Arctostaphylos uva-ursi (L.) Spreng. 347 | Skagit, Upper 242 | t89 131 | 42 | Other 3 | Smoke Plant 63 | Leaves used as a tobacco substitute. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
7891 | Camassia quamash (Pursh) Greene 700 | Skagit, Upper 242 | t89 131 | 40 | Food 1 | Bulbs steamed in an earth oven and eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 40 | |
10169 | Claytonia sibirica L. 1007 | Skagit, Upper 242 | t89 131 | 42 | Drug 2 | Throat Aid 123 | Infusion of plant used as a general tonic for sore throats. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
11287 | Corylus cornuta var. californica (A. DC.) Sharp 1112 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Nuts eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 | |
11288 | Corylus cornuta var. californica (A. DC.) Sharp 1112 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Winter Use Food 59 | Nuts stored for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
13491 | Equisetum sp. 1428 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Tender shoots eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 | |
14880 | Fragaria sp. 1635 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Fruit pulped and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
14881 | Fragaria sp. 1635 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
15128 | Frangula purshiana (DC.) Cooper 1648 | Skagit, Upper 242 | t89 131 | 42 | Drug 2 | Laxative 36 | Decoction of bark used as a laxative. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
15689 | Gaultheria shallon Pursh 1703 | Skagit, Upper 242 | t89 131 | 38 | Drug 2 | Other 18 | Infusion of leaves taken as a convalescent tea. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
15690 | Gaultheria shallon Pursh 1703 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Fruit pulped and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
15691 | Gaultheria shallon Pursh 1703 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
20279 | Lilium columbianum hort. ex Baker 2184 | Skagit, Upper 242 | t89 131 | 40 | Food 1 | Bulbs baked or steamed in an earth oven and eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 40 | |
21859 | Mahonia aquifolium (Pursh) Nutt. 2370 | Skagit, Upper 242 | t89 131 | 37 | Food 1 | Dried Food 4 | Berries pulped, dried and stored in cakes for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 37 |
21860 | Mahonia aquifolium (Pursh) Nutt. 2370 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit eaten raw or mashed. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
21924 | Mahonia nervosa (Pursh) Nutt. 2374 | Skagit, Upper 242 | t89 131 | 37 | Food 1 | Dried Food 4 | Berries pulped, dried and stored in cakes for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 37 |
21925 | Mahonia nervosa (Pursh) Nutt. 2374 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit eaten raw or mashed. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
22126 | Maianthemum racemosum ssp. racemosum 2381 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries used for food. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
22285 | Malus fusca (Raf.) Schneid. 2391 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit ripened in storage and then eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
24229 | Oemleria cerasiformis (Torr. & Gray ex Hook. & Arn.) Landon 2610 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
26026 | Perideridia gairdneri (Hook. & Arn.) Mathias 2831 | Skagit, Upper 242 | t89 131 | 40 | Food 1 | Roots steamed in an earth oven and eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 40 | |
29046 | Polypodium virginianum L. 3080 | Skagit, Upper 242 | t89 131 | 42 | Drug 2 | Dermatological Aid 8 | Plant used to make a demulcent. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
29047 | Polypodium virginianum L. 3080 | Skagit, Upper 242 | t89 131 | 42 | Drug 2 | Expectorant 139 | Plant used to make an expectorant. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
29048 | Polypodium virginianum L. 3080 | Skagit, Upper 242 | t89 131 | 42 | Drug 2 | Laxative 36 | Plant used to make a laxative. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
31499 | Pteridium aquilinum (L.) Kuhn 3214 | Skagit, Upper 242 | t89 131 | 40 | Food 1 | Roots roasted in ashes, peeled and eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 40 | |
33496 | Ribes divaricatum Dougl. 3368 | Skagit, Upper 242 | t89 131 | 38 | Drug 2 | Throat Aid 123 | Roots boiled for sore throats. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
33497 | Ribes divaricatum Dougl. 3368 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh and never stored. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
33575 | Ribes lacustre (Pers.) Poir. 3375 | Skagit, Upper 242 | t89 131 | 38 | Drug 2 | Gynecological Aid 22 | Decoction of bark taken by women during childbirth. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
33576 | Ribes lacustre (Pers.) Poir. 3375 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
33601 | Ribes laxiflorum Pursh 3376 | Skagit, Upper 242 | t89 131 | 38 | Drug 2 | Cold Remedy 21 | Bark boiled and used as a cold medicine. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
33602 | Ribes laxiflorum Pursh 3376 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
33714 | Ribes sanguineum Pursh 3394 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Fruit eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
34080 | Rosa nutkana K. Presl 3427 | Skagit, Upper 242 | t89 131 | 42 | Drug 2 | Throat Aid 123 | Decoction of roots and sugar used for sore throats. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
34081 | Rosa nutkana K. Presl 3427 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Beverage 27 | Leaves used to make tea. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
34082 | Rosa nutkana K. Presl 3427 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Spice 86 | Hips mixed with dried salmon eggs to enhance the flavor. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
34644 | Rubus leucodermis Dougl. ex Torr. & Gray 3457 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Berries pulped and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
34645 | Rubus leucodermis Dougl. ex Torr. & Gray 3457 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
34861 | Rubus parviflorus Nutt. 3463 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
34862 | Rubus parviflorus Nutt. 3463 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Tender shoots peeled and eaten in spring and early summer. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 | |
35031 | Rubus spectabilis Pursh 3470 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
35032 | Rubus spectabilis Pursh 3470 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Green sprouts peeled and eaten or cooked in an earth oven. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 | |
35101 | Rubus ursinus ssp. macropetalus (Dougl. ex Hook.) Taylor & MacBryde 3473 | Skagit, Upper 242 | t89 131 | 38 | Drug 2 | Gastrointestinal Aid 14 | Infusion of leaves taken for stomach trouble. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
35102 | Rubus ursinus ssp. macropetalus (Dougl. ex Hook.) Taylor & MacBryde 3473 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Berries pulped and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
35103 | Rubus ursinus ssp. macropetalus (Dougl. ex Hook.) Taylor & MacBryde 3473 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
36591 | Sambucus nigra ssp. caerulea (Raf.) R. Bolli 3565 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Berries steamed, pulped and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
36592 | Sambucus nigra ssp. caerulea (Raf.) R. Bolli 3565 | Skagit, Upper 242 | t89 131 | 37 | Food 1 | Fruit 52 | Fruit eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 37 |
36911 | Sambucus racemosa var. racemosa 3569 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Berries steamed, pulped and dried for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
36912 | Sambucus racemosa var. racemosa 3569 | Skagit, Upper 242 | t89 131 | 37 | Food 1 | Fruit 52 | Fruit eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 37 |
41847 | Urtica dioica ssp. gracilis (Ait.) Seland. 4059 | Skagit, Upper 242 | t89 131 | 42 | Fiber 4 | Cordage 99 | Mature shoot fibers used to make cordage. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 |
41848 | Urtica dioica ssp. gracilis (Ait.) Seland. 4059 | Skagit, Upper 242 | t89 131 | 42 | Food 1 | Tender shoots cooked and eaten. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 42 | |
42077 | Vaccinium membranaceum Dougl. ex Torr. 4077 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Dried Food 4 | Berries pulped, dried and stored for winter use. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
42078 | Vaccinium membranaceum Dougl. ex Torr. 4077 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
42349 | Vaccinium parvifolium Sm. 4085 | Skagit, Upper 242 | t89 131 | 38 | Drug 2 | Cold Remedy 21 | Decoction of bark taken for colds. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, page 38 |
42350 | Vaccinium parvifolium Sm. 4085 | Skagit, Upper 242 | t89 131 | 38 | Food 1 | Fruit 52 | Berries eaten fresh. | Theodoratus, Robert J., 1989, Loss, Transfer, and Reintroduction in the Use of Wild Plant Foods in the Upper Skagit Valley, Northwest Anthropological Research Notes 23(1):35-52, 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) );