use_subcategories
Data source: Native American Ethnobotany Database · About: NAEB
1 row where name = "Snow Gear" and parent = 4
This data as json, CSV (advanced)
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) );