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-09-19 | Brooklyn | 2205 | 1555 | 17.7028 | 14.0833 | 0.061455 | 0.455352 | 0 | 61 | 181 | 136 |
| 2019-09-19 | EWR | 2 | 1 | 18.275 | 18.275 | -0.084557 | null | 0 | 61 | null | 0 |
| 2019-09-19 | Manhattan | 218196 | 216265 | 14.4757 | 12.0333 | 0.0749 | 0.386293 | 0 | 61 | 308 | 82 |
| 2019-09-19 | Queens | 15588 | 14970 | 38.0905 | 36.9333 | 0.12675 | 0.370913 | 0 | 61 | 140 | 105 |
| 2019-09-19 | Staten Island | 6 | 2 | 65.7389 | 56.9833 | -0.029365 | 0.0719 | 0 | 61 | 18 | 9 |
| 2019-09-20 | Bronx | 217 | 47 | 25.0181 | 18.0833 | 0.086534 | 0.886918 | 0 | 67 | 78 | 72 |
| 2019-09-20 | Brooklyn | 2466 | 1734 | 17.9482 | 14.925 | 0.054024 | 0.473834 | 0 | 67 | 160 | 149 |
| 2019-09-20 | EWR | 2 | 1 | 21.0333 | 21.0333 | 0.054067 | null | 0 | 67 | null | 0 |
| 2019-09-20 | Manhattan | 211830 | 209721 | 14.4375 | 11.8 | 0.072988 | 0.393217 | 0 | 67 | 293 | 104 |
| 2019-09-20 | Queens | 14981 | 14354 | 39.9062 | 38.6833 | 0.172886 | 0.379783 | 0 | 67 | 142 | 122 |
| 2019-09-20 | Staten Island | 4 | 2 | 69.0917 | 73.9833 | -0.130345 | 0.053626 | 0 | 67 | 17 | 15 |
| 2019-09-21 | Bronx | 324 | 71 | 16.3425 | 12.25 | -0.044069 | 0.583106 | 0 | 72.5 | 110 | 69 |
| 2019-09-21 | Brooklyn | 2823 | 1803 | 16.5041 | 14.0167 | 0.040091 | 0.447019 | 0 | 72.5 | 338 | 111 |
| 2019-09-21 | Manhattan | 205978 | 203210 | 13.3357 | 11.1167 | -0.00148 | 0.417978 | 0 | 72.5 | 421 | 65 |
| 2019-09-21 | Queens | 12387 | 11501 | 32.2691 | 31.1333 | -0.004859 | 0.398592 | 0 | 72.5 | 258 | 97 |
| 2019-09-21 | Staten Island | 1 | 0 | 63.8333 | 63.8333 | null | null | 0 | 72.5 | 39 | 14 |
| 2019-09-22 | Bronx | 259 | 52 | 16.8098 | 13.15 | -0.141049 | 0.607612 | 0 | 76.5 | 74 | 55 |
| 2019-09-22 | Brooklyn | 2539 | 1505 | 15.5283 | 13.6333 | -0.042852 | 0.516539 | 0 | 76.5 | 239 | 103 |
| 2019-09-22 | Manhattan | 173658 | 170944 | 12.7967 | 10.5 | -0.072798 | 0.417089 | 0 | 76.5 | 320 | 66 |
| 2019-09-22 | Queens | 16518 | 15704 | 33.1599 | 31.65 | 0.001681 | 0.391096 | 0 | 76.5 | 232 | 108 |
| 2019-09-22 | Staten Island | 5 | 0 | 62.9267 | 64.8 | null | null | 0 | 76.5 | 39 | 10 |
| 2019-09-23 | Bronx | 162 | 27 | 23.6969 | 17.5 | -0.040445 | 0.408432 | 0.11 | 79.5 | 72 | 55 |
| 2019-09-23 | Brooklyn | 1786 | 1188 | 18.3394 | 14.175 | 0.021102 | 0.439754 | 0.11 | 79.5 | 170 | 129 |
| 2019-09-23 | EWR | 1 | 0 | 3.35 | 3.35 | null | null | 0.11 | 79.5 | null | 0 |
| 2019-09-23 | Manhattan | 165705 | 164068 | 15.1557 | 11.65 | 0.10126 | 0.491322 | 0.11 | 79.5 | 246 | 92 |