Daily duration index
Per day: trips, mean minutes and the composition-adjusted duration index (mean log of minutes / route-hour median), with weather, events and collisions.
351 rows Download CSV
| dateTEXT | tripsINTEGER | indexed_tripsINTEGER | mean_minREAL | median_minREAL | mean_log_ratioREAL | sd_log_ratioREAL | precipitationREAL | snowREAL | snow_depthREAL | tavgREAL | eventsINTEGER | collisionsINTEGER |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019-06-14 | 228589 | 224015 | 15.6575 | 12.0667 | 0.043342 | 0.390151 | 0 | 0 | 0 | 65.5 | 989 | 493 |
| 2019-06-15 | 208755 | 203427 | 13.0415 | 10.45 | -0.103536 | 0.400445 | 0 | 0 | 0 | 70.5 | 1532 | 392 |
| 2019-06-16 | 177096 | 171992 | 13.1524 | 10.0167 | -0.184698 | 0.402666 | 0.04 | 0 | 0 | 72.5 | 1173 | 349 |
| 2019-06-17 | 203591 | 199901 | 14.9668 | 11.65 | -0.029609 | 0.380849 | 0 | 0 | 0 | 72.5 | 827 | 346 |
| 2019-06-18 | 229198 | 225515 | 16.0994 | 12.7333 | 0.109337 | 0.401434 | 0.79 | 0 | 0 | 70 | 891 | 459 |
| 2019-06-19 | 232890 | 229041 | 16.1086 | 12.7 | 0.086894 | 0.398977 | 0.11 | 0 | 0 | 68.5 | 956 | 400 |
| 2019-06-20 | 240757 | 236546 | 16.3517 | 12.6667 | 0.103049 | 0.409415 | 0.42 | 0 | 0 | 71.5 | 1001 | 434 |
| 2019-06-21 | 234216 | 229296 | 16.1918 | 12.1667 | 0.065093 | 0.406986 | 0.53 | 0 | 0 | 71 | 957 | 471 |
| 2019-06-22 | 208690 | 203603 | 14.1409 | 11.2333 | -0.049435 | 0.406829 | 0 | 0 | 0 | 70 | 1514 | 395 |
| 2019-06-23 | 188257 | 183040 | 13.7125 | 10.4333 | -0.153483 | 0.404096 | 0 | 0 | 0 | 73.5 | 1264 | 346 |
| 2019-06-24 | 205579 | 201819 | 15.1898 | 11.4333 | -0.036732 | 0.38956 | 0 | 0 | 0 | 75.5 | 774 | 487 |
| 2019-06-25 | 227453 | 223584 | 15.0111 | 11.7667 | 0.017015 | 0.387279 | 0.86 | 0 | 0 | 78 | 838 | 423 |
| 2019-06-26 | 235301 | 231313 | 16.2357 | 12.45 | 0.071068 | 0.401509 | 0 | 0 | 0 | 79.5 | 890 | 507 |
| 2019-06-27 | 239156 | 234927 | 16.7549 | 12.65 | 0.091246 | 0.40637 | 0 | 0 | 0 | 80 | 905 | 483 |
| 2019-06-28 | 227722 | 223218 | 15.7347 | 11.9833 | 0.051572 | 0.406455 | 0 | 0 | 0 | 81 | 814 | 487 |
| 2019-06-29 | 203727 | 198858 | 13.923 | 11.25 | -0.015431 | 0.411609 | 0.08 | 0 | 0 | 81.5 | 1401 | 418 |
| 2019-06-30 | 157106 | 152231 | 15.0498 | 11.4333 | -0.008689 | 0.468844 | 0.06 | 0 | 0 | 76 | 1126 | 366 |
| 2019-07-01 | 180480 | 176666 | 14.041 | 10.8667 | -0.069978 | 0.383464 | 0 | 0 | 0 | 75 | 803 | 418 |
| 2019-07-02 | 186329 | 182703 | 13.9358 | 10.9833 | -0.039777 | 0.38757 | 0.02 | 0 | 0 | 78 | 864 | 389 |
| 2019-07-03 | 168769 | 165160 | 15.1915 | 11.4 | 0.015589 | 0.441866 | 0 | 0 | 0 | 81 | 883 | 438 |
| 2019-07-04 | 115777 | 112327 | 11.6461 | 8.8333 | -0.297512 | 0.440258 | 0 | 0 | 0 | 82 | 794 | 260 |
| 2019-07-05 | 132534 | 129136 | 12.0482 | 9.7833 | -0.209091 | 0.391132 | 0 | 0 | 0 | 79 | 809 | 375 |
| 2019-07-06 | 143665 | 140189 | 12.32 | 10.0667 | -0.19783 | 0.407345 | 0 | 0 | 0 | 83 | 1183 | 300 |
| 2019-07-07 | 142709 | 138809 | 13.4912 | 10.2333 | -0.21636 | 0.398108 | 0 | 0 | 0 | 79 | 1070 | 274 |
| 2019-07-08 | 177974 | 174752 | 14.5431 | 11.1667 | -0.082489 | 0.373914 | 0.04 | 0 | 0 | 73 | 937 | 395 |