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-11-14 | Bronx | 126 | 35 | 23.7216 | 18.5833 | 0.110801 | 0.616699 | 0 | 36.5 | 50 | 48 |
| 2019-11-14 | Brooklyn | 1939 | 1379 | 16.4133 | 13.5167 | -0.013531 | 0.459432 | 0 | 36.5 | 137 | 129 |
| 2019-11-14 | EWR | 1 | 0 | 0.4167 | 0.4167 | null | null | 0 | 36.5 | null | 0 |
| 2019-11-14 | Manhattan | 228955 | 226992 | 14.4037 | 12.0333 | 0.088705 | 0.383472 | 0 | 36.5 | 205 | 71 |
| 2019-11-14 | Queens | 14616 | 14067 | 38.144 | 37.2667 | 0.111516 | 0.366093 | 0 | 36.5 | 91 | 109 |
| 2019-11-14 | Staten Island | 7 | 2 | 54.7167 | 50.7833 | -0.040595 | 0.025766 | 0 | 36.5 | 9 | 12 |
| 2019-11-15 | Bronx | 189 | 53 | 19.9966 | 15.4333 | -0.058675 | 0.671806 | 0 | 44 | 46 | 56 |
| 2019-11-15 | Brooklyn | 2240 | 1549 | 17.2716 | 13.925 | 0.01898 | 0.45479 | 0 | 44 | 116 | 128 |
| 2019-11-15 | EWR | 3 | 3 | 0.4056 | 0.25 | -0.170392 | 1.331142 | 0 | 44 | null | 0 |
| 2019-11-15 | Manhattan | 224770 | 222590 | 14.2826 | 11.8667 | 0.084997 | 0.3877 | 0 | 44 | 195 | 81 |
| 2019-11-15 | Queens | 14774 | 14206 | 39.2198 | 38.2833 | 0.146783 | 0.388266 | 0 | 44 | 84 | 120 |
| 2019-11-15 | Staten Island | 6 | 2 | 54.3806 | 43.125 | -0.004917 | 0.125787 | 0 | 44 | 7 | 5 |
| 2019-11-16 | Bronx | 129 | 30 | 16.9709 | 12.2833 | -0.077848 | 0.372948 | 0 | 36.5 | 62 | 50 |
| 2019-11-16 | Brooklyn | 2665 | 1729 | 15.3396 | 13.0833 | -0.009102 | 0.461338 | 0 | 36.5 | 199 | 116 |
| 2019-11-16 | EWR | 3 | 3 | 0.3111 | 0.1167 | -0.642668 | 1.326001 | 0 | 36.5 | null | 0 |
| 2019-11-16 | Manhattan | 230233 | 227599 | 12.9058 | 10.8167 | 0.005393 | 0.41666 | 0 | 36.5 | 247 | 65 |
| 2019-11-16 | Queens | 11051 | 10296 | 29.363 | 27.8833 | -0.046565 | 0.430824 | 0 | 36.5 | 150 | 107 |
| 2019-11-16 | Staten Island | 5 | 0 | 43.7367 | 57.75 | null | null | 0 | 36.5 | 16 | 9 |
| 2019-11-17 | Bronx | 165 | 30 | 14.33 | 11.0333 | -0.517279 | 1.012051 | 0 | 36.5 | 45 | 28 |
| 2019-11-17 | Brooklyn | 2267 | 1388 | 14.9413 | 12.7833 | -0.045197 | 0.427508 | 0 | 36.5 | 177 | 96 |
| 2019-11-17 | EWR | 2 | 2 | 2.7333 | 2.7333 | 1.593747 | 1.531482 | 0 | 36.5 | null | 0 |
| 2019-11-17 | Manhattan | 179247 | 176896 | 12.023 | 9.9 | -0.105815 | 0.402009 | 0 | 36.5 | 222 | 59 |
| 2019-11-17 | Queens | 14895 | 14079 | 28.5289 | 27.45 | -0.102902 | 0.378389 | 0 | 36.5 | 135 | 76 |
| 2019-11-17 | Staten Island | 11 | 1 | 33.5424 | 31.75 | 0.676412 | null | 0 | 36.5 | 19 | 6 |
| 2019-11-18 | Bronx | 162 | 44 | 21.2943 | 16.5083 | -0.184472 | 0.784673 | 0.48 | 39.5 | 43 | 82 |