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-20 | Staten Island | 4 | 0 | 42.7542 | 30.7583 | null | null | 0 | 75.5 | 32 | 11 |
| 2019-05-21 | Bronx | 269 | 46 | 26.7032 | 20.9833 | -0.11075 | 0.818309 | 0 | 63.5 | 141 | 82 |
| 2019-05-21 | Brooklyn | 2356 | 1484 | 18.8466 | 14.6083 | -0.044853 | 0.5415 | 0 | 63.5 | 240 | 131 |
| 2019-05-21 | EWR | 2 | 0 | 22.65 | 22.65 | null | null | 0 | 63.5 | null | 0 |
| 2019-05-21 | Manhattan | 222176 | 220014 | 14.0646 | 11.5167 | 0.036202 | 0.387085 | 0 | 63.5 | 353 | 107 |
| 2019-05-21 | Queens | 15978 | 15218 | 34.8344 | 33.4167 | 0.044908 | 0.352963 | 0 | 63.5 | 211 | 165 |
| 2019-05-21 | Staten Island | 4 | 2 | 56.1542 | 56.3 | 0.357371 | 0.354693 | 0 | 63.5 | 35 | 10 |
| 2019-05-22 | Bronx | 368 | 46 | 27.6922 | 22.9583 | -0.050357 | 0.666946 | 0 | 64 | 146 | 83 |
| 2019-05-22 | Brooklyn | 2515 | 1650 | 19.1791 | 14.8 | -0.001467 | 0.435823 | 0 | 64 | 268 | 140 |
| 2019-05-22 | EWR | 1 | 1 | 2.2667 | 2.2667 | 2.022283 | null | 0 | 64 | null | 0 |
| 2019-05-22 | Manhattan | 228375 | 225816 | 14.4138 | 11.7667 | 0.05842 | 0.39604 | 0 | 64 | 389 | 101 |
| 2019-05-22 | Queens | 15492 | 14728 | 36.3904 | 35.2917 | 0.084535 | 0.386838 | 0 | 64 | 233 | 117 |
| 2019-05-22 | Staten Island | 6 | 2 | 67.5444 | 66.6333 | 0.394303 | 0.32398 | 0 | 64 | 36 | 7 |
| 2019-05-23 | Bronx | 261 | 47 | 29.5936 | 22.05 | 0.092568 | 0.684765 | 0.48 | 63.5 | 145 | 86 |
| 2019-05-23 | Brooklyn | 2716 | 1782 | 19.9518 | 14.9583 | 0.045622 | 0.456316 | 0.48 | 63.5 | 298 | 160 |
| 2019-05-23 | EWR | 1 | 1 | 6.8 | 6.8 | 3.120895 | null | 0.48 | 63.5 | null | 0 |
| 2019-05-23 | Manhattan | 225479 | 223093 | 14.6563 | 11.7333 | 0.078958 | 0.397754 | 0.48 | 63.5 | 398 | 85 |
| 2019-05-23 | Queens | 15048 | 14239 | 38.7194 | 36.6833 | 0.147303 | 0.414708 | 0.48 | 63.5 | 246 | 128 |
| 2019-05-23 | Staten Island | 12 | 2 | 42.9778 | 32.4917 | 0.179887 | 0.237686 | 0.48 | 63.5 | 39 | 6 |
| 2019-05-24 | Bronx | 332 | 52 | 25.8208 | 22.35 | 0.027428 | 0.439499 | 0 | 67 | 161 | 79 |
| 2019-05-24 | Brooklyn | 2589 | 1547 | 19.5482 | 15.55 | -0.01477 | 0.497642 | 0 | 67 | 222 | 148 |
| 2019-05-24 | Manhattan | 195232 | 192694 | 13.5649 | 10.9167 | -0.002783 | 0.396314 | 0 | 67 | 303 | 88 |
| 2019-05-24 | Queens | 16055 | 15157 | 35.3918 | 33.05 | 0.068974 | 0.362324 | 0 | 67 | 225 | 130 |
| 2019-05-24 | Staten Island | 5 | 0 | 26.5 | 12.7333 | null | null | 0 | 67 | 27 | 13 |
| 2019-05-25 | Bronx | 298 | 59 | 17.4911 | 13.5917 | -0.249735 | 0.600888 | 0 | 63 | 151 | 59 |