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-10-17 | 241726 | 238510 | 16.3523 | 12.9833 | 0.111181 | 0.392963 | 0 | 0 | 0 | 54 | 735 | 379 |
| 2019-10-18 | 244539 | 240523 | 16.3465 | 12.6333 | 0.09899 | 0.395379 | 0 | 0 | 0 | 52.5 | 674 | 397 |
| 2019-10-19 | 227116 | 222411 | 14.4602 | 11.6333 | 0.006112 | 0.422461 | 0 | 0 | 0 | 51.5 | 954 | 354 |
| 2019-10-20 | 201422 | 197258 | 13.8754 | 10.8167 | -0.086383 | 0.40578 | 0.54 | 0 | 0 | 54 | 835 | 298 |
| 2019-10-21 | 198623 | 195931 | 14.3194 | 11.4833 | -0.04355 | 0.376467 | 0 | 0 | 0 | 59 | 594 | 358 |
| 2019-10-22 | 225278 | 222629 | 14.9811 | 12.2167 | 0.055849 | 0.384081 | 0.57 | 0 | 0 | 59 | 680 | 347 |
| 2019-10-23 | 229163 | 226135 | 16.0645 | 12.6833 | 0.077383 | 0.385183 | 0.01 | 0 | 0 | 59.5 | 722 | 421 |
| 2019-10-24 | 238969 | 235763 | 16.9297 | 13.2 | 0.11976 | 0.387157 | 0 | 0 | 0 | 58.5 | 703 | 400 |
| 2019-10-25 | 237313 | 233708 | 15.9863 | 12.6 | 0.086698 | 0.384965 | 0 | 0 | 0 | 58.5 | 629 | 427 |
| 2019-10-26 | 231194 | 226288 | 14.4688 | 11.7417 | 0.022728 | 0.419069 | 0.01 | 0 | 0 | 57.5 | 911 | 331 |
| 2019-10-27 | 195626 | 190720 | 13.5879 | 10.9 | -0.08843 | 0.408691 | 1.38 | 0 | 0 | 61 | 783 | 295 |
| 2019-10-28 | 202323 | 199444 | 14.7766 | 11.75 | -0.018186 | 0.376869 | 0 | 0 | 0 | 59 | 558 | 387 |
| 2019-10-29 | 224312 | 221503 | 15.7405 | 12.6167 | 0.100597 | 0.394944 | 0.07 | 0 | 0 | 56.5 | 613 | 408 |
| 2019-10-30 | 227211 | 224244 | 15.2839 | 12.3333 | 0.065136 | 0.381327 | 0.06 | 0 | 0 | 60.5 | 673 | 389 |
| 2019-10-31 | 227120 | 223866 | 15.1023 | 12.0333 | 0.080605 | 0.416255 | 0.54 | 0 | 0 | 65.5 | 651 | 406 |
| 2019-11-01 | 259519 | 255212 | 15.6134 | 12.3833 | 0.103779 | 0.38956 | 0.11 | 0 | 0 | 56.5 | 559 | 522 |
| 2019-11-02 | 236084 | 231600 | 14.1701 | 11.6167 | 0.03003 | 0.419253 | 0 | 0 | 0 | 46.5 | 786 | 362 |
| 2019-11-03 | 196396 | 192013 | 13.4341 | 10.35 | -0.100726 | 0.464086 | 0 | 0 | 0 | 48 | 718 | 312 |
| 2019-11-04 | 204187 | 201272 | 15.2338 | 11.85 | -0.001309 | 0.379606 | 0 | 0 | 0 | 48.5 | 477 | 418 |
| 2019-11-05 | 215967 | 213228 | 14.5011 | 11.9167 | 0.014658 | 0.38267 | 0 | 0 | 0 | 56 | 514 | 294 |
| 2019-11-06 | 229947 | 226872 | 15.8913 | 12.7333 | 0.080202 | 0.385108 | 0 | 0 | 0 | 49.5 | 567 | 401 |
| 2019-11-07 | 242998 | 239730 | 16.7588 | 13.0833 | 0.129706 | 0.398978 | 0.1 | 0 | 0 | 49 | 545 | 438 |
| 2019-11-08 | 252856 | 249532 | 16.0117 | 12.6167 | 0.112698 | 0.394049 | 0 | 0 | 0 | 35 | 504 | 433 |
| 2019-11-09 | 231546 | 227349 | 14.5846 | 11.9167 | 0.042119 | 0.423673 | 0 | 0 | 0 | 34 | 716 | 331 |
| 2019-11-10 | 191601 | 187485 | 13.9377 | 11.1833 | -0.07745 | 0.401199 | 0 | 0 | 0 | 44.5 | 664 | 297 |