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