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-04-07 | Brooklyn | 3352 | 1809 | 16.3769 | 13.9833 | -0.044364 | 0.431561 | 0 | 58.5 | 229 | 108 |
| 2019-04-07 | EWR | 2 | 2 | 1.125 | 1.125 | 0.597577 | 1.734088 | 0 | 58.5 | null | 0 |
| 2019-04-07 | Manhattan | 188621 | 185331 | 11.7688 | 9.7 | -0.148037 | 0.406878 | 0 | 58.5 | 320 | 55 |
| 2019-04-07 | Queens | 16690 | 15606 | 31.9829 | 29.9 | -0.032047 | 0.381243 | 0 | 58.5 | 214 | 78 |
| 2019-04-07 | Staten Island | 11 | 2 | 19.3242 | 5.5167 | -0.04536 | 0.080084 | 0 | 58.5 | 33 | 10 |
| 2019-04-08 | Bronx | 352 | 81 | 23.6389 | 18.6833 | -0.112545 | 0.434701 | 0.26 | 64 | 115 | 64 |
| 2019-04-08 | Brooklyn | 2348 | 1484 | 18.2201 | 14.7417 | -0.028856 | 0.42883 | 0.26 | 64 | 199 | 131 |
| 2019-04-08 | EWR | 1 | 1 | 0.8833 | 0.8833 | 0.712195 | null | 0.26 | 64 | null | 0 |
| 2019-04-08 | Manhattan | 195158 | 192981 | 12.2187 | 10.1 | -0.087274 | 0.381695 | 0.26 | 64 | 271 | 72 |
| 2019-04-08 | Queens | 17171 | 16318 | 33.0915 | 31.5833 | -0.023738 | 0.35015 | 0.26 | 64 | 173 | 108 |
| 2019-04-08 | Staten Island | 5 | 2 | 63.48 | 65.6667 | -0.116452 | 0.016096 | 0.26 | 64 | 23 | 8 |
| 2019-04-09 | Bronx | 366 | 75 | 25.4422 | 20.6083 | -0.073081 | 0.584611 | 0.03 | 48.5 | 113 | 53 |
| 2019-04-09 | Brooklyn | 2583 | 1702 | 17.7581 | 13.9 | -0.015589 | 0.468714 | 0.03 | 48.5 | 199 | 122 |
| 2019-04-09 | EWR | 1 | 1 | 1.5833 | 1.5833 | 1.663505 | null | 0.03 | 48.5 | null | 0 |
| 2019-04-09 | Manhattan | 227561 | 225202 | 12.8748 | 10.8 | -0.014943 | 0.382288 | 0.03 | 48.5 | 277 | 65 |
| 2019-04-09 | Queens | 15138 | 14341 | 31.9066 | 30.7167 | -0.037218 | 0.352766 | 0.03 | 48.5 | 179 | 96 |
| 2019-04-09 | Staten Island | 6 | 2 | 36.9639 | 40.6167 | -0.088196 | 0.084036 | 0.03 | 48.5 | 24 | 7 |
| 2019-04-10 | Bronx | 392 | 62 | 26.1702 | 20.55 | -0.039123 | 0.604047 | 0 | 52.5 | 125 | 66 |
| 2019-04-10 | Brooklyn | 2703 | 1777 | 18.3702 | 14.4 | 0.001321 | 0.483587 | 0 | 52.5 | 209 | 137 |
| 2019-04-10 | EWR | 2 | 2 | 0.2333 | 0.2333 | -0.228379 | 0.39944 | 0 | 52.5 | null | 0 |
| 2019-04-10 | Manhattan | 227838 | 225459 | 13.4576 | 11.1167 | 0.010886 | 0.38093 | 0 | 52.5 | 312 | 64 |
| 2019-04-10 | Queens | 15487 | 14648 | 34.2597 | 32.8 | 0.031352 | 0.359106 | 0 | 52.5 | 188 | 131 |
| 2019-04-10 | Staten Island | 7 | 1 | 46.0571 | 52.1833 | -0.310678 | null | 0 | 52.5 | 30 | 8 |
| 2019-04-11 | Bronx | 360 | 70 | 25.0074 | 21.6583 | -0.016494 | 0.778561 | 0 | 47.5 | 122 | 60 |
| 2019-04-11 | Brooklyn | 2714 | 1798 | 18.3441 | 14.1167 | 0.007119 | 0.462456 | 0 | 47.5 | 211 | 107 |