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)
);