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-09-22 | 192979 | 188205 | 14.5823 | 11.2333 | -0.066363 | 0.416453 | 0 | 0 | 0 | 76.5 | 904 | 342 |
| 2019-09-23 | 183644 | 180624 | 17.3864 | 12.5667 | 0.10293 | 0.483747 | 0.11 | 0 | 0 | 79.5 | 631 | 396 |
| 2019-09-24 | 197944 | 194743 | 16.6945 | 12.65 | 0.113986 | 0.450661 | 0 | 0 | 0 | 69.5 | 709 | 399 |
| 2019-09-25 | 203710 | 200465 | 17.4155 | 13.0333 | 0.153599 | 0.477051 | 0 | 0 | 0 | 68.5 | 775 | 378 |
| 2019-09-26 | 223529 | 219964 | 17.0905 | 12.65 | 0.120788 | 0.427598 | 0.02 | 0 | 0 | 73 | 737 | 399 |
| 2019-09-27 | 222891 | 219079 | 16.4884 | 12.6 | 0.101134 | 0.403564 | 0 | 0 | 0 | 67.5 | 721 | 453 |
| 2019-09-28 | 220050 | 215327 | 13.8213 | 11.2667 | -0.028569 | 0.407324 | 0 | 0 | 0 | 73.5 | 1037 | 348 |
| 2019-09-29 | 187178 | 182601 | 13.2218 | 10.3167 | -0.141386 | 0.399549 | 0 | 0 | 0 | 72.5 | 885 | 311 |
| 2019-09-30 | 169590 | 166986 | 12.9787 | 10.3 | -0.135437 | 0.374039 | 0 | 0 | 0 | 65.5 | 574 | 286 |
| 2019-10-01 | 197970 | 195180 | 13.6194 | 11.0667 | -0.062591 | 0.372181 | 0 | 0 | 0 | 72 | 684 | 295 |
| 2019-10-02 | 229318 | 226089 | 16.0581 | 12.5833 | 0.08809 | 0.396009 | 0.03 | 0 | 0 | 78 | 744 | 436 |
| 2019-10-03 | 241937 | 238606 | 17.0112 | 13.2667 | 0.170766 | 0.408846 | 0.34 | 0 | 0 | 58 | 724 | 456 |
| 2019-10-04 | 237801 | 234021 | 15.774 | 12.3833 | 0.081547 | 0.394062 | 0 | 0 | 0 | 58 | 698 | 455 |
| 2019-10-05 | 222501 | 217919 | 14.1829 | 11.5 | 0.012996 | 0.410967 | 0 | 0 | 0 | 53 | 1019 | 341 |
| 2019-10-06 | 184017 | 179791 | 14.8031 | 11.2833 | -0.037314 | 0.434157 | 0.01 | 0 | 0 | 63.5 | 877 | 290 |
| 2019-10-07 | 206971 | 203946 | 14.0503 | 11.1667 | -0.034666 | 0.378038 | 0.2 | 0 | 0 | 69 | 624 | 376 |
| 2019-10-08 | 212076 | 209210 | 14.0132 | 11.3333 | 0.000648 | 0.392407 | 0.02 | 0 | 0 | 60.5 | 692 | 337 |
| 2019-10-09 | 213746 | 211217 | 13.207 | 10.75 | -0.036826 | 0.389804 | 0.54 | 0 | 0 | 55 | 686 | 262 |
| 2019-10-10 | 233342 | 230319 | 16.073 | 12.75 | 0.090511 | 0.3921 | 0 | 0 | 0 | 62 | 737 | 391 |
| 2019-10-11 | 233566 | 230072 | 16.0944 | 12.6333 | 0.085506 | 0.392568 | 0 | 0 | 0 | 59.5 | 707 | 378 |
| 2019-10-12 | 215199 | 210938 | 14.1816 | 11.65 | -0.010887 | 0.415408 | 0 | 0 | 0 | 61 | 969 | 316 |
| 2019-10-13 | 186057 | 181871 | 14.2301 | 11.2167 | -0.071447 | 0.425431 | 0 | 0 | 0 | 60 | 840 | 283 |
| 2019-10-14 | 171819 | 169109 | 13.4723 | 10.4667 | -0.145462 | 0.398662 | 0 | 0 | 0 | 65 | 598 | 271 |
| 2019-10-15 | 222636 | 219671 | 15.0836 | 12.1667 | 0.013842 | 0.374755 | 0 | 0 | 0 | 57.5 | 686 | 358 |
| 2019-10-16 | 225462 | 222327 | 17.2502 | 13.3333 | 0.164055 | 0.429175 | 1.83 | 0 | 0 | 59 | 746 | 423 |