field | type |
---|---|
id | string |
vehicle.trip.trip_id | string |
vehicle.trip.start_date | string |
vehicle.trip.route_id | string |
vehicle.position.latitude | double |
vehicle.position.longitude | double |
vehicle.position.bearing | double |
vehicle.position.speed | double |
vehicle.current_stop_sequence | bigint |
vehicle.current_status | bigint |
vehicle.timestamp | timestamp |
vehicle.stop_id | string |
vehicle.vehicle.id | string |
vehicle.occupancy_status | double |
vehicle.trip.schedule_relationship | double |
year | month | day | no. of observations |
---|---|---|---|
2023 | 4 | 27 | 7,829 |
2023 | 4 | 28 | 738,889 |
2023 | 4 | 29 | 507,479 |
2023 | 4 | 30 | 457,540 |
2023 | 5 | 1 | 727,803 |
2023 | 5 | 2 | 747,851 |
2023 | 5 | 3 | 744,365 |
2023 | 5 | 4 | 739,739 |
2023 | 5 | 5 | 737,897 |
2023 | 5 | 6 | 502,233 |
2023 | 5 | 7 | 455,896 |
2023 | 5 | 8 | 703,004 |
2023 | 5 | 9 | 727,976 |
2023 | 5 | 10 | 740,407 |
2023 | 5 | 11 | 735,649 |
2023 | 5 | 12 | 733,136 |
2023 | 5 | 13 | 498,507 |
2023 | 5 | 14 | 446,379 |
2023 | 5 | 15 | 707,980 |
2023 | 5 | 16 | 742,519 |
2023 | 5 | 17 | 740,629 |
2023 | 5 | 18 | 731,545 |
2023 | 5 | 19 | 729,309 |
2023 | 5 | 20 | 493,400 |
2023 | 5 | 21 | 441,844 |
2023 | 5 | 22 | 689,313 |
2023 | 5 | 23 | 716,995 |
2023 | 5 | 24 | 725,500 |
2023 | 5 | 25 | 730,981 |
2023 | 5 | 26 | 730,995 |
2023 | 5 | 27 | 489,508 |
2023 | 5 | 28 | 449,626 |
2023 | 5 | 29 | 440,558 |
2023 | 5 | 30 | 714,736 |
2023 | 5 | 31 | 732,981 |
2023 | 6 | 1 | 740,180 |
2023 | 6 | 2 | 734,440 |
2023 | 6 | 3 | 499,734 |
2023 | 6 | 4 | 455,957 |
2023 | 6 | 5 | 716,953 |
2023 | 6 | 6 | 741,616 |
2023 | 6 | 7 | 735,372 |
2023 | 6 | 8 | 734,500 |
2023 | 6 | 9 | 729,371 |
2023 | 6 | 10 | 496,738 |
2023 | 6 | 11 | 445,560 |
2023 | 6 | 12 | 706,821 |
2023 | 6 | 13 | 728,743 |
2023 | 6 | 14 | 738,647 |
2023 | 6 | 15 | 728,343 |
2023 | 6 | 16 | 720,999 |
2023 | 6 | 17 | 489,032 |
2023 | 6 | 18 | 446,457 |
2023 | 6 | 19 | 483,064 |
2023 | 6 | 20 | 713,492 |
2023 | 6 | 21 | 728,733 |
2023 | 6 | 22 | 718,187 |
2023 | 6 | 23 | 680,695 |
2023 | 6 | 24 | 490,681 |
2023 | 6 | 25 | 444,160 |
2023 | 6 | 26 | 702,947 |
2023 | 6 | 27 | 736,492 |
2023 | 6 | 28 | 743,514 |
2023 | 6 | 29 | 753,151 |
2023 | 6 | 30 | 734,345 |
2023 | 7 | 1 | 521,130 |
2023 | 7 | 2 | 470,236 |
2023 | 7 | 3 | 699,031 |
2023 | 7 | 4 | 459,004 |
2023 | 7 | 5 | 681,754 |
2023 | 7 | 6 | 749,079 |
2023 | 7 | 7 | 742,329 |
2023 | 7 | 8 | 514,514 |
2023 | 7 | 9 | 468,784 |
2023 | 7 | 10 | 723,023 |
2023 | 7 | 11 | 752,856 |
2023 | 7 | 12 | 751,238 |
2023 | 7 | 13 | 748,206 |
2023 | 7 | 14 | 746,401 |
2023 | 7 | 15 | 512,750 |
2023 | 7 | 16 | 464,137 |
2023 | 7 | 17 | 725,851 |
2023 | 7 | 18 | 744,560 |
2023 | 7 | 19 | 749,983 |
2023 | 7 | 20 | 747,966 |
2023 | 7 | 21 | 734,139 |
2023 | 7 | 22 | 516,378 |
2023 | 7 | 23 | 468,645 |
2023 | 7 | 24 | 712,970 |
2023 | 7 | 25 | 744,259 |
2023 | 7 | 26 | 744,439 |
2023 | 7 | 27 | 744,248 |
2023 | 7 | 28 | 737,046 |
2023 | 7 | 29 | 504,011 |
2023 | 7 | 30 | 452,641 |
2023 | 7 | 31 | 704,655 |
2023 | 8 | 1 | 743,388 |
2023 | 8 | 2 | 738,901 |
2023 | 8 | 3 | 736,490 |
2023 | 8 | 4 | 736,293 |
2023 | 8 | 5 | 511,516 |
2023 | 8 | 6 | 442,292 |
2023 | 8 | 7 | 715,989 |
2023 | 8 | 8 | 740,772 |
2023 | 8 | 9 | 732,125 |
2023 | 8 | 10 | 745,174 |
2023 | 8 | 11 | 744,378 |
2023 | 8 | 12 | 512,845 |
2023 | 8 | 13 | 460,317 |
2023 | 8 | 14 | 718,495 |
2023 | 8 | 15 | 745,605 |
2023 | 8 | 16 | 740,824 |
2023 | 8 | 17 | 747,081 |
2023 | 8 | 18 | 738,888 |
2023 | 8 | 19 | 510,610 |
2023 | 8 | 20 | 459,830 |
2023 | 8 | 21 | 713,421 |
2023 | 8 | 22 | 741,195 |
2023 | 8 | 23 | 745,272 |
2023 | 8 | 24 | 744,235 |
2023 | 8 | 25 | 742,930 |
2023 | 8 | 26 | 515,110 |
2023 | 8 | 27 | 469,231 |
2023 | 8 | 28 | 715,985 |
2023 | 8 | 29 | 754,351 |
2023 | 8 | 30 | 746,891 |
2023 | 8 | 31 | 749,798 |
2023 | 9 | 1 | 750,015 |
2023 | 9 | 2 | 515,981 |
2023 | 9 | 3 | 467,180 |
2023 | 9 | 4 | 454,387 |
2023 | 9 | 5 | 725,686 |
2023 | 9 | 6 | 751,359 |
2023 | 9 | 7 | 751,921 |
2023 | 9 | 8 | 748,208 |
2023 | 9 | 9 | 507,566 |
2023 | 9 | 10 | 449,142 |
2023 | 9 | 11 | 719,134 |
2023 | 9 | 12 | 758,296 |
2023 | 9 | 13 | 748,181 |
2023 | 9 | 14 | 753,065 |
2023 | 9 | 15 | 742,819 |
2023 | 9 | 16 | 511,093 |
2023 | 9 | 17 | 456,812 |
2023 | 9 | 18 | 722,817 |
2023 | 9 | 19 | 738,396 |
2023 | 9 | 20 | 720,461 |
2023 | 9 | 21 | 727,742 |
2023 | 9 | 22 | 724,077 |
2023 | 9 | 23 | 495,762 |
2023 | 9 | 24 | 445,245 |
2023 | 9 | 25 | 701,421 |
2023 | 9 | 26 | 723,713 |
2023 | 9 | 27 | 723,095 |
2023 | 9 | 28 | 728,346 |
2023 | 9 | 29 | 719,442 |
2023 | 9 | 30 | 486,433 |
2023 | 10 | 1 | 447,399 |
2023 | 10 | 2 | 690,272 |
2023 | 10 | 3 | 726,841 |
2023 | 10 | 4 | 729,399 |
2023 | 10 | 5 | 729,883 |
2023 | 10 | 6 | 722,685 |
2023 | 10 | 7 | 492,056 |
2023 | 10 | 8 | 442,275 |
2023 | 10 | 9 | 489,888 |
2023 | 10 | 10 | 711,968 |
2023 | 10 | 11 | 727,655 |
2023 | 10 | 12 | 723,466 |
2023 | 10 | 13 | 719,641 |
2023 | 10 | 14 | 501,087 |
2023 | 10 | 15 | 447,266 |
2023 | 10 | 16 | 702,935 |
2023 | 10 | 17 | 731,548 |
2023 | 10 | 18 | 731,622 |
2023 | 10 | 19 | 727,818 |
2023 | 10 | 20 | 730,242 |
2023 | 10 | 21 | 509,106 |
2023 | 10 | 22 | 460,181 |
2023 | 10 | 23 | 717,134 |
2023 | 10 | 24 | 746,911 |
2023 | 10 | 25 | 753,833 |
2023 | 10 | 26 | 764,175 |
2023 | 10 | 27 | 756,265 |
2023 | 10 | 28 | 526,630 |
2023 | 10 | 29 | 473,414 |
2023 | 10 | 30 | 743,830 |
2023 | 10 | 31 | 763,073 |
2023 | 11 | 1 | 763,918 |
2023 | 11 | 2 | 761,017 |
2023 | 11 | 3 | 755,728 |
2023 | 11 | 4 | 517,085 |
2023 | 11 | 5 | 438,150 |
2023 | 11 | 6 | 728,304 |
2023 | 11 | 7 | 763,363 |
2023 | 11 | 8 | 767,697 |
2023 | 11 | 9 | 767,038 |
2023 | 11 | 10 | 582,804 |
2023 | 11 | 11 | 526,122 |
2023 | 11 | 12 | 478,499 |
2023 | 11 | 13 | 727,963 |
2023 | 11 | 14 | 761,462 |
2023 | 11 | 15 | 764,147 |
2023 | 11 | 16 | 765,332 |
2023 | 11 | 17 | 761,766 |
2023 | 11 | 18 | 532,182 |
2023 | 11 | 19 | 474,972 |
2023 | 11 | 20 | 723,200 |
2023 | 11 | 21 | 759,072 |
2023 | 11 | 22 | 752,834 |
2023 | 11 | 23 | 464,700 |
2023 | 11 | 24 | 696,810 |
2023 | 11 | 25 | 531,576 |
2023 | 11 | 26 | 473,410 |
2023 | 11 | 27 | 725,683 |
2023 | 11 | 28 | 759,925 |
2023 | 11 | 29 | 756,093 |
2023 | 11 | 30 | 761,084 |
2023 | 12 | 1 | 753,243 |
2023 | 12 | 2 | 526,053 |
2023 | 12 | 3 | 470,206 |
2023 | 12 | 4 | 726,233 |
2023 | 12 | 5 | 765,251 |
2023 | 12 | 6 | 764,167 |
2023 | 12 | 7 | 762,271 |
2023 | 12 | 8 | 157,635 |