Crowdsourced air traffic data from The OpenSky Network 2020
The data in this dataset is derived and cleaned from the full OpenSky dataset to illustrate the development of air traffic during the COVID-19 pandemic. It spans all flights seen by the network's more than 2500 members since 1 January 2019. More data will be periodically included in the dataset until the end of the COVID-19 pandemic.
Source: https://zenodo.org/record/5092942#.YRBCyTpRXYd
Martin Strohmeier, Xavier Olive, Jannis LΓΌbbe, Matthias SchΓ€fer, and Vincent Lenders "Crowdsourced air traffic data from the OpenSky Network 2019β2020" Earth System Science Data 13(2), 2021 https://doi.org/10.5194/essd-13-357-2021
Download the Datasetβ
Run the command:
wget -O- https://zenodo.org/record/5092942 | grep -oP 'https://zenodo.org/record/5092942/files/flightlist_\d+_\d+\.csv\.gz' | xargs wget
Download will take about 2 minutes with good internet connection. There are 30 files with total size of 4.3 GB.
Create the Tableβ
CREATE TABLE opensky
(
callsign String,
number String,
icao24 String,
registration String,
typecode String,
origin String,
destination String,
firstseen DateTime,
lastseen DateTime,
day DateTime,
latitude_1 Float64,
longitude_1 Float64,
altitude_1 Float64,
latitude_2 Float64,
longitude_2 Float64,
altitude_2 Float64
) ENGINE = MergeTree ORDER BY (origin, destination, callsign);
Import Dataβ
Upload data into ClickHouse in parallel:
ls -1 flightlist_*.csv.gz | xargs -P100 -I{} bash -c 'gzip -c -d "{}" | clickhouse-client --date_time_input_format best_effort --query "INSERT INTO opensky FORMAT CSVWithNames"'
- Here we pass the list of files (
ls -1 flightlist_*.csv.gz
) toxargs
for parallel processing.xargs -P100
specifies to use up to 100 parallel workers but as we only have 30 files, the number of workers will be only 30. - For every file,
xargs
will run a script withbash -c
. The script has substitution in form of{}
and thexargs
command will substitute the filename to it (we have asked it forxargs
with-I{}
). - The script will decompress the file (
gzip -c -d "{}"
) to standard output (-c
parameter) and the output is redirected toclickhouse-client
. - We also asked to parse DateTime fields with extended parser (--date_time_input_format best_effort) to recognize ISO-8601 format with timezone offsets.
Finally, clickhouse-client
will do insertion. It will read input data in CSVWithNames format.
Parallel upload takes 24 seconds.
If you don't like parallel upload, here is sequential variant:
for file in flightlist_*.csv.gz; do gzip -c -d "$file" | clickhouse-client --date_time_input_format best_effort --query "INSERT INTO opensky FORMAT CSVWithNames"; done
Validate the Dataβ
Query:
SELECT count() FROM opensky;
Result:
βββcount()ββ
β 66010819 β
ββββββββββββ
The size of dataset in ClickHouse is just 2.66 GiB, check it.
Query:
SELECT formatReadableSize(total_bytes) FROM system.tables WHERE name = 'opensky';
Result:
ββformatReadableSize(total_bytes)ββ
β 2.66 GiB β
βββββββββββββββββββββββββββββββββββ
Run Some Queriesβ
Total distance travelled is 68 billion kilometers.
Query:
SELECT formatReadableQuantity(sum(geoDistance(longitude_1, latitude_1, longitude_2, latitude_2)) / 1000) FROM opensky;
Result:
ββformatReadableQuantity(divide(sum(geoDistance(longitude_1, latitude_1, longitude_2, latitude_2)), 1000))ββ
β 68.72 billion β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Average flight distance is around 1000 km.
Query:
SELECT avg(geoDistance(longitude_1, latitude_1, longitude_2, latitude_2)) FROM opensky;
Result:
ββavg(geoDistance(longitude_1, latitude_1, longitude_2, latitude_2))ββ
β 1041090.6465708319 β
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Most busy origin airports and the average distance seenβ
Query:
SELECT
origin,
count(),
round(avg(geoDistance(longitude_1, latitude_1, longitude_2, latitude_2))) AS distance,
bar(distance, 0, 10000000, 100) AS bar
FROM opensky
WHERE origin != ''
GROUP BY origin
ORDER BY count() DESC
LIMIT 100;
Result:
ββoriginββ¬βcount()ββ¬βdistanceββ¬βbarβββββββββββββββββββββββββββββββββββββ
1. β KORD β 745007 β 1546108 β ββββββββββββββββ β
2. β KDFW β 696702 β 1358721 β ββββββββββββββ β
3. β KATL β 667286 β 1169661 β ββββββββββββ β
4. β KDEN β 582709 β 1287742 β βββββββββββββ β
5. β KLAX β 581952 β 2628393 β βββββββββββββββββββββββββββ β
6. β KLAS β 447789 β 1336967 β ββββββββββββββ β
7. β KPHX β 428558 β 1345635 β ββββββββββββββ β
8. β KSEA β 412592 β 1757317 β ββββββββββββββββββ β
9. β KCLT β 404612 β 880355 β βββββββββ β
10. β VIDP β 363074 β 1445052 β βββββββββββββββ β
11. β EDDF β 362643 β 2263960 β βββββββββββββββββββββββ β
12. β KSFO β 361869 β 2445732 β βββββββββββββββββββββββββ β
13. β KJFK β 349232 β 2996550 β ββββββββββββββββββββββββββββββ β
14. β KMSP β 346010 β 1287328 β βββββββββββββ β
15. β LFPG β 344748 β 2206203 β ββββββββββββββββββββββ β
16. β EGLL β 341370 β 3216593 β βββββββββββββββββββββββββββββββββ β
17. β EHAM β 340272 β 2116425 β ββββββββββββββββββββββ β
18. β KEWR β 337696 β 1826545 β βββββββββββββββββββ β
19. β KPHL β 320762 β 1291761 β βββββββββββββ β
20. β OMDB β 308855 β 2855706 β βββββββββββββββββββββββββββββ β
21. β UUEE β 307098 β 1555122 β ββββββββββββββββ β
22. β KBOS β 304416 β 1621675 β βββββββββββββββββ β
23. β LEMD β 291787 β 1695097 β βββββββββββββββββ β
24. β YSSY β 272979 β 1875298 β βββββββββββββββββββ β
25. β KMIA β 265121 β 1923542 β ββββββββββββββββββββ β
26. β ZGSZ β 263497 β 745086 β ββββββββ β
27. β EDDM β 256691 β 1361453 β ββββββββββββββ β
28. β WMKK β 254264 β 1626688 β βββββββββββββββββ β
29. β CYYZ β 251192 β 2175026 β ββββββββββββββββββββββ β
30. β KLGA β 248699 β 1106935 β βββββββββββ β
31. β VHHH β 248473 β 3457658 β βββββββββββββββββββββββββββββββββββ β
32. β RJTT β 243477 β 1272744 β βββββββββββββ β
33. β KBWI β 241440 β 1187060 β ββββββββββββ β
34. β KIAD β 239558 β 1683485 β βββββββββββββββββ β
35. β KIAH β 234202 β 1538335 β ββββββββββββββββ β
36. β KFLL β 223447 β 1464410 β βββββββββββββββ β
37. β KDAL β 212055 β 1082339 β βββββββββββ β
38. β KDCA β 207883 β 1013359 β βββββββββββ β
39. β LIRF β 207047 β 1427965 β βββββββββββββββ β
40. β PANC β 206007 β 2525359 β ββββββββββββββββββββββββββ β
41. β LTFJ β 205415 β 860470 β βββββββββ β
42. β KDTW β 204020 β 1106716 β βββββββββββ β
43. β VABB β 201679 β 1300865 β βββββββββββββ β
44. β OTHH β 200797 β 3759544 β ββββββββββββββββββββββββββββββββββββββ β
45. β KMDW β 200796 β 1232551 β βββββββββββββ β
46. β KSAN β 198003 β 1495195 β βββββββββββββββ β
47. β KPDX β 197760 β 1269230 β βββββββββββββ β
48. β SBGR β 197624 β 2041697 β βββββββββββββββββββββ β
49. β VOBL β 189011 β 1040180 β βββββββββββ β
50. β LEBL β 188956 β 1283190 β βββββββββββββ β
51. β YBBN β 188011 β 1253405 β βββββββββββββ β
52. β LSZH β 187934 β 1572029 β ββββββββββββββββ β
53. β YMML β 187643 β 1870076 β βββββββββββββββββββ β
54. β RCTP β 184466 β 2773976 β ββββββββββββββββββββββββββββ β
55. β KSNA β 180045 β 778484 β ββββββββ β
56. β EGKK β 176420 β 1694770 β βββββββββββββββββ β
57. β LOWW β 176191 β 1274833 β βββββββββββββ β
58. β UUDD β 176099 β 1368226 β ββββββββββββββ β
59. β RKSI β 173466 β 3079026 β βββββββββββββββββββββββββββββββ β
60. β EKCH β 172128 β 1229895 β βββββββββββββ β
61. β KOAK β 171119 β 1114447 β ββββββββββββ β
62. β RPLL β 170122 β 1440735 β βββββββββββββββ β
63. β KRDU β 167001 β 830521 β βββββββββ β
64. β KAUS β 164524 β 1256198 β βββββββββββββ β
65. β KBNA β 163242 β 1022726 β βββββββββββ β
66. β KSDF β 162655 β 1380867 β ββββββββββββββ β
67. β ENGM β 160732 β 910108 β βββββββββ β
68. β LIMC β 160696 β 1564620 β ββββββββββββββββ β
69. β KSJC β 159278 β 1081125 β βββββββββββ β
70. β KSTL β 157984 β 1026699 β βββββββββββ β
71. β UUWW β 156811 β 1261155 β βββββββββββββ β
72. β KIND β 153929 β 987944 β ββββββββββ β
73. β ESSA β 153390 β 1203439 β ββββββββββββ β
74. β KMCO β 153351 β 1508657 β βββββββββββββββ β
75. β KDVT β 152895 β 74048 β β β
76. β VTBS β 152645 β 2255591 β βββββββββββββββββββββββ β
77. β CYVR β 149574 β 2027413 β βββββββββββββββββββββ β
78. β EIDW β 148723 β 1503985 β βββββββββββββββ β
79. β LFPO β 143277 β 1152964 β ββββββββββββ β
80. β EGSS β 140830 β 1348183 β ββββββββββββββ β
81. β KAPA β 140776 β 420441 β βββββ β
82. β KHOU β 138985 β 1068806 β βββββββββββ β
83. β KTPA β 138033 β 1338223 β ββββββββββββββ β
84. β KFFZ β 137333 β 55397 β β β
85. β NZAA β 136092 β 1581264 β ββββββββββββββββ β
86. β YPPH β 133916 β 1271550 β βββββββββββββ β
87. β RJBB β 133522 β 1805623 β ββββββββββββββββββ β
88. β EDDL β 133018 β 1265919 β βββββββββββββ β
89. β ULLI β 130501 β 1197108 β ββββββββββββ β
90. β KIWA β 127195 β 250876 β βββ β
91. β KTEB β 126969 β 1189414 β ββββββββββββ β
92. β VOMM β 125616 β 1127757 β ββββββββββββ β
93. β LSGG β 123998 β 1049101 β βββββββββββ β
94. β LPPT β 122733 β 1779187 β ββββββββββββββββββ β
95. β WSSS β 120493 β 3264122 β βββββββββββββββββββββββββββββββββ β
96. β EBBR β 118539 β 1579939 β ββββββββββββββββ β
97. β VTBD β 118107 β 661627 β βββββββ β
98. β KVNY β 116326 β 692960 β βββββββ β
99. β EDDT β 115122 β 941740 β ββββββββββ β
100. β EFHK β 114860 β 1629143 β βββββββββββββββββ β
ββββββββββ΄ββββββββββ΄βββββββββββ΄βββββββββββββββββββββββββββββββββββββββββ
Number of flights from three major Moscow airports, weeklyβ
Query:
SELECT
toMonday(day) AS k,
count() AS c,
bar(c, 0, 10000, 100) AS bar
FROM opensky
WHERE origin IN ('UUEE', 'UUDD', 'UUWW')
GROUP BY k
ORDER BY k ASC;
Result:
βββββββββββkββ¬ββββcββ¬βbarβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
1. β 2018-12-31 β 5248 β βββββββββββββββββββββββββββββββββββββββββββββββββββββ β
2. β 2019-01-07 β 6302 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
3. β 2019-01-14 β 5701 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
4. β 2019-01-21 β 5638 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
5. β 2019-01-28 β 5731 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
6. β 2019-02-04 β 5683 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
7. β 2019-02-11 β 5759 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
8. β 2019-02-18 β 5736 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
9. β 2019-02-25 β 5873 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
10. β 2019-03-04 β 5965 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
11. β 2019-03-11 β 5900 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
12. β 2019-03-18 β 5823 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
13. β 2019-03-25 β 5899 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
14. β 2019-04-01 β 6043 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
15. β 2019-04-08 β 6098 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
16. β 2019-04-15 β 6196 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
17. β 2019-04-22 β 6486 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
18. β 2019-04-29 β 6682 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
19. β 2019-05-06 β 6739 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
20. β 2019-05-13 β 6600 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
21. β 2019-05-20 β 6575 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
22. β 2019-05-27 β 6786 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
23. β 2019-06-03 β 6872 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
24. β 2019-06-10 β 7045 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
25. β 2019-06-17 β 7045 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
26. β 2019-06-24 β 6852 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
27. β 2019-07-01 β 7248 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
28. β 2019-07-08 β 7284 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
29. β 2019-07-15 β 7142 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
30. β 2019-07-22 β 7108 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
31. β 2019-07-29 β 7251 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
32. β 2019-08-05 β 7403 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
33. β 2019-08-12 β 7457 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
34. β 2019-08-19 β 7502 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
35. β 2019-08-26 β 7540 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
36. β 2019-09-02 β 7237 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
37. β 2019-09-09 β 7328 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
38. β 2019-09-16 β 5566 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
39. β 2019-09-23 β 7049 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
40. β 2019-09-30 β 6880 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
41. β 2019-10-07 β 6518 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
42. β 2019-10-14 β 6688 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
43. β 2019-10-21 β 6667 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
44. β 2019-10-28 β 6303 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
45. β 2019-11-04 β 6298 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
46. β 2019-11-11 β 6137 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
47. β 2019-11-18 β 6051 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
48. β 2019-11-25 β 5820 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
49. β 2019-12-02 β 5942 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
50. β 2019-12-09 β 4891 β βββββββββββββββββββββββββββββββββββββββββββββββββ β
51. β 2019-12-16 β 5682 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
52. β 2019-12-23 β 6111 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
53. β 2019-12-30 β 5870 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
54. β 2020-01-06 β 5953 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
55. β 2020-01-13 β 5698 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
56. β 2020-01-20 β 5339 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
57. β 2020-01-27 β 5566 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
58. β 2020-02-03 β 5801 β ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
59. β 2020-02-10 β 5692 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
60. β 2020-02-17 β 5912 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
61. β 2020-02-24 β 6031 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
62. β 2020-03-02 β 6105 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
63. β 2020-03-09 β 5823 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
64. β 2020-03-16 β 4659 β βββββββββββββββββββββββββββββββββββββββββββββββ β
65. β 2020-03-23 β 3720 β ββββββββββββββββββββββββββββββββββββββ β
66. β 2020-03-30 β 1720 β ββββββββββββββββββ β
67. β 2020-04-06 β 849 β βββββββββ β
68. β 2020-04-13 β 710 β βββββββ β
69. β 2020-04-20 β 725 β ββββββββ β
70. β 2020-04-27 β 920 β ββββββββββ β
71. β 2020-05-04 β 859 β βββββββββ β
72. β 2020-05-11 β 1047 β βββββββββββ β
73. β 2020-05-18 β 1135 β ββββββββββββ β
74. β 2020-05-25 β 1266 β βββββββββββββ β
75. β 2020-06-01 β 1793 β ββββββββββββββββββ β
76. β 2020-06-08 β 1979 β ββββββββββββββββββββ β
77. β 2020-06-15 β 2297 β βββββββββββββββββββββββ β
78. β 2020-06-22 β 2788 β ββββββββββββββββββββββββββββ β
79. β 2020-06-29 β 3389 β ββββββββββββββββββββββββββββββββββ β
80. β 2020-07-06 β 3545 β ββββββββββββββββββββββββββββββββββββ β
81. β 2020-07-13 β 3569 β ββββββββββββββββββββββββββββββββββββ β
82. β 2020-07-20 β 3784 β ββββββββββββββββββββββββββββββββββββββ β
83. β 2020-07-27 β 3960 β ββββββββββββββββββββββββββββββββββββββββ β
84. β 2020-08-03 β 4323 β ββββββββββββββββββββββββββββββββββββββββββββ β
85. β 2020-08-10 β 4581 β ββββββββββββββββββββββββββββββββββββββββββββββ β
86. β 2020-08-17 β 4791 β ββββββββββββββββββββββββββββββββββββββββββββββββ β
87. β 2020-08-24 β 4928 β ββββββββββββββββββββββββββββββββββββββββββββββββββ β
88. β 2020-08-31 β 4687 β βββββββββββββββββββββββββββββββββββββββββββββββ β
89. β 2020-09-07 β 4643 β βββββββββββββββββββββββββββββββββββββββββββββββ β
90. β 2020-09-14 β 4594 β ββββββββββββββββββββββββββββββββββββββββββββββ β
91. β 2020-09-21 β 4478 β βββββββββββββββββββββββββββββββββββββββββββββ β
92. β 2020-09-28 β 4382 β ββββββββββββββββββββββββββββββββββββββββββββ β
93. β 2020-10-05 β 4261 β βββββββββββββββββββββββββββββββββββββββββββ β
94. β 2020-10-12 β 4243 β βββββββββββββββββββββββββββββββββββββββββββ β
95. β 2020-10-19 β 3941 β ββββββββββββββββββββββββββββββββββββββββ β
96. β 2020-10-26 β 3616 β βββββββββββββββββββββββββββββββββββββ β
97. β 2020-11-02 β 3586 β ββββββββββββββββββββββββββββββββββββ β
98. β 2020-11-09 β 3403 β ββββββββββββββββββββββββββββββββββ β
99. β 2020-11-16 β 3336 β ββββββββββββββββββββββββββββββββββ β
100. β 2020-11-23 β 3230 β βββββββββββββββββββββββββββββββββ β
101. β 2020-11-30 β 3183 β ββββββββββββββββββββββββββββββββ β
102. β 2020-12-07 β 3285 β βββββββββββββββββββββββββββββββββ β
103. β 2020-12-14 β 3367 β ββββββββββββββββββββββββββββββββββ β
104. β 2020-12-21 β 3748 β ββββββββββββββββββββββββββββββββββββββ β
105. β 2020-12-28 β 3986 β ββββββββββββββββββββββββββββββββββββββββ β
106. β 2021-01-04 β 3906 β βββββββββββββββββββββββββββββββββββββββ β
107. β 2021-01-11 β 3425 β βββββββββββββββββββββββββββββββββββ β
108. β 2021-01-18 β 3144 β ββββββββββββββββββββββββββββββββ β
109. β 2021-01-25 β 3115 β ββββββββββββββββββββββββββββββββ β
110. β 2021-02-01 β 3285 β βββββββββββββββββββββββββββββββββ β
111. β 2021-02-08 β 3321 β ββββββββββββββββββββββββββββββββββ β
112. β 2021-02-15 β 3475 β βββββββββββββββββββββββββββββββββββ β
113. β 2021-02-22 β 3549 β ββββββββββββββββββββββββββββββββββββ β
114. β 2021-03-01 β 3755 β ββββββββββββββββββββββββββββββββββββββ β
115. β 2021-03-08 β 3080 β βββββββββββββββββββββββββββββββ β
116. β 2021-03-15 β 3789 β ββββββββββββββββββββββββββββββββββββββ β
117. β 2021-03-22 β 3804 β ββββββββββββββββββββββββββββββββββββββ β
118. β 2021-03-29 β 4238 β βββββββββββββββββββββββββββββββββββββββββββ β
119. β 2021-04-05 β 4307 β βββββββββββββββββββββββββββββββββββββββββββ β
120. β 2021-04-12 β 4225 β βββββββββββββββββββββββββββββββββββββββββββ β
121. β 2021-04-19 β 4391 β ββββββββββββββββββββββββββββββββββββββββββββ β
122. β 2021-04-26 β 4868 β βββββββββββββββββββββββββββββββββββββββββββββββββ β
123. β 2021-05-03 β 4977 β ββββββββββββββββββββββββββββββββββββββββββββββββββ β
124. β 2021-05-10 β 5164 β ββββββββββββββββββββββββββββββββββββββββββββββββββββ β
125. β 2021-05-17 β 4986 β ββββββββββββββββββββββββββββββββββββββββββββββββββ β
126. β 2021-05-24 β 5024 β βββββββββββββββββββββββββββββββββββββββββββββββββββ β
127. β 2021-05-31 β 4824 β βββββββββββββββββββββββββββββββββββββββββββββββββ β
128. β 2021-06-07 β 5652 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
129. β 2021-06-14 β 5613 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
130. β 2021-06-21 β 6061 β βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ β
131. β 2021-06-28 β 2554 β ββββββββββββββββββββββββββ β
ββββββββββββββ΄βββββββ΄βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Online Playgroundβ
You can test other queries to this data set using the interactive resource Online Playground. For example, like this. However, please note that you cannot create temporary tables here.