use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by id descending
This data as json, CSV (advanced)
id ▲ | parent | name |
---|---|---|
289 | Dye 5 | Red-Yellow |
288 | Drug 2 | Dietary Aid |
287 | Drug 2 | Dietary Aid |
286 | Drug 2 | Dietary Aid |
285 | Drug 2 | Dietary Aid |
284 | Drug 2 | Dietary Aid |
283 | Drug 2 | Dietary Aid |
282 | Other 3 | Preservative |
281 | Drug 2 | Dietary Aid |
280 | Drug 2 | Dietary Aid |
279 | Drug 2 | Dietary Aid |
278 | Drug 2 | Dietary Aid |
277 | Drug 2 | Dietary Aid |
276 | Drug 2 | Dietary Aid |
275 | Drug 2 | Dietary Aid |
274 | Drug 2 | Dietary Aid |
273 | Drug 2 | Dietary Aid |
272 | Drug 2 | Dietary Aid |
271 | Fiber 4 | Other |
270 | Drug 2 | Dietary Aid |
269 | Other 3 | Preservative |
268 | Drug 2 | Dietary Aid |
267 | Drug 2 | Dietary Aid |
266 | Other 3 | Preservative |
265 | Drug 2 | Dietary Aid |
264 | Drug 2 | Dietary Aid |
263 | Dye 5 | White |
262 | Drug 2 | Dietary Aid |
261 | Other 3 | Preservative |
260 | Drug 2 | Dietary Aid |
259 | Drug 2 | Dietary Aid |
258 | Drug 2 | Dietary Aid |
257 | Drug 2 | Dietary Aid |
256 | Drug 2 | Dietary Aid |
255 | Drug 2 | Dietary Aid |
254 | Drug 2 | Dietary Aid |
253 | Drug 2 | Dietary Aid |
252 | Drug 2 | Dietary Aid |
251 | Drug 2 | Dietary Aid |
250 | Fiber 4 | Other |
249 | Fiber 4 | Other |
248 | Drug 2 | Dietary Aid |
247 | Drug 2 | Dietary Aid |
246 | Drug 2 | Dietary Aid |
245 | Drug 2 | Dietary Aid |
244 | Drug 2 | Dietary Aid |
243 | Drug 2 | Dietary Aid |
242 | Drug 2 | Dietary Aid |
241 | Other 3 | Malicious Magic |
240 | Drug 2 | Dietary Aid |
239 | Drug 2 | Dietary Aid |
238 | Drug 2 | Dietary Aid |
237 | Drug 2 | Dietary Aid |
236 | Drug 2 | Dietary Aid |
235 | Drug 2 | Dietary Aid |
234 | Drug 2 | Dietary Aid |
233 | Drug 2 | Dietary Aid |
232 | Drug 2 | Dietary Aid |
231 | Other 3 | Preservative |
230 | Food 1 | Breakfast Food |
229 | Drug 2 | Dietary Aid |
228 | Dye 5 | Blue-Black |
227 | Drug 2 | Dietary Aid |
226 | Drug 2 | Dietary Aid |
225 | Drug 2 | Dietary Aid |
224 | Other 3 | Plant Indicator |
223 | Other 3 | Preservative |
222 | Drug 2 | Dietary Aid |
221 | Drug 2 | Dietary Aid |
220 | Drug 2 | Dietary Aid |
219 | Drug 2 | Dietary Aid |
218 | Food 1 | Appetizer |
217 | Dye 5 | Gray |
216 | Drug 2 | Dietary Aid |
215 | Drug 2 | Dietary Aid |
214 | Drug 2 | Dietary Aid |
213 | Drug 2 | Dietary Aid |
212 | Drug 2 | Dietary Aid |
211 | Drug 2 | Dietary Aid |
210 | Drug 2 | Dietary Aid |
209 | Drug 2 | Dietary Aid |
208 | Drug 2 | Dietary Aid |
207 | Drug 2 | Dietary Aid |
206 | Drug 2 | Dietary Aid |
205 | Dye 5 | Pink |
204 | Drug 2 | Dietary Aid |
203 | Other 3 | Snuff |
202 | Drug 2 | Dietary Aid |
201 | Drug 2 | Dietary Aid |
200 | Drug 2 | Dietary Aid |
199 | Drug 2 | Dietary Aid |
198 | Drug 2 | Dietary Aid |
197 | Drug 2 | Dietary Aid |
196 | Drug 2 | Basket Medicine |
195 | Drug 2 | Dietary Aid |
194 | Drug 2 | Dietary Aid |
193 | Dye 5 | Orange |
192 | Drug 2 | Vertigo Medicine |
191 | Drug 2 | Dietary Aid |
190 | Drug 2 | Alterative |
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) );