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-08 | Bronx | 308 | 53 | 25.019 | 21.325 | -0.050011 | 0.543929 | 0 | 63 | 155 | 68 |
| 2019-05-08 | Brooklyn | 2777 | 1821 | 18.143 | 14.4167 | -0.015711 | 0.422071 | 0 | 63 | 250 | 136 |
| 2019-05-08 | EWR | 3 | 3 | 0.2778 | 0.35 | -0.341501 | 1.32869 | 0 | 63 | null | 0 |
| 2019-05-08 | Manhattan | 223387 | 221066 | 14.1027 | 11.65 | 0.044299 | 0.397155 | 0 | 63 | 372 | 85 |
| 2019-05-08 | Queens | 16501 | 15663 | 35.7791 | 34.9667 | 0.064415 | 0.355283 | 0 | 63 | 228 | 105 |
| 2019-05-08 | Staten Island | 11 | 2 | 25.6712 | 20 | 0.040071 | 0.070683 | 0 | 63 | 34 | 15 |
| 2019-05-09 | Bronx | 304 | 60 | 24.36 | 18.5417 | -0.030984 | 0.581416 | 0 | 57 | 147 | 64 |
| 2019-05-09 | Brooklyn | 2668 | 1774 | 18.8521 | 14.1917 | -0.010986 | 0.459838 | 0 | 57 | 250 | 126 |
| 2019-05-09 | EWR | 1 | 1 | 2.3833 | 2.3833 | 1.94242 | null | 0 | 57 | null | 0 |
| 2019-05-09 | Manhattan | 237082 | 234617 | 14.3123 | 11.8333 | 0.064713 | 0.392631 | 0 | 57 | 390 | 75 |
| 2019-05-09 | Queens | 16169 | 15399 | 34.8838 | 33.5667 | 0.04368 | 0.340607 | 0 | 57 | 232 | 107 |
| 2019-05-09 | Staten Island | 6 | 1 | 41.5861 | 49.975 | 0.189519 | null | 0 | 57 | 35 | 14 |
| 2019-05-10 | Bronx | 354 | 79 | 22.0067 | 17.6667 | -0.05348 | 0.90896 | 0.04 | 64.5 | 157 | 79 |
| 2019-05-10 | Brooklyn | 3057 | 2015 | 18.2398 | 14.6667 | 0.035792 | 0.436383 | 0.04 | 64.5 | 227 | 154 |
| 2019-05-10 | EWR | 2 | 2 | 0.1583 | 0.1583 | -0.640467 | 0.074501 | 0.04 | 64.5 | null | 0 |
| 2019-05-10 | Manhattan | 230974 | 228402 | 13.569 | 11.1333 | 0.025901 | 0.384204 | 0.04 | 64.5 | 325 | 90 |
| 2019-05-10 | Queens | 16042 | 15240 | 34.6481 | 33.3083 | 0.050403 | 0.365482 | 0.04 | 64.5 | 211 | 106 |
| 2019-05-10 | Staten Island | 4 | 2 | 61.45 | 67.2417 | 0.057377 | 0.213527 | 0.04 | 64.5 | 28 | 5 |
| 2019-05-11 | Bronx | 358 | 72 | 18.289 | 14.8917 | -0.07853 | 0.474434 | 0.04 | 62.5 | 156 | 72 |
| 2019-05-11 | Brooklyn | 3574 | 2239 | 16.4061 | 14.0667 | 0.038449 | 0.476803 | 0.04 | 62.5 | 291 | 138 |
| 2019-05-11 | Manhattan | 222748 | 219765 | 12.097 | 10.1333 | -0.080256 | 0.39393 | 0.04 | 62.5 | 448 | 75 |
| 2019-05-11 | Queens | 12371 | 11436 | 31.2346 | 29.4333 | -0.031346 | 0.397864 | 0.04 | 62.5 | 306 | 132 |
| 2019-05-11 | Staten Island | 5 | 0 | 32.54 | 39.9833 | null | null | 0.04 | 62.5 | 35 | 8 |
| 2019-05-12 | Bronx | 338 | 46 | 17.7032 | 14.5167 | -0.345366 | 0.807763 | 1.32 | 51 | 105 | 55 |
| 2019-05-12 | Brooklyn | 2708 | 1637 | 14.6516 | 12.1333 | -0.059553 | 0.487805 | 1.32 | 51 | 265 | 130 |