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,400,876 |