use_subcategories

Data source: Native American Ethnobotany Database · About: NAEB

389 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: parent

id ▼ parent name
1 Food 1 Preserves
2 Food 1 Bread & Cake
3 Drug 2 Kidney Aid
4 Food 1 Dried Food
5 Food 1 Forage
6 Drug 2 Analgesic
7 Food 1 Sauce & Relish
8 Drug 2 Dermatological Aid
9 Drug 2 Cough Medicine
10 Food 1 Snack Food
11 Drug 2 Blood Medicine
12 Drug 2 Ceremonial Medicine
13 Drug 2 Poison
14 Drug 2 Gastrointestinal Aid
15 Drug 2 Sedative
16 Drug 2 Anthelmintic
17 Other 3 Tools
18 Drug 2 Other
19 Food 1 Dietary Aid
20 Drug 2 Panacea
21 Drug 2 Cold Remedy
22 Drug 2 Gynecological Aid
23 Drug 2 Oral Aid
24 Other 3 Toys & Games
25 Drug 2 Eye Medicine
26 Other 3 Paint
27 Food 1 Beverage
28 Other 3 Hunting & Fishing Item
29 Drug 2 Cathartic
30 Other 3 Ceremonial Items
31 Food 1 Vegetable
32 Other 3 Containers
33 Other 3 Cooking Tools
34 Drug 2 Veterinary Aid
35 Drug 2 Antirheumatic (External)
36 Drug 2 Laxative
37 Other 3 Fuel
38 Other 3 Decorations
39 Drug 2 Orthopedic Aid
40 Drug 2 Emetic
41 Food 1 Dessert
42 Drug 2 Pediatric Aid
43 Fiber 4 Basketry
44 Food 1 Porridge
45 Drug 2 Febrifuge
46 Drug 2 Venereal Aid
47 Food 1 Special Food
48 Drug 2 Pulmonary Aid
49 Drug 2 Tuberculosis Remedy
50 Food 1 Fodder
51 Fiber 4 Snow Gear
52 Food 1 Fruit
53 Other 3 Incense & Fragrance
54 Drug 2 Narcotic
55 Dye 5 Blue
56 Food 1 Soup
57 Other 3 Fasteners
58 Other 3 Protection
59 Food 1 Winter Use Food
60 Drug 2 Psychological Aid
61 Drug 2 Hunting Medicine
62 Drug 2 Respiratory Aid
63 Other 3 Smoke Plant
64 Drug 2 Cancer Treatment
65 Drug 2 Hemostat
66 Food 1 Frozen Food
67 Fiber 4 Mats, Rugs & Bedding
68 Drug 2 Antidiarrheal
69 Drug 2 Tonic
70 Fiber 4 Canoe Material
71 Drug 2 Toothache Remedy
72 Dye 5 Yellow
73 Fiber 4 Clothing
74 Drug 2 Hemorrhoid Remedy
75 Food 1 Staple
76 Other 3 Insecticide
77 Drug 2 Diaphoretic
78 Drug 2 Herbal Steam
79 Other 3 Smoking Tools
80 Drug 2 Urinary Aid
81 Drug 2 Liver Aid
82 Drug 2 Burn Dressing
83 Food 1 Preservative
84 Drug 2 Abortifacient
85 Food 1 Candy
86 Food 1 Spice
87 Drug 2 Misc. Disease Remedy
88 Food 1 Pie & Pudding
89 Drug 2 Witchcraft Medicine
90 Drug 2 Stimulant
91 Fiber 4 Building Material
92 Drug 2 Antirheumatic (Internal)
93 Fiber 4 Brushes & Brooms
94 Fiber 4 Caulking Material
95 Drug 2 Anesthetic
96 Drug 2 Dietary Aid
97 Drug 2 Anticonvulsive
98 Other 3 Weapon
99 Fiber 4 Cordage
100 Other 3 Preservative

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE use_subcategories (
        id INTEGER PRIMARY KEY NOT NULL,
        parent INTEGER, 
        name TEXT,
        FOREIGN KEY(parent) REFERENCES use_categories(id)
        );