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-05-25 | Brooklyn | 2277 | 1349 | 15.1523 | 13.1167 | -0.045208 | 0.46489 | 0 | 63 | 273 | 106 |
| 2019-05-25 | Manhattan | 160564 | 158047 | 11.624 | 9.7667 | -0.162126 | 0.396327 | 0 | 63 | 359 | 64 |
| 2019-05-25 | Queens | 11821 | 10928 | 25.3189 | 24.2 | -0.172798 | 0.39098 | 0 | 63 | 295 | 113 |
| 2019-05-25 | Staten Island | 4 | 0 | 26.1708 | 26.0333 | null | null | 0 | 63 | 30 | 8 |
| 2019-05-26 | Bronx | 421 | 46 | 16.8489 | 15.3667 | -0.245354 | 0.799393 | 0.2 | 72.5 | 109 | 53 |
| 2019-05-26 | Brooklyn | 2542 | 1432 | 15.7434 | 13.3333 | -0.071759 | 0.446734 | 0.2 | 72.5 | 265 | 119 |
| 2019-05-26 | Manhattan | 140023 | 137674 | 11.0823 | 9.2167 | -0.233203 | 0.393837 | 0.2 | 72.5 | 333 | 55 |
| 2019-05-26 | Queens | 12066 | 11105 | 26.5656 | 24.6333 | -0.150166 | 0.385976 | 0.2 | 72.5 | 271 | 98 |
| 2019-05-26 | Staten Island | 14 | 0 | 24.3107 | 15.1583 | null | null | 0.2 | 72.5 | 28 | 10 |
| 2019-05-27 | Bronx | 265 | 26 | 17.8164 | 14.4 | -0.09684 | 0.605974 | 0 | 72 | 114 | 47 |
| 2019-05-27 | Brooklyn | 1622 | 955 | 14.2233 | 11.9917 | -0.136762 | 0.457942 | 0 | 72 | 193 | 96 |
| 2019-05-27 | Manhattan | 118351 | 116680 | 10.2412 | 8.4833 | -0.321471 | 0.385354 | 0 | 72 | 244 | 40 |
| 2019-05-27 | Queens | 17140 | 16313 | 27.436 | 26.1333 | -0.171258 | 0.378315 | 0 | 72 | 188 | 75 |
| 2019-05-27 | Staten Island | 10 | 2 | 23.2383 | 8.05 | 0.290395 | 0.719061 | 0 | 72 | 25 | 13 |
| 2019-05-28 | Bronx | 259 | 36 | 26.0196 | 21.8667 | 0.05649 | 0.466506 | 0.17 | 66.5 | 138 | 51 |
| 2019-05-28 | Brooklyn | 1947 | 1218 | 18.5862 | 14.3833 | -0.040914 | 0.456262 | 0.17 | 66.5 | 233 | 145 |
| 2019-05-28 | Manhattan | 193470 | 191525 | 13.1191 | 10.9167 | -0.002394 | 0.394824 | 0.17 | 66.5 | 299 | 93 |
| 2019-05-28 | Queens | 16273 | 15472 | 35.795 | 33.8333 | 0.021485 | 0.352661 | 0.17 | 66.5 | 210 | 134 |
| 2019-05-28 | Staten Island | 5 | 2 | 58.3233 | 68.7333 | 0.145727 | 0.157246 | 0.17 | 66.5 | 36 | 5 |
| 2019-05-29 | Bronx | 314 | 63 | 24.9279 | 19.025 | -0.051119 | 0.846049 | 0.8 | 63 | 144 | 63 |
| 2019-05-29 | Brooklyn | 2340 | 1576 | 18.6491 | 14.2333 | -0.00299 | 0.469287 | 0.8 | 63 | 247 | 124 |
| 2019-05-29 | EWR | 1 | 0 | 87.6667 | 87.6667 | null | null | 0.8 | 63 | null | 0 |
| 2019-05-29 | Manhattan | 212900 | 210848 | 14.4228 | 11.8833 | 0.096737 | 0.414174 | 0.8 | 63 | 345 | 78 |
| 2019-05-29 | Queens | 16473 | 15629 | 35.4399 | 32.3 | 0.065537 | 0.356264 | 0.8 | 63 | 227 | 115 |
| 2019-05-29 | Staten Island | 6 | 0 | 32.2889 | 19.1583 | null | null | 0.8 | 63 | 36 | 7 |