use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
31 rows where parent = 1
This data as json, CSV (advanced)
id ▼ | parent | name |
---|---|---|
1 | Food 1 | Preserves |
2 | Food 1 | Bread & Cake |
4 | Food 1 | Dried Food |
5 | Food 1 | Forage |
7 | Food 1 | Sauce & Relish |
10 | Food 1 | Snack Food |
19 | Food 1 | Dietary Aid |
27 | Food 1 | Beverage |
31 | Food 1 | Vegetable |
41 | Food 1 | Dessert |
44 | Food 1 | Porridge |
47 | Food 1 | Special Food |
50 | Food 1 | Fodder |
52 | Food 1 | Fruit |
56 | Food 1 | Soup |
59 | Food 1 | Winter Use Food |
66 | Food 1 | Frozen Food |
75 | Food 1 | Staple |
83 | Food 1 | Preservative |
85 | Food 1 | Candy |
86 | Food 1 | Spice |
88 | Food 1 | Pie & Pudding |
101 | Food 1 | Baby Food |
112 | Food 1 | Substitution Food |
113 | Food 1 | Starvation Food |
131 | Food 1 | Cooking Agent |
135 | Food 1 | Sweetener |
163 | Food 1 | Sour |
171 | Food 1 | Ice Cream |
218 | Food 1 | Appetizer |
230 | Food 1 | Breakfast Food |
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) );