use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by name
This data as json, CSV (advanced)
id | parent | name ▼ |
---|---|---|
84 | Drug 2 | Abortifacient |
149 | Drug 2 | Adjuvant |
190 | Drug 2 | Alterative |
6 | Drug 2 | Analgesic |
95 | Drug 2 | Anesthetic |
16 | Drug 2 | Anthelmintic |
97 | Drug 2 | Anticonvulsive |
68 | Drug 2 | Antidiarrheal |
122 | Drug 2 | Antidote |
103 | Drug 2 | Antiemetic |
111 | Drug 2 | Antihemorrhagic |
35 | Drug 2 | Antirheumatic (External) |
92 | Drug 2 | Antirheumatic (Internal) |
218 | Food 1 | Appetizer |
101 | Food 1 | Baby Food |
196 | Drug 2 | Basket Medicine |
43 | Fiber 4 | Basketry |
27 | Food 1 | Beverage |
108 | Dye 5 | Black |
11 | Drug 2 | Blood Medicine |
55 | Dye 5 | Blue |
228 | Dye 5 | Blue-Black |
2 | Food 1 | Bread & Cake |
230 | Food 1 | Breakfast Food |
148 | Drug 2 | Breast Treatment |
150 | Dye 5 | Brown |
93 | Fiber 4 | Brushes & Brooms |
91 | Fiber 4 | Building Material |
82 | Drug 2 | Burn Dressing |
64 | Drug 2 | Cancer Treatment |
85 | Food 1 | Candy |
70 | Fiber 4 | Canoe Material |
119 | Drug 2 | Carminative |
132 | Other 3 | Cash Crop |
29 | Drug 2 | Cathartic |
94 | Fiber 4 | Caulking Material |
30 | Other 3 | Ceremonial Items |
12 | Drug 2 | Ceremonial Medicine |
107 | Other 3 | Cleaning Agent |
73 | Fiber 4 | Clothing |
21 | Drug 2 | Cold Remedy |
32 | Other 3 | Containers |
126 | Drug 2 | Contraceptive |
131 | Food 1 | Cooking Agent |
33 | Other 3 | Cooking Tools |
99 | Fiber 4 | Cordage |
9 | Drug 2 | Cough Medicine |
38 | Other 3 | Decorations |
8 | Drug 2 | Dermatological Aid |
167 | Other 3 | Designs |
41 | Food 1 | Dessert |
77 | Drug 2 | Diaphoretic |
19 | Food 1 | Dietary Aid |
96 | Drug 2 | Dietary Aid |
116 | Drug 2 | Dietary Aid |
130 | Drug 2 | Dietary Aid |
140 | Drug 2 | Dietary Aid |
151 | Drug 2 | Dietary Aid |
152 | Drug 2 | Dietary Aid |
155 | Drug 2 | Dietary Aid |
157 | Drug 2 | Dietary Aid |
158 | Drug 2 | Dietary Aid |
159 | Drug 2 | Dietary Aid |
160 | Drug 2 | Dietary Aid |
162 | Drug 2 | Dietary Aid |
165 | Drug 2 | Dietary Aid |
166 | Drug 2 | Dietary Aid |
173 | Drug 2 | Dietary Aid |
175 | Drug 2 | Dietary Aid |
183 | Drug 2 | Dietary Aid |
188 | Drug 2 | Dietary Aid |
189 | Drug 2 | Dietary Aid |
191 | Drug 2 | Dietary Aid |
194 | Drug 2 | Dietary Aid |
195 | Drug 2 | Dietary Aid |
197 | Drug 2 | Dietary Aid |
198 | Drug 2 | Dietary Aid |
199 | Drug 2 | Dietary Aid |
200 | Drug 2 | Dietary Aid |
201 | Drug 2 | Dietary Aid |
202 | Drug 2 | Dietary Aid |
204 | Drug 2 | Dietary Aid |
206 | Drug 2 | Dietary Aid |
207 | Drug 2 | Dietary Aid |
208 | Drug 2 | Dietary Aid |
209 | Drug 2 | Dietary Aid |
210 | Drug 2 | Dietary Aid |
211 | Drug 2 | Dietary Aid |
212 | Drug 2 | Dietary Aid |
213 | Drug 2 | Dietary Aid |
214 | Drug 2 | Dietary Aid |
215 | Drug 2 | Dietary Aid |
216 | Drug 2 | Dietary Aid |
219 | Drug 2 | Dietary Aid |
220 | Drug 2 | Dietary Aid |
221 | Drug 2 | Dietary Aid |
222 | Drug 2 | Dietary Aid |
225 | Drug 2 | Dietary Aid |
226 | Drug 2 | Dietary Aid |
227 | Drug 2 | Dietary Aid |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE use_subcategories ( id INTEGER PRIMARY KEY NOT NULL, parent INTEGER, name TEXT, FOREIGN KEY(parent) REFERENCES use_categories(id) );