uses
Data source: Native American Ethnobotany Database · About: NAEB
64 rows where species = 4056
This data as json, CSV (advanced)
Suggested facets: tribe, use_category
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
41613 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Cahuilla 24 | bs72 31 | 143 | Drug 2 | Analgesic 6 | Leaves used for headaches. | Bean, Lowell John and Katherine Siva Saubel, 1972, Temalpakh (From the Earth); Cahuilla Indian Knowledge and Usage of Plants, Banning, CA. Malki Museum Press, page 143 |
41614 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Concow 49 | c02 89 | 349 | Food 1 | Beverage 27 | Root bark used to make a drink. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41615 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Costanoan 50 | b84 16 | 249 | Food 1 | Bread & Cake 2 | Kernels roasted or ground into flour for cakes. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 249 |
41616 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Costanoan 50 | b84 16 | 249 | Food 1 | Fruit 52 | Fruits eaten raw or boiled. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 249 |
41617 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Costanoan 50 | b84 16 | 249 | Other 3 | Hunting & Fishing Item 28 | Burning leaf smoke used to drive ground squirrels from burrows. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 249 |
41618 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Costanoan 50 | b84 16 | 249 | Other 3 | Incense & Fragrance 53 | Leaves hung in bunches to freshen air. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 249 |
41619 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Costanoan 50 | b84 16 | 7 | Other 3 | Insecticide 76 | Burning leaf smoke used to rid one of fleas. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 7 |
41620 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Costanoan 50 | b84 16 | 249 | Other 3 | Insecticide 76 | Burning leaf smoke used to rid one of fleas. | Bocek, Barbara R., 1984, Ethnobotany of Costanoan Indians, California, Based on Collections by John P. Harrington, Economic Botany 38(2):240-255, page 249 |
41621 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Drug 2 | Analgesic 6 | Infusion of plant taken by women for the pains of afterbirth. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41622 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Drug 2 | Cold Remedy 21 | Plant used as steambath or burning boughs used to fumigate house for colds. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41623 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | b81 70 | 59 | Drug 2 | Dermatological Aid 8 | Poultice of ground seeds applied to sores. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 |
41624 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Drug 2 | Disinfectant 129 | Boughs used in fire to fumigate the house for colds and other sicknesses. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41625 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Drug 2 | Gynecological Aid 22 | Infusion of plant taken by women for the pains of afterbirth. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41626 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Drug 2 | Panacea 20 | Plant used as steambath or burning bough to fumigate house for any sickness. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41627 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Food 1 | Nuts hulled, stored, parched in ashes, cracked open and eaten. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 | |
41628 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | b81 70 | 59 | Food 1 | Seeds shelled, roasted and eaten. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 | |
41629 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Food 1 | Winter Use Food 59 | Nuts hulled and stored in big baskets for winter use. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41630 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | b81 70 | 59 | Other 3 | Ceremonial Items 30 | Foliage placed on fire during the Brush Dance to drive evil spirits away. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 |
41631 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Karok 105 | sg52 71 | 383 | Other 3 | Toys & Games 24 | Leaves thrown into the fire by children to hear them crack like firecrackers. | Schenck, Sara M. and E. W. Gifford, 1952, Karok Ethnobotany, Anthropological Records 13(6):377-392, page 383 |
41632 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Analgesic 6 | Decoction taken, used as wash or poultice of leaves applied for headaches. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41633 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Antirheumatic (External) 35 | Infusion of leaves used as a bath for rheumatism. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41634 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Dermatological Aid 8 | Decoction of leaves used as wash for vermin on the head. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41635 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Gastrointestinal Aid 14 | Decoction of plant taken for stomachaches and headaches. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41636 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Gastrointestinal Aid 14 | Poultice of leaves applied as counterirritant for chronic stomach complaints. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41637 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Panacea 20 | Burning leaf vapor used for many diseases. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41638 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Drug 2 | Stimulant 90 | Nuts eaten as a stimulant. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41639 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Food 1 | Bread & Cake 2 | Nuts roasted, shelled, pounded into a small mass and molded into 'bread.' | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41640 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Food 1 | Sauce & Relish 7 | Nuts eaten as a relish. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41641 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Food 1 | Sauce & Relish 7 | Nuts used as a condiment. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41642 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Food 1 | Nuts roasted and eaten. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 | |
41643 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Mendocino Indian 137 | c02 89 | 349 | Other 3 | Insecticide 76 | Leaves used for fleas. | Chestnut, V. K., 1902, Plants Used by the Indians of Mendocino County, California, Contributions from the U.S. National Herbarium 7:295-408., page 349 |
41644 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Miwok 144 | bg33 100 | 174 | Drug 2 | Analgesic 6 | Poultice of leaves and twigs bound to forehead for headaches. | Barrett, S. A. and E. W. Gifford, 1933, Miwok Material Culture, Bulletin of the Public Museum of the City of Milwaukee 2(4):11, page 174 |
41645 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo 200 | g67 80 | 13 | Drug 2 | Analgesic 6 | Poultice of heated leaves applied for rheumatic and neuralgic pains. | Gifford, E. W., 1967, Ethnographic Notes on the Southwestern Pomo, Anthropological Records 25:10-15, page 13 |
41646 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo 200 | g67 80 | 13 | Drug 2 | Antirheumatic (External) 35 | Poultice of heated leaves applied for rheumatic pains. | Gifford, E. W., 1967, Ethnographic Notes on the Southwestern Pomo, Anthropological Records 25:10-15, page 13 |
41647 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Analgesic 6 | Indian doctor would sing and hit you with little branches for pain or headache. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41648 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Analgesic 6 | Poultice of leaves used for rheumatic and neuralgic pains. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41649 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Antirheumatic (External) 35 | Poultice of leaves used for rheumatic pains. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41650 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Cold Remedy 21 | Decoction of leaves taken for colds. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41651 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Cold Remedy 21 | Indian doctor would sing and hit you with little branches for a cold. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41652 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Dermatological Aid 8 | Decoction of leaves used to wash sores. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41653 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Dermatological Aid 8 | Peppernut charcoal rubbed into a man's moustache to groom it. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41654 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Gynecological Aid 22 | Decoction of leaves taken for menstrual cramps and clotting. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41655 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Respiratory Aid 62 | Decoction of leaves taken to clear up 'slime' in the chest. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41656 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Drug 2 | Throat Aid 123 | Decoction of leaves taken for sore throats. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41657 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Food 1 | Dried Food 4 | Fruit sun dried. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41658 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Food 1 | Fruit 52 | Ffleshy end of the husk eaten raw and the kernel roasted and eaten whole. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41659 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Food 1 | Roasted kernels or kernel meal cakes eaten with greens, buckeye meal, acorn meal, mush or seaweed. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 | |
41660 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Food 1 | Winter Use Food 59 | Pounded kernel meal used to make sun dried, flat cakes and stored for winter use. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41661 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Other 3 | Hunting & Fishing Item 28 | Leaves rubbed on a man's body before he went hunting to take the body smell away. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41662 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Other 3 | Protection 58 | Small, leafy branches hung in homes for protection against any harm that might come into the homes. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41663 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Pomo, Kashaya 202 | gl80 40 | 90 | Other 3 | Sacred Items 185 | Plant very sacred to the Kashaya Pomo because of it's ceremonial uses. | Goodrich, Jennie and Claudia Lawson, 1980, Kashaya Pomo Plants, Los Angeles. American Indian Studies Center, University of California, Los Angeles, page 90 |
41664 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Tolowa 266 | b81 70 | 59 | Food 1 | Fruit 52 | Fruit shelled, roasted and eaten. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 |
41665 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | c57ii 69 | 47 | Drug 2 | Analgesic 6 | Crushed leaves inhaled for headaches. | Curtin, L. S. M., 1957, Some Plants Used by the Yuki Indians ... II. Food Plants, The Masterkey 31:85-94, page 47 |
41666 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | m90 111 | 43 | Drug 2 | Analgesic 6 | Poultice of crushed leaves applied as compress for headaches. | Murphey, Edith Van Allen, 1990, Indian Uses of Native Plants, Glenwood, Ill. Meyerbooks. Originally published in 1959, page 43 |
41667 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | m90 111 | 43 | Drug 2 | Antirheumatic (External) 35 | Decoction of leaves used as wash for rheumatism. | Murphey, Edith Van Allen, 1990, Indian Uses of Native Plants, Glenwood, Ill. Meyerbooks. Originally published in 1959, page 43 |
41668 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | c57ii 69 | 47 | Drug 2 | Respiratory Aid 62 | Crushed leaves inhaled to open the nasal passages. | Curtin, L. S. M., 1957, Some Plants Used by the Yuki Indians ... II. Food Plants, The Masterkey 31:85-94, page 47 |
41669 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | c57ii 69 | 87 | Food 1 | Nuts roasted in hot ashes, cracked and eaten. | Curtin, L. S. M., 1957, Some Plants Used by the Yuki Indians ... II. Food Plants, The Masterkey 31:85-94, page 87 | |
41670 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | c57i 46 | 47 | Food 1 | Species used for food. | Curtin, L. S. M., 1957, Some Plants Used by the Yuki Indians ... I. Historical Review and Medicinal Plants, The Masterkey 31:40-48, page 47 | |
41671 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yuki 287 | c57ii 69 | 91 | Other 3 | Insecticide 76 | Leafy branches used for fleas. | Curtin, L. S. M., 1957, Some Plants Used by the Yuki Indians ... II. Food Plants, The Masterkey 31:85-94, page 91 |
41672 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yurok 289 | b81 70 | 59 | Drug 2 | Plant used for medicinal purposes. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 | |
41673 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yurok 289 | b81 70 | 59 | Food 1 | Fruit 52 | Fruit used for food. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 |
41674 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yurok 289 | b81 70 | 59 | Food 1 | Seeds baked in the sand under a fire and used for food. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 | |
41675 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yurok 289 | b81 70 | 59 | Other 3 | Good Luck Charm 147 | Leaves burned, to take bad luck away, in the house or the smoke waved over people as they leave. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 |
41676 | Umbellularia californica (Hook. & Arn.) Nutt. 4056 | Yurok 289 | b81 70 | 59 | Other 3 | Insecticide 76 | Plant put under the bed to rid it of fleas. | Baker, Marc A., 1981, The Ethnobotany of the Yurok, Tolowa and Karok Indians of Northwest California, Humboldt State University, M.A. Thesis, page 59 |
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) );