use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by name descending
This data as json, CSV (advanced)
id | parent | name ▲ |
---|---|---|
319 | Fiber 4 | Other |
342 | Fiber 4 | Other |
350 | Fiber 4 | Other |
368 | Fiber 4 | Other |
371 | Fiber 4 | Other |
372 | Fiber 4 | Other |
39 | Drug 2 | Orthopedic Aid |
172 | Dye 5 | Orange-Yellow |
176 | Dye 5 | Orange-Red |
193 | Dye 5 | Orange |
23 | Drug 2 | Oral Aid |
118 | Drug 2 | Nose Medicine |
54 | Drug 2 | Narcotic |
146 | Other 3 | Musical Instrument |
105 | Dye 5 | Mordant |
87 | Drug 2 | Misc. Disease Remedy |
67 | Fiber 4 | Mats, Rugs & Bedding |
241 | Other 3 | Malicious Magic |
181 | Other 3 | Malicious Charm |
376 | Other 3 | Lubricant |
133 | Drug 2 | Love Medicine |
81 | Drug 2 | Liver Aid |
145 | Other 3 | Lighting |
36 | Drug 2 | Laxative |
3 | Drug 2 | Kidney Aid |
125 | Other 3 | Jewelry |
110 | Drug 2 | Internal Medicine |
76 | Other 3 | Insecticide |
53 | Other 3 | Incense & Fragrance |
171 | Food 1 | Ice Cream |
184 | Drug 2 | Hypotensive |
61 | Drug 2 | Hunting Medicine |
28 | Other 3 | Hunting & Fishing Item |
144 | Other 3 | Hide Preparation |
78 | Drug 2 | Herbal Steam |
65 | Drug 2 | Hemostat |
74 | Drug 2 | Hemorrhoid Remedy |
104 | Drug 2 | Heart Medicine |
153 | Drug 2 | Hallucinogen |
22 | Drug 2 | Gynecological Aid |
121 | Dye 5 | Green |
217 | Dye 5 | Gray |
147 | Other 3 | Good Luck Charm |
177 | Drug 2 | Gland Medicine |
14 | Drug 2 | Gastrointestinal Aid |
109 | Fiber 4 | Furniture |
37 | Other 3 | Fuel |
52 | Food 1 | Fruit |
66 | Food 1 | Frozen Food |
5 | Food 1 | Forage |
50 | Food 1 | Fodder |
186 | Other 3 | Fertilizer |
45 | Drug 2 | Febrifuge |
57 | Other 3 | Fasteners |
25 | Drug 2 | Eye Medicine |
139 | Drug 2 | Expectorant |
40 | Drug 2 | Emetic |
156 | Drug 2 | Ear Medicine |
4 | Food 1 | Dried Food |
117 | Drug 2 | Diuretic |
129 | Drug 2 | Disinfectant |
19 | Food 1 | Dietary Aid |
96 | Drug 2 | Dietary Aid |
116 | Drug 2 | Dietary Aid |
130 | Drug 2 | Dietary Aid |
140 | Drug 2 | Dietary Aid |
151 | Drug 2 | Dietary Aid |
152 | Drug 2 | Dietary Aid |
155 | Drug 2 | Dietary Aid |
157 | Drug 2 | Dietary Aid |
158 | Drug 2 | Dietary Aid |
159 | Drug 2 | Dietary Aid |
160 | Drug 2 | Dietary Aid |
162 | Drug 2 | Dietary Aid |
165 | Drug 2 | Dietary Aid |
166 | Drug 2 | Dietary Aid |
173 | Drug 2 | Dietary Aid |
175 | Drug 2 | Dietary Aid |
183 | Drug 2 | Dietary Aid |
188 | Drug 2 | Dietary Aid |
189 | Drug 2 | Dietary Aid |
191 | Drug 2 | Dietary Aid |
194 | Drug 2 | Dietary Aid |
195 | Drug 2 | Dietary Aid |
197 | Drug 2 | Dietary Aid |
198 | Drug 2 | Dietary Aid |
199 | Drug 2 | Dietary Aid |
200 | Drug 2 | Dietary Aid |
201 | Drug 2 | Dietary Aid |
202 | Drug 2 | Dietary Aid |
204 | Drug 2 | Dietary Aid |
206 | Drug 2 | Dietary Aid |
207 | Drug 2 | Dietary Aid |
208 | Drug 2 | Dietary Aid |
209 | Drug 2 | Dietary Aid |
210 | Drug 2 | Dietary Aid |
211 | Drug 2 | Dietary Aid |
212 | Drug 2 | Dietary Aid |
213 | Drug 2 | Dietary Aid |
214 | Drug 2 | Dietary Aid |
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) );