use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows
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 |
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) );