use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
389 rows sorted by id descending
This data as json, CSV (advanced)
id ▲ | parent | name |
---|---|---|
189 | Drug 2 | Dietary Aid |
188 | Drug 2 | Dietary Aid |
187 | Other 3 | Preservative |
186 | Other 3 | Fertilizer |
185 | Other 3 | Sacred Items |
184 | Drug 2 | Hypotensive |
183 | Drug 2 | Dietary Aid |
182 | Dye 5 | Yellow-Brown |
181 | Other 3 | Malicious Charm |
180 | Other 3 | Preservative |
179 | Other 3 | Preservative |
178 | Other 3 | Preservative |
177 | Drug 2 | Gland Medicine |
176 | Dye 5 | Orange-Red |
175 | Drug 2 | Dietary Aid |
174 | Fiber 4 | Other |
173 | Drug 2 | Dietary Aid |
172 | Dye 5 | Orange-Yellow |
171 | Food 1 | Ice Cream |
170 | Fiber 4 | Sporting Equipment |
169 | Other 3 | Preservative |
168 | Other 3 | Water Indicator |
167 | Other 3 | Designs |
166 | Drug 2 | Dietary Aid |
165 | Drug 2 | Dietary Aid |
164 | Other 3 | Stable Gear |
163 | Food 1 | Sour |
162 | Drug 2 | Dietary Aid |
161 | Dye 5 | Purple |
160 | Drug 2 | Dietary Aid |
159 | Drug 2 | Dietary Aid |
158 | Drug 2 | Dietary Aid |
157 | Drug 2 | Dietary Aid |
156 | Drug 2 | Ear Medicine |
155 | Drug 2 | Dietary Aid |
154 | Other 3 | Waterproofing Agent |
153 | Drug 2 | Hallucinogen |
152 | Drug 2 | Dietary Aid |
151 | Drug 2 | Dietary Aid |
150 | Dye 5 | Brown |
149 | Drug 2 | Adjuvant |
148 | Drug 2 | Breast Treatment |
147 | Other 3 | Good Luck Charm |
146 | Other 3 | Musical Instrument |
145 | Other 3 | Lighting |
144 | Other 3 | Hide Preparation |
143 | Other 3 | Paper |
142 | Drug 2 | Reproductive Aid |
141 | Other 3 | Planting Seeds |
140 | Drug 2 | Dietary Aid |
139 | Drug 2 | Expectorant |
138 | Drug 2 | Poultice |
137 | Drug 2 | Preventive Medicine |
136 | Dye 5 | Red |
135 | Food 1 | Sweetener |
134 | Drug 2 | Sports Medicine |
133 | Drug 2 | Love Medicine |
132 | Other 3 | Cash Crop |
131 | Food 1 | Cooking Agent |
130 | Drug 2 | Dietary Aid |
129 | Drug 2 | Disinfectant |
128 | Drug 2 | Strengthener |
127 | Dye 5 | Red-Brown |
126 | Drug 2 | Contraceptive |
125 | Other 3 | Jewelry |
124 | Fiber 4 | Scouring Material |
123 | Drug 2 | Throat Aid |
122 | Drug 2 | Antidote |
121 | Dye 5 | Green |
120 | Other 3 | Walking Sticks |
119 | Drug 2 | Carminative |
118 | Drug 2 | Nose Medicine |
117 | Drug 2 | Diuretic |
116 | Drug 2 | Dietary Aid |
115 | Other 3 | Season Indicator |
114 | Drug 2 | Snake Bite Remedy |
113 | Food 1 | Starvation Food |
112 | Food 1 | Substitution Food |
111 | Drug 2 | Antihemorrhagic |
110 | Drug 2 | Internal Medicine |
109 | Fiber 4 | Furniture |
108 | Dye 5 | Black |
107 | Other 3 | Cleaning Agent |
106 | Other 3 | Soap |
105 | Dye 5 | Mordant |
104 | Drug 2 | Heart Medicine |
103 | Drug 2 | Antiemetic |
102 | Fiber 4 | Sewing Material |
101 | Food 1 | Baby Food |
100 | Other 3 | Preservative |
99 | Fiber 4 | Cordage |
98 | Other 3 | Weapon |
97 | Drug 2 | Anticonvulsive |
96 | Drug 2 | Dietary Aid |
95 | Drug 2 | Anesthetic |
94 | Fiber 4 | Caulking Material |
93 | Fiber 4 | Brushes & Brooms |
92 | Drug 2 | Antirheumatic (Internal) |
91 | Fiber 4 | Building Material |
90 | Drug 2 | Stimulant |
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) );