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-10-23 | Queens | 15379 | 14835 | 37.6226 | 35.9667 | 0.102078 | 0.390175 | 0.01 | 59.5 | 154 | 132 |
| 2019-10-23 | Staten Island | 8 | 0 | 69.0917 | 72.675 | null | null | 0.01 | 59.5 | 15 | 12 |
| 2019-10-24 | Bronx | 151 | 42 | 20.3432 | 15.0167 | 0.031222 | 0.686268 | 0 | 58.5 | 85 | 61 |
| 2019-10-24 | Brooklyn | 2234 | 1593 | 18.3594 | 14.6917 | 0.069554 | 0.494855 | 0 | 58.5 | 180 | 135 |
| 2019-10-24 | EWR | 2 | 1 | 33.1833 | 33.1833 | -0.587787 | null | 0 | 58.5 | null | 0 |
| 2019-10-24 | Manhattan | 220890 | 219032 | 15.3436 | 12.5833 | 0.119763 | 0.386998 | 0 | 58.5 | 283 | 71 |
| 2019-10-24 | Queens | 15682 | 15094 | 39.0122 | 37.8833 | 0.125322 | 0.374797 | 0 | 58.5 | 140 | 127 |
| 2019-10-24 | Staten Island | 10 | 1 | 47.875 | 41.9 | -0.016302 | null | 0 | 58.5 | 15 | 6 |
| 2019-10-25 | Bronx | 149 | 34 | 22.8125 | 16.6333 | 0.031157 | 0.552229 | 0 | 58.5 | 74 | 63 |
| 2019-10-25 | Brooklyn | 2355 | 1663 | 16.9358 | 14.3333 | 0.022029 | 0.478581 | 0 | 58.5 | 139 | 135 |
| 2019-10-25 | EWR | 1 | 1 | 0.1833 | 0.1833 | -0.204794 | null | 0 | 58.5 | null | 0 |
| 2019-10-25 | Manhattan | 219479 | 217348 | 14.4037 | 12.0167 | 0.084885 | 0.384706 | 0 | 58.5 | 258 | 84 |
| 2019-10-25 | Queens | 15318 | 14660 | 38.4328 | 37.75 | 0.121066 | 0.374137 | 0 | 58.5 | 143 | 134 |
| 2019-10-25 | Staten Island | 11 | 2 | 39.5864 | 28.9167 | -0.017304 | 0.312469 | 0 | 58.5 | 15 | 11 |
| 2019-10-26 | Bronx | 161 | 25 | 19.7881 | 14.0333 | -0.236064 | 0.7361 | 0.01 | 57.5 | 90 | 51 |
| 2019-10-26 | Brooklyn | 2984 | 1820 | 16.7592 | 14.4917 | 0.043855 | 0.427967 | 0.01 | 57.5 | 244 | 108 |
| 2019-10-26 | Manhattan | 216321 | 213546 | 13.5898 | 11.3333 | 0.025689 | 0.419187 | 0.01 | 57.5 | 336 | 71 |
| 2019-10-26 | Queens | 11721 | 10897 | 30.015 | 29.25 | -0.038251 | 0.409313 | 0.01 | 57.5 | 217 | 93 |
| 2019-10-26 | Staten Island | 7 | 0 | 46.5643 | 37.9167 | null | null | 0.01 | 57.5 | 24 | 8 |
| 2019-10-27 | Bronx | 151 | 26 | 16.1401 | 11.8333 | 0.014264 | 0.484617 | 1.38 | 61 | 64 | 37 |
| 2019-10-27 | Brooklyn | 2832 | 1589 | 15.5787 | 13.9667 | 0.00272 | 0.489917 | 1.38 | 61 | 220 | 90 |
| 2019-10-27 | EWR | 2 | 1 | 0.2167 | 0.2167 | 0.024098 | null | 1.38 | 61 | null | 0 |
| 2019-10-27 | Manhattan | 176813 | 174093 | 12.3415 | 10.2167 | -0.084423 | 0.409688 | 1.38 | 61 | 279 | 65 |
| 2019-10-27 | Queens | 15819 | 15009 | 27.1279 | 26.8333 | -0.144738 | 0.381484 | 1.38 | 61 | 191 | 92 |
| 2019-10-27 | Staten Island | 9 | 2 | 35.3778 | 25.2167 | -0.06696 | 0.402578 | 1.38 | 61 | 29 | 11 |