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-07-29 | Manhattan | 168774 | 167202 | 12.3509 | 10.3167 | -0.082741 | 0.374041 | 0 | 81.5 | 309 | 74 |
| 2019-07-29 | Queens | 14959 | 14228 | 33.5171 | 32.0833 | -0.001773 | 0.346251 | 0 | 81.5 | 187 | 143 |
| 2019-07-29 | Staten Island | 6 | 2 | 59.1167 | 62.6083 | 0.44642 | 0.052533 | 0 | 81.5 | 40 | 10 |
| 2019-07-30 | Bronx | 258 | 44 | 22.7828 | 18.975 | -0.07567 | 0.513456 | 0.01 | 85 | 141 | 65 |
| 2019-07-30 | Brooklyn | 1685 | 1102 | 17.9953 | 14.4 | -0.010328 | 0.458097 | 0.01 | 85 | 294 | 132 |
| 2019-07-30 | EWR | 2 | 2 | 0.525 | 0.525 | 0.23471 | 1.207384 | 0.01 | 85 | null | 0 |
| 2019-07-30 | Manhattan | 194179 | 192475 | 13.5221 | 11.1833 | 0.017079 | 0.391848 | 0.01 | 85 | 337 | 79 |
| 2019-07-30 | Queens | 13515 | 12853 | 33.2279 | 32.4167 | 0.019453 | 0.376983 | 0.01 | 85 | 215 | 119 |
| 2019-07-30 | Staten Island | 6 | 2 | 52.2806 | 51.95 | 0.073712 | 0.02769 | 0.01 | 85 | 45 | 14 |
| 2019-07-31 | Bronx | 205 | 33 | 25.3353 | 18.8167 | -0.093268 | 0.835945 | 0.36 | 78.5 | 137 | 44 |
| 2019-07-31 | Brooklyn | 1859 | 1197 | 17.9437 | 14.4833 | -0.022978 | 0.448738 | 0.36 | 78.5 | 311 | 120 |
| 2019-07-31 | Manhattan | 196302 | 194434 | 14.2988 | 11.85 | 0.068826 | 0.401837 | 0.36 | 78.5 | 378 | 98 |
| 2019-07-31 | Queens | 13192 | 12506 | 34.1836 | 31.6167 | 0.051605 | 0.364906 | 0.36 | 78.5 | 219 | 118 |
| 2019-07-31 | Staten Island | 6 | 1 | 62.2972 | 62.5083 | 0.111768 | null | 0.36 | 78.5 | 46 | 4 |
| 2019-08-01 | Bronx | 218 | 51 | 22.8284 | 18.0583 | 0.153166 | 0.510686 | 0 | 78.5 | 138 | 71 |
| 2019-08-01 | Brooklyn | 2124 | 1431 | 17.4266 | 14.4 | 0.028862 | 0.446587 | 0 | 78.5 | 305 | 130 |
| 2019-08-01 | EWR | 1 | 1 | 0.3333 | 0.3333 | -0.024693 | null | 0 | 78.5 | null | 0 |
| 2019-08-01 | Manhattan | 200546 | 198492 | 14.1086 | 11.6333 | 0.035008 | 0.382735 | 0 | 78.5 | 386 | 78 |
| 2019-08-01 | Queens | 16460 | 15717 | 35.3146 | 33.7833 | 0.065954 | 0.354441 | 0 | 78.5 | 208 | 114 |
| 2019-08-01 | Staten Island | 7 | 2 | 48.4786 | 34.8167 | 0.300521 | 0.339094 | 0 | 78.5 | 47 | 4 |
| 2019-08-02 | Bronx | 317 | 44 | 20.6012 | 16.7167 | 0.010226 | 0.527258 | 0 | 78.5 | 132 | 65 |
| 2019-08-02 | Brooklyn | 1983 | 1297 | 16.9114 | 13.9167 | 0.037436 | 0.477534 | 0 | 78.5 | 278 | 126 |
| 2019-08-02 | Manhattan | 185042 | 182779 | 13.3966 | 11.15 | -0.000981 | 0.389786 | 0 | 78.5 | 310 | 80 |
| 2019-08-02 | Queens | 14249 | 13502 | 33.6568 | 32.8667 | 0.040955 | 0.371021 | 0 | 78.5 | 201 | 108 |
| 2019-08-02 | Staten Island | 6 | 2 | 50.3361 | 49.2583 | 0.124089 | 0.057711 | 0 | 78.5 | 35 | 11 |