| field | type |
|---|---|
| id | string |
| vehicle.trip.trip_id | string |
| vehicle.trip.start_time | string |
| vehicle.trip.start_date | string |
| vehicle.trip.schedule_relationship | bigint |
| vehicle.trip.route_id | string |
| vehicle.position.latitude | double |
| vehicle.position.longitude | double |
| vehicle.position.bearing | double |
| vehicle.position.speed | double |
| vehicle.timestamp | timestamp |
| vehicle.congestion_level | bigint |
| vehicle.vehicle.id | string |
| vehicle.occupancy_status | bigint |
| year | month | day | no. of observations |
|---|---|---|---|
| 2023 | 4 | 27 | 25,447 |
| 2023 | 4 | 28 | 1,984,393 |
| 2023 | 4 | 29 | 1,334,975 |
| 2023 | 4 | 30 | 1,669,310 |
| 2023 | 5 | 1 | 2,418,341 |
| 2023 | 5 | 2 | 2,452,609 |
| 2023 | 5 | 3 | 2,458,974 |
| 2023 | 5 | 4 | 2,443,405 |
| 2023 | 5 | 5 | 1,959,317 |
| 2023 | 5 | 6 | 1,314,568 |
| 2023 | 5 | 7 | 1,640,073 |
| 2023 | 5 | 8 | 2,403,930 |
| 2023 | 5 | 9 | 2,431,109 |
| 2023 | 5 | 10 | 2,444,982 |
| 2023 | 5 | 11 | 2,426,247 |
| 2023 | 5 | 12 | 1,963,728 |
| 2023 | 5 | 13 | 1,342,906 |
| 2023 | 5 | 14 | 1,628,274 |
| 2023 | 5 | 15 | 2,399,167 |
| 2023 | 5 | 16 | 2,428,725 |
| 2023 | 5 | 17 | 2,436,852 |
| 2023 | 5 | 18 | 2,411,381 |
| 2023 | 5 | 19 | 1,949,870 |
| 2023 | 5 | 20 | 1,310,794 |
| 2023 | 5 | 21 | 1,651,996 |
| 2023 | 5 | 22 | 2,410,253 |
| 2023 | 5 | 23 | 2,414,570 |
| 2023 | 5 | 24 | 2,442,754 |
| 2023 | 5 | 25 | 2,433,079 |
| 2023 | 5 | 26 | 1,940,692 |
| 2023 | 5 | 27 | 1,320,721 |
| 2023 | 5 | 28 | 1,657,204 |
| 2023 | 5 | 29 | 2,418,307 |
| 2023 | 5 | 30 | 2,444,292 |
| 2023 | 5 | 31 | 2,455,462 |
| 2023 | 6 | 1 | 2,428,326 |
| 2023 | 6 | 2 | 1,954,809 |
| 2023 | 6 | 3 | 1,269,985 |
| 2023 | 6 | 4 | 1,650,023 |
| 2023 | 6 | 5 | 2,431,516 |
| 2023 | 6 | 6 | 2,431,884 |
| 2023 | 6 | 7 | 2,460,234 |
| 2023 | 6 | 8 | 2,445,698 |
| 2023 | 6 | 9 | 1,950,031 |
| 2023 | 6 | 10 | 1,311,133 |
| 2023 | 6 | 11 | 1,081,120 |
| 2023 | 6 | 12 | 1,648,840 |
| 2023 | 6 | 13 | 2,665,594 |
| 2023 | 6 | 14 | 2,467,726 |
| 2023 | 6 | 15 | 2,457,365 |
| 2023 | 6 | 16 | 1,957,280 |
| 2023 | 6 | 17 | 1,302,765 |
| 2023 | 6 | 18 | 1,636,308 |
| 2023 | 6 | 19 | 2,377,701 |
| 2023 | 6 | 20 | 2,424,354 |
| 2023 | 6 | 21 | 2,423,516 |
| 2023 | 6 | 22 | 2,424,757 |
| 2023 | 6 | 23 | 1,937,645 |
| 2023 | 6 | 24 | 1,348,776 |
| 2023 | 6 | 25 | 1,678,292 |
| 2023 | 6 | 26 | 2,395,902 |
| 2023 | 6 | 27 | 2,410,586 |
| 2023 | 6 | 28 | 2,368,336 |
| 2023 | 6 | 29 | 2,394,987 |
| 2023 | 6 | 30 | 1,897,031 |
| 2023 | 7 | 1 | 1,256,095 |
| 2023 | 7 | 2 | 1,501,534 |
| 2023 | 7 | 3 | 2,097,833 |
| 2023 | 7 | 4 | 2,101,980 |
| 2023 | 7 | 5 | 2,133,491 |
| 2023 | 7 | 6 | 2,153,701 |
| 2023 | 7 | 7 | 1,790,896 |
| 2023 | 7 | 8 | 1,320,918 |
| 2023 | 7 | 9 | 1,546,477 |
| 2023 | 7 | 10 | 2,131,542 |
| 2023 | 7 | 11 | 2,147,914 |
| 2023 | 7 | 12 | 2,148,365 |
| 2023 | 7 | 13 | 2,122,306 |
| 2023 | 7 | 14 | 1,792,696 |
| 2023 | 7 | 15 | 1,311,614 |
| 2023 | 7 | 16 | 1,624,259 |
| 2023 | 7 | 17 | 2,354,031 |
| 2023 | 7 | 18 | 2,409,017 |
| 2023 | 7 | 19 | 2,405,782 |
| 2023 | 7 | 20 | 2,401,164 |
| 2023 | 7 | 21 | 1,928,930 |
| 2023 | 7 | 22 | 1,291,613 |
| 2023 | 7 | 23 | 1,642,421 |
| 2023 | 7 | 24 | 2,390,921 |
| 2023 | 7 | 25 | 2,404,809 |
| 2023 | 7 | 26 | 2,426,462 |
| 2023 | 7 | 27 | 2,411,524 |
| 2023 | 7 | 28 | 1,936,508 |
| 2023 | 7 | 29 | 1,318,287 |
| 2023 | 7 | 30 | 1,675,342 |
| 2023 | 7 | 31 | 2,408,143 |
| 2023 | 8 | 1 | 2,428,756 |
| 2023 | 8 | 2 | 2,425,913 |
| 2023 | 8 | 3 | 2,430,931 |
| 2023 | 8 | 4 | 1,951,266 |
| 2023 | 8 | 5 | 1,325,581 |
| 2023 | 8 | 6 | 1,670,869 |
| 2023 | 8 | 7 | 2,399,809 |
| 2023 | 8 | 8 | 2,410,934 |
| 2023 | 8 | 9 | 2,428,265 |
| 2023 | 8 | 10 | 2,423,670 |
| 2023 | 8 | 11 | 1,946,723 |
| 2023 | 8 | 12 | 1,300,746 |
| 2023 | 8 | 13 | 1,592,164 |
| 2023 | 8 | 14 | 2,402,674 |
| 2023 | 8 | 15 | 2,431,226 |
| 2023 | 8 | 16 | 2,423,722 |
| 2023 | 8 | 17 | 2,409,669 |
| 2023 | 8 | 18 | 1,945,996 |
| 2023 | 8 | 19 | 1,297,330 |
| 2023 | 8 | 20 | 1,652,312 |
| 2023 | 8 | 21 | 2,410,371 |
| 2023 | 8 | 22 | 2,434,503 |
| 2023 | 8 | 23 | 2,426,707 |
| 2023 | 8 | 24 | 2,411,790 |
| 2023 | 8 | 25 | 1,943,282 |
| 2023 | 8 | 26 | 1,312,087 |
| 2023 | 8 | 27 | 1,640,887 |
| 2023 | 8 | 28 | 2,388,317 |
| 2023 | 8 | 29 | 2,411,994 |
| 2023 | 8 | 30 | 2,435,322 |
| 2023 | 8 | 31 | 2,381,670 |
| 2023 | 9 | 1 | 1,925,767 |
| 2023 | 9 | 2 | 1,303,983 |
| 2023 | 9 | 3 | 1,626,039 |
| 2023 | 9 | 4 | 2,386,032 |
| 2023 | 9 | 5 | 2,416,089 |
| 2023 | 9 | 6 | 2,426,169 |
| 2023 | 9 | 7 | 2,434,628 |
| 2023 | 9 | 8 | 1,918,346 |
| 2023 | 9 | 9 | 1,299,051 |
| 2023 | 9 | 10 | 1,653,725 |
| 2023 | 9 | 11 | 2,406,933 |
| 2023 | 9 | 12 | 2,426,244 |
| 2023 | 9 | 13 | 2,440,734 |
| 2023 | 9 | 14 | 2,444,016 |
| 2023 | 9 | 15 | 1,970,616 |
| 2023 | 9 | 16 | 1,340,500 |
| 2023 | 9 | 17 | 1,673,282 |
| 2023 | 9 | 18 | 2,418,560 |
| 2023 | 9 | 19 | 2,427,784 |
| 2023 | 9 | 20 | 2,174,698 |
| 2023 | 9 | 21 | 2,426,093 |
| 2023 | 9 | 22 | 1,930,163 |
| 2023 | 9 | 23 | 1,316,961 |
| 2023 | 9 | 24 | 1,529,100 |
| 2023 | 9 | 25 | 2,141,149 |
| 2023 | 9 | 26 | 2,165,324 |
| 2023 | 9 | 27 | 2,167,007 |
| 2023 | 9 | 28 | 2,168,575 |
| 2023 | 9 | 29 | 1,810,344 |
| 2023 | 9 | 30 | 1,356,249 |
| 2023 | 10 | 1 | 1,092,757 |
| 2023 | 10 | 2 | 1,533,336 |
| 2023 | 10 | 3 | 2,137,776 |
| 2023 | 10 | 4 | 2,173,331 |
| 2023 | 10 | 5 | 2,175,983 |
| 2023 | 10 | 6 | 1,790,508 |
| 2023 | 10 | 7 | 1,302,630 |
| 2023 | 10 | 8 | 1,686,491 |
| 2023 | 10 | 9 | 2,414,327 |
| 2023 | 10 | 10 | 2,450,027 |
| 2023 | 10 | 11 | 2,458,058 |
| 2023 | 10 | 12 | 2,452,483 |
| 2023 | 10 | 13 | 1,967,172 |
| 2023 | 10 | 14 | 1,303,818 |
| 2023 | 10 | 15 | 1,697,657 |
| 2023 | 10 | 16 | 2,432,715 |
| 2023 | 10 | 17 | 2,440,461 |
| 2023 | 10 | 18 | 2,452,244 |
| 2023 | 10 | 19 | 2,440,342 |
| 2023 | 10 | 20 | 1,951,417 |
| 2023 | 10 | 21 | 1,297,768 |
| 2023 | 10 | 22 | 1,698,264 |
| 2023 | 10 | 23 | 2,429,328 |
| 2023 | 10 | 24 | 2,452,675 |
| 2023 | 10 | 25 | 2,454,431 |
| 2023 | 10 | 26 | 2,447,681 |
| 2023 | 10 | 27 | 1,950,746 |
| 2023 | 10 | 28 | 1,313,209 |
| 2023 | 10 | 29 | 1,714,144 |
| 2023 | 10 | 30 | 2,433,785 |
| 2023 | 10 | 31 | 2,449,421 |
| 2023 | 11 | 1 | 2,431,139 |
| 2023 | 11 | 2 | 2,452,647 |
| 2023 | 11 | 3 | 1,961,947 |
| 2023 | 11 | 4 | 1,329,580 |
| 2023 | 11 | 5 | 1,702,386 |
| 2023 | 11 | 6 | 2,404,332 |
| 2023 | 11 | 7 | 2,439,687 |
| 2023 | 11 | 8 | 2,439,732 |
| 2023 | 11 | 9 | 2,466,537 |
| 2023 | 11 | 10 | 1,971,301 |
| 2023 | 11 | 11 | 1,342,875 |
| 2023 | 11 | 12 | 1,686,538 |
| 2023 | 11 | 13 | 2,404,661 |
| 2023 | 11 | 14 | 2,440,070 |
| 2023 | 11 | 15 | 2,427,803 |
| 2023 | 11 | 16 | 2,442,827 |
| 2023 | 11 | 17 | 1,962,904 |
| 2023 | 11 | 18 | 1,334,241 |
| 2023 | 11 | 19 | 1,707,893 |
| 2023 | 11 | 20 | 2,421,921 |
| 2023 | 11 | 21 | 2,425,112 |
| 2023 | 11 | 22 | 2,456,457 |
| 2023 | 11 | 23 | 2,486,003 |
| 2023 | 11 | 24 | 1,981,872 |
| 2023 | 11 | 25 | 1,346,956 |
| 2023 | 11 | 26 | 1,714,286 |
| 2023 | 11 | 27 | 2,412,841 |
| 2023 | 11 | 28 | 2,434,319 |
| 2023 | 11 | 29 | 2,466,029 |
| 2023 | 11 | 30 | 2,451,838 |
| 2023 | 12 | 1 | 1,981,135 |
| 2023 | 12 | 2 | 1,351,704 |
| 2023 | 12 | 3 | 1,758,874 |
| 2023 | 12 | 4 | 2,448,075 |
| 2023 | 12 | 5 | 2,477,084 |
| 2023 | 12 | 6 | 2,500,680 |
| 2023 | 12 | 7 | 2,481,267 |
| 2023 | 12 | 8 | 1,969,574 |
| 2023 | 12 | 9 | 1,311,577 |
| 2023 | 12 | 10 | 1,722,935 |
| 2023 | 12 | 11 | 2,450,327 |
| 2023 | 12 | 12 | 2,471,916 |
| 2023 | 12 | 13 | 2,473,441 |
| 2023 | 12 | 14 | 2,452,972 |
| 2023 | 12 | 15 | 2,014,523 |
| 2023 | 12 | 16 | 1,414,203 |
| 2023 | 12 | 17 | 1,698,089 |
| 2023 | 12 | 18 | 2,291,540 |
| 2023 | 12 | 19 | 2,237,546 |
| 2023 | 12 | 20 | 2,177,489 |
| 2023 | 12 | 21 | 2,173,280 |
| 2023 | 12 | 22 | 1,800,439 |
| 2023 | 12 | 23 | 1,304,547 |
| 2023 | 12 | 24 | 1,056,187 |
| 2023 | 12 | 25 | 1,014,066 |
| 2023 | 12 | 26 | 1,424,194 |
| 2023 | 12 | 27 | 1,948,604 |
| 2023 | 12 | 28 | 2,006,792 |
| 2023 | 12 | 29 | 1,729,774 |
| 2023 | 12 | 30 | 1,312,578 |
| 2023 | 12 | 31 | 1,151,703 |
| 2024 | 1 | 1 | 1,443,088 |
| 2024 | 1 | 2 | 2,011,447 |
| 2024 | 1 | 3 | 2,035,837 |
| 2024 | 1 | 4 | 2,035,225 |
| 2024 | 1 | 5 | 1,725,450 |
| 2024 | 1 | 6 | 1,373,528 |
| 2024 | 1 | 7 | 1,605,596 |
| 2024 | 1 | 8 | 2,100,655 |
| 2024 | 1 | 9 | 2,127,000 |
| 2024 | 1 | 10 | 2,136,263 |
| 2024 | 1 | 11 | 2,137,515 |
| 2024 | 1 | 12 | 1,810,890 |
| 2024 | 1 | 13 | 1,355,639 |
| 2024 | 1 | 14 | 1,589,997 |
| 2024 | 1 | 15 | 2,100,572 |
| 2024 | 1 | 16 | 2,116,867 |
| 2024 | 1 | 17 | 2,153,145 |
| 2024 | 1 | 18 | 2,140,131 |
| 2024 | 1 | 19 | 1,817,341 |
| 2024 | 1 | 20 | 1,335,941 |
| 2024 | 1 | 21 | 1,575,468 |
| 2024 | 1 | 22 | 2,130,956 |
| 2024 | 1 | 23 | 2,137,319 |
| 2024 | 1 | 24 | 2,147,276 |
| 2024 | 1 | 25 | 1,680,888 |
| 2024 | 1 | 26 | 1,163,173 |
| 2024 | 1 | 27 | 1,258,165 |
| 2024 | 1 | 28 | 1,539,018 |
| 2024 | 1 | 29 | 2,198,307 |
| 2024 | 1 | 30 | 2,312,678 |
| 2024 | 1 | 31 | 2,341,075 |
| 2024 | 2 | 1 | 2,347,516 |
| 2024 | 2 | 2 | 1,944,678 |
| 2024 | 2 | 3 | 1,395,649 |
| 2024 | 2 | 4 | 1,719,533 |
| 2024 | 2 | 5 | 2,358,957 |
| 2024 | 2 | 6 | 2,350,051 |
| 2024 | 2 | 7 | 2,381,915 |
| 2024 | 2 | 8 | 2,359,491 |
| 2024 | 2 | 9 | 1,900,677 |
| 2024 | 2 | 10 | 1,306,306 |
| 2024 | 2 | 11 | 1,662,126 |
| 2024 | 2 | 12 | 2,343,221 |
| 2024 | 2 | 13 | 2,363,562 |
| 2024 | 2 | 14 | 2,381,105 |
| 2024 | 2 | 15 | 2,328,198 |
| 2024 | 2 | 16 | 1,877,593 |
| 2024 | 2 | 17 | 1,339,153 |
| 2024 | 2 | 18 | 1,667,292 |
| 2024 | 2 | 19 | 2,331,633 |
| 2024 | 2 | 20 | 2,323,303 |
| 2024 | 2 | 21 | 2,317,169 |
| 2024 | 2 | 22 | 2,337,942 |
| 2024 | 2 | 23 | 1,850,040 |
| 2024 | 2 | 24 | 1,259,163 |
| 2024 | 2 | 25 | 1,641,471 |
| 2024 | 2 | 26 | 2,321,579 |
| 2024 | 2 | 27 | 2,329,346 |
| 2024 | 2 | 28 | 2,342,684 |
| 2024 | 2 | 29 | 2,317,886 |
| 2024 | 3 | 1 | 1,896,073 |
| 2024 | 3 | 2 | 1,307,630 |
| 2024 | 3 | 3 | 1,644,153 |
| 2024 | 3 | 4 | 2,300,073 |
| 2024 | 3 | 5 | 2,333,019 |
| 2024 | 3 | 6 | 2,332,428 |
| 2024 | 3 | 7 | 2,324,460 |
| 2024 | 3 | 8 | 1,882,482 |
| 2024 | 3 | 9 | 1,335,341 |
| 2024 | 3 | 10 | 1,634,780 |
| 2024 | 3 | 11 | 2,241,945 |
| 2024 | 3 | 12 | 2,319,482 |
| 2024 | 3 | 13 | 2,349,451 |
| 2024 | 3 | 14 | 2,349,528 |
| 2024 | 3 | 15 | 1,904,538 |
| 2024 | 3 | 16 | 1,346,489 |
| 2024 | 3 | 17 | 1,680,263 |
| 2024 | 3 | 18 | 2,350,817 |
| 2024 | 3 | 19 | 2,418,178 |
| 2024 | 3 | 20 | 2,432,129 |
| 2024 | 3 | 21 | 2,443,556 |
| 2024 | 3 | 22 | 1,989,231 |
| 2024 | 3 | 23 | 1,392,847 |
| 2024 | 3 | 24 | 1,769,701 |
| 2024 | 3 | 25 | 2,047,389 |
| 2024 | 3 | 26 | 2,056,395 |
| 2024 | 3 | 27 | 2,294,885 |
| 2024 | 3 | 28 | 1,902,945 |
| 2024 | 3 | 29 | 1,202,593 |
| 2024 | 3 | 30 | 1,303,393 |
| 2024 | 3 | 31 | 1,109,237 |
| 2024 | 4 | 1 | 1,683,478 |
| 2024 | 4 | 2 | 2,392,452 |
| 2024 | 4 | 3 | 2,423,589 |
| 2024 | 4 | 4 | 2,448,499 |
| 2024 | 4 | 5 | 1,948,794 |
| 2024 | 4 | 6 | 1,316,442 |
| 2024 | 4 | 7 | 1,713,827 |
| 2024 | 4 | 8 | 2,425,073 |
| 2024 | 4 | 9 | 2,461,949 |
| 2024 | 4 | 10 | 2,440,809 |
| 2024 | 4 | 11 | 2,454,019 |
| 2024 | 4 | 12 | 1,991,420 |
| 2024 | 4 | 13 | 1,404,751 |
| 2024 | 4 | 14 | 1,603,079 |
| 2024 | 4 | 15 | 2,142,412 |
| 2024 | 4 | 16 | 2,172,492 |
| 2024 | 4 | 17 | 2,179,903 |
| 2024 | 4 | 18 | 2,184,372 |
| 2024 | 4 | 19 | 1,837,130 |
| 2024 | 4 | 20 | 1,359,507 |
| 2024 | 4 | 21 | 1,566,633 |
| 2024 | 4 | 22 | 2,141,212 |
| 2024 | 4 | 23 | 2,181,518 |
| 2024 | 4 | 24 | 1,755,652 |
| 2024 | 4 | 25 | 1,185,621 |