re-enrichments (view)
1 row where d = "Hilb" sorted by c
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW "re-enrichments" AS select c, d1 as d, e, path from (select all_essentially_wide_subcategories.subcategory as c, all_essentially_wide_subcategories.supercategory as d1, all_full_subcategories.subcategory as d2, all_full_subcategories.supercategory as e, all_essentially_wide_subcategories.kind || ' + ' || all_full_subcategories.kind as path from all_essentially_wide_subcategories join all_full_subcategories where d1 == d2);