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-05-30 | Bronx | 270 | 41 | 29.2718 | 22.725 | -0.037154 | 0.636861 | 0.95 | 63.5 | 138 | 70 |
| 2019-05-30 | Brooklyn | 2500 | 1618 | 19.5025 | 15 | 0.019313 | 0.480241 | 0.95 | 63.5 | 255 | 132 |
| 2019-05-30 | Manhattan | 223969 | 221841 | 14.6828 | 12 | 0.104767 | 0.402568 | 0.95 | 63.5 | 353 | 81 |
| 2019-05-30 | Queens | 16450 | 15642 | 36.6033 | 35.4167 | 0.08972 | 0.35731 | 0.95 | 63.5 | 235 | 97 |
| 2019-05-30 | Staten Island | 9 | 0 | 28.6019 | 14.35 | null | null | 0.95 | 63.5 | 39 | 11 |
| 2019-05-31 | Bronx | 481 | 85 | 26.558 | 21.2333 | 0.00908 | 0.622946 | 0 | 71.5 | 148 | 81 |
| 2019-05-31 | Brooklyn | 3112 | 1994 | 20.0717 | 15.7167 | 0.060247 | 0.453208 | 0 | 71.5 | 241 | 172 |
| 2019-05-31 | EWR | 1 | 0 | 0.3833 | 0.3833 | null | null | 0 | 71.5 | null | 0 |
| 2019-05-31 | Manhattan | 222521 | 219862 | 14.076 | 11.35 | 0.046092 | 0.401721 | 0 | 71.5 | 314 | 107 |
| 2019-05-31 | Queens | 18184 | 17149 | 36.6647 | 34.9917 | 0.133979 | 0.368553 | 0 | 71.5 | 216 | 138 |
| 2019-05-31 | Staten Island | 9 | 2 | 37.237 | 21.65 | 0.116077 | 0.022274 | 0 | 71.5 | 31 | 9 |
| 2019-06-01 | Bronx | 413 | 64 | 18.1791 | 15.1667 | -0.10414 | 0.893149 | 0 | 71.5 | 185 | 58 |
| 2019-06-01 | Brooklyn | 3408 | 2111 | 15.8457 | 13.825 | -0.009809 | 0.441933 | 0 | 71.5 | 369 | 97 |
| 2019-06-01 | Manhattan | 214802 | 211304 | 12.6247 | 10.3833 | -0.065386 | 0.409035 | 0 | 71.5 | 482 | 75 |
| 2019-06-01 | Queens | 13550 | 12549 | 29.7443 | 28.4333 | -0.048381 | 0.392469 | 0 | 71.5 | 367 | 109 |
| 2019-06-01 | Staten Island | 10 | 0 | 18.79 | 12.1917 | null | null | 0 | 71.5 | 45 | 16 |
| 2019-06-02 | Bronx | 443 | 56 | 19.99 | 17.1667 | -0.176571 | 0.953849 | 0.86 | 71 | 121 | 49 |
| 2019-06-02 | Brooklyn | 2961 | 1648 | 15.9455 | 13.45 | -0.067143 | 0.48753 | 0.86 | 71 | 336 | 137 |
| 2019-06-02 | EWR | 2 | 1 | 27.375 | 27.375 | 0.017392 | null | 0.86 | 71 | null | 0 |
| 2019-06-02 | Manhattan | 178317 | 175157 | 12.7054 | 10.1333 | -0.073731 | 0.421786 | 0.86 | 71 | 427 | 44 |
| 2019-06-02 | Queens | 15940 | 14866 | 30.599 | 28.975 | -0.066004 | 0.384772 | 0.86 | 71 | 307 | 105 |
| 2019-06-02 | Staten Island | 8 | 0 | 37.0896 | 21.4167 | null | null | 0.86 | 71 | 43 | 6 |
| 2019-06-03 | Bronx | 368 | 64 | 26.1673 | 20.5917 | 0.068261 | 0.692607 | 0 | 64 | 129 | 86 |
| 2019-06-03 | Brooklyn | 2395 | 1395 | 20.018 | 15.4167 | -0.02531 | 0.428874 | 0 | 64 | 229 | 145 |
| 2019-06-03 | Manhattan | 192744 | 190571 | 13.2567 | 10.65 | -0.036712 | 0.395543 | 0 | 64 | 323 | 71 |