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-11-09 | Staten Island | 7 | 0 | 24.7143 | 10.5667 | null | null | 0 | 34 | 19 | 2 |
| 2019-11-10 | Bronx | 161 | 23 | 15.2496 | 12.1167 | -0.059649 | 0.522987 | 0 | 44.5 | 49 | 48 |
| 2019-11-10 | Brooklyn | 2206 | 1325 | 14.8104 | 13 | -0.083925 | 0.435076 | 0 | 44.5 | 187 | 79 |
| 2019-11-10 | EWR | 1 | 1 | 0.2833 | 0.2833 | -0.187212 | null | 0 | 44.5 | null | 0 |
| 2019-11-10 | Manhattan | 174379 | 172038 | 12.6952 | 10.5667 | -0.073836 | 0.402378 | 0 | 44.5 | 257 | 61 |
| 2019-11-10 | Queens | 14849 | 14096 | 28.375 | 27.3833 | -0.120965 | 0.380221 | 0 | 44.5 | 147 | 100 |
| 2019-11-10 | Staten Island | 5 | 2 | 47.1233 | 50.4667 | -0.095147 | 0.049548 | 0 | 44.5 | 24 | 9 |
| 2019-11-11 | Bronx | 123 | 23 | 13.395 | 10.2167 | -0.125315 | 0.513191 | 0 | 54 | 46 | 53 |
| 2019-11-11 | Brooklyn | 1228 | 828 | 14.7147 | 12.2917 | -0.130483 | 0.419961 | 0 | 54 | 130 | 90 |
| 2019-11-11 | EWR | 2 | 1 | 19.9583 | 19.9583 | 0.217723 | null | 0 | 54 | null | 0 |
| 2019-11-11 | Manhattan | 159476 | 158038 | 13.5138 | 10.7333 | 0.001219 | 0.450299 | 0 | 54 | 185 | 63 |
| 2019-11-11 | Queens | 15202 | 14609 | 30.5156 | 29.0333 | -0.095306 | 0.381126 | 0 | 54 | 80 | 89 |
| 2019-11-11 | Staten Island | 6 | 2 | 50.3806 | 44.5167 | -0.329594 | 0.028571 | 0 | 54 | 8 | 11 |
| 2019-11-12 | Bronx | 164 | 36 | 19.7926 | 14.8167 | 0.076513 | 0.450106 | 0.04 | 41 | 50 | 76 |
| 2019-11-12 | Brooklyn | 1789 | 1307 | 16.2854 | 13 | 0.00291 | 0.453831 | 0.04 | 41 | 136 | 136 |
| 2019-11-12 | EWR | 3 | 2 | 0.5444 | 0.5 | 0.729808 | 0.606277 | 0.04 | 41 | null | 0 |
| 2019-11-12 | Manhattan | 211140 | 209551 | 14.7058 | 11.95 | 0.121944 | 0.447266 | 0.04 | 41 | 201 | 70 |
| 2019-11-12 | Queens | 14355 | 13858 | 36.5334 | 33.5 | 0.078266 | 0.391976 | 0.04 | 41 | 90 | 117 |
| 2019-11-12 | Staten Island | 8 | 2 | 41.3375 | 27.6417 | -0.170533 | 0.084794 | 0.04 | 41 | 9 | 7 |
| 2019-11-13 | Bronx | 127 | 30 | 20.3814 | 16.1333 | 0.190513 | 0.63233 | 0 | 28.5 | 51 | 68 |
| 2019-11-13 | Brooklyn | 1911 | 1343 | 17.767 | 14.3 | 0.029061 | 0.490726 | 0 | 28.5 | 150 | 120 |
| 2019-11-13 | EWR | 2 | 1 | 17.3833 | 17.3833 | 0 | null | 0 | 28.5 | null | 0 |
| 2019-11-13 | Manhattan | 220662 | 218898 | 14.4609 | 12.1167 | 0.105359 | 0.39939 | 0 | 28.5 | 214 | 73 |
| 2019-11-13 | Queens | 14116 | 13583 | 36.8942 | 35.175 | 0.082771 | 0.372018 | 0 | 28.5 | 102 | 125 |
| 2019-11-13 | Staten Island | 6 | 1 | 51.2306 | 43.7333 | -0.069601 | null | 0 | 28.5 | 11 | 10 |