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-12-14 | EWR | 3 | 3 | 1.05 | 0.8333 | 0.920829 | 0.633602 | 1.16 | 50.5 | null | 0 |
| 2019-12-14 | Manhattan | 233936 | 230943 | 14.1298 | 11.65 | 0.072548 | 0.440778 | 1.16 | 50.5 | 63 | 58 |
| 2019-12-14 | Queens | 11509 | 10747 | 31.6932 | 29.95 | 0.018209 | 0.408879 | 1.16 | 50.5 | 25 | 109 |
| 2019-12-14 | Staten Island | 9 | 0 | 36.0463 | 20.0167 | null | null | 1.16 | 50.5 | 6 | 9 |
| 2019-12-15 | Bronx | 161 | 37 | 15.396 | 11.05 | 0.00102 | 0.670741 | 0 | 43 | 8 | 52 |
| 2019-12-15 | Brooklyn | 3109 | 1941 | 15.7711 | 13.6333 | -0.009602 | 0.432221 | 0 | 43 | 17 | 108 |
| 2019-12-15 | EWR | 2 | 0 | 23.7083 | 23.7083 | null | null | 0 | 43 | null | 0 |
| 2019-12-15 | Manhattan | 201713 | 198950 | 12.6599 | 10.3833 | -0.065208 | 0.418819 | 0 | 43 | 34 | 77 |
| 2019-12-15 | Queens | 14589 | 13805 | 29.2196 | 27.7333 | -0.070846 | 0.376189 | 0 | 43 | 17 | 82 |
| 2019-12-15 | Staten Island | 6 | 0 | 56.7222 | 61.1417 | null | null | 0 | 43 | 5 | 9 |
| 2019-12-16 | Bronx | 150 | 33 | 19.7894 | 14.8917 | -0.051609 | 0.554338 | 0.1 | 35 | 3 | 51 |
| 2019-12-16 | Brooklyn | 1576 | 1182 | 16.0644 | 13.0583 | -0.017508 | 0.419605 | 0.1 | 35 | 7 | 107 |
| 2019-12-16 | EWR | 2 | 1 | 0.35 | 0.35 | 0.332134 | null | 0.1 | 35 | null | 0 |
| 2019-12-16 | Manhattan | 206303 | 204557 | 13.5349 | 11.1833 | 0.032808 | 0.391365 | 0.1 | 35 | 24 | 74 |
| 2019-12-16 | Queens | 13485 | 12959 | 34.1723 | 32.7333 | 0.044134 | 0.371766 | 0.1 | 35 | 5 | 101 |
| 2019-12-16 | Staten Island | 4 | 1 | 47.875 | 55.1583 | -0.383646 | null | 0.1 | 35 | 3 | 8 |
| 2019-12-17 | Bronx | 167 | 29 | 22.5544 | 17.75 | 0.163139 | 0.629661 | 0.9 | 33.5 | 1 | 79 |
| 2019-12-17 | Brooklyn | 2075 | 1499 | 16.4158 | 13.3833 | 0.030858 | 0.4241 | 0.9 | 33.5 | 6 | 141 |
| 2019-12-17 | EWR | 2 | 0 | 0.325 | 0.325 | null | null | 0.9 | 33.5 | null | 0 |
| 2019-12-17 | Manhattan | 226894 | 224970 | 14.0127 | 11.55 | 0.086283 | 0.403527 | 0.9 | 33.5 | 29 | 99 |
| 2019-12-17 | Queens | 11993 | 11410 | 36.2447 | 33.7667 | 0.103309 | 0.390603 | 0.9 | 33.5 | 7 | 152 |
| 2019-12-17 | Staten Island | 5 | 1 | 32.9567 | 28.9333 | -0.009677 | null | 0.9 | 33.5 | 3 | 6 |
| 2019-12-18 | Bronx | 150 | 33 | 22.916 | 17.0417 | 0.071099 | 0.531524 | 0.03 | 28.5 | 1 | 74 |
| 2019-12-18 | Brooklyn | 2217 | 1631 | 16.2783 | 13 | 0.016728 | 0.445807 | 0.03 | 28.5 | 4 | 157 |
| 2019-12-18 | EWR | 4 | 4 | 0.1417 | 0.075 | -1.159052 | 0.919843 | 0.03 | 28.5 | null | 0 |