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-11-11 | 176037 | 173501 | 14.9917 | 11.4833 | -0.007556 | 0.445641 | 0 | 0 | 0 | 54 | 449 | 306 |
| 2019-11-12 | 227459 | 224756 | 16.1002 | 12.5333 | 0.118554 | 0.444307 | 0.04 | 0 | 0 | 41 | 486 | 406 |
| 2019-11-13 | 236824 | 233856 | 15.8288 | 12.65 | 0.103618 | 0.398548 | 0 | 0 | 0 | 28.5 | 528 | 396 |
| 2019-11-14 | 245644 | 242475 | 15.838 | 12.5833 | 0.089449 | 0.383116 | 0 | 0 | 0 | 36.5 | 492 | 369 |
| 2019-11-15 | 241982 | 238403 | 15.8381 | 12.4167 | 0.088214 | 0.388627 | 0 | 0 | 0 | 44 | 448 | 390 |
| 2019-11-16 | 244086 | 239657 | 13.6801 | 11.15 | 0.003038 | 0.417766 | 0 | 0 | 0 | 36.5 | 674 | 347 |
| 2019-11-17 | 196587 | 192396 | 13.3103 | 10.4833 | -0.105207 | 0.400798 | 0 | 0 | 0 | 36.5 | 598 | 265 |
| 2019-11-18 | 214366 | 211446 | 14.9849 | 11.45 | 0.016671 | 0.387082 | 0.48 | 0 | 0 | 39.5 | 396 | 479 |
| 2019-11-19 | 220877 | 218152 | 15.1046 | 12.0833 | 0.046325 | 0.385245 | 0.18 | 0 | 0 | 44 | 421 | 386 |
| 2019-11-20 | 234934 | 231826 | 15.2144 | 12.2833 | 0.062532 | 0.387716 | 0 | 0 | 0 | 44.5 | 454 | 347 |
| 2019-11-21 | 245542 | 242366 | 15.885 | 12.55 | 0.080597 | 0.382524 | 0 | 0 | 0 | 46 | 413 | 430 |
| 2019-11-22 | 232148 | 228775 | 15.1126 | 11.9333 | 0.066765 | 0.388266 | 0.07 | 0 | 0 | 45.5 | 375 | 404 |
| 2019-11-23 | 227111 | 223141 | 13.2434 | 10.9 | -0.035254 | 0.404986 | 0.03 | 0 | 0 | 39.5 | 559 | 337 |
| 2019-11-24 | 192647 | 188847 | 12.5121 | 10.05 | -0.122161 | 0.399629 | 0.9 | 0 | 0 | 43 | 483 | 346 |
| 2019-11-25 | 198053 | 195397 | 14.14 | 11.45 | -0.000909 | 0.383684 | 0 | 0 | 0 | 46 | 313 | 408 |
| 2019-11-26 | 210561 | 207676 | 15.9347 | 12.4667 | 0.094113 | 0.403832 | 0 | 0 | 0 | 52.5 | 327 | 440 |
| 2019-11-27 | 195654 | 192487 | 14.4391 | 11.4 | 0.018212 | 0.419278 | 0.04 | 0 | 0 | 54 | 365 | 375 |
| 2019-11-28 | 128783 | 124846 | 11.7576 | 9.2 | -0.220453 | 0.436393 | 0 | 0 | 0 | 45 | 288 | 246 |
| 2019-11-29 | 154451 | 151936 | 12.188 | 10 | -0.176203 | 0.40915 | 0 | 0 | 0 | 35 | 244 | 298 |
| 2019-11-30 | 179368 | 176171 | 13.6565 | 10.9667 | -0.104489 | 0.411746 | 0 | 0 | 0 | 37 | 307 | 296 |
| 2019-12-01 | 171561 | 168041 | 13.4025 | 10.4 | -0.138178 | 0.406573 | 0.62 | 0 | 0 | 34.5 | 81 | 280 |
| 2019-12-02 | 195262 | 192696 | 14.5659 | 11.1333 | -0.021519 | 0.394639 | 0.48 | 1.3 | 0 | 34 | 49 | 386 |
| 2019-12-03 | 234433 | 231510 | 15.545 | 12.1167 | 0.052606 | 0.388328 | 0.02 | 0.3 | 1.2 | 33 | 55 | 389 |
| 2019-12-04 | 235848 | 232726 | 16.3218 | 12.7833 | 0.106107 | 0.410175 | 0 | 0 | 0 | 35.5 | 57 | 355 |
| 2019-12-05 | 255406 | 251813 | 16.6869 | 12.8667 | 0.113538 | 0.396781 | 0 | 0 | 0 | 39 | 60 | 390 |