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-18 | Manhattan | 235870 | 233771 | 14.5302 | 11.75 | 0.100827 | 0.412576 | 0.03 | 28.5 | 26 | 72 |
| 2019-12-18 | Queens | 12308 | 11727 | 35.1228 | 32.6667 | 0.090249 | 0.413074 | 0.03 | 28.5 | 7 | 142 |
| 2019-12-18 | Staten Island | 7 | 2 | 55.0976 | 65.3667 | 0.090541 | 0.11916 | 0.03 | 28.5 | 3 | 10 |
| 2019-12-19 | Bronx | 178 | 35 | 21.4523 | 15.9583 | 0.069021 | 0.728722 | 0 | 20.5 | 6 | 63 |
| 2019-12-19 | Brooklyn | 2418 | 1707 | 16.6053 | 13.3667 | -0.015106 | 0.444827 | 0 | 20.5 | 15 | 158 |
| 2019-12-19 | EWR | 4 | 2 | 18.6375 | 1 | 0.296356 | 0.599895 | 0 | 20.5 | null | 0 |
| 2019-12-19 | Manhattan | 253050 | 250604 | 14.4711 | 11.8167 | 0.109391 | 0.411297 | 0 | 20.5 | 29 | 72 |
| 2019-12-19 | Queens | 13596 | 12943 | 37.2244 | 34.0083 | 0.157495 | 0.406166 | 0 | 20.5 | 6 | 131 |
| 2019-12-19 | Staten Island | 5 | 1 | 39.5767 | 25.1333 | 0.190846 | null | 0 | 20.5 | 3 | 13 |
| 2019-12-20 | Bronx | 223 | 41 | 20.9747 | 16.7167 | 0.045554 | 0.600699 | 0 | 27.5 | 2 | 80 |
| 2019-12-20 | Brooklyn | 2597 | 1813 | 17.1163 | 13.9167 | 0.043788 | 0.411771 | 0 | 27.5 | 10 | 170 |
| 2019-12-20 | EWR | 3 | 3 | 0.1167 | 0.05 | -1.316897 | 0.869942 | 0 | 27.5 | null | 0 |
| 2019-12-20 | Manhattan | 241574 | 238787 | 14.046 | 11.4 | 0.077164 | 0.403187 | 0 | 27.5 | 34 | 77 |
| 2019-12-20 | Queens | 12790 | 12131 | 38.0086 | 36.2333 | 0.148856 | 0.385343 | 0 | 27.5 | 6 | 112 |
| 2019-12-20 | Staten Island | 7 | 1 | 57.0429 | 52.6667 | 0.04184 | null | 0 | 27.5 | 4 | 14 |
| 2019-12-21 | Bronx | 182 | 27 | 17.6553 | 11.7167 | -0.106588 | 0.339409 | 0 | 29 | 8 | 53 |
| 2019-12-21 | Brooklyn | 2044 | 1304 | 14.8926 | 12.4333 | -0.074028 | 0.451536 | 0 | 29 | 18 | 118 |
| 2019-12-21 | EWR | 1 | 1 | 5.6667 | 5.6667 | 3.025585 | null | 0 | 29 | null | 0 |
| 2019-12-21 | Manhattan | 201260 | 198681 | 12.5126 | 10.35 | -0.046188 | 0.426538 | 0 | 29 | 52 | 53 |
| 2019-12-21 | Queens | 10070 | 9390 | 29.7749 | 27.05 | -0.023456 | 0.417798 | 0 | 29 | 14 | 99 |
| 2019-12-21 | Staten Island | 6 | 0 | 46.1778 | 50.8333 | null | null | 0 | 29 | 8 | 13 |
| 2019-12-22 | Bronx | 183 | 29 | 14.7431 | 11.7833 | -0.234347 | 0.672368 | 0 | 38 | 7 | 62 |
| 2019-12-22 | Brooklyn | 1655 | 975 | 14.7631 | 12.3833 | -0.135979 | 0.499873 | 0 | 38 | 12 | 104 |
| 2019-12-22 | EWR | 1 | 1 | 0.2167 | 0.2167 | 0.039221 | null | 0 | 38 | null | 0 |
| 2019-12-22 | Manhattan | 154641 | 152376 | 12.6605 | 10.2833 | -0.073697 | 0.441166 | 0 | 38 | 45 | 52 |