use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
252 rows where parent = 2
This data as json, CSV (advanced)
id ▼ | parent | name |
---|---|---|
103 | Drug 2 | Antiemetic |
104 | Drug 2 | Heart Medicine |
110 | Drug 2 | Internal Medicine |
111 | Drug 2 | Antihemorrhagic |
114 | Drug 2 | Snake Bite Remedy |
116 | Drug 2 | Dietary Aid |
117 | Drug 2 | Diuretic |
118 | Drug 2 | Nose Medicine |
119 | Drug 2 | Carminative |
122 | Drug 2 | Antidote |
123 | Drug 2 | Throat Aid |
126 | Drug 2 | Contraceptive |
128 | Drug 2 | Strengthener |
129 | Drug 2 | Disinfectant |
130 | Drug 2 | Dietary Aid |
133 | Drug 2 | Love Medicine |
134 | Drug 2 | Sports Medicine |
137 | Drug 2 | Preventive Medicine |
138 | Drug 2 | Poultice |
139 | Drug 2 | Expectorant |
140 | Drug 2 | Dietary Aid |
142 | Drug 2 | Reproductive Aid |
148 | Drug 2 | Breast Treatment |
149 | Drug 2 | Adjuvant |
151 | Drug 2 | Dietary Aid |
152 | Drug 2 | Dietary Aid |
153 | Drug 2 | Hallucinogen |
155 | Drug 2 | Dietary Aid |
156 | Drug 2 | Ear Medicine |
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 |
177 | Drug 2 | Gland Medicine |
183 | Drug 2 | Dietary Aid |
184 | Drug 2 | Hypotensive |
188 | Drug 2 | Dietary Aid |
189 | Drug 2 | Dietary Aid |
190 | Drug 2 | Alterative |
191 | Drug 2 | Dietary Aid |
192 | Drug 2 | Vertigo Medicine |
194 | Drug 2 | Dietary Aid |
195 | Drug 2 | Dietary Aid |
196 | Drug 2 | Basket Medicine |
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 |
215 | Drug 2 | Dietary Aid |
216 | Drug 2 | Dietary Aid |
219 | Drug 2 | Dietary Aid |
220 | Drug 2 | Dietary Aid |
221 | Drug 2 | Dietary Aid |
222 | Drug 2 | Dietary Aid |
225 | Drug 2 | Dietary Aid |
226 | Drug 2 | Dietary Aid |
227 | Drug 2 | Dietary Aid |
229 | Drug 2 | Dietary Aid |
232 | Drug 2 | Dietary Aid |
233 | Drug 2 | Dietary Aid |
234 | Drug 2 | Dietary Aid |
235 | Drug 2 | Dietary Aid |
236 | Drug 2 | Dietary Aid |
237 | Drug 2 | Dietary Aid |
238 | Drug 2 | Dietary Aid |
239 | Drug 2 | Dietary Aid |
240 | Drug 2 | Dietary Aid |
242 | Drug 2 | Dietary Aid |
243 | Drug 2 | Dietary Aid |
244 | Drug 2 | Dietary Aid |
245 | Drug 2 | Dietary Aid |
246 | Drug 2 | Dietary Aid |
247 | Drug 2 | Dietary Aid |
248 | Drug 2 | Dietary Aid |
251 | Drug 2 | Dietary Aid |
252 | Drug 2 | Dietary Aid |
253 | Drug 2 | Dietary Aid |
254 | Drug 2 | Dietary Aid |
255 | Drug 2 | Dietary Aid |
256 | Drug 2 | Dietary Aid |
257 | Drug 2 | Dietary Aid |
258 | Drug 2 | Dietary Aid |
259 | 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) );