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-08-03 | 180760 | 176402 | 13.478 | 10.8667 | -0.077531 | 0.414485 | 0.21 | 0 | 0 | 77 | 1502 | 374 |
| 2019-08-04 | 161214 | 157186 | 13.3004 | 10.3667 | -0.166835 | 0.397228 | 0 | 0 | 0 | 78 | 1178 | 318 |
| 2019-08-05 | 177074 | 174206 | 14.377 | 11.2167 | -0.077238 | 0.374741 | 0 | 0 | 0 | 76 | 910 | 412 |
| 2019-08-06 | 203466 | 200273 | 14.3033 | 11.55 | -0.024566 | 0.375622 | 0.04 | 0 | 0 | 75 | 1055 | 347 |
| 2019-08-07 | 206463 | 203458 | 15.2583 | 12.3167 | 0.061933 | 0.401439 | 1.18 | 0 | 0 | 76.5 | 1051 | 381 |
| 2019-08-08 | 213676 | 210080 | 15.8596 | 12.2667 | 0.041031 | 0.391165 | 0.2 | 0 | 0 | 75.5 | 1069 | 434 |
| 2019-08-09 | 196135 | 192543 | 15.4729 | 11.8 | 0.004441 | 0.399933 | 0.08 | 0 | 0 | 75.5 | 926 | 409 |
| 2019-08-10 | 173160 | 168981 | 13.3218 | 10.6333 | -0.11759 | 0.400694 | 0 | 0 | 0 | 73.5 | 1535 | 379 |
| 2019-08-11 | 148551 | 144322 | 13.2574 | 10.1833 | -0.197616 | 0.40371 | 0 | 0 | 0 | 71.5 | 1209 | 298 |
| 2019-08-12 | 175402 | 172499 | 13.629 | 10.5667 | -0.134772 | 0.370391 | 0 | 0 | 0 | 76.5 | 884 | 386 |
| 2019-08-13 | 193803 | 191142 | 13.7509 | 11.2167 | -0.061436 | 0.372502 | 0.07 | 0 | 0 | 75 | 964 | 307 |
| 2019-08-14 | 199666 | 196724 | 14.5877 | 11.5667 | -0.017989 | 0.378031 | 0 | 0 | 0 | 78.5 | 996 | 360 |
| 2019-08-15 | 203336 | 200048 | 14.7699 | 11.8167 | -0.00687 | 0.371871 | 0 | 0 | 0 | 77.5 | 1021 | 365 |
| 2019-08-16 | 188223 | 184778 | 14.5683 | 11.5667 | -0.022916 | 0.389933 | 0 | 0 | 0 | 73.5 | 946 | 350 |
| 2019-08-17 | 175960 | 171556 | 13.4593 | 10.9667 | -0.092756 | 0.402693 | 0 | 0 | 0 | 80 | 1593 | 368 |
| 2019-08-18 | 159721 | 155488 | 13.1145 | 10.35 | -0.16116 | 0.404389 | 0.64 | 0 | 0 | 80 | 1163 | 308 |
| 2019-08-19 | 172614 | 169706 | 14.1508 | 10.7667 | -0.106793 | 0.383701 | 0 | 0 | 0 | 81 | 873 | 371 |
| 2019-08-20 | 188997 | 185977 | 13.9291 | 11.15 | -0.059205 | 0.374768 | 0 | 0 | 0 | 81.5 | 926 | 375 |
| 2019-08-21 | 199571 | 196558 | 13.9969 | 11.3833 | -0.033416 | 0.37781 | 0.1 | 0 | 0 | 80.5 | 963 | 353 |
| 2019-08-22 | 208833 | 205583 | 14.6619 | 11.5333 | 0.000015 | 0.385019 | 1.01 | 0 | 0 | 80.5 | 964 | 360 |
| 2019-08-23 | 184382 | 180865 | 14.5679 | 11.5167 | -0.0308 | 0.38422 | 0.09 | 0 | 0 | 69.5 | 909 | 354 |
| 2019-08-24 | 170249 | 165829 | 13.4694 | 10.8333 | -0.110722 | 0.402013 | 0 | 0 | 0 | 70 | 1577 | 325 |
| 2019-08-25 | 153670 | 149643 | 13.5473 | 10.6333 | -0.160586 | 0.396177 | 0 | 0 | 0 | 70 | 1058 | 307 |
| 2019-08-26 | 160204 | 157269 | 13.7747 | 10.75 | -0.123717 | 0.370937 | 0 | 0 | 0 | 67.5 | 684 | 334 |
| 2019-08-27 | 177759 | 174771 | 13.8458 | 11 | -0.082108 | 0.363953 | 0 | 0 | 0 | 68.5 | 689 | 325 |