6 unmodified lines
7```dataview
8TABLE length(rows) AS "Trips"
9FLATTEN filter(tags, (t) => startswith(t, "country/")) AS country
10WHERE country
11GROUP BY replace(country, "country/", "")
11GROUP BY replace(country, "country/", "") AS "Country"
12SORT length(rows) DESC
13```
14
15## countries by year
1 unmodified line
17```dataview
18TABLE join(unique(map(filter(flat(rows.tags), (t) => startswith(t, "country/")), (t) => replace(t, "country/", ""))), ", ") AS "Countries", length(rows) AS "Trips"
19WHERE date
20SORT date DESC
21GROUP BY dateformat(date, "yyyy")
21GROUP BY dateformat(date, "yyyy") AS "Year"
22```
23
24## cities
25
26```dataview
27TABLE length(rows) AS "Trips"
28FLATTEN filter(tags, (t) => startswith(t, "city/")) AS city
29WHERE city
30GROUP BY replace(city, "city/", "")
30GROUP BY replace(city, "city/", "") AS "City"
31SORT length(rows) DESC
32```
33
34## cities by year
1 unmodified line
36```dataview
37TABLE join(unique(map(filter(flat(rows.tags), (t) => startswith(t, "city/")), (t) => replace(t, "city/", ""))), ", ") AS "Cities", length(rows) AS "Trips"
38WHERE date
39SORT date DESC
40GROUP BY dateformat(date, "yyyy")
40GROUP BY dateformat(date, "yyyy") AS "Year"
41```