use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
252 rows where parent = 2 sorted by parent
This data as json, CSV (advanced)
id | parent ▼ | name |
---|---|---|
3 | Drug 2 | Kidney Aid |
6 | Drug 2 | Analgesic |
8 | Drug 2 | Dermatological Aid |
9 | Drug 2 | Cough Medicine |
11 | Drug 2 | Blood Medicine |
12 | Drug 2 | Ceremonial Medicine |
13 | Drug 2 | Poison |
14 | Drug 2 | Gastrointestinal Aid |
15 | Drug 2 | Sedative |
16 | Drug 2 | Anthelmintic |
18 | Drug 2 | Other |
20 | Drug 2 | Panacea |
21 | Drug 2 | Cold Remedy |
22 | Drug 2 | Gynecological Aid |
23 | Drug 2 | Oral Aid |
25 | Drug 2 | Eye Medicine |
29 | Drug 2 | Cathartic |
34 | Drug 2 | Veterinary Aid |
35 | Drug 2 | Antirheumatic (External) |
36 | Drug 2 | Laxative |
39 | Drug 2 | Orthopedic Aid |
40 | Drug 2 | Emetic |
42 | Drug 2 | Pediatric Aid |
45 | Drug 2 | Febrifuge |
46 | Drug 2 | Venereal Aid |
48 | Drug 2 | Pulmonary Aid |
49 | Drug 2 | Tuberculosis Remedy |
54 | Drug 2 | Narcotic |
60 | Drug 2 | Psychological Aid |
61 | Drug 2 | Hunting Medicine |
62 | Drug 2 | Respiratory Aid |
64 | Drug 2 | Cancer Treatment |
65 | Drug 2 | Hemostat |
68 | Drug 2 | Antidiarrheal |
69 | Drug 2 | Tonic |
71 | Drug 2 | Toothache Remedy |
74 | Drug 2 | Hemorrhoid Remedy |
77 | Drug 2 | Diaphoretic |
78 | Drug 2 | Herbal Steam |
80 | Drug 2 | Urinary Aid |
81 | Drug 2 | Liver Aid |
82 | Drug 2 | Burn Dressing |
84 | Drug 2 | Abortifacient |
87 | Drug 2 | Misc. Disease Remedy |
89 | Drug 2 | Witchcraft Medicine |
90 | Drug 2 | Stimulant |
92 | Drug 2 | Antirheumatic (Internal) |
95 | Drug 2 | Anesthetic |
96 | Drug 2 | Dietary Aid |
97 | Drug 2 | Anticonvulsive |
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 |
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) );