use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by name
This data as json, CSV (advanced)
id | parent | name ▼ |
---|---|---|
354 | Drug 2 | Dietary Aid |
355 | Drug 2 | Dietary Aid |
357 | Drug 2 | Dietary Aid |
358 | Drug 2 | Dietary Aid |
359 | Drug 2 | Dietary Aid |
360 | Drug 2 | Dietary Aid |
361 | Drug 2 | Dietary Aid |
362 | Drug 2 | Dietary Aid |
363 | Drug 2 | Dietary Aid |
364 | Drug 2 | Dietary Aid |
365 | Drug 2 | Dietary Aid |
366 | Drug 2 | Dietary Aid |
367 | Drug 2 | Dietary Aid |
369 | Drug 2 | Dietary Aid |
370 | Drug 2 | Dietary Aid |
373 | Drug 2 | Dietary Aid |
374 | Drug 2 | Dietary Aid |
375 | Drug 2 | Dietary Aid |
377 | Drug 2 | Dietary Aid |
378 | Drug 2 | Dietary Aid |
379 | Drug 2 | Dietary Aid |
380 | Drug 2 | Dietary Aid |
382 | Drug 2 | Dietary Aid |
383 | Drug 2 | Dietary Aid |
384 | Drug 2 | Dietary Aid |
387 | Drug 2 | Dietary Aid |
388 | Drug 2 | Dietary Aid |
389 | Drug 2 | Dietary Aid |
129 | Drug 2 | Disinfectant |
117 | Drug 2 | Diuretic |
4 | Food 1 | Dried Food |
156 | Drug 2 | Ear Medicine |
40 | Drug 2 | Emetic |
139 | Drug 2 | Expectorant |
25 | Drug 2 | Eye Medicine |
57 | Other 3 | Fasteners |
45 | Drug 2 | Febrifuge |
186 | Other 3 | Fertilizer |
50 | Food 1 | Fodder |
5 | Food 1 | Forage |
66 | Food 1 | Frozen Food |
52 | Food 1 | Fruit |
37 | Other 3 | Fuel |
109 | Fiber 4 | Furniture |
14 | Drug 2 | Gastrointestinal Aid |
177 | Drug 2 | Gland Medicine |
147 | Other 3 | Good Luck Charm |
217 | Dye 5 | Gray |
121 | Dye 5 | Green |
22 | Drug 2 | Gynecological Aid |
153 | Drug 2 | Hallucinogen |
104 | Drug 2 | Heart Medicine |
74 | Drug 2 | Hemorrhoid Remedy |
65 | Drug 2 | Hemostat |
78 | Drug 2 | Herbal Steam |
144 | Other 3 | Hide Preparation |
28 | Other 3 | Hunting & Fishing Item |
61 | Drug 2 | Hunting Medicine |
184 | Drug 2 | Hypotensive |
171 | Food 1 | Ice Cream |
53 | Other 3 | Incense & Fragrance |
76 | Other 3 | Insecticide |
110 | Drug 2 | Internal Medicine |
125 | Other 3 | Jewelry |
3 | Drug 2 | Kidney Aid |
36 | Drug 2 | Laxative |
145 | Other 3 | Lighting |
81 | Drug 2 | Liver Aid |
133 | Drug 2 | Love Medicine |
376 | Other 3 | Lubricant |
181 | Other 3 | Malicious Charm |
241 | Other 3 | Malicious Magic |
67 | Fiber 4 | Mats, Rugs & Bedding |
87 | Drug 2 | Misc. Disease Remedy |
105 | Dye 5 | Mordant |
146 | Other 3 | Musical Instrument |
54 | Drug 2 | Narcotic |
118 | Drug 2 | Nose Medicine |
23 | Drug 2 | Oral Aid |
193 | Dye 5 | Orange |
176 | Dye 5 | Orange-Red |
172 | Dye 5 | Orange-Yellow |
39 | Drug 2 | Orthopedic Aid |
18 | Drug 2 | Other |
174 | Fiber 4 | Other |
249 | Fiber 4 | Other |
250 | Fiber 4 | Other |
271 | Fiber 4 | Other |
298 | Fiber 4 | Other |
310 | Fiber 4 | Other |
319 | Fiber 4 | Other |
342 | Fiber 4 | Other |
350 | Fiber 4 | Other |
368 | Fiber 4 | Other |
371 | Fiber 4 | Other |
372 | Fiber 4 | Other |
26 | Other 3 | Paint |
20 | Drug 2 | Panacea |
143 | Other 3 | Paper |
42 | Drug 2 | Pediatric 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) );