flights_per_day (view)
1,700 rows
This data as json, CSV (advanced)
Suggested facets: number_of_flights, day (date)
number_of_flights | day |
---|---|
2 | 2017-04-26 |
2 | 2017-04-27 |
1 | 2017-04-29 |
9 | 2017-04-30 |
3 | 2017-05-06 |
1 | 2017-05-09 |
2 | 2017-05-10 |
3 | 2017-05-11 |
2 | 2017-05-12 |
4 | 2017-05-13 |
2 | 2017-05-15 |
2 | 2017-05-16 |
1 | 2017-05-18 |
4 | 2017-05-19 |
2 | 2017-05-20 |
2 | 2017-05-21 |
4 | 2017-05-22 |
2 | 2017-05-23 |
1 | 2017-05-24 |
1 | 2017-05-25 |
1 | 2017-05-26 |
1 | 2017-05-27 |
3 | 2017-05-29 |
1 | 2017-05-30 |
1 | 2017-05-31 |
2 | 2017-06-01 |
3 | 2017-06-02 |
3 | 2017-06-03 |
3 | 2017-06-04 |
2 | 2017-06-05 |
2 | 2017-06-06 |
1 | 2017-06-09 |
3 | 2017-06-10 |
1 | 2017-06-11 |
2 | 2017-06-12 |
3 | 2017-06-13 |
1 | 2017-06-15 |
2 | 2017-06-16 |
1 | 2017-06-17 |
1 | 2017-06-18 |
2 | 2017-06-20 |
3 | 2017-06-22 |
1 | 2017-06-23 |
1 | 2017-06-24 |
4 | 2017-06-25 |
3 | 2017-06-26 |
2 | 2017-06-27 |
2 | 2017-06-28 |
2 | 2017-06-29 |
1 | 2017-06-30 |
2 | 2017-07-02 |
1 | 2017-07-04 |
3 | 2017-07-05 |
2 | 2017-07-06 |
1 | 2017-07-08 |
1 | 2017-07-10 |
1 | 2017-07-11 |
2 | 2017-07-13 |
1 | 2017-07-15 |
4 | 2017-07-16 |
3 | 2017-07-17 |
1 | 2017-07-18 |
2 | 2017-07-19 |
3 | 2017-07-20 |
2 | 2017-07-21 |
1 | 2017-07-22 |
3 | 2017-07-23 |
3 | 2017-07-24 |
2 | 2017-07-26 |
4 | 2017-07-27 |
1 | 2017-07-28 |
3 | 2017-07-30 |
2 | 2017-07-31 |
1 | 2017-08-01 |
2 | 2017-08-02 |
3 | 2017-08-03 |
1 | 2017-08-04 |
1 | 2017-08-05 |
3 | 2017-08-06 |
1 | 2017-08-11 |
2 | 2017-08-15 |
2 | 2017-08-16 |
1 | 2017-08-18 |
1 | 2017-08-19 |
2 | 2017-08-20 |
1 | 2017-08-21 |
2 | 2017-08-23 |
1 | 2017-08-24 |
1 | 2017-08-25 |
1 | 2017-08-28 |
2 | 2017-08-29 |
1 | 2017-08-30 |
1 | 2017-08-31 |
2 | 2017-09-03 |
2 | 2017-09-04 |
3 | 2017-09-05 |
1 | 2017-09-06 |
4 | 2017-09-07 |
5 | 2017-09-09 |
3 | 2017-09-10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW flights_per_day AS SELECT count(*) AS number_of_flights, date(strftime('%Y-%m-%d', aircraft."timestamp")) AS day FROM aircraft GROUP BY (date(strftime('%Y-%m-%d', aircraft."timestamp"))) ORDER BY (date(strftime('%Y-%m-%d', aircraft."timestamp")));