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-28 | 190855 | 187813 | 14.397 | 11.2667 | -0.038687 | 0.378024 | 0.08 | 0 | 0 | 70.5 | 735 | 338 |
| 2019-08-29 | 185297 | 182030 | 14.8159 | 11.3667 | -0.040574 | 0.379336 | 0 | 0 | 0 | 73 | 685 | 372 |
| 2019-08-30 | 177310 | 173382 | 14.2862 | 10.8833 | -0.082542 | 0.386857 | 0 | 0 | 0 | 76.5 | 559 | 396 |
| 2019-08-31 | 152884 | 148553 | 12.7506 | 10.2667 | -0.177422 | 0.403205 | 0 | 0 | 0 | 75 | 792 | 339 |
| 2019-09-01 | 139225 | 134955 | 13.3282 | 10.6 | -0.168038 | 0.414624 | 0 | 0 | 0 | 70.5 | 552 | 299 |
| 2019-09-02 | 127538 | 124665 | 12.1997 | 9.25 | -0.292657 | 0.393081 | 0.3 | 0 | 0 | 71.5 | 318 | 297 |
| 2019-09-03 | 186569 | 183358 | 14.7333 | 11.1667 | -0.05222 | 0.380299 | 0 | 0 | 0 | 74.5 | 459 | 421 |
| 2019-09-04 | 211718 | 208348 | 14.7369 | 11.7333 | 0.012312 | 0.383537 | 0 | 0 | 0 | 77.5 | 533 | 360 |
| 2019-09-05 | 226404 | 222938 | 15.0514 | 12.1333 | 0.0388 | 0.380601 | 0 | 0 | 0 | 69.5 | 553 | 424 |
| 2019-09-06 | 224697 | 221129 | 16.2212 | 12.5167 | 0.114392 | 0.408154 | 0.32 | 0 | 0 | 62.5 | 520 | 405 |
| 2019-09-07 | 203320 | 199017 | 14.2274 | 11.45 | 0.004469 | 0.422158 | 0.02 | 0 | 0 | 65.5 | 1089 | 328 |
| 2019-09-08 | 181665 | 177095 | 14.037 | 10.7 | -0.102613 | 0.419267 | 0 | 0 | 0 | 70 | 876 | 297 |
| 2019-09-09 | 200067 | 196958 | 14.5564 | 11.3667 | -0.037266 | 0.382926 | 0 | 0 | 0 | 71 | 544 | 388 |
| 2019-09-10 | 221837 | 218956 | 15.4583 | 12.1667 | 0.049838 | 0.401109 | 0.01 | 0 | 0 | 71 | 616 | 394 |
| 2019-09-11 | 228811 | 225666 | 14.9998 | 12.0167 | 0.042353 | 0.395489 | 0 | 0 | 0 | 78.5 | 664 | 407 |
| 2019-09-12 | 245352 | 242042 | 16.4686 | 12.95 | 0.124703 | 0.397217 | 0.17 | 0 | 0 | 71 | 679 | 476 |
| 2019-09-13 | 230554 | 226751 | 16.0461 | 12.4833 | 0.081166 | 0.389957 | 0 | 0 | 0 | 64.5 | 640 | 445 |
| 2019-09-14 | 217492 | 212769 | 14.1855 | 11.5167 | -0.01282 | 0.42113 | 0 | 0 | 0 | 67.5 | 1161 | 342 |
| 2019-09-15 | 191643 | 187099 | 14.3284 | 11.1 | -0.073717 | 0.417194 | 0 | 0 | 0 | 75 | 956 | 387 |
| 2019-09-16 | 205304 | 202186 | 15.1023 | 11.6667 | -0.00875 | 0.385945 | 0 | 0 | 0 | 72.5 | 599 | 414 |
| 2019-09-17 | 220351 | 217363 | 15.2277 | 11.9833 | 0.028835 | 0.382163 | 0 | 0 | 0 | 69 | 679 | 404 |
| 2019-09-18 | 227733 | 224413 | 15.6009 | 12.4333 | 0.057512 | 0.386257 | 0 | 0 | 0 | 63 | 713 | 408 |
| 2019-09-19 | 236176 | 232835 | 16.0712 | 12.6333 | 0.078125 | 0.386095 | 0 | 0 | 0 | 61 | 726 | 383 |
| 2019-09-20 | 229500 | 225859 | 16.1488 | 12.3833 | 0.079192 | 0.393979 | 0 | 0 | 0 | 67 | 690 | 462 |
| 2019-09-21 | 221513 | 216585 | 14.4394 | 11.5667 | -0.001327 | 0.417302 | 0 | 0 | 0 | 72.5 | 1166 | 356 |