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-08 | Bronx | 266 | 38 | 18.9573 | 14.85 | -0.000822 | 0.430127 | 0 | 72 | 184 | 63 |
| 2019-06-08 | Brooklyn | 3169 | 1965 | 16.4257 | 14.0667 | 0.014406 | 0.447809 | 0 | 72 | 370 | 133 |
| 2019-06-08 | Manhattan | 200144 | 197334 | 12.5565 | 10.55 | -0.053738 | 0.406986 | 0 | 72 | 476 | 68 |
| 2019-06-08 | Queens | 13366 | 12437 | 29.6824 | 28.5333 | -0.00227 | 0.436335 | 0 | 72 | 381 | 109 |
| 2019-06-08 | Staten Island | 6 | 0 | 39.9889 | 49.9667 | null | null | 0 | 72 | 50 | 8 |
| 2019-06-09 | Bronx | 321 | 44 | 19.064 | 15.6167 | -0.056809 | 0.701471 | 0 | 69 | 128 | 58 |
| 2019-06-09 | Brooklyn | 2665 | 1539 | 15.3469 | 13.1333 | -0.054355 | 0.463947 | 0 | 69 | 336 | 129 |
| 2019-06-09 | EWR | 2 | 2 | 0.8833 | 0.8833 | 0.762589 | 1.336305 | 0 | 69 | null | 0 |
| 2019-06-09 | Manhattan | 159647 | 156946 | 11.9246 | 9.7333 | -0.138257 | 0.409923 | 0 | 69 | 407 | 65 |
| 2019-06-09 | Queens | 16719 | 15780 | 28.6276 | 27.1 | -0.096705 | 0.389578 | 0 | 69 | 310 | 110 |
| 2019-06-09 | Staten Island | 7 | 0 | 36.2667 | 31.3667 | null | null | 0 | 69 | 47 | 6 |
| 2019-06-10 | Bronx | 291 | 49 | 25.6498 | 22.0333 | -0.019478 | 0.620103 | 0.62 | 65 | 132 | 57 |
| 2019-06-10 | Brooklyn | 1768 | 1091 | 18.6179 | 14.8833 | -0.044595 | 0.448529 | 0.62 | 65 | 219 | 114 |
| 2019-06-10 | EWR | 2 | 1 | 29.1333 | 29.1333 | 1.299283 | null | 0.62 | 65 | null | 0 |
| 2019-06-10 | Manhattan | 190925 | 188989 | 13.2356 | 10.7333 | 0.004839 | 0.405703 | 0.62 | 65 | 299 | 73 |
| 2019-06-10 | Queens | 16269 | 15489 | 33.4092 | 30.9667 | -0.003943 | 0.370578 | 0.62 | 65 | 204 | 133 |
| 2019-06-10 | Staten Island | 11 | 0 | 40.8348 | 38.6 | null | null | 0.62 | 65 | 30 | 12 |
| 2019-06-11 | Bronx | 342 | 56 | 29.3625 | 24.2833 | 0.141316 | 0.606294 | 0.45 | 70 | 122 | 67 |
| 2019-06-11 | Brooklyn | 2352 | 1401 | 20.0137 | 15.875 | 0.002412 | 0.426322 | 0.45 | 70 | 236 | 134 |
| 2019-06-11 | EWR | 2 | 1 | 0.5333 | 0.5333 | 1.203973 | null | 0.45 | 70 | null | 0 |
| 2019-06-11 | Manhattan | 207354 | 205294 | 13.9443 | 11.55 | 0.04721 | 0.397887 | 0.45 | 70 | 344 | 76 |
| 2019-06-11 | Queens | 16621 | 15770 | 35.6022 | 33.55 | 0.078675 | 0.353102 | 0.45 | 70 | 195 | 143 |
| 2019-06-11 | Staten Island | 5 | 2 | 39.08 | 42.7 | -0.153645 | 0.033765 | 0.45 | 70 | 36 | 11 |
| 2019-06-12 | Bronx | 286 | 41 | 25.8252 | 20.2333 | 0.165687 | 0.729862 | 0 | 66.5 | 150 | 74 |
| 2019-06-12 | Brooklyn | 2564 | 1594 | 18.9818 | 15.3583 | 0.016126 | 0.421105 | 0 | 66.5 | 259 | 130 |