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-31 | 210513 | 204610 | 12.7747 | 9.9333 | -0.146029 | 0.397996 | 0.06 | 0 | 0 | 52 | 676 | 282 |
| 2019-04-01 | 219875 | 214962 | 13.9327 | 10.7167 | -0.078363 | 0.383541 | 0 | 0 | 0 | 39.5 | 693 | 382 |
| 2019-04-02 | 243993 | 239176 | 14.2633 | 11.4167 | -0.017235 | 0.377704 | 0 | 0 | 0 | 45.5 | 694 | 349 |
| 2019-04-03 | 249432 | 244185 | 14.9044 | 11.8 | 0.009886 | 0.381925 | 0 | 0 | 0 | 54 | 769 | 392 |
| 2019-04-04 | 261905 | 256232 | 15.7138 | 12.1167 | 0.049983 | 0.386013 | 0 | 0 | 0 | 52 | 776 | 418 |
| 2019-04-05 | 276379 | 270577 | 15.5476 | 12.0167 | 0.084765 | 0.395227 | 0.2 | 0 | 0 | 41.5 | 723 | 459 |
| 2019-04-06 | 246887 | 240672 | 13.6922 | 11.0333 | -0.039317 | 0.411569 | 0 | 0 | 0 | 53.5 | 898 | 367 |
| 2019-04-07 | 209123 | 202817 | 13.4732 | 10.35 | -0.138135 | 0.406571 | 0 | 0 | 0 | 58.5 | 869 | 312 |
| 2019-04-08 | 215035 | 210867 | 13.9708 | 10.7667 | -0.081952 | 0.380128 | 0.26 | 0 | 0 | 64 | 781 | 383 |
| 2019-04-09 | 245655 | 241323 | 14.1182 | 11.3167 | -0.016283 | 0.381405 | 0.03 | 0 | 0 | 48.5 | 792 | 343 |
| 2019-04-10 | 246429 | 241949 | 14.8399 | 11.6833 | 0.012039 | 0.380605 | 0 | 0 | 0 | 52.5 | 864 | 406 |
| 2019-04-11 | 258935 | 254398 | 15.1513 | 11.9667 | 0.037436 | 0.389228 | 0 | 0 | 0 | 47.5 | 881 | 347 |
| 2019-04-12 | 263979 | 258957 | 15.0827 | 11.7333 | 0.051704 | 0.393904 | 0.63 | 0 | 0 | 57 | 798 | 448 |
| 2019-04-13 | 248972 | 242640 | 13.7949 | 11 | -0.046322 | 0.419234 | 0.24 | 0 | 0 | 68 | 1023 | 394 |
| 2019-04-14 | 212113 | 206371 | 13.1021 | 10.2333 | -0.131272 | 0.414454 | 0.01 | 0 | 0 | 66.5 | 964 | 292 |
| 2019-04-15 | 233576 | 229414 | 14.2525 | 10.8833 | -0.037879 | 0.39795 | 0.96 | 0 | 0 | 55.5 | 857 | 414 |
| 2019-04-16 | 240427 | 235902 | 15.1829 | 12 | 0.031534 | 0.387385 | 0 | 0 | 0 | 55 | 865 | 413 |
| 2019-04-17 | 250652 | 246273 | 15.1946 | 12.1 | 0.050677 | 0.392355 | 0.01 | 0 | 0 | 55.5 | 926 | 402 |
| 2019-04-18 | 252554 | 248388 | 15.9833 | 12.5 | 0.087575 | 0.405006 | 0 | 0 | 0 | 56.5 | 920 | 324 |
| 2019-04-19 | 228135 | 223526 | 13.2017 | 10.7167 | -0.070321 | 0.394421 | 0.01 | 0 | 0 | 69 | 850 | 327 |
| 2019-04-20 | 200121 | 195526 | 12.3314 | 10.1333 | -0.117296 | 0.408162 | 0.7 | 0 | 0 | 59.5 | 1029 | 306 |
| 2019-04-21 | 174974 | 169785 | 12.0906 | 9.6333 | -0.231588 | 0.402386 | 0 | 0 | 0 | 59.5 | 916 | 276 |
| 2019-04-22 | 199887 | 196697 | 14.4334 | 11.1 | -0.051382 | 0.395262 | 0.24 | 0 | 0 | 58 | 837 | 340 |
| 2019-04-23 | 222196 | 218620 | 14.3634 | 11.5833 | -0.025451 | 0.378616 | 0.08 | 0 | 0 | 66.5 | 873 | 392 |
| 2019-04-24 | 228307 | 224462 | 14.8114 | 11.95 | 0.011272 | 0.387891 | 0 | 0 | 0 | 62 | 934 | 337 |