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-10-15 | Bronx | 185 | 46 | 21.2401 | 18.5667 | -0.052619 | 0.926822 | 0 | 57.5 | 82 | 49 |
| 2019-10-15 | Brooklyn | 1952 | 1459 | 16.1188 | 14.05 | -0.025972 | 0.419484 | 0 | 57.5 | 184 | 119 |
| 2019-10-15 | EWR | 1 | 1 | 0.2833 | 0.2833 | -0.057158 | null | 0 | 57.5 | null | 0 |
| 2019-10-15 | Manhattan | 204113 | 202375 | 13.595 | 11.5167 | 0.014761 | 0.376822 | 0 | 57.5 | 266 | 76 |
| 2019-10-15 | Queens | 16378 | 15788 | 33.4291 | 33.0333 | 0.005946 | 0.339127 | 0 | 57.5 | 136 | 102 |
| 2019-10-15 | Staten Island | 7 | 2 | 47.9214 | 48.4167 | -0.083354 | 0.177986 | 0 | 57.5 | 18 | 12 |
| 2019-10-16 | Bronx | 177 | 40 | 20.7204 | 14.8 | 0.214396 | 0.626516 | 1.83 | 59 | 82 | 80 |
| 2019-10-16 | Brooklyn | 1999 | 1465 | 16.4417 | 13.4167 | 0.023694 | 0.459406 | 1.83 | 59 | 199 | 126 |
| 2019-10-16 | EWR | 1 | 1 | 0.0833 | 0.0833 | -1.193922 | null | 1.83 | 59 | null | 0 |
| 2019-10-16 | Manhattan | 208630 | 206742 | 15.634 | 12.7333 | 0.166268 | 0.429949 | 1.83 | 59 | 294 | 91 |
| 2019-10-16 | Queens | 14648 | 14077 | 40.3236 | 36.7083 | 0.146153 | 0.410545 | 1.83 | 59 | 154 | 115 |
| 2019-10-16 | Staten Island | 7 | 2 | 51.7429 | 47.75 | -0.127431 | 0.168127 | 1.83 | 59 | 17 | 11 |
| 2019-10-17 | Bronx | 161 | 33 | 23.1861 | 17.3667 | 0.185934 | 0.391377 | 0 | 54 | 85 | 66 |
| 2019-10-17 | Brooklyn | 2103 | 1514 | 17.1819 | 14.3167 | 0.023588 | 0.422273 | 0 | 54 | 192 | 126 |
| 2019-10-17 | EWR | 3 | 2 | 31.7 | 0.1833 | -0.62253 | 0 | 0 | 54 | null | 0 |
| 2019-10-17 | Manhattan | 223842 | 221983 | 14.9455 | 12.4 | 0.112552 | 0.394149 | 0 | 54 | 297 | 74 |
| 2019-10-17 | Queens | 15612 | 14977 | 36.3236 | 34.4667 | 0.099652 | 0.370431 | 0 | 54 | 144 | 105 |
| 2019-10-17 | Staten Island | 5 | 1 | 59.6833 | 49.9333 | 0.190093 | null | 0 | 54 | 17 | 8 |
| 2019-10-18 | Bronx | 242 | 43 | 22.857 | 18.7583 | 0.336274 | 0.674041 | 0 | 52.5 | 80 | 82 |
| 2019-10-18 | Brooklyn | 2524 | 1749 | 17.2777 | 14.1667 | 0.080053 | 0.441364 | 0 | 52.5 | 153 | 121 |
| 2019-10-18 | EWR | 3 | 3 | 4.8389 | 0.65 | 1.535143 | 2.161634 | 0 | 52.5 | null | 0 |
| 2019-10-18 | Manhattan | 224183 | 221882 | 14.608 | 11.95 | 0.094991 | 0.395164 | 0 | 52.5 | 285 | 65 |
| 2019-10-18 | Queens | 17581 | 16845 | 38.2832 | 36.2833 | 0.152781 | 0.386886 | 0 | 52.5 | 142 | 118 |
| 2019-10-18 | Staten Island | 6 | 1 | 47.0139 | 36.1583 | 0 | null | 0 | 52.5 | 14 | 11 |
| 2019-10-19 | Bronx | 193 | 45 | 17.2973 | 13.1167 | -0.217322 | 0.755214 | 0 | 51.5 | 86 | 72 |