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-11-18 | Brooklyn | 1797 | 1253 | 17.0825 | 13.8667 | -0.005384 | 0.475713 | 0.48 | 39.5 | 123 | 163 |
| 2019-11-18 | EWR | 1 | 1 | 0.4167 | 0.4167 | 0.198451 | null | 0.48 | 39.5 | null | 0 |
| 2019-11-18 | Manhattan | 197552 | 195973 | 13.2116 | 10.85 | 0.011542 | 0.387903 | 0.48 | 39.5 | 150 | 72 |
| 2019-11-18 | Queens | 14846 | 14173 | 38.2421 | 36.2833 | 0.09015 | 0.356365 | 0.48 | 39.5 | 71 | 150 |
| 2019-11-18 | Staten Island | 8 | 2 | 48.5521 | 46.825 | -0.050687 | 0.059741 | 0.48 | 39.5 | 9 | 12 |
| 2019-11-19 | Bronx | 132 | 34 | 22.0109 | 15.8167 | -0.147772 | 0.695563 | 0.18 | 44 | 43 | 72 |
| 2019-11-19 | Brooklyn | 1824 | 1321 | 16.3177 | 13.5583 | -0.030072 | 0.427346 | 0.18 | 44 | 134 | 138 |
| 2019-11-19 | EWR | 2 | 1 | 0.625 | 0.625 | 0.325422 | null | 0.18 | 44 | null | 0 |
| 2019-11-19 | Manhattan | 205166 | 203578 | 13.7264 | 11.5667 | 0.046541 | 0.385001 | 0.18 | 44 | 156 | 79 |
| 2019-11-19 | Queens | 13749 | 13216 | 35.4351 | 33.4 | 0.051153 | 0.382629 | 0.18 | 44 | 79 | 88 |
| 2019-11-19 | Staten Island | 4 | 2 | 47.9583 | 51.0833 | -0.193533 | 0.254981 | 0.18 | 44 | 9 | 9 |
| 2019-11-20 | Bronx | 151 | 37 | 21.0319 | 13.9 | 0.002901 | 0.587388 | 0 | 44.5 | 47 | 47 |
| 2019-11-20 | Brooklyn | 1907 | 1368 | 16.3666 | 13.7333 | -0.007008 | 0.425091 | 0 | 44.5 | 133 | 125 |
| 2019-11-20 | EWR | 4 | 2 | 1.2917 | 0.5167 | -0.45312 | 0.067394 | 0 | 44.5 | null | 0 |
| 2019-11-20 | Manhattan | 219343 | 217457 | 14.0305 | 11.8 | 0.064597 | 0.38862 | 0 | 44.5 | 169 | 59 |
| 2019-11-20 | Queens | 13522 | 12961 | 34.1746 | 32.7083 | 0.035461 | 0.365381 | 0 | 44.5 | 93 | 105 |
| 2019-11-20 | Staten Island | 7 | 1 | 53.4929 | 50.9 | 0.177345 | null | 0 | 44.5 | 12 | 11 |
| 2019-11-21 | Bronx | 125 | 26 | 24.2423 | 20.1833 | -0.180131 | 0.848697 | 0 | 46 | 43 | 74 |
| 2019-11-21 | Brooklyn | 1986 | 1458 | 16.6052 | 13.9167 | 0.008675 | 0.43762 | 0 | 46 | 118 | 148 |
| 2019-11-21 | EWR | 2 | 2 | 0.325 | 0.325 | -0.617112 | 1.293106 | 0 | 46 | null | 0 |
| 2019-11-21 | Manhattan | 228757 | 226775 | 14.5077 | 12.0333 | 0.079519 | 0.38066 | 0 | 46 | 161 | 90 |
| 2019-11-21 | Queens | 14667 | 14104 | 37.1817 | 35.9167 | 0.105969 | 0.402583 | 0 | 46 | 82 | 103 |
| 2019-11-21 | Staten Island | 5 | 1 | 67.05 | 70.8833 | -0.104826 | null | 0 | 46 | 9 | 15 |
| 2019-11-22 | Bronx | 178 | 40 | 20.116 | 15 | 0.096592 | 0.524535 | 0.07 | 45.5 | 43 | 61 |
| 2019-11-22 | Brooklyn | 2050 | 1443 | 16.2586 | 13.4917 | 0.029569 | 0.397737 | 0.07 | 45.5 | 104 | 149 |