species
Data source: Native American Ethnobotany Database · About: NAEB
4,260 rows sorted by family_apg descending
This data as json, CSV (advanced)
id | name | common_names | usda_code | family | family_apg ▲ |
---|---|---|---|---|---|
3905 | Taxus sp. | Yew | Taxaceae | Taxaceae | |
3966 | Torreya californica Torr. | California Nutmeg | TOCA | Taxaceae | Taxaceae |
3889 | Tamarix aphylla (L.) Karst. | Athel Tamarisk | TAAP | Tamaricaceae | Tamaricaceae |
3890 | Tamarix gallica L. | French Tamarisk | TAGA | Tamaricaceae | Tamaricaceae |
3881 | Symplocos tinctoria (L.) L'H‚r. | Common Sweetleaf | SYTI | Symplocaceae | Symplocaceae |
1797 | Halesia carolina L. | Carolina Silverbell | HACA3 | Styracaceae | Styracaceae |
3819 | Staphylea trifolia L. | American Bladdernut | STTR | Staphyleaceae | Staphyleaceae |
724 | Capsicum annuum L. | Cayenne Pepper | CAANA4 | Solanaceae | Solanaceae |
725 | Capsicum annuum var. annuum | Cayenne Pepper | CAANA4 | Solanaceae | Solanaceae |
726 | Capsicum annuum var. glabriusculum (Dunal) Heiser & Pickersgill | Cayenne Pepper | CAANG | Solanaceae | Solanaceae |
864 | Chamaesaracha coronopus (Dunal) Gray | Greenleaf Five Eyes | CHCO2 | Solanaceae | Solanaceae |
1240 | Datura discolor Bernh. | Desert Thornapple | DADI2 | Solanaceae | Solanaceae |
1241 | Datura quercifolia Kunth | Chinese Thornapple | DAQU | Solanaceae | Solanaceae |
1242 | Datura sp. | Jimson Weed | Solanaceae | Solanaceae | |
1243 | Datura stramonium L. | Jimsonweed | DAST | Solanaceae | Solanaceae |
1244 | Datura wrightii Regel | Sacred Thornapple | DAWR2 | Solanaceae | Solanaceae |
2313 | Lycium andersonii Gray | Anderson's Wolfberry | LYANA4 | Solanaceae | Solanaceae |
2314 | Lycium exsertum Gray | Arizona Desertthorn | LYEX | Solanaceae | Solanaceae |
2315 | Lycium fremontii Gray | Fremont's Desertthorn | LYFR | Solanaceae | Solanaceae |
2316 | Lycium pallidum Miers | Pale Wolfberry | LYPAP | Solanaceae | Solanaceae |
2317 | Lycium sp. | Wolfberry | Solanaceae | Solanaceae | |
2318 | Lycium torreyi Gray | Squawthorn | LYTO | Solanaceae | Solanaceae |
2577 | Nicotiana attenuata Torr. ex S. Wats. | Coyote Tobacco | NIAT | Solanaceae | Solanaceae |
2578 | Nicotiana clevelandii Gray | Cleveland's Tobacco | NICL | Solanaceae | Solanaceae |
2579 | Nicotiana glauca Graham | Tree Tobacco | NIGL | Solanaceae | Solanaceae |
2580 | Nicotiana obtusifolia var. obtusifolia | Desert Tobacco | NIOBO | Solanaceae | Solanaceae |
2581 | Nicotiana obtusifolia var. palmeri (Gray) Kartesz | Palmer's Tobacco | NIOBP | Solanaceae | Solanaceae |
2582 | Nicotiana plumbaginifolia Viviani | Tex-mex Tobacco | NIPL2 | Solanaceae | Solanaceae |
2583 | Nicotiana quadrivalvis Pursh | Indian Tobacco | NIQUQ | Solanaceae | Solanaceae |
2584 | Nicotiana quadrivalvis var. bigelovii (Torr.) DeWolf | Bigelow's Tobacco | NIQUB | Solanaceae | Solanaceae |
2585 | Nicotiana rustica L. | Aztec Tobacco | NIRU | Solanaceae | Solanaceae |
2586 | Nicotiana sp. | Tobacco | Solanaceae | Solanaceae | |
2587 | Nicotiana tabacum L. | Cultivated Tobacco | NITA | Solanaceae | Solanaceae |
2912 | Physalis acutifolia (Miers) Sandw. | Sharpleaf Groundcherry | PHAC6 | Solanaceae | Solanaceae |
2913 | Physalis hederifolia var. fendleri (Gray) Cronq. | Fendler's Groundcherry | PHHEF | Solanaceae | Solanaceae |
2914 | Physalis heterophylla Nees | Clammy Groundcherry | PHHEH3 | Solanaceae | Solanaceae |
2915 | Physalis lanceolata Michx. | Lanceleaf Groundcherry | PHHI8 | Solanaceae | Solanaceae |
2916 | Physalis longifolia Nutt. | Longleaf Groundcherry | PHLOL3 | Solanaceae | Solanaceae |
2917 | Physalis philadelphica Lam. | Mexican Groundcherry | PHPHI | Solanaceae | Solanaceae |
2918 | Physalis pubescens L. | Husk Tomato | PHPUP4 | Solanaceae | Solanaceae |
2919 | Physalis sp. | Ground Cherry | Solanaceae | Solanaceae | |
2920 | Physalis subulata var. neomexicana (Rydb.) Waterfall ex Kartesz & Gandhi | New Mexican Groundcherry | PHSUN | Solanaceae | Solanaceae |
2921 | Physalis virginiana P. Mill. | Virginia Groundcherry | PHVIV3 | Solanaceae | Solanaceae |
2922 | Physalis viscosa L. | Starhair Groundcherry | PHVI17 | Solanaceae | Solanaceae |
3297 | Quincula lobata (Torr.) Raf. | Chinese Lantern | QULO2 | Solanaceae | Solanaceae |
3716 | Solanum carolinense L. | Carolina Horsenettle | SOCAC4 | Solanaceae | Solanaceae |
3717 | Solanum donianum Walp. | Mullein Nightshade | SODO3 | Solanaceae | Solanaceae |
3718 | Solanum douglasii Dunal | Greenspot Nightshade | SODO | Solanaceae | Solanaceae |
3719 | Solanum dulcamara L. | Climbing Nightshade | SODUD | Solanaceae | Solanaceae |
3720 | Solanum elaeagnifolium Cav. | Silverleaf Nightshade | SOEL | Solanaceae | Solanaceae |
3721 | Solanum fendleri Gray ex Torr. | Fendler's Horsenettle | SOFEF | Solanaceae | Solanaceae |
3722 | Solanum jamesii Torr. | Wild Potato | SOJA | Solanaceae | Solanaceae |
3723 | Solanum lycopersicum var. lycopersicum | Garden Tomato | SOLYL | Solanaceae | Solanaceae |
3724 | Solanum nigrum L. | Black Nightshade | SOPT3 | Solanaceae | Solanaceae |
3725 | Solanum physalifolium Rusby | Hoe Nightshade | SOPH | Solanaceae | Solanaceae |
3726 | Solanum rostratum Dunal | Buffalobur Nightshade | SORO | Solanaceae | Solanaceae |
3727 | Solanum sp. | Nightshade | Solanaceae | Solanaceae | |
3728 | Solanum triflorum Nutt. | Cutleaf Nightshade | SOTR | Solanaceae | Solanaceae |
3729 | Solanum tuberosum L. | Irish Potato | SOTU | Solanaceae | Solanaceae |
3730 | Solanum umbelliferum Eschsch. | Bluewitch Nightshade | SOUMU | Solanaceae | Solanaceae |
3731 | Solanum xanti Gray | Purple Nightshade | SOXAX | Solanaceae | Solanaceae |
3706 | Smilax auriculata Walt. | Earleaf Greenbrier | SMAU | Smilacaceae | Smilacaceae |
3707 | Smilax bona-nox L. | Saw Greenbrier | SMBO2 | Smilacaceae | Smilacaceae |
3708 | Smilax californica (A. DC.) Gray | California Greenbrier | SMCA2 | Smilacaceae | Smilacaceae |
3709 | Smilax glauca Walt. | Cat Greenbrier | SMGL | Smilacaceae | Smilacaceae |
3710 | Smilax herbacea L. | Smooth Carrionflower | SMHE | Smilacaceae | Smilacaceae |
3711 | Smilax laurifolia L. | Laurel Greenbrier | SMLA | Smilacaceae | Smilacaceae |
3712 | Smilax pseudochina L. | Bamboovine | SMPS | Smilacaceae | Smilacaceae |
3713 | Smilax rotundifolia L. | Roundleaf Greenbrier | SMRO | Smilacaceae | Smilacaceae |
3714 | Smilax sp. | Catbriar | Smilacaceae | Smilacaceae | |
3715 | Smilax tamnoides L. | Bristly Greenbrier | SMTA2 | Smilacaceae | Smilacaceae |
3688 | Simmondsia chinensis (Link) Schneid. | Jojoba | SICH | Simmondsiaceae | Simmondsiaceae |
776 | Castela emoryi (Gray) Moran & Felger | Thorn Of Christ | CAEM4 | Simaroubaceae | Simaroubaceae |
615 | Boykinia occidentalis Torr. & Gray | Coastal Brookfoam | BOOC2 | Saxifragaceae | Saxifragaceae |
1233 | Darmera peltata (Torr. ex Benth.) Voss | Indian Rhubarb | DAPE | Saxifragaceae | Saxifragaceae |
1865 | Heuchera americana L. | American Alumroot | HEAMA2 | Saxifragaceae | Saxifragaceae |
1866 | Heuchera americana var. hispida (Pursh) E. Wells | Hairy Alumroot | HEAMH2 | Saxifragaceae | Saxifragaceae |
1867 | Heuchera bracteata (Torr.) Ser. | Bracted Alumroot | HEBR2 | Saxifragaceae | Saxifragaceae |
1868 | Heuchera cylindrica Dougl. ex Hook. | Roundleaf Alumroot | HECYC | Saxifragaceae | Saxifragaceae |
1869 | Heuchera cylindrica var. alpina Sw. | Alpine Alumroot | HECYA | Saxifragaceae | Saxifragaceae |
1870 | Heuchera cylindrica var. glabella (Torr. & Gray) Wheelock | Beautiful Alumroot | HECYG | Saxifragaceae | Saxifragaceae |
1871 | Heuchera flabellifolia Rydb. | Bridger Mountain Alumroot | HEFLF | Saxifragaceae | Saxifragaceae |
1872 | Heuchera glabra Willd. ex Roemer & J.A. Schultes | Alpine Heuchera | HEGL5 | Saxifragaceae | Saxifragaceae |
1873 | Heuchera micrantha Dougl. ex Lindl. | Crevice Alumroot | HEMIM2 | Saxifragaceae | Saxifragaceae |
1874 | Heuchera novomexicana Wheelock | New Mexico Alumroot | HENO | Saxifragaceae | Saxifragaceae |
1875 | Heuchera parviflora Bartl. | Littleflower Alumroot | HEPAP4 | Saxifragaceae | Saxifragaceae |
1876 | Heuchera parvifolia Nutt. ex Torr. & Gray | Littleleaf Alumroot | HEPAP6 | Saxifragaceae | Saxifragaceae |
1877 | Heuchera richardsonii R. Br. | Richardson's Alumroot | HERI | Saxifragaceae | Saxifragaceae |
1878 | Heuchera rubescens Torr. | Pink Alumroot | HERUR2 | Saxifragaceae | Saxifragaceae |
1879 | Heuchera sp. | Alum Root | Saxifragaceae | Saxifragaceae | |
2143 | Leptarrhena pyrolifolia (D. Don) R. Br. ex Ser. | Fireleaf Leptarrhena | LEPY | Saxifragaceae | Saxifragaceae |
2213 | Lithophragma affine Gray | Common Woodlandstar | LIAFA | Saxifragaceae | Saxifragaceae |
2495 | Mitella diphylla L. | Twoleaf Miterwort | MIDI3 | Saxifragaceae | Saxifragaceae |
2496 | Mitella nuda L. | Naked Miterwort | MINU3 | Saxifragaceae | Saxifragaceae |
2497 | Mitella sp. | Saxifragaceae | Saxifragaceae | ||
2498 | Mitella trifida Graham | Threeparted Miterwort | MITRT | Saxifragaceae | Saxifragaceae |
2750 | Parnassia fimbriata Koenig | Rocky Mountain Parnassia | PAFIF | Saxifragaceae | Saxifragaceae |
2826 | Penthorum sedoides L. | Ditch Stonecrop | PESE6 | Saxifragaceae | Saxifragaceae |
3592 | Saxifraga ferruginea Graham | Rustyhair Saxifrage | SAFEF | Saxifragaceae | Saxifragaceae |
3593 | Saxifraga micranthidifolia (Haw.) Steud. | Lettuceleaf Saxifrage | SAMI6 | Saxifragaceae | Saxifragaceae |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE species ( id INTEGER PRIMARY KEY NOT NULL, name TEXT, common_names TEXT, usda_code TEXT, family TEXT, family_apg TEXT );