flights_per_year (view)
7 rows
This data as json, CSV (advanced)
Suggested facets: year (date)
number_of_flights | year |
---|---|
288 | 2017-01-01 |
559 | 2018-01-01 |
649 | 2019-01-01 |
473 | 2020-01-01 |
818 | 2021-01-01 |
959 | 2022-01-01 |
810 | 2023-01-01 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW flights_per_year AS SELECT count(*) AS number_of_flights, date(strftime('%Y-01-01', aircraft."timestamp")) AS year FROM aircraft GROUP BY (date(strftime('%Y-01-01', aircraft."timestamp"))) ORDER BY (date(strftime('%Y-01-01', aircraft."timestamp")));