| 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 | 756,074 |
| 2023 | 12 | 9 | 528,167 |
| 2023 | 12 | 10 | 465,014 |
| 2023 | 12 | 11 | 721,922 |
| 2023 | 12 | 12 | 765,025 |
| 2023 | 12 | 13 | 771,406 |
| 2023 | 12 | 14 | 765,371 |
| 2023 | 12 | 15 | 757,899 |
| 2023 | 12 | 16 | 525,997 |
| 2023 | 12 | 17 | 482,745 |
| 2023 | 12 | 18 | 740,927 |
| 2023 | 12 | 19 | 769,653 |
| 2023 | 12 | 20 | 757,343 |
| 2023 | 12 | 21 | 760,067 |
| 2023 | 12 | 22 | 754,762 |
| 2023 | 12 | 23 | 539,890 |
| 2023 | 12 | 24 | 484,840 |
| 2023 | 12 | 25 | 446,657 |
| 2023 | 12 | 26 | 717,147 |
| 2023 | 12 | 27 | 767,695 |
| 2023 | 12 | 28 | 773,697 |
| 2023 | 12 | 29 | 778,698 |
| 2023 | 12 | 30 | 556,121 |
| 2023 | 12 | 31 | 492,147 |
| 2024 | 1 | 1 | 453,390 |
| 2024 | 1 | 2 | 728,465 |
| 2024 | 1 | 3 | 775,287 |
| 2024 | 1 | 4 | 789,181 |
| 2024 | 1 | 5 | 785,318 |
| 2024 | 1 | 6 | 549,959 |
| 2024 | 1 | 7 | 492,751 |
| 2024 | 1 | 8 | 748,093 |
| 2024 | 1 | 9 | 782,382 |
| 2024 | 1 | 10 | 776,155 |
| 2024 | 1 | 11 | 780,853 |
| 2024 | 1 | 12 | 786,183 |
| 2024 | 1 | 13 | 549,613 |
| 2024 | 1 | 14 | 498,847 |
| 2024 | 1 | 15 | 485,346 |
| 2024 | 1 | 16 | 426,257 |
| 2024 | 1 | 17 | 710,109 |
| 2024 | 1 | 18 | 776,690 |
| 2024 | 1 | 19 | 563,063 |
| 2024 | 1 | 20 | 478,107 |
| 2024 | 1 | 21 | 486,284 |
| 2024 | 1 | 22 | 742,500 |
| 2024 | 1 | 23 | 781,520 |
| 2024 | 1 | 24 | 775,117 |
| 2024 | 1 | 25 | 772,275 |
| 2024 | 1 | 26 | 767,087 |
| 2024 | 1 | 27 | 543,422 |
| 2024 | 1 | 28 | 489,004 |
| 2024 | 1 | 29 | 744,924 |
| 2024 | 1 | 30 | 784,269 |
| 2024 | 1 | 31 | 786,209 |
| 2024 | 2 | 1 | 780,292 |
| 2024 | 2 | 2 | 779,158 |
| 2024 | 2 | 3 | 549,527 |
| 2024 | 2 | 4 | 490,980 |
| 2024 | 2 | 5 | 744,327 |
| 2024 | 2 | 6 | 778,581 |
| 2024 | 2 | 7 | 776,035 |
| 2024 | 2 | 8 | 776,087 |
| 2024 | 2 | 9 | 763,985 |
| 2024 | 2 | 10 | 546,792 |
| 2024 | 2 | 11 | 479,826 |
| 2024 | 2 | 12 | 725,095 |
| 2024 | 2 | 13 | 768,791 |
| 2024 | 2 | 14 | 769,479 |
| 2024 | 2 | 15 | 767,233 |
| 2024 | 2 | 16 | 767,492 |
| 2024 | 2 | 17 | 538,317 |
| 2024 | 2 | 18 | 485,409 |
| 2024 | 2 | 19 | 519,553 |
| 2024 | 2 | 20 | 750,664 |
| 2024 | 2 | 21 | 773,806 |
| 2024 | 2 | 22 | 756,859 |
| 2024 | 2 | 23 | 780,858 |
| 2024 | 2 | 24 | 545,697 |
| 2024 | 2 | 25 | 487,030 |
| 2024 | 2 | 26 | 741,235 |
| 2024 | 2 | 27 | 788,773 |
| 2024 | 2 | 28 | 786,026 |
| 2024 | 2 | 29 | 780,853 |
| 2024 | 3 | 1 | 776,623 |
| 2024 | 3 | 2 | 549,109 |
| 2024 | 3 | 3 | 495,638 |
| 2024 | 3 | 4 | 750,779 |
| 2024 | 3 | 5 | 785,052 |
| 2024 | 3 | 6 | 789,562 |
| 2024 | 3 | 7 | 783,627 |
| 2024 | 3 | 8 | 775,827 |
| 2024 | 3 | 9 | 556,949 |
| 2024 | 3 | 10 | 503,796 |
| 2024 | 3 | 11 | 758,035 |
| 2024 | 3 | 12 | 788,875 |
| 2024 | 3 | 13 | 789,118 |
| 2024 | 3 | 14 | 778,782 |
| 2024 | 3 | 15 | 774,855 |
| 2024 | 3 | 16 | 515,389 |
| 2024 | 3 | 17 | 492,517 |
| 2024 | 3 | 18 | 657,836 |
| 2024 | 3 | 19 | 789,265 |
| 2024 | 3 | 20 | 786,986 |
| 2024 | 3 | 21 | 781,956 |
| 2024 | 3 | 22 | 778,835 |
| 2024 | 3 | 23 | 536,737 |
| 2024 | 3 | 24 | 490,190 |
| 2024 | 3 | 25 | 764,413 |
| 2024 | 3 | 26 | 784,569 |
| 2024 | 3 | 27 | 785,422 |
| 2024 | 3 | 28 | 783,919 |
| 2024 | 3 | 29 | 773,972 |
| 2024 | 3 | 30 | 544,956 |
| 2024 | 3 | 31 | 489,317 |
| 2024 | 4 | 1 | 754,295 |
| 2024 | 4 | 2 | 783,877 |
| 2024 | 4 | 3 | 784,278 |
| 2024 | 4 | 4 | 791,873 |
| 2024 | 4 | 5 | 779,300 |
| 2024 | 4 | 6 | 543,216 |
| 2024 | 4 | 7 | 492,612 |
| 2024 | 4 | 8 | 761,297 |
| 2024 | 4 | 9 | 788,195 |
| 2024 | 4 | 10 | 786,724 |
| 2024 | 4 | 11 | 792,837 |
| 2024 | 4 | 12 | 781,114 |
| 2024 | 4 | 13 | 546,279 |
| 2024 | 4 | 14 | 493,239 |
| 2024 | 4 | 15 | 751,905 |
| 2024 | 4 | 16 | 777,006 |
| 2024 | 4 | 17 | 783,800 |
| 2024 | 4 | 18 | 785,626 |
| 2024 | 4 | 19 | 779,550 |
| 2024 | 4 | 20 | 93,613 |