32 unmodified lines
33
34## cities by year
35
36```dataview
37TABLE length(unique(map(filter(flat(rows.tags), (t) => startswith(t, "city/")), (t) => replace(t, "city/", "")))) AS "Cities", join(unique(map(filter(flat(rows.tags), (t) => startswith(t, "city/")), (t) => replace(t, "city/", ""))), ", ") AS "List"
37TABLE length(unique(map(filter(flat(rows.tags), (t) => startswith(t, "city/")), (t) => replace(t, "city/", "")))) AS "Count", join(unique(map(filter(flat(rows.tags), (t) => startswith(t, "city/")), (t) => replace(t, "city/", ""))), ", ") AS "Cities"
38WHERE date
39SORT date DESC
40GROUP BY dateformat(date, "yyyy") AS "Year"
41```