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