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-12-06 | 258293 | 254605 | 15.9383 | 12.6 | 0.105379 | 0.398481 | 0 | 0 | 0 | 42 | 69 | 367 |
| 2019-12-07 | 252947 | 248463 | 14.7319 | 11.8667 | 0.055777 | 0.442912 | 0 | 0 | 0 | 34 | 133 | 353 |
| 2019-12-08 | 208863 | 204653 | 13.8444 | 10.95 | -0.071495 | 0.413029 | 0 | 0 | 0 | 37 | 115 | 299 |
| 2019-12-09 | 210883 | 208097 | 16.6123 | 12.4667 | 0.098433 | 0.419482 | 1.57 | 0 | 0 | 48.5 | 42 | 478 |
| 2019-12-10 | 231727 | 228790 | 16.6426 | 12.8833 | 0.127181 | 0.419098 | 0.13 | 0 | 0 | 48.5 | 42 | 438 |
| 2019-12-11 | 250753 | 247555 | 15.6289 | 12.45 | 0.092902 | 0.406001 | 0.26 | 0.2 | 0 | 35.5 | 63 | 390 |
| 2019-12-12 | 260803 | 257036 | 17.4147 | 13.3833 | 0.157173 | 0.418222 | 0 | 0 | 0 | 31 | 79 | 385 |
| 2019-12-13 | 260686 | 256507 | 17.2971 | 13.3833 | 0.188757 | 0.422665 | 0.81 | 0 | 0 | 40.5 | 53 | 491 |
| 2019-12-14 | 249104 | 244063 | 14.9689 | 12.05 | 0.069896 | 0.439835 | 1.16 | 0 | 0 | 50.5 | 123 | 362 |
| 2019-12-15 | 219580 | 214733 | 13.8075 | 10.9417 | -0.065056 | 0.416423 | 0 | 0 | 0 | 43 | 81 | 328 |
| 2019-12-16 | 221520 | 218733 | 14.814 | 11.7 | 0.033194 | 0.390444 | 0.1 | 0 | 0 | 35 | 42 | 341 |
| 2019-12-17 | 241136 | 237909 | 15.1453 | 11.9667 | 0.086759 | 0.403123 | 0.9 | 0 | 0 | 33.5 | 46 | 477 |
| 2019-12-18 | 250556 | 247168 | 15.5632 | 12.15 | 0.099746 | 0.412943 | 0.03 | 0.7 | 0 | 28.5 | 41 | 455 |
| 2019-12-19 | 269251 | 265292 | 15.6444 | 12.25 | 0.110933 | 0.411582 | 0 | 0 | 0 | 20.5 | 59 | 437 |
| 2019-12-20 | 257194 | 252776 | 15.2757 | 11.8333 | 0.080343 | 0.402784 | 0 | 0 | 0 | 27.5 | 56 | 453 |
| 2019-12-21 | 213563 | 209403 | 13.3546 | 10.7 | -0.045335 | 0.426382 | 0 | 0 | 0 | 29 | 100 | 336 |
| 2019-12-22 | 167117 | 163340 | 13.6979 | 10.7667 | -0.074139 | 0.44052 | 0 | 0 | 0 | 38 | 83 | 343 |
| 2019-12-23 | 168416 | 165589 | 14.4319 | 11.2167 | -0.021868 | 0.41312 | 0 | 0 | 0 | 49 | 54 | 397 |
| 2019-12-24 | 153057 | 149553 | 11.438 | 9.1 | -0.199625 | 0.397293 | 0 | 0 | 0 | 41.5 | 52 | 0 |
| 2019-12-25 | 94990 | 92081 | 11.9069 | 9.5667 | -0.262279 | 0.429284 | 0 | 0 | 0 | 39.5 | 46 | 0 |
| 2019-12-26 | 137547 | 135217 | 13.6811 | 10.85 | -0.138242 | 0.406481 | 0 | 0 | 0 | 41 | 54 | 0 |
| 2019-12-27 | 158694 | 155926 | 14.219 | 11.3833 | -0.078932 | 0.403565 | 0 | 0 | 0 | 50 | 60 | 0 |
| 2019-12-28 | 161928 | 158558 | 14.2069 | 11.4167 | -0.077732 | 0.447043 | 0 | 0 | 0 | 47 | 79 | 0 |
| 2019-12-29 | 154783 | 151341 | 13.7504 | 10.8667 | -0.12932 | 0.423048 | 0.25 | 0 | 0 | 41.5 | 62 | 0 |
| 2019-12-30 | 163258 | 160784 | 13.7047 | 10.6833 | -0.087231 | 0.395033 | 0.74 | 0 | 0 | 39 | 50 | 0 |