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-08-03 | Bronx | 281 | 53 | 18.068 | 12.9333 | -0.143743 | 0.77141 | 0.21 | 77 | 211 | 76 |
| 2019-08-03 | Brooklyn | 2015 | 1228 | 15.6143 | 13.35 | -0.029972 | 0.502529 | 0.21 | 77 | 445 | 113 |
| 2019-08-03 | EWR | 1 | 0 | 42.9167 | 42.9167 | null | null | 0.21 | 77 | null | 0 |
| 2019-08-03 | Manhattan | 166875 | 164293 | 12.3891 | 10.3667 | -0.077943 | 0.41483 | 0.21 | 77 | 412 | 70 |
| 2019-08-03 | Queens | 11579 | 10828 | 28.6697 | 28.2 | -0.076344 | 0.39501 | 0.21 | 77 | 380 | 104 |
| 2019-08-03 | Staten Island | 9 | 0 | 32.6389 | 12.4167 | null | null | 0.21 | 77 | 54 | 11 |
| 2019-08-04 | Bronx | 330 | 61 | 16.0691 | 13.425 | -0.149082 | 0.715968 | 0 | 78 | 140 | 58 |
| 2019-08-04 | Brooklyn | 1955 | 1189 | 14.5762 | 12.6667 | -0.060297 | 0.476294 | 0 | 78 | 338 | 103 |
| 2019-08-04 | EWR | 3 | 2 | 3.3167 | 0.5 | -0.01961 | 0.75015 | 0 | 78 | null | 0 |
| 2019-08-04 | Manhattan | 143710 | 141584 | 11.5198 | 9.65 | -0.177846 | 0.395452 | 0 | 78 | 340 | 58 |
| 2019-08-04 | Queens | 15211 | 14350 | 29.8918 | 28.3833 | -0.067116 | 0.390396 | 0 | 78 | 315 | 90 |
| 2019-08-04 | Staten Island | 5 | 0 | 42.1233 | 40.3167 | null | null | 0 | 78 | 45 | 9 |
| 2019-08-05 | Bronx | 215 | 39 | 21.0375 | 16 | -0.019419 | 0.415758 | 0 | 76 | 115 | 67 |
| 2019-08-05 | Brooklyn | 1549 | 1028 | 16.1668 | 13.6333 | -0.08805 | 0.466524 | 0 | 76 | 277 | 144 |
| 2019-08-05 | Manhattan | 160076 | 158553 | 12.5817 | 10.5167 | -0.08257 | 0.375262 | 0 | 76 | 307 | 77 |
| 2019-08-05 | Queens | 15230 | 14586 | 32.9554 | 32.05 | -0.018673 | 0.356275 | 0 | 76 | 174 | 116 |
| 2019-08-05 | Staten Island | 4 | 0 | 75.6 | 75.325 | null | null | 0 | 76 | 37 | 8 |
| 2019-08-06 | Bronx | 232 | 33 | 20.4541 | 17.3417 | -0.037434 | 0.794664 | 0.04 | 75 | 134 | 57 |
| 2019-08-06 | Brooklyn | 1583 | 1044 | 17.4893 | 14.3833 | -0.008146 | 0.433492 | 0.04 | 75 | 305 | 125 |
| 2019-08-06 | EWR | 1 | 1 | 0.3333 | 0.3333 | -0.262364 | null | 0.04 | 75 | null | 0 |
| 2019-08-06 | Manhattan | 188754 | 186969 | 13.1045 | 11.0333 | -0.024735 | 0.376609 | 0.04 | 75 | 351 | 66 |
| 2019-08-06 | Queens | 12886 | 12226 | 31.348 | 29.8167 | -0.023329 | 0.352802 | 0.04 | 75 | 218 | 91 |
| 2019-08-06 | Staten Island | 10 | 0 | 31.7383 | 14.6417 | null | null | 0.04 | 75 | 47 | 8 |
| 2019-08-07 | Bronx | 192 | 28 | 21.0965 | 16.2833 | 0.018516 | 0.397797 | 1.18 | 76.5 | 130 | 67 |
| 2019-08-07 | Brooklyn | 1646 | 1096 | 17.0823 | 14.05 | -0.016899 | 0.468541 | 1.18 | 76.5 | 304 | 131 |