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-04-25 | 251758 | 247929 | 15.3381 | 12.2 | 0.047709 | 0.395991 | 0.02 | 0 | 0 | 57 | 923 | 341 |
| 2019-04-26 | 237754 | 233676 | 15.2613 | 11.95 | 0.076412 | 0.43243 | 1.03 | 0 | 0 | 55 | 829 | 336 |
| 2019-04-27 | 237673 | 232483 | 13.7598 | 10.9833 | -0.034575 | 0.433007 | 0.07 | 0 | 0 | 52.5 | 1092 | 342 |
| 2019-04-28 | 208912 | 203759 | 12.5958 | 10.05 | -0.161862 | 0.40259 | 0.01 | 0 | 0 | 49 | 1058 | 253 |
| 2019-04-29 | 215255 | 211845 | 13.9122 | 10.9333 | -0.07693 | 0.380661 | 0.01 | 0 | 0 | 50.5 | 900 | 375 |
| 2019-04-30 | 240019 | 236480 | 14.7692 | 11.7 | 0.000484 | 0.390263 | 0.04 | 0 | 0 | 54 | 916 | 367 |
| 2019-05-01 | 254726 | 250773 | 15.0033 | 11.85 | 0.026445 | 0.394191 | 0 | 0 | 0 | 53 | 989 | 397 |
| 2019-05-02 | 262388 | 258293 | 15.6534 | 12.2 | 0.058402 | 0.393593 | 0.01 | 0 | 0 | 64 | 1012 | 424 |
| 2019-05-03 | 259939 | 255551 | 15.273 | 11.8667 | 0.039147 | 0.394647 | 0.06 | 0 | 0 | 53 | 917 | 445 |
| 2019-05-04 | 251944 | 246583 | 13.2499 | 10.75 | -0.055987 | 0.409976 | 0.11 | 0 | 0 | 62 | 1215 | 349 |
| 2019-05-05 | 223080 | 217614 | 12.9094 | 9.7667 | -0.139735 | 0.414891 | 1.31 | 0 | 0 | 54.5 | 1113 | 337 |
| 2019-05-06 | 214763 | 211159 | 14.7972 | 11.2667 | -0.042544 | 0.393413 | 0 | 0 | 0 | 62.5 | 949 | 410 |
| 2019-05-07 | 236924 | 232908 | 14.7049 | 11.65 | 0.010287 | 0.387981 | 0.11 | 0 | 0 | 61 | 976 | 435 |
| 2019-05-08 | 242987 | 238608 | 15.635 | 12.2833 | 0.045136 | 0.394863 | 0 | 0 | 0 | 63 | 1039 | 409 |
| 2019-05-09 | 256230 | 251852 | 15.6702 | 12.4167 | 0.062879 | 0.390321 | 0 | 0 | 0 | 57 | 1054 | 386 |
| 2019-05-10 | 250433 | 245740 | 14.9889 | 11.6833 | 0.027471 | 0.383856 | 0.04 | 0 | 0 | 64.5 | 948 | 434 |
| 2019-05-11 | 239056 | 233512 | 13.1615 | 10.5167 | -0.076722 | 0.395328 | 0.04 | 0 | 0 | 62.5 | 1236 | 425 |
| 2019-05-12 | 212852 | 208040 | 12.9864 | 9.8333 | -0.133539 | 0.407417 | 1.32 | 0 | 0 | 51 | 1018 | 355 |
| 2019-05-13 | 228672 | 225184 | 15.5185 | 11.6167 | 0.031902 | 0.412358 | 0.7 | 0 | 0 | 45 | 938 | 392 |
| 2019-05-14 | 246153 | 242275 | 15.2018 | 12.0333 | 0.056959 | 0.388252 | 0.3 | 0 | 0 | 48 | 1001 | 414 |
| 2019-05-15 | 243375 | 239193 | 16.3041 | 12.45 | 0.077969 | 0.407917 | 0.01 | 0 | 0 | 56.5 | 1041 | 426 |
| 2019-05-16 | 247927 | 243456 | 17.1702 | 12.8833 | 0.117661 | 0.42431 | 0.12 | 0 | 0 | 62.5 | 1079 | 415 |
| 2019-05-17 | 255778 | 250732 | 16.3726 | 12.15 | 0.073178 | 0.410431 | 0.03 | 0 | 0 | 68 | 965 | 459 |
| 2019-05-18 | 242546 | 235919 | 14.4462 | 11.35 | -0.016562 | 0.420859 | 0 | 0 | 0 | 65.5 | 1323 | 416 |
| 2019-05-19 | 209750 | 203658 | 13.9832 | 10.75 | -0.111142 | 0.409353 | 0.06 | 0 | 0 | 68 | 1210 | 340 |