use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by name descending
This data as json, CSV (advanced)
id | parent | name ▲ |
---|---|---|
182 | Dye 5 | Yellow-Brown |
72 | Dye 5 | Yellow |
89 | Drug 2 | Witchcraft Medicine |
59 | Food 1 | Winter Use Food |
263 | Dye 5 | White |
98 | Other 3 | Weapon |
154 | Other 3 | Waterproofing Agent |
168 | Other 3 | Water Indicator |
120 | Other 3 | Walking Sticks |
34 | Drug 2 | Veterinary Aid |
192 | Drug 2 | Vertigo Medicine |
46 | Drug 2 | Venereal Aid |
31 | Food 1 | Vegetable |
80 | Drug 2 | Urinary Aid |
49 | Drug 2 | Tuberculosis Remedy |
24 | Other 3 | Toys & Games |
71 | Drug 2 | Toothache Remedy |
17 | Other 3 | Tools |
69 | Drug 2 | Tonic |
123 | Drug 2 | Throat Aid |
135 | Food 1 | Sweetener |
112 | Food 1 | Substitution Food |
128 | Drug 2 | Strengthener |
90 | Drug 2 | Stimulant |
113 | Food 1 | Starvation Food |
75 | Food 1 | Staple |
164 | Other 3 | Stable Gear |
134 | Drug 2 | Sports Medicine |
170 | Fiber 4 | Sporting Equipment |
86 | Food 1 | Spice |
47 | Food 1 | Special Food |
163 | Food 1 | Sour |
56 | Food 1 | Soup |
106 | Other 3 | Soap |
203 | Other 3 | Snuff |
51 | Fiber 4 | Snow Gear |
114 | Drug 2 | Snake Bite Remedy |
10 | Food 1 | Snack Food |
79 | Other 3 | Smoking Tools |
63 | Other 3 | Smoke Plant |
102 | Fiber 4 | Sewing Material |
15 | Drug 2 | Sedative |
115 | Other 3 | Season Indicator |
124 | Fiber 4 | Scouring Material |
7 | Food 1 | Sauce & Relish |
185 | Other 3 | Sacred Items |
62 | Drug 2 | Respiratory Aid |
142 | Drug 2 | Reproductive Aid |
289 | Dye 5 | Red-Yellow |
127 | Dye 5 | Red-Brown |
136 | Dye 5 | Red |
161 | Dye 5 | Purple |
48 | Drug 2 | Pulmonary Aid |
60 | Drug 2 | Psychological Aid |
58 | Other 3 | Protection |
137 | Drug 2 | Preventive Medicine |
1 | Food 1 | Preserves |
83 | Food 1 | Preservative |
100 | Other 3 | Preservative |
169 | Other 3 | Preservative |
178 | Other 3 | Preservative |
179 | Other 3 | Preservative |
180 | Other 3 | Preservative |
187 | Other 3 | Preservative |
223 | Other 3 | Preservative |
231 | Other 3 | Preservative |
261 | Other 3 | Preservative |
266 | Other 3 | Preservative |
269 | Other 3 | Preservative |
282 | Other 3 | Preservative |
292 | Other 3 | Preservative |
303 | Other 3 | Preservative |
320 | Other 3 | Preservative |
322 | Other 3 | Preservative |
328 | Other 3 | Preservative |
329 | Other 3 | Preservative |
338 | Other 3 | Preservative |
340 | Other 3 | Preservative |
356 | Other 3 | Preservative |
381 | Other 3 | Preservative |
385 | Other 3 | Preservative |
386 | Other 3 | Preservative |
138 | Drug 2 | Poultice |
44 | Food 1 | Porridge |
13 | Drug 2 | Poison |
141 | Other 3 | Planting Seeds |
224 | Other 3 | Plant Indicator |
205 | Dye 5 | Pink |
88 | Food 1 | Pie & Pudding |
42 | Drug 2 | Pediatric Aid |
143 | Other 3 | Paper |
20 | Drug 2 | Panacea |
26 | Other 3 | Paint |
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 |
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) );