use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
18 rows where parent = 5 sorted by id descending
This data as json, CSV (advanced)
id ▲ | parent | name |
---|---|---|
289 | Dye 5 | Red-Yellow |
263 | Dye 5 | White |
228 | Dye 5 | Blue-Black |
217 | Dye 5 | Gray |
205 | Dye 5 | Pink |
193 | Dye 5 | Orange |
182 | Dye 5 | Yellow-Brown |
176 | Dye 5 | Orange-Red |
172 | Dye 5 | Orange-Yellow |
161 | Dye 5 | Purple |
150 | Dye 5 | Brown |
136 | Dye 5 | Red |
127 | Dye 5 | Red-Brown |
121 | Dye 5 | Green |
108 | Dye 5 | Black |
105 | Dye 5 | Mordant |
72 | Dye 5 | Yellow |
55 | Dye 5 | Blue |
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) );