re-enrichments (view)

1 row where d = "FinVect_k"

✎ View and edit SQL

This data as json, CSV (advanced)

d ✖

  • FinVect_k · 1 ✖
c d e path
Mat_k FinVect_k Vect_k skeleton + full

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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