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-03 | Queens | 19354 | 18322 | 33.881 | 31.7833 | 0.021917 | 0.359585 | 0 | 64 | 199 | 132 |
| 2019-06-03 | Staten Island | 8 | 0 | 31.5396 | 22.5833 | null | null | 0 | 64 | 26 | 12 |
| 2019-06-04 | Bronx | 291 | 45 | 23.7297 | 19.3167 | -0.037654 | 0.724602 | 0 | 62 | 131 | 75 |
| 2019-06-04 | Brooklyn | 2773 | 1777 | 18.0141 | 14.5333 | -0.035541 | 0.4226 | 0 | 62 | 236 | 125 |
| 2019-06-04 | EWR | 2 | 0 | 29.3917 | 29.3917 | null | null | 0 | 62 | null | 0 |
| 2019-06-04 | Manhattan | 196480 | 194395 | 12.2448 | 10.1833 | -0.087319 | 0.374692 | 0 | 62 | 332 | 76 |
| 2019-06-04 | Queens | 15081 | 14420 | 31.5918 | 30.5667 | -0.045295 | 0.326041 | 0 | 62 | 222 | 128 |
| 2019-06-04 | Staten Island | 7 | 2 | 27.5214 | 18.6833 | 0.003426 | 0.07138 | 0 | 62 | 36 | 12 |
| 2019-06-05 | Bronx | 256 | 43 | 28.2972 | 24.3667 | 0.047527 | 0.531381 | 0 | 72.5 | 163 | 78 |
| 2019-06-05 | Brooklyn | 2414 | 1603 | 17.4736 | 14.025 | -0.02027 | 0.414716 | 0 | 72.5 | 265 | 148 |
| 2019-06-05 | Manhattan | 222122 | 219987 | 13.6429 | 11.2167 | 0.01883 | 0.387716 | 0 | 72.5 | 396 | 68 |
| 2019-06-05 | Queens | 15082 | 14369 | 34.412 | 33 | 0.025012 | 0.345406 | 0 | 72.5 | 255 | 115 |
| 2019-06-05 | Staten Island | 8 | 0 | 49 | 40.5417 | null | null | 0 | 72.5 | 42 | 11 |
| 2019-06-06 | Bronx | 302 | 40 | 25.7985 | 21.4583 | -0.040137 | 0.853302 | 0.04 | 75.5 | 126 | 72 |
| 2019-06-06 | Brooklyn | 2792 | 1753 | 19.9926 | 15.3583 | 0.007188 | 0.425571 | 0.04 | 75.5 | 254 | 156 |
| 2019-06-06 | EWR | 3 | 2 | 6.25 | 8.4333 | 2.194404 | 1.430771 | 0.04 | 75.5 | null | 0 |
| 2019-06-06 | Manhattan | 227631 | 225261 | 14.7408 | 11.9333 | 0.08061 | 0.406113 | 0.04 | 75.5 | 382 | 93 |
| 2019-06-06 | Queens | 16404 | 15602 | 38.7924 | 37.2333 | 0.13901 | 0.36254 | 0.04 | 75.5 | 225 | 134 |
| 2019-06-06 | Staten Island | 6 | 1 | 49.6028 | 38.2417 | 0.458018 | null | 0.04 | 75.5 | 36 | 8 |
| 2019-06-07 | Bronx | 339 | 62 | 26.1913 | 21.75 | 0.240042 | 0.702224 | 0 | 73.5 | 162 | 106 |
| 2019-06-07 | Brooklyn | 2883 | 1743 | 20.6797 | 15.9333 | 0.057148 | 0.454023 | 0 | 73.5 | 250 | 143 |
| 2019-06-07 | EWR | 1 | 1 | 0.05 | 0.05 | -2.159484 | null | 0 | 73.5 | null | 0 |
| 2019-06-07 | Manhattan | 217781 | 215192 | 14.3004 | 11.5667 | 0.064893 | 0.407773 | 0 | 73.5 | 350 | 101 |
| 2019-06-07 | Queens | 14979 | 14105 | 36.6857 | 35.9333 | 0.094329 | 0.382605 | 0 | 73.5 | 250 | 124 |
| 2019-06-07 | Staten Island | 7 | 0 | 30.4167 | 22.3333 | null | null | 0 | 73.5 | 31 | 8 |