uses
Data source: Native American Ethnobotany Database · About: NAEB
66 rows where species = 3894
This data as json, CSV (advanced)
id ▼ | species | tribe | source | pageno | use_category | use_subcategory | notes | rawsource |
---|---|---|---|---|---|---|---|---|
39329 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Aleut 5 | s73 94 | 327 | Drug 2 | Dermatological Aid 8 | Poultice of steamed or wilted leaves applied to indolent ulcers. | Smith, G. Warren, 1973, Arctic Pharmacognosia, Arctic 26:324-333, page 327 |
39330 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Aleut 5 | s73 94 | 327 | Drug 2 | Gastrointestinal Aid 14 | Poultice of steamed or wilted leaves applied to stomachaches. | Smith, G. Warren, 1973, Arctic Pharmacognosia, Arctic 26:324-333, page 327 |
39331 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Aleut 5 | s73 94 | 327 | Drug 2 | Throat Aid 123 | Poultice of steamed or wilted leaves applied to sore throats. | Smith, G. Warren, 1973, Arctic Pharmacognosia, Arctic 26:324-333, page 327 |
39332 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Algonquin, Quebec 7 | b80 67 | 242 | Drug 2 | Blood Medicine 11 | Greens eaten to purify the blood. | Black, Meredith Jean, 1980, Algonquin Ethnobotany: An Interpretation of Aboriginal Adaptation in South Western Quebec, Ottawa. National Museums of Canada. Mercury Series Number 65, page 242 |
39333 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Algonquin, Quebec 7 | b80 67 | 242 | Drug 2 | Poultice 138 | Leaves used for plasters or poultices. | Black, Meredith Jean, 1980, Algonquin Ethnobotany: An Interpretation of Aboriginal Adaptation in South Western Quebec, Ottawa. National Museums of Canada. Mercury Series Number 65, page 242 |
39334 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Apache, Chiricahua & Mescalero 11 | co36 95 | 51 | Food 1 | Spice 86 | Flower used to flavor drinks and make them stronger. | Castetter, Edward F. and M. E. Opler, 1936, Ethnobiological Studies in the American Southwest III. The Ethnobiology of the Chiricahua and Mescalero Apache, University of New Mexico Bulletin 4(5):1-63, page 51 |
39335 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Bella Coola 21 | s29 9 | 65 | Drug 2 | Analgesic 6 | Decoction of roots taken for stomach pain. | Smith, Harlan I., 1929, Materia Medica of the Bella Coola and Neighboring Tribes of British Columbia, National Museum of Canada Bulletin 56:47-68, page 65 |
39336 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Bella Coola 21 | s29 9 | 65 | Drug 2 | Gastrointestinal Aid 14 | Decoction of root taken for stomach pain. | Smith, Harlan I., 1929, Materia Medica of the Bella Coola and Neighboring Tribes of British Columbia, National Museum of Canada Bulletin 56:47-68, page 65 |
39337 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Cherokee 32 | hc75 1 | 31 | Drug 2 | Blood Medicine 11 | Infusion of root used for blood. | Hamel, Paul B. and Mary U. Chiltoskey, 1975, Cherokee Plants and Their Uses -- A 400 Year History, Sylva, N.C. Herald Publishing Co., page 31 |
39338 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Cherokee 32 | hc75 1 | 31 | Drug 2 | Sedative 15 | Infusion of herb used to 'calm nerves.' | Hamel, Paul B. and Mary U. Chiltoskey, 1975, Cherokee Plants and Their Uses -- A 400 Year History, Sylva, N.C. Herald Publishing Co., page 31 |
39339 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Cherokee 32 | hc75 1 | 31 | Drug 2 | Toothache Remedy 71 | Chewed for toothache. | Hamel, Paul B. and Mary U. Chiltoskey, 1975, Cherokee Plants and Their Uses -- A 400 Year History, Sylva, N.C. Herald Publishing Co., page 31 |
39340 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Cherokee 32 | perry75 86 | 35 | Drug 2 | Leaves and stems used as medicine. | Perry, Myra Jean, 1975, Food Use of 'Wild' Plants by Cherokee Indians, The University of Tennessee, M.S. Thesis, page 35 | |
39341 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Cherokee 32 | perry75 86 | 35 | Food 1 | Vegetable 31 | Leaves and stems used for potherbs and salads. | Perry, Myra Jean, 1975, Food Use of 'Wild' Plants by Cherokee Indians, The University of Tennessee, M.S. Thesis, page 35 |
39342 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Chippewa 38 | d28 4 | 360 | Drug 2 | Gynecological Aid 22 | Compound infusion of root taken to produce postpartum milk flow. | Densmore, Frances, 1928, Uses of Plants by the Chippewa Indians, SI-BAE Annual Report #44:273-379, page 360 |
39343 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Delaware 62 | t72 97 | 39 | Drug 2 | Laxative 36 | Plant used to make a laxative-tonic. | Tantaquidgeon, Gladys, 1972, Folk Medicine of the Delaware and Related Algonkian Indians, Harrisburg. Pennsylvania Historical Commission Anthropological Papers #3, page 39 |
39344 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Delaware, Oklahoma 63 | t42 22 | 32, 80 | Drug 2 | Laxative 36 | Plant used to make a 'laxative-tonic.' | Tantaquidgeon, Gladys, 1942, A Study of Delaware Indian Medicine Practice and Folk Beliefs, Harrisburg. Pennsylvania Historical Commission, page 32, 80 |
39345 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Delaware, Oklahoma 63 | t42 22 | 32, 80 | Drug 2 | Tonic 69 | Plant used to make a 'laxative-tonic.' | Tantaquidgeon, Gladys, 1942, A Study of Delaware Indian Medicine Practice and Folk Beliefs, Harrisburg. Pennsylvania Historical Commission, page 32, 80 |
39346 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Hesquiat 92 | te82 41 | 62 | Other 3 | Toys & Games 24 | Hollow stems made into whistles. | Turner, Nancy J. and Barbara S. Efrat, 1982, Ethnobotany of the Hesquiat Indians of Vancouver Island, Victoria. British Columbia Provincial Museum, page 62 |
39347 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Hoh 94 | r36 77 | 69 | Drug 2 | Used for medicine. | Reagan, Albert B., 1936, Plants Used by the Hoh and Quileute Indians, Kansas Academy of Science 37:55-70, page 69 | |
39348 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Analgesic 6 | Compound decoction of dried plants taken for pain. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39349 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Analgesic 6 | Compound infusion of roots and bark taken for back pain. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39350 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | r45ii 59 | 61 | Drug 2 | Analgesic 6 | Infusion of flowers, roots and roots from another plant taken for lower back pain. | Rousseau, Jacques, 1945, Le Folklore Botanique De Caughnawaga, Contributions de l'Institut botanique l'Universite de Montreal 55:7-72, page 61 |
39351 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 478 | Drug 2 | Blood Medicine 11 | Decoction of plants taken for anemia. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 478 |
39352 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 478 | Drug 2 | Dermatological Aid 8 | Compound decoction of bark and roots taken for sores caused by bad blood. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 478 |
39353 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 476 | Drug 2 | Dermatological Aid 8 | Compound infusion of plants and roots taken and used as wash for liverspots. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 476 |
39354 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 476 | Drug 2 | Emetic 40 | Infusion of roots taken as an emetic. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 476 |
39355 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Eye Medicine 25 | Compound infusion of roots and bark taken for dark circles and puffy eyes. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39356 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Kidney Aid 3 | Compound infusion of roots and bark taken for kidney trouble and dropsy. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39357 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Laxative 36 | Compound decoction of flowers and leaves taken as a laxative. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39358 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Love Medicine 133 | Decoction of roots used as wash for a love medicine. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39359 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Orthopedic Aid 39 | Compound infusion of roots and bark taken for back pain. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39360 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Pulmonary Aid 48 | Compound decoction of dried plants taken for swollen lungs. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39361 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 476 | Drug 2 | Toothache Remedy 71 | Flower stem chewed for worms in the teeth that cause decay. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 476 |
39362 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Urinary Aid 80 | Decoction of plants used as wash on parts affected by smashed testicles. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39363 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 476 | Drug 2 | Urinary Aid 80 | Poultice of smashed flowers applied to swollen testicles. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 476 |
39364 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | h77 7 | 477 | Drug 2 | Witchcraft Medicine 89 | Decoction of roots used as a wash for an anti-witch medicine. | Herrick, James William, 1977, Iroquois Medical Botany, State University of New York, Albany, PhD Thesis, page 477 |
39365 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | r45i 116 | 99 | Food 1 | Beverage 27 | Used to make wine. | Rousseau, Jacques, 1945, Le Folklore Botanique De L'ile Aux Coudres, Contributions de l'Institut botanique l'Universite de Montreal 55:75-111, page 99 |
39366 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | w16 112 | 118 | Food 1 | Vegetable 31 | Cooked and seasoned with salt, pepper or butter. | Waugh, F. W., 1916, Iroquis Foods and Food Preparation, Ottawa. Canada Department of Mines, page 118 |
39367 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Iroquois 100 | p10 107 | 93 | Food 1 | Vegetable 31 | Young plants boiled and eaten as greens. | Parker, Arthur Caswell, 1910, Iroquois Uses of Maize and Other Food Plants, Albany, NY. University of the State of New York, page 93 |
39368 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Kiowa 111 | vs39 140 | 62 | Drug 2 | Gynecological Aid 22 | Decoction of young leaves taken by women for menstrual cramps. | Vestal, Paul A. and Richard Evans Schultes, 1939, The Economic Botany of the Kiowa Indians, Cambridge MA. Botanical Museum of Harvard University, page 62 |
39369 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Kiowa 111 | vs39 140 | 62 | Food 1 | Vegetable 31 | Young leaves used as greens. | Vestal, Paul A. and Richard Evans Schultes, 1939, The Economic Botany of the Kiowa Indians, Cambridge MA. Botanical Museum of Harvard University, page 62 |
39370 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Malecite 134 | sd52 78 | 6 | Food 1 | Species used for food. | Speck, Frank G. and R.W. Dexter, 1952, Utilization of Animals and Plants by the Malecite Indians of New Brunswick, Journal of the Washington Academy of Sciences 42:1-7, page 6 | |
39371 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Menominee 138 | s23 51 | 65 | Food 1 | Vegetable 31 | Leaves cooked with maple sap vinegar for a dish of greens. | Smith, Huron H., 1923, Ethnobotany of the Menomini Indians, Bulletin of the Public Museum of the City of Milwaukee 4:1-174, page 65 |
39372 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Meskwaki 139 | smith28 21 | 218 | Drug 2 | Pulmonary Aid 48 | Infusion of root taken for chest pain when other remedies fail. | Smith, Huron H., 1928, Ethnobotany of the Meskwaki Indians, Bulletin of the Public Museum of the City of Milwaukee 4:175-326, page 218 |
39373 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Meskwaki 139 | smith28 21 | 257 | Food 1 | Vegetable 31 | Spring leaves used as greens and cooked with pork. | Smith, Huron H., 1928, Ethnobotany of the Meskwaki Indians, Bulletin of the Public Museum of the City of Milwaukee 4:175-326, page 257 |
39374 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Micmac 141 | sd51 182 | 258 | Food 1 | Vegetable 31 | Leaves used as greens in food. | Speck, Frank G. and R.W. Dexter, 1951, Utilization of Animals and Plants by the Micmac Indians of New Brunswick, Journal of the Washington Academy of Sciences 41:250-259, page 258 |
39375 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Mohegan 149 | tan28 110 | 266 | Drug 2 | Cathartic 29 | Infusion of plant taken as a physic. | Tantaquidgeon, Gladys, 1928, Mohegan Medicinal Practices, Weather-Lore and Superstitions, SI-BAE Annual Report #43: 264-270, page 266 |
39376 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Mohegan 149 | t72 97 | 75, 132 | Drug 2 | Cathartic 29 | Strong infusion of dried leaves taken as a physic. | Tantaquidgeon, Gladys, 1972, Folk Medicine of the Delaware and Related Algonkian Indians, Harrisburg. Pennsylvania Historical Commission Anthropological Papers #3, page 75, 132 |
39377 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Mohegan 149 | tan28 110 | 266 | Drug 2 | Tonic 69 | Compound decoction or infusion of plants taken as a spring tonic. | Tantaquidgeon, Gladys, 1928, Mohegan Medicinal Practices, Weather-Lore and Superstitions, SI-BAE Annual Report #43: 264-270, page 266 |
39378 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Mohegan 149 | t72 97 | 75, 132 | Drug 2 | Tonic 69 | Compound infusion of root taken as a tonic. | Tantaquidgeon, Gladys, 1972, Folk Medicine of the Delaware and Related Algonkian Indians, Harrisburg. Pennsylvania Historical Commission Anthropological Papers #3, page 75, 132 |
39379 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Mohegan 149 | cw45 62 | 121 | Drug 2 | Tonic 69 | Dandelion and white daisy used to make wines and taken as tonics. | Carr, Lloyd G. and Carlos Westey, 1945, Surviving Folktales & Herbal Lore Among the Shinnecock Indians, Journal of American Folklore 58:113-123, page 121 |
39380 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Mohegan 149 | t72 97 | 83 | Food 1 | Cooked and used for food. | Tantaquidgeon, Gladys, 1972, Folk Medicine of the Delaware and Related Algonkian Indians, Harrisburg. Pennsylvania Historical Commission Anthropological Papers #3, page 83 | |
39381 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Ojibwa 173 | r28 8 | 238 | Drug 2 | Blood Medicine 11 | Roots used as a blood medicine. | Reagan, Albert B., 1928, Plants Used by the Bois Fort Chippewa (Ojibwa) Indians of Minnesota, Wisconsin Archeologist 7(4):230-248, page 238 |
39382 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Ojibwa 173 | smith32 20 | 366 | Drug 2 | Gastrointestinal Aid 14 | Infusion of root taken for heartburn. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 366 |
39383 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Ojibwa 173 | smith32 20 | 399 | Food 1 | Vegetable 31 | Young leaves gathered in spring and cooked as greens with pork or venison and maple sap vinegar. | Smith, Huron H., 1932, Ethnobotany of the Ojibwe Indians, Bulletin of the Public Museum of Milwaukee 4:327-525, page 399 |
39384 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Okanagan-Colville 175 | tbk80 32 | 85 | Food 1 | Vegetable 31 | Leaves eaten as greens. | Turner, Nancy J., R. Bouchard and Dorothy I.D. Kennedy, 1980, Ethnobotany of the Okanagan-Colville Indians of British Columbia and Washington, Victoria. British Columbia Provincial Museum, page 85 |
39385 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Papago 188 | cu35 27 | 65 | Drug 2 | Analgesic 6 | Infusion of blossoms taken for menstrual cramps. | Castetter, Edward F. and Ruth M. Underhill, 1935, Ethnobiological Studies in the American Southwest II. The Ethnobiology of the Papago Indians, University of New Mexico Bulletin 4(3):1-84, page 65 |
39386 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Papago 188 | cu35 27 | 65 | Drug 2 | Gynecological Aid 22 | Infusion of blossoms taken for menstrual cramps. | Castetter, Edward F. and Ruth M. Underhill, 1935, Ethnobiological Studies in the American Southwest II. The Ethnobiology of the Papago Indians, University of New Mexico Bulletin 4(3):1-84, page 65 |
39387 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Papago 188 | cu35 27 | 14 | Food 1 | Vegetable 31 | Cooked or uncooked leaves eaten as greens. | Castetter, Edward F. and Ruth M. Underhill, 1935, Ethnobiological Studies in the American Southwest II. The Ethnobiology of the Papago Indians, University of New Mexico Bulletin 4(3):1-84, page 14 |
39388 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Potawatomi 206 | smith33 43 | 54 | Drug 2 | Tonic 69 | Root used as a bitter tonic. | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 54 |
39389 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Potawatomi 206 | smith33 43 | 98 | Food 1 | Leaves cooked with maple sap vinegar and often combined with pork or deer meat. | Smith, Huron H., 1933, Ethnobotany of the Forest Potawatomi Indians, Bulletin of the Public Museum of the City of Milwaukee 7:1-230, page 98 | |
39390 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Quileute 209 | r36 77 | 69 | Drug 2 | Used for medicine. | Reagan, Albert B., 1936, Plants Used by the Hoh and Quileute Indians, Kansas Academy of Science 37:55-70, page 69 | |
39391 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Rappahannock 211 | shc42 102 | 34 | Drug 2 | Blood Medicine 11 | Infusion of root taken as a blood tonic. | Speck, Frank G., R.B. Hassrick and E.S. Carpenter, 1942, Rappahannock Herbals, Folk-Lore and Science of Cures, Proceedings of the Delaware County Institute of Science 10:7-55., page 34 |
39392 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Rappahannock 211 | shc42 102 | 34 | Drug 2 | Gastrointestinal Aid 14 | Infusion of root taken for dyspepsia. | Speck, Frank G., R.B. Hassrick and E.S. Carpenter, 1942, Rappahannock Herbals, Folk-Lore and Science of Cures, Proceedings of the Delaware County Institute of Science 10:7-55., page 34 |
39393 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Shinnecock 231 | cw45 62 | 121 | Drug 2 | Tonic 69 | Dandelion and white daisy used to make wines and taken as tonics. | Carr, Lloyd G. and Carlos Westey, 1945, Surviving Folktales & Herbal Lore Among the Shinnecock Indians, Journal of American Folklore 58:113-123, page 121 |
39394 | Taraxacum officinale G.H. Weber ex Wiggers 3894 | Ute 272 | c09 142 | 36 | Food 1 | Leaves formerly used as food. | Chamberlin, Ralph V., 1909, Some Plant Names of the Ute Indians, American Anthropologist 11:27-40, page 36 |
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) );