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