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-06-16 | Queens | 16576 | 15565 | 30.2218 | 28.2167 | -0.073344 | 0.385914 | 0.04 | 72.5 | 300 | 107 |
| 2019-06-16 | Staten Island | 7 | 0 | 35.381 | 18.9 | null | null | 0.04 | 72.5 | 38 | 7 |
| 2019-06-17 | Bronx | 291 | 42 | 24.3651 | 20.35 | -0.020962 | 0.457328 | 0 | 72.5 | 108 | 63 |
| 2019-06-17 | Brooklyn | 1935 | 1131 | 19.2004 | 15.5167 | -0.030536 | 0.478266 | 0 | 72.5 | 227 | 128 |
| 2019-06-17 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.871802 | null | 0 | 72.5 | null | 0 |
| 2019-06-17 | Manhattan | 183695 | 181836 | 13.0859 | 10.8833 | -0.031596 | 0.382165 | 0 | 72.5 | 286 | 54 |
| 2019-06-17 | Queens | 17661 | 16891 | 33.8976 | 32.4333 | -0.008065 | 0.357496 | 0 | 72.5 | 179 | 96 |
| 2019-06-17 | Staten Island | 8 | 0 | 48.0708 | 41.7333 | null | null | 0 | 72.5 | 27 | 5 |
| 2019-06-18 | Bronx | 259 | 43 | 28.0373 | 22.7667 | 0.028271 | 0.336527 | 0.79 | 70 | 114 | 68 |
| 2019-06-18 | Brooklyn | 2155 | 1360 | 19.3973 | 14.7333 | 0.044918 | 0.422698 | 0.79 | 70 | 236 | 162 |
| 2019-06-18 | Manhattan | 212249 | 210282 | 14.6492 | 12.15 | 0.111281 | 0.403384 | 0.79 | 70 | 315 | 92 |
| 2019-06-18 | Queens | 14527 | 13830 | 36.5786 | 34.5333 | 0.086372 | 0.367067 | 0.79 | 70 | 191 | 126 |
| 2019-06-18 | Staten Island | 8 | 0 | 30.3479 | 19.425 | null | null | 0.79 | 70 | 35 | 11 |
| 2019-06-19 | Bronx | 243 | 49 | 24.2797 | 19.95 | 0.150728 | 0.612794 | 0.11 | 68.5 | 118 | 61 |
| 2019-06-19 | Brooklyn | 2415 | 1580 | 18.5609 | 14.6667 | 0.026057 | 0.463357 | 0.11 | 68.5 | 252 | 117 |
| 2019-06-19 | EWR | 3 | 2 | 0.4444 | 0.35 | 0.46263 | 0.436255 | 0.11 | 68.5 | null | 0 |
| 2019-06-19 | Manhattan | 214109 | 212065 | 14.6199 | 12.05 | 0.088921 | 0.40044 | 0.11 | 68.5 | 350 | 80 |
| 2019-06-19 | Queens | 16114 | 15343 | 35.3875 | 33.15 | 0.064875 | 0.368406 | 0.11 | 68.5 | 199 | 131 |
| 2019-06-19 | Staten Island | 6 | 2 | 54.8056 | 60.4167 | 0.204483 | 0.10758 | 0.11 | 68.5 | 37 | 11 |
| 2019-06-20 | Bronx | 258 | 38 | 23.6545 | 18.375 | -0.122955 | 0.599235 | 0.42 | 71.5 | 130 | 79 |
| 2019-06-20 | Brooklyn | 2604 | 1676 | 19.6809 | 15.7 | 0.058325 | 0.44963 | 0.42 | 71.5 | 256 | 147 |
| 2019-06-20 | EWR | 3 | 2 | 0.8167 | 0.2 | 0.563716 | 2.020506 | 0.42 | 71.5 | null | 0 |
| 2019-06-20 | Manhattan | 222088 | 219852 | 14.8351 | 12.0667 | 0.103 | 0.411417 | 0.42 | 71.5 | 368 | 99 |
| 2019-06-20 | Queens | 15799 | 14977 | 36.9946 | 34.4833 | 0.109272 | 0.372195 | 0.42 | 71.5 | 210 | 105 |
| 2019-06-20 | Staten Island | 5 | 1 | 51.46 | 28.0833 | 0.301827 | null | 0.42 | 71.5 | 37 | 4 |