essentially_wide_subcategories
1 row where subcategory = "Surj"
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "essentially_wide_subcategories" ( "subcategory" TEXT NOT NULL, "supercategory" TEXT NOT NULL, FOREIGN KEY("subcategory") REFERENCES "categories"("name") on update cascade on delete restrict, FOREIGN KEY("supercategory") REFERENCES "categories"("name") on update cascade on delete restrict, PRIMARY KEY("subcategory","supercategory") );