47,286 rows

View and edit SQL

datadate controlpoint arrivaldeparture resident number
2020-01-24 Airport Arrival Hong Kong Residents 20724
2020-01-24 Express Rail Link West Kowloon Arrival Hong Kong Residents 1717
2020-01-24 Hung Hom Arrival Hong Kong Residents 433
2020-01-24 Lo Wu Arrival Hong Kong Residents 26340
2020-01-24 Lok Ma Chau Spur Line Arrival Hong Kong Residents 16750
2020-01-24 Hong Kong-Zhuhai-Macao Bridge Arrival Hong Kong Residents 7294
2020-01-24 Lok Ma Chau Arrival Hong Kong Residents 10591
2020-01-24 Man Kam To Arrival Hong Kong Residents 1093
2020-01-24 Sha Tau Kok Arrival Hong Kong Residents 1008
2020-01-24 Shenzhen Bay Arrival Hong Kong Residents 8792
2020-01-24 China Ferry Terminal Arrival Hong Kong Residents 1013
2020-01-24 Harbour Control Arrival Hong Kong Residents 7
2020-01-24 Kai Tak Cruise Terminal Arrival Hong Kong Residents 466
2020-01-24 Macau Ferry Terminal Arrival Hong Kong Residents 6001
2020-01-24 Tuen Mun Ferry Terminal Arrival Hong Kong Residents 434
2020-01-24 Airport Arrival Mainland Visitors 9124
2020-01-24 Express Rail Link West Kowloon Arrival Mainland Visitors 2380
2020-01-24 Hung Hom Arrival Mainland Visitors 470
2020-01-24 Lo Wu Arrival Mainland Visitors 7383
2020-01-24 Lok Ma Chau Spur Line Arrival Mainland Visitors 4979
2020-01-24 Hong Kong-Zhuhai-Macao Bridge Arrival Mainland Visitors 1949
2020-01-24 Lok Ma Chau Arrival Mainland Visitors 2921
2020-01-24 Man Kam To Arrival Mainland Visitors 367
2020-01-24 Sha Tau Kok Arrival Mainland Visitors 264
2020-01-24 Shenzhen Bay Arrival Mainland Visitors 5354
2020-01-24 China Ferry Terminal Arrival Mainland Visitors 442
2020-01-24 Harbour Control Arrival Mainland Visitors 0
2020-01-24 Kai Tak Cruise Terminal Arrival Mainland Visitors 707
2020-01-24 Macau Ferry Terminal Arrival Mainland Visitors 358
2020-01-24 Tuen Mun Ferry Terminal Arrival Mainland Visitors 7
2020-01-24 Airport Arrival Other Visitors 14116
2020-01-24 Express Rail Link West Kowloon Arrival Other Visitors 337
2020-01-24 Hung Hom Arrival Other Visitors 71
2020-01-24 Lo Wu Arrival Other Visitors 429
2020-01-24 Lok Ma Chau Spur Line Arrival Other Visitors 196
2020-01-24 Hong Kong-Zhuhai-Macao Bridge Arrival Other Visitors 2130
2020-01-24 Lok Ma Chau Arrival Other Visitors 407
2020-01-24 Man Kam To Arrival Other Visitors 9
2020-01-24 Sha Tau Kok Arrival Other Visitors 27
2020-01-24 Shenzhen Bay Arrival Other Visitors 685
2020-01-24 China Ferry Terminal Arrival Other Visitors 373
2020-01-24 Harbour Control Arrival Other Visitors 259
2020-01-24 Kai Tak Cruise Terminal Arrival Other Visitors 2400
2020-01-24 Macau Ferry Terminal Arrival Other Visitors 1395
2020-01-24 Tuen Mun Ferry Terminal Arrival Other Visitors 38
2020-01-24 Airport Departure Hong Kong Residents 74876
2020-01-24 Express Rail Link West Kowloon Departure Hong Kong Residents 20096
2020-01-24 Hung Hom Departure Hong Kong Residents 3498
2020-01-24 Lo Wu Departure Hong Kong Residents 72074
2020-01-24 Lok Ma Chau Spur Line Departure Hong Kong Residents 32215
2020-01-24 Hong Kong-Zhuhai-Macao Bridge Departure Hong Kong Residents 15775
2020-01-24 Lok Ma Chau Departure Hong Kong Residents 17682
2020-01-24 Man Kam To Departure Hong Kong Residents 1890
2020-01-24 Sha Tau Kok Departure Hong Kong Residents 3207
2020-01-24 Shenzhen Bay Departure Hong Kong Residents 37864
2020-01-24 China Ferry Terminal Departure Hong Kong Residents 3511
2020-01-24 Harbour Control Departure Hong Kong Residents 77
2020-01-24 Kai Tak Cruise Terminal Departure Hong Kong Residents 2487
2020-01-24 Macau Ferry Terminal Departure Hong Kong Residents 8985
2020-01-24 Tuen Mun Ferry Terminal Departure Hong Kong Residents 548
2020-01-24 Airport Departure Mainland Visitors 4451
2020-01-24 Express Rail Link West Kowloon Departure Mainland Visitors 2800
2020-01-24 Hung Hom Departure Mainland Visitors 194
2020-01-24 Lo Wu Departure Mainland Visitors 6231
2020-01-24 Lok Ma Chau Spur Line Departure Mainland Visitors 3766
2020-01-24 Hong Kong-Zhuhai-Macao Bridge Departure Mainland Visitors 2804
2020-01-24 Lok Ma Chau Departure Mainland Visitors 3901
2020-01-24 Man Kam To Departure Mainland Visitors 219
2020-01-24 Sha Tau Kok Departure Mainland Visitors 210
2020-01-24 Shenzhen Bay Departure Mainland Visitors 5142
2020-01-24 China Ferry Terminal Departure Mainland Visitors 453
2020-01-24 Harbour Control Departure Mainland Visitors 0
2020-01-24 Kai Tak Cruise Terminal Departure Mainland Visitors 775
2020-01-24 Macau Ferry Terminal Departure Mainland Visitors 390
2020-01-24 Tuen Mun Ferry Terminal Departure Mainland Visitors 4
2020-01-24 Airport Departure Other Visitors 7242
2020-01-24 Express Rail Link West Kowloon Departure Other Visitors 316
2020-01-24 Hung Hom Departure Other Visitors 51
2020-01-24 Lo Wu Departure Other Visitors 413
2020-01-24 Lok Ma Chau Spur Line Departure Other Visitors 167
2020-01-24 Hong Kong-Zhuhai-Macao Bridge Departure Other Visitors 2086
2020-01-24 Lok Ma Chau Departure Other Visitors 283
2020-01-24 Man Kam To Departure Other Visitors 9
2020-01-24 Sha Tau Kok Departure Other Visitors 40
2020-01-24 Shenzhen Bay Departure Other Visitors 484
2020-01-24 China Ferry Terminal Departure Other Visitors 312
2020-01-24 Harbour Control Departure Other Visitors 4
2020-01-24 Kai Tak Cruise Terminal Departure Other Visitors 280
2020-01-24 Macau Ferry Terminal Departure Other Visitors 1314
2020-01-24 Tuen Mun Ferry Terminal Departure Other Visitors 17
2020-01-25 Airport Arrival Hong Kong Residents 14907
2020-01-25 Express Rail Link West Kowloon Arrival Hong Kong Residents 1852
2020-01-25 Hung Hom Arrival Hong Kong Residents 575
2020-01-25 Lo Wu Arrival Hong Kong Residents 20716
2020-01-25 Lok Ma Chau Spur Line Arrival Hong Kong Residents 12511
2020-01-25 Hong Kong-Zhuhai-Macao Bridge Arrival Hong Kong Residents 9121
2020-01-25 Lok Ma Chau Arrival Hong Kong Residents 7187
2020-01-25 Man Kam To Arrival Hong Kong Residents 753
2020-01-25 Sha Tau Kok Arrival Hong Kong Residents 923
2020-01-25 Shenzhen Bay Arrival Hong Kong Residents 9834

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW immdpassengers AS select substr(datadate, 1, 4) || '-' || substr(datadate, 5, 2) || '-' || substr(datadate, 7, 2) as datadate, controlpoint, arrivaldeparture, resident, cast(replace(number, ',', '') as number) as number from immdpassengertraffic where controlpoint <> 'Total' and resident <> 'Total' order by datadate;