bookings
183,364 rows
This data as json, CSV (advanced)
Suggested facets: flight_date (date), booking_date (date)
Link | rowid ▼ | passenger_id | origin_airport | destination_airport | flight_date | booking_date | price |
---|---|---|---|---|---|---|---|
1 | 1 | 872246 | 3 | 2 | 2021-01-01 00:00:00 | 2020-12-25 00:00:00 | 151.77 |
2 | 2 | 131244 | 7 | 1 | 2021-01-01 00:00:00 | 2020-12-26 00:00:00 | 147.19 |
3 | 3 | 781453 | 7 | 6 | 2021-01-01 00:00:00 | 2020-11-17 00:00:00 | 150.45 |
4 | 4 | 895667 | 5 | 1 | 2021-01-01 00:00:00 | 2020-11-10 00:00:00 | 146.6 |
5 | 5 | 207175 | 3 | 4 | 2021-01-01 00:00:00 | 2020-12-26 00:00:00 | 148.8 |
6 | 6 | 865179 | 3 | 7 | 2021-01-01 00:00:00 | 2020-12-02 00:00:00 | 150.36 |
7 | 7 | 969693 | 10 | 9 | 2021-01-01 00:00:00 | 2020-11-21 00:00:00 | 151.19 |
8 | 8 | 148050 | 11 | 7 | 2021-01-01 00:00:00 | 2020-11-19 00:00:00 | 147.28 |
9 | 9 | 498591 | 1 | 7 | 2021-01-01 00:00:00 | 2020-12-14 00:00:00 | 149.53 |
10 | 10 | 802729 | 8 | 9 | 2021-01-01 00:00:00 | 2020-12-14 00:00:00 | 152.02 |
11 | 11 | 660086 | 7 | 2 | 2021-01-01 00:00:00 | 2020-11-15 00:00:00 | 147.45 |
12 | 12 | 821590 | 3 | 12 | 2021-01-01 00:00:00 | 2020-11-26 00:00:00 | 147.2 |
13 | 13 | 944151 | 1 | 2 | 2021-01-01 00:00:00 | 2020-12-11 00:00:00 | 149.01 |
14 | 14 | 322955 | 5 | 9 | 2021-01-01 00:00:00 | 2020-11-20 00:00:00 | 149.99 |
15 | 15 | 246413 | 12 | 3 | 2021-01-01 00:00:00 | 2020-12-16 00:00:00 | 152.45 |
16 | 16 | 518801 | 12 | 5 | 2021-01-01 00:00:00 | 2020-12-08 00:00:00 | 147.19 |
17 | 17 | 214975 | 11 | 1 | 2021-01-01 00:00:00 | 2020-12-22 00:00:00 | 151.27 |
18 | 18 | 500156 | 10 | 4 | 2021-01-01 00:00:00 | 2020-11-23 00:00:00 | 154.96 |
19 | 19 | 813328 | 11 | 1 | 2021-01-01 00:00:00 | 2020-11-15 00:00:00 | 146.15 |
20 | 20 | 216970 | 9 | 3 | 2021-01-01 00:00:00 | 2020-12-13 00:00:00 | 149.35 |
21 | 21 | 624902 | 6 | 9 | 2021-01-01 00:00:00 | 2020-11-13 00:00:00 | 146.79 |
22 | 22 | 738551 | 12 | 11 | 2021-01-01 00:00:00 | 2020-12-19 00:00:00 | 146.53 |
23 | 23 | 100599 | 11 | 5 | 2021-01-01 00:00:00 | 2020-11-23 00:00:00 | 148.24 |
24 | 24 | 351083 | 3 | 9 | 2021-01-01 00:00:00 | 2020-12-28 00:00:00 | 147.41 |
25 | 25 | 955662 | 7 | 11 | 2021-01-01 00:00:00 | 2020-12-27 00:00:00 | 154.78 |
26 | 26 | 676510 | 8 | 11 | 2021-01-01 00:00:00 | 2020-12-21 00:00:00 | 147.65 |
27 | 27 | 891952 | 10 | 5 | 2021-01-01 00:00:00 | 2020-11-15 00:00:00 | 151.9 |
28 | 28 | 491559 | 10 | 6 | 2021-01-01 00:00:00 | 2020-12-03 00:00:00 | 154.0 |
29 | 29 | 122056 | 2 | 4 | 2021-01-01 00:00:00 | 2020-11-24 00:00:00 | 150.54 |
30 | 30 | 340062 | 7 | 8 | 2021-01-01 00:00:00 | 2020-12-27 00:00:00 | 154.05 |
31 | 31 | 801474 | 7 | 3 | 2021-01-01 00:00:00 | 2020-11-30 00:00:00 | 147.14 |
32 | 32 | 922733 | 5 | 8 | 2021-01-01 00:00:00 | 2020-12-01 00:00:00 | 153.07 |
33 | 33 | 544154 | 1 | 9 | 2021-01-01 00:00:00 | 2020-12-05 00:00:00 | 149.67 |
34 | 34 | 203198 | 12 | 6 | 2021-01-01 00:00:00 | 2020-12-28 00:00:00 | 149.03 |
35 | 35 | 662336 | 1 | 3 | 2021-01-01 00:00:00 | 2020-12-03 00:00:00 | 146.4 |
36 | 36 | 564656 | 4 | 1 | 2021-01-01 00:00:00 | 2020-11-10 00:00:00 | 153.61 |
37 | 37 | 976638 | 7 | 5 | 2021-01-01 00:00:00 | 2020-12-31 00:00:00 | 154.69 |
38 | 38 | 604740 | 8 | 11 | 2021-01-01 00:00:00 | 2020-12-18 00:00:00 | 153.65 |
39 | 39 | 378085 | 8 | 11 | 2021-01-01 00:00:00 | 2020-11-02 00:00:00 | 152.84 |
40 | 40 | 921414 | 4 | 12 | 2021-01-01 00:00:00 | 2020-11-26 00:00:00 | 151.62 |
41 | 41 | 707314 | 2 | 1 | 2021-01-01 00:00:00 | 2020-11-14 00:00:00 | 150.42 |
42 | 42 | 627276 | 7 | 11 | 2021-01-01 00:00:00 | 2020-11-03 00:00:00 | 153.53 |
43 | 43 | 171849 | 5 | 2 | 2021-01-01 00:00:00 | 2020-11-23 00:00:00 | 145.68 |
44 | 44 | 358175 | 10 | 12 | 2021-01-01 00:00:00 | 2020-11-24 00:00:00 | 150.95 |
45 | 45 | 648177 | 10 | 5 | 2021-01-01 00:00:00 | 2020-12-11 00:00:00 | 154.35 |
46 | 46 | 515011 | 6 | 3 | 2021-01-01 00:00:00 | 2020-12-23 00:00:00 | 151.72 |
47 | 47 | 109767 | 3 | 7 | 2021-01-01 00:00:00 | 2020-12-02 00:00:00 | 151.21 |
48 | 48 | 630458 | 7 | 9 | 2021-01-01 00:00:00 | 2020-12-15 00:00:00 | 146.32 |
49 | 49 | 398830 | 1 | 9 | 2021-01-01 00:00:00 | 2020-12-21 00:00:00 | 149.38 |
50 | 50 | 654634 | 9 | 6 | 2021-01-01 00:00:00 | 2020-12-31 00:00:00 | 151.68 |
51 | 51 | 377312 | 12 | 8 | 2021-01-01 00:00:00 | 2020-12-24 00:00:00 | 153.9 |
52 | 52 | 320861 | 8 | 12 | 2021-01-01 00:00:00 | 2020-11-16 00:00:00 | 148.43 |
53 | 53 | 987204 | 9 | 3 | 2021-01-01 00:00:00 | 2020-12-28 00:00:00 | 145.92 |
54 | 54 | 908577 | 3 | 4 | 2021-01-01 00:00:00 | 2020-12-23 00:00:00 | 151.37 |
55 | 55 | 548462 | 6 | 12 | 2021-01-01 00:00:00 | 2020-11-26 00:00:00 | 145.1 |
56 | 56 | 137778 | 6 | 11 | 2021-01-01 00:00:00 | 2020-11-08 00:00:00 | 148.69 |
57 | 57 | 482364 | 10 | 9 | 2021-01-01 00:00:00 | 2020-11-04 00:00:00 | 154.33 |
58 | 58 | 815198 | 7 | 2 | 2021-01-01 00:00:00 | 2020-12-16 00:00:00 | 151.67 |
59 | 59 | 750810 | 5 | 10 | 2021-01-01 00:00:00 | 2020-11-14 00:00:00 | 146.55 |
60 | 60 | 532322 | 8 | 2 | 2021-01-01 00:00:00 | 2020-12-30 00:00:00 | 146.79 |
61 | 61 | 950132 | 10 | 6 | 2021-01-01 00:00:00 | 2020-12-16 00:00:00 | 147.67 |
62 | 62 | 593554 | 7 | 8 | 2021-01-01 00:00:00 | 2020-12-17 00:00:00 | 147.0 |
63 | 63 | 333752 | 9 | 8 | 2021-01-01 00:00:00 | 2020-12-30 00:00:00 | 151.6 |
64 | 64 | 468203 | 3 | 9 | 2021-01-01 00:00:00 | 2020-11-20 00:00:00 | 150.09 |
65 | 65 | 220944 | 11 | 7 | 2021-01-01 00:00:00 | 2020-11-05 00:00:00 | 154.7 |
66 | 66 | 555673 | 3 | 6 | 2021-01-01 00:00:00 | 2020-12-09 00:00:00 | 152.29 |
67 | 67 | 503906 | 5 | 7 | 2021-01-01 00:00:00 | 2020-11-04 00:00:00 | 150.77 |
68 | 68 | 945687 | 6 | 11 | 2021-01-01 00:00:00 | 2020-11-27 00:00:00 | 151.87 |
69 | 69 | 552248 | 12 | 3 | 2021-01-01 00:00:00 | 2020-12-27 00:00:00 | 154.49 |
70 | 70 | 854717 | 11 | 7 | 2021-01-01 00:00:00 | 2020-11-04 00:00:00 | 148.0 |
71 | 71 | 681343 | 4 | 3 | 2021-01-01 00:00:00 | 2020-12-23 00:00:00 | 146.92 |
72 | 72 | 745414 | 10 | 2 | 2021-01-01 00:00:00 | 2020-11-25 00:00:00 | 148.01 |
73 | 73 | 550770 | 7 | 9 | 2021-01-01 00:00:00 | 2020-11-11 00:00:00 | 150.8 |
74 | 74 | 324082 | 10 | 6 | 2021-01-01 00:00:00 | 2020-11-29 00:00:00 | 149.73 |
75 | 75 | 397571 | 12 | 7 | 2021-01-01 00:00:00 | 2020-11-29 00:00:00 | 151.64 |
76 | 76 | 805477 | 7 | 2 | 2021-01-01 00:00:00 | 2020-12-12 00:00:00 | 147.25 |
77 | 77 | 740967 | 1 | 5 | 2021-01-01 00:00:00 | 2020-11-07 00:00:00 | 152.68 |
78 | 78 | 830180 | 6 | 12 | 2021-01-01 00:00:00 | 2020-12-07 00:00:00 | 149.94 |
79 | 79 | 916232 | 6 | 7 | 2021-01-01 00:00:00 | 2020-12-04 00:00:00 | 147.19 |
80 | 80 | 684482 | 12 | 1 | 2021-01-01 00:00:00 | 2020-12-16 00:00:00 | 154.17 |
81 | 81 | 656932 | 2 | 12 | 2021-01-01 00:00:00 | 2020-11-26 00:00:00 | 150.95 |
82 | 82 | 629298 | 10 | 6 | 2021-01-01 00:00:00 | 2020-12-04 00:00:00 | 153.31 |
83 | 83 | 571932 | 8 | 4 | 2021-01-01 00:00:00 | 2020-12-15 00:00:00 | 152.52 |
84 | 84 | 608136 | 9 | 5 | 2021-01-01 00:00:00 | 2020-11-21 00:00:00 | 147.39 |
85 | 85 | 452161 | 6 | 3 | 2021-01-01 00:00:00 | 2020-12-11 00:00:00 | 153.93 |
86 | 86 | 840734 | 2 | 3 | 2021-01-01 00:00:00 | 2020-12-18 00:00:00 | 145.64 |
87 | 87 | 316881 | 5 | 7 | 2021-01-01 00:00:00 | 2020-11-08 00:00:00 | 149.2 |
88 | 88 | 998348 | 11 | 1 | 2021-01-01 00:00:00 | 2020-11-05 00:00:00 | 152.66 |
89 | 89 | 890075 | 1 | 9 | 2021-01-01 00:00:00 | 2020-12-07 00:00:00 | 153.53 |
90 | 90 | 672661 | 10 | 6 | 2021-01-01 00:00:00 | 2020-11-10 00:00:00 | 151.03 |
91 | 91 | 130434 | 2 | 5 | 2021-01-01 00:00:00 | 2020-12-07 00:00:00 | 148.36 |
92 | 92 | 233827 | 10 | 4 | 2021-01-01 00:00:00 | 2020-11-22 00:00:00 | 150.34 |
93 | 93 | 188025 | 11 | 1 | 2021-01-01 00:00:00 | 2020-11-20 00:00:00 | 149.29 |
94 | 94 | 443254 | 8 | 11 | 2021-01-01 00:00:00 | 2020-12-18 00:00:00 | 149.55 |
95 | 95 | 364525 | 4 | 5 | 2021-01-01 00:00:00 | 2020-11-08 00:00:00 | 145.82 |
96 | 96 | 335113 | 5 | 3 | 2021-01-01 00:00:00 | 2020-11-20 00:00:00 | 145.69 |
97 | 97 | 309044 | 7 | 2 | 2021-01-01 00:00:00 | 2020-11-08 00:00:00 | 145.2 |
98 | 98 | 691364 | 2 | 7 | 2021-01-01 00:00:00 | 2020-12-18 00:00:00 | 149.65 |
99 | 99 | 884256 | 3 | 6 | 2021-01-01 00:00:00 | 2020-11-16 00:00:00 | 146.15 |
100 | 100 | 427110 | 9 | 7 | 2021-01-01 00:00:00 | 2020-11-25 00:00:00 | 151.77 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "bookings" ("passenger_id" BIGINT, "origin_airport" BIGINT, "destination_airport" BIGINT, "flight_date" TIMESTAMP_NS, "booking_date" TIMESTAMP_NS, "price" DOUBLE);