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-07-09 | 203105 | 199851 | 14.6143 | 11.6833 | -0.017531 | 0.377216 | 0 | 0 | 0 | 78 | 1015 | 422 |
| 2019-07-10 | 220038 | 216415 | 14.5537 | 11.6333 | -0.006912 | 0.378864 | 0 | 0 | 0 | 81 | 1068 | 366 |
| 2019-07-11 | 225315 | 221820 | 15.9604 | 12.5667 | 0.100107 | 0.407625 | 0.79 | 0 | 0 | 80 | 1077 | 443 |
| 2019-07-12 | 204395 | 200393 | 16.001 | 12.15 | 0.047114 | 0.4183 | 0 | 0 | 0 | 79.5 | 972 | 468 |
| 2019-07-13 | 200110 | 193896 | 14.4076 | 11.5167 | -0.053275 | 0.429479 | 0 | 0 | 0 | 77.5 | 1513 | 346 |
| 2019-07-14 | 166783 | 162128 | 13.236 | 10.1667 | -0.181707 | 0.399823 | 0 | 0 | 0 | 82.5 | 1204 | 313 |
| 2019-07-15 | 187930 | 184669 | 14.5706 | 11.3333 | -0.060851 | 0.376535 | 0 | 0 | 0 | 76.5 | 956 | 433 |
| 2019-07-16 | 216609 | 213123 | 15.1009 | 11.9 | 0.019368 | 0.394101 | 0 | 0 | 0 | 81.5 | 1055 | 458 |
| 2019-07-17 | 233973 | 230378 | 15.2492 | 12.2333 | 0.072657 | 0.397303 | 1.82 | 0 | 0 | 83 | 1102 | 408 |
| 2019-07-18 | 223431 | 219791 | 16.1096 | 12.7 | 0.074814 | 0.395084 | 0.51 | 0 | 0 | 75 | 1080 | 428 |
| 2019-07-19 | 226097 | 221302 | 15.0871 | 11.7667 | 0.009881 | 0.395197 | 0 | 0 | 0 | 81 | 977 | 437 |
| 2019-07-20 | 187242 | 182903 | 12.384 | 10.0667 | -0.15043 | 0.399344 | 0 | 0 | 0 | 88.5 | 1466 | 386 |
| 2019-07-21 | 168581 | 164632 | 12.2951 | 9.6667 | -0.214698 | 0.395801 | 0 | 0 | 0 | 87.5 | 1152 | 314 |
| 2019-07-22 | 201238 | 197642 | 14.7075 | 11.4667 | -0.021578 | 0.385854 | 1.66 | 0 | 0 | 81 | 947 | 410 |
| 2019-07-23 | 210216 | 207133 | 14.8827 | 11.8833 | 0.00119 | 0.374082 | 0.53 | 0 | 0 | 70.5 | 1032 | 363 |
| 2019-07-24 | 217412 | 213880 | 15.3871 | 12.3333 | 0.034707 | 0.381907 | 0.02 | 0 | 0 | 75 | 1103 | 422 |
| 2019-07-25 | 222997 | 219297 | 15.9488 | 12.5333 | 0.058502 | 0.384697 | 0 | 0 | 0 | 77 | 1116 | 388 |
| 2019-07-26 | 203529 | 199587 | 15.8253 | 12.2 | 0.047555 | 0.404987 | 0 | 0 | 0 | 78.5 | 971 | 412 |
| 2019-07-27 | 183267 | 178689 | 13.3318 | 10.7833 | -0.098863 | 0.403221 | 0 | 0 | 0 | 78.5 | 1563 | 376 |
| 2019-07-28 | 165724 | 161314 | 13.4574 | 10.35 | -0.160626 | 0.400345 | 0.01 | 0 | 0 | 79.5 | 1199 | 366 |
| 2019-07-29 | 185573 | 182516 | 14.1107 | 10.9833 | -0.076242 | 0.372828 | 0 | 0 | 0 | 81.5 | 930 | 442 |
| 2019-07-30 | 209645 | 206478 | 14.8408 | 11.75 | 0.017063 | 0.391363 | 0.01 | 0 | 0 | 85 | 1032 | 409 |
| 2019-07-31 | 211564 | 208171 | 15.5828 | 12.3833 | 0.067238 | 0.400185 | 0.36 | 0 | 0 | 78.5 | 1091 | 384 |
| 2019-08-01 | 219356 | 215694 | 15.7417 | 12.3333 | 0.037252 | 0.381326 | 0 | 0 | 0 | 78.5 | 1084 | 397 |
| 2019-08-02 | 201597 | 197624 | 14.8756 | 11.75 | 0.00214 | 0.38936 | 0 | 0 | 0 | 78.5 | 956 | 390 |