use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by parent descending
This data as json, CSV (advanced)
Suggested facets: parent
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 |
43 | Fiber 4 | Basketry |
51 | Fiber 4 | Snow Gear |
67 | Fiber 4 | Mats, Rugs & Bedding |
70 | Fiber 4 | Canoe Material |
73 | Fiber 4 | Clothing |
91 | Fiber 4 | Building Material |
93 | Fiber 4 | Brushes & Brooms |
94 | Fiber 4 | Caulking Material |
99 | Fiber 4 | Cordage |
102 | Fiber 4 | Sewing Material |
109 | Fiber 4 | Furniture |
124 | Fiber 4 | Scouring Material |
170 | Fiber 4 | Sporting Equipment |
174 | Fiber 4 | Other |
249 | Fiber 4 | Other |
250 | Fiber 4 | Other |
271 | Fiber 4 | Other |
298 | Fiber 4 | Other |
310 | Fiber 4 | Other |
319 | Fiber 4 | Other |
342 | Fiber 4 | Other |
350 | Fiber 4 | Other |
368 | Fiber 4 | Other |
371 | Fiber 4 | Other |
372 | Fiber 4 | Other |
17 | Other 3 | Tools |
24 | Other 3 | Toys & Games |
26 | Other 3 | Paint |
28 | Other 3 | Hunting & Fishing Item |
30 | Other 3 | Ceremonial Items |
32 | Other 3 | Containers |
33 | Other 3 | Cooking Tools |
37 | Other 3 | Fuel |
38 | Other 3 | Decorations |
53 | Other 3 | Incense & Fragrance |
57 | Other 3 | Fasteners |
58 | Other 3 | Protection |
63 | Other 3 | Smoke Plant |
76 | Other 3 | Insecticide |
79 | Other 3 | Smoking Tools |
98 | Other 3 | Weapon |
100 | Other 3 | Preservative |
106 | Other 3 | Soap |
107 | Other 3 | Cleaning Agent |
115 | Other 3 | Season Indicator |
120 | Other 3 | Walking Sticks |
125 | Other 3 | Jewelry |
132 | Other 3 | Cash Crop |
141 | Other 3 | Planting Seeds |
143 | Other 3 | Paper |
144 | Other 3 | Hide Preparation |
145 | Other 3 | Lighting |
146 | Other 3 | Musical Instrument |
147 | Other 3 | Good Luck Charm |
154 | Other 3 | Waterproofing Agent |
164 | Other 3 | Stable Gear |
167 | Other 3 | Designs |
168 | Other 3 | Water Indicator |
169 | Other 3 | Preservative |
178 | Other 3 | Preservative |
179 | Other 3 | Preservative |
180 | Other 3 | Preservative |
181 | Other 3 | Malicious Charm |
185 | Other 3 | Sacred Items |
186 | Other 3 | Fertilizer |
187 | Other 3 | Preservative |
203 | Other 3 | Snuff |
223 | Other 3 | Preservative |
224 | Other 3 | Plant Indicator |
231 | Other 3 | Preservative |
241 | Other 3 | Malicious Magic |
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 |
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) );