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-03-06 | 269606 | 264556 | 14.7766 | 11.6833 | 0.033909 | 0.393985 | 0 | 0 | 1.2 | 22.5 | 134 | 374 |
| 2019-03-07 | 274945 | 269695 | 15.2121 | 11.8667 | 0.047104 | 0.392198 | 0 | 0 | 1.2 | 25 | 139 | 363 |
| 2019-03-08 | 269268 | 263631 | 15.1115 | 11.8333 | 0.048591 | 0.387179 | 0 | 0 | 0 | 31.5 | 126 | 403 |
| 2019-03-09 | 257768 | 251640 | 13.7165 | 11.0667 | -0.021052 | 0.415153 | 0 | 0 | 0 | 41.5 | 198 | 338 |
| 2019-03-10 | 216353 | 210398 | 13.2083 | 10.0167 | -0.126334 | 0.445578 | 0.54 | 0 | 0 | 39 | 194 | 305 |
| 2019-03-11 | 222689 | 218271 | 14.1939 | 10.9667 | -0.059691 | 0.383518 | 0 | 0 | 0 | 46 | 137 | 402 |
| 2019-03-12 | 253031 | 248495 | 14.3408 | 11.4 | -0.003754 | 0.382809 | 0 | 0 | 0 | 39 | 137 | 405 |
| 2019-03-13 | 255968 | 251089 | 14.6859 | 11.6 | 0.006062 | 0.376812 | 0 | 0 | 0 | 40.5 | 127 | 365 |
| 2019-03-14 | 264278 | 258769 | 15.2312 | 11.9667 | 0.031862 | 0.384373 | 0 | 0 | 0 | 49.5 | 134 | 401 |
| 2019-03-15 | 268585 | 262593 | 14.9343 | 11.5667 | 0.025475 | 0.388146 | 0.39 | 0 | 0 | 62 | 122 | 427 |
| 2019-03-16 | 255147 | 248509 | 14.1026 | 11.2167 | -0.002142 | 0.433185 | 0 | 0 | 0 | 47.5 | 139 | 345 |
| 2019-03-17 | 212140 | 205178 | 13.203 | 10.1833 | -0.129178 | 0.419409 | 0 | 0 | 0 | 39.5 | 421 | 261 |
| 2019-03-18 | 209417 | 204747 | 13.7124 | 10.5167 | -0.110485 | 0.374699 | 0 | 0 | 0 | 39 | 434 | 392 |
| 2019-03-19 | 225153 | 220189 | 14.1576 | 11.2 | -0.049021 | 0.372638 | 0 | 0 | 0 | 43 | 442 | 372 |
| 2019-03-20 | 236443 | 231406 | 14.4681 | 11.3667 | -0.030346 | 0.373021 | 0 | 0 | 0 | 45 | 476 | 374 |
| 2019-03-21 | 258938 | 253921 | 15.7016 | 12.1667 | 0.072856 | 0.401965 | 0.75 | 0 | 0 | 43.5 | 485 | 389 |
| 2019-03-22 | 256421 | 250975 | 14.505 | 11.3333 | 0.008038 | 0.38696 | 0.68 | 0 | 0 | 43.5 | 454 | 446 |
| 2019-03-23 | 241088 | 235208 | 13.0544 | 10.6 | -0.07117 | 0.407567 | 0 | 0 | 0 | 41.5 | 569 | 342 |
| 2019-03-24 | 197419 | 191583 | 13.5698 | 10.55 | -0.12626 | 0.401559 | 0 | 0 | 0 | 49 | 531 | 292 |
| 2019-03-25 | 200096 | 195412 | 13.7684 | 10.6 | -0.11483 | 0.370505 | 0 | 0 | 0 | 49 | 540 | 352 |
| 2019-03-26 | 226574 | 221782 | 14.2658 | 11.3 | -0.039085 | 0.383958 | 0 | 0 | 0 | 41 | 534 | 415 |
| 2019-03-27 | 236827 | 231767 | 14.62 | 11.6333 | -0.006107 | 0.386146 | 0 | 0 | 0 | 40.5 | 594 | 359 |
| 2019-03-28 | 246103 | 240797 | 15.156 | 11.85 | 0.013469 | 0.376225 | 0 | 0 | 0 | 45 | 602 | 403 |
| 2019-03-29 | 242603 | 237044 | 14.9042 | 11.7667 | 0.014716 | 0.383476 | 0 | 0 | 0 | 54 | 577 | 378 |
| 2019-03-30 | 236888 | 230441 | 13.8288 | 11.15 | -0.036802 | 0.418012 | 0 | 0 | 0 | 61 | 694 | 337 |