Borough-day duration index
Per pickup borough and day: trips, the duration index, permitted events and collisions in that borough.
2,001 rows Download CSV
| dateTEXT | boroughTEXT | tripsINTEGER | indexed_tripsINTEGER | mean_minREAL | median_minREAL | mean_log_ratioREAL | sd_log_ratioREAL | precipitationREAL | tavgREAL | eventsINTEGER | collisionsINTEGER |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019-03-24 | Staten Island | 10 | 1 | 33.2933 | 18.725 | 0.008998 | null | 0 | 49 | 17 | 6 |
| 2019-03-25 | Bronx | 458 | 74 | 26.3804 | 22.05 | -0.089715 | 0.669098 | 0 | 49 | 90 | 59 |
| 2019-03-25 | Brooklyn | 2304 | 1299 | 19.8485 | 15.9667 | -0.077863 | 0.422818 | 0 | 49 | 141 | 129 |
| 2019-03-25 | EWR | 1 | 1 | 2.0333 | 2.0333 | 1.88625 | null | 0 | 49 | null | 0 |
| 2019-03-25 | Manhattan | 179321 | 177028 | 11.8713 | 9.85 | -0.120141 | 0.37428 | 0 | 49 | 163 | 58 |
| 2019-03-25 | Queens | 18007 | 17008 | 31.5575 | 30.0333 | -0.062594 | 0.316521 | 0 | 49 | 130 | 99 |
| 2019-03-25 | Staten Island | 5 | 2 | 30.3867 | 17.3 | -0.150452 | 0.037447 | 0 | 49 | 16 | 7 |
| 2019-03-26 | Bronx | 482 | 66 | 28.1356 | 24.4583 | -0.043591 | 0.511444 | 0 | 41 | 84 | 70 |
| 2019-03-26 | Brooklyn | 2654 | 1575 | 19.8338 | 15.1833 | -0.016741 | 0.44007 | 0 | 41 | 125 | 146 |
| 2019-03-26 | EWR | 2 | 2 | 0.2083 | 0.2083 | -1.22494 | 1.558941 | 0 | 41 | null | 0 |
| 2019-03-26 | Manhattan | 207563 | 205198 | 12.8479 | 10.6667 | -0.037307 | 0.387367 | 0 | 41 | 171 | 80 |
| 2019-03-26 | Queens | 15869 | 14940 | 31.4545 | 30.1667 | -0.065676 | 0.323797 | 0 | 41 | 139 | 114 |
| 2019-03-26 | Staten Island | 4 | 1 | 37.425 | 36.0417 | -0.190407 | null | 0 | 41 | 15 | 5 |
| 2019-03-27 | Bronx | 480 | 71 | 26.1249 | 24.2583 | -0.111853 | 0.54684 | 0 | 40.5 | 94 | 56 |
| 2019-03-27 | Brooklyn | 2726 | 1623 | 19.5694 | 15.6 | -0.050537 | 0.453997 | 0 | 40.5 | 144 | 141 |
| 2019-03-27 | Manhattan | 217627 | 214998 | 13.2714 | 11.0167 | -0.002077 | 0.389917 | 0 | 40.5 | 199 | 68 |
| 2019-03-27 | Queens | 15990 | 15074 | 31.7807 | 30.7667 | -0.05828 | 0.312004 | 0 | 40.5 | 140 | 88 |
| 2019-03-27 | Staten Island | 4 | 1 | 35.2042 | 23.6833 | -0.357732 | null | 0 | 40.5 | 17 | 6 |
| 2019-03-28 | Bronx | 501 | 80 | 29.3995 | 26.4 | -0.02255 | 0.691198 | 0 | 45 | 94 | 78 |
| 2019-03-28 | Brooklyn | 2928 | 1777 | 20.0897 | 15.6083 | -0.016415 | 0.431516 | 0 | 45 | 144 | 143 |
| 2019-03-28 | Manhattan | 226802 | 224004 | 13.6668 | 11.25 | 0.011533 | 0.37794 | 0 | 45 | 204 | 68 |
| 2019-03-28 | Queens | 15866 | 14933 | 35.0811 | 33.9667 | 0.046276 | 0.337418 | 0 | 45 | 144 | 107 |
| 2019-03-28 | Staten Island | 6 | 3 | 22.2417 | 22.1 | -0.029492 | 0.268812 | 0 | 45 | 16 | 7 |
| 2019-03-29 | Bronx | 486 | 84 | 26.7129 | 23.275 | -0.098461 | 0.545765 | 0 | 54 | 90 | 59 |
| 2019-03-29 | Brooklyn | 3295 | 2007 | 19.7657 | 15.9333 | 0.011504 | 0.460097 | 0 | 54 | 152 | 118 |