flights_per_year (view)

7 rows

✎ View and edit SQL

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

CSV options: 

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