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-06 | Brooklyn | 2220 | 1374 | 14.2971 | 12.1333 | -0.077782 | 0.467509 | 0.01 | 63.5 | 236 | 73 |
| 2019-10-06 | EWR | 3 | 2 | 14.1944 | 1.2333 | 0.06548 | 1.722738 | 0.01 | 63.5 | null | 0 |
| 2019-10-06 | Manhattan | 166361 | 163985 | 13.3928 | 10.5833 | -0.034021 | 0.436991 | 0.01 | 63.5 | 313 | 71 |
| 2019-10-06 | Queens | 15212 | 14389 | 30.2885 | 28.9167 | -0.070558 | 0.394468 | 0.01 | 63.5 | 221 | 83 |
| 2019-10-06 | Staten Island | 4 | 2 | 65.8167 | 73.075 | -0.14341 | 0.215538 | 0.01 | 63.5 | 37 | 3 |
| 2019-10-07 | Bronx | 180 | 37 | 21.412 | 16.2167 | -0.059048 | 0.825024 | 0.2 | 69 | 76 | 60 |
| 2019-10-07 | Brooklyn | 1804 | 1186 | 16.2966 | 14.125 | -0.037559 | 0.443653 | 0.2 | 69 | 169 | 114 |
| 2019-10-07 | Manhattan | 190237 | 188638 | 12.6304 | 10.5833 | -0.035365 | 0.378637 | 0.2 | 69 | 241 | 76 |
| 2019-10-07 | Queens | 14746 | 14084 | 31.9953 | 30.6667 | -0.024991 | 0.361759 | 0.2 | 69 | 122 | 121 |
| 2019-10-07 | Staten Island | 4 | 1 | 42.7625 | 47.8333 | -0.00341 | null | 0.2 | 69 | 16 | 5 |
| 2019-10-08 | Bronx | 165 | 33 | 20.4312 | 14.2333 | -0.195401 | 0.555 | 0.02 | 60.5 | 84 | 62 |
| 2019-10-08 | Brooklyn | 1770 | 1215 | 15.7866 | 13.0917 | -0.052096 | 0.44537 | 0.02 | 60.5 | 176 | 113 |
| 2019-10-08 | Manhattan | 197589 | 196033 | 12.9874 | 10.9 | 0.005218 | 0.391666 | 0.02 | 60.5 | 273 | 62 |
| 2019-10-08 | Queens | 12549 | 11929 | 29.8203 | 28.5833 | -0.068543 | 0.391298 | 0.02 | 60.5 | 142 | 93 |
| 2019-10-08 | Staten Island | 3 | 0 | 56.8944 | 51.2167 | null | null | 0.02 | 60.5 | 17 | 7 |
| 2019-10-09 | Bronx | 157 | 29 | 18.8296 | 15.8667 | -0.233774 | 0.409452 | 0.54 | 55 | 78 | 33 |
| 2019-10-09 | Brooklyn | 1518 | 1080 | 13.8111 | 11.3333 | -0.116464 | 0.428658 | 0.54 | 55 | 182 | 82 |
| 2019-10-09 | EWR | 1 | 1 | 2.85 | 2.85 | 2.121239 | null | 0.54 | 55 | null | 0 |
| 2019-10-09 | Manhattan | 199260 | 197802 | 12.1752 | 10.3 | -0.03259 | 0.389106 | 0.54 | 55 | 265 | 46 |
| 2019-10-09 | Queens | 12803 | 12303 | 29.1132 | 28.4333 | -0.097667 | 0.391046 | 0.54 | 55 | 147 | 96 |
| 2019-10-09 | Staten Island | 7 | 2 | 34.5333 | 24.6167 | 0.046964 | 0.257077 | 0.54 | 55 | 14 | 5 |
| 2019-10-10 | Bronx | 151 | 29 | 21.7807 | 16.9833 | 0.03802 | 0.342371 | 0 | 62 | 89 | 61 |
| 2019-10-10 | Brooklyn | 1928 | 1379 | 16.3897 | 13.575 | 0.008312 | 0.414953 | 0 | 62 | 193 | 132 |
| 2019-10-10 | EWR | 2 | 2 | 0.4583 | 0.4583 | -0.474777 | 1.494398 | 0 | 62 | null | 0 |
| 2019-10-10 | Manhattan | 216100 | 214353 | 14.5777 | 12.15 | 0.090966 | 0.392132 | 0 | 62 | 295 | 68 |