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-08 | Bronx | 191 | 33 | 22.4968 | 17.4167 | -0.021756 | 0.375478 | 0.04 | 73 | 113 | 73 |
| 2019-07-08 | Brooklyn | 1570 | 962 | 17.883 | 14.1583 | -0.068259 | 0.468202 | 0.04 | 73 | 285 | 125 |
| 2019-07-08 | EWR | 2 | 1 | 0.0917 | 0.0917 | -1.427116 | null | 0.04 | 73 | null | 0 |
| 2019-07-08 | Manhattan | 157585 | 155914 | 12.2957 | 10.2333 | -0.090685 | 0.377132 | 0.04 | 73 | 313 | 72 |
| 2019-07-08 | Queens | 18619 | 17840 | 33.1941 | 31.55 | -0.011681 | 0.329742 | 0.04 | 73 | 192 | 117 |
| 2019-07-08 | Staten Island | 7 | 2 | 37.6667 | 27.85 | 0.091801 | 0.092413 | 0.04 | 73 | 34 | 8 |
| 2019-07-09 | Bronx | 246 | 41 | 22.4661 | 18.0583 | -0.019667 | 0.535479 | 0 | 78 | 131 | 80 |
| 2019-07-09 | Brooklyn | 1780 | 1102 | 18.3262 | 15.4 | -0.016355 | 0.416245 | 0 | 78 | 291 | 139 |
| 2019-07-09 | Manhattan | 185839 | 184173 | 13.0828 | 11.0333 | -0.017138 | 0.379577 | 0 | 78 | 344 | 75 |
| 2019-07-09 | Queens | 15236 | 14533 | 32.7236 | 31.1167 | -0.022612 | 0.341936 | 0 | 78 | 203 | 118 |
| 2019-07-09 | Staten Island | 4 | 2 | 52.3167 | 45.6917 | 0.096738 | 0.172106 | 0 | 78 | 46 | 10 |
| 2019-07-10 | Bronx | 266 | 41 | 22.0111 | 19.0917 | -0.149023 | 0.831049 | 0 | 81 | 132 | 58 |
| 2019-07-10 | Brooklyn | 2112 | 1339 | 18.645 | 14.4 | 0.035778 | 0.518705 | 0 | 81 | 294 | 115 |
| 2019-07-10 | EWR | 2 | 1 | 0.3 | 0.3 | 0.565314 | null | 0 | 81 | null | 0 |
| 2019-07-10 | Manhattan | 203246 | 201334 | 13.1894 | 11.0667 | -0.007209 | 0.3806 | 0 | 81 | 384 | 78 |
| 2019-07-10 | Queens | 14404 | 13699 | 33.0532 | 31.7167 | -0.006353 | 0.331792 | 0 | 81 | 215 | 107 |
| 2019-07-10 | Staten Island | 8 | 1 | 40.8333 | 37.9417 | 0.171408 | null | 0 | 81 | 43 | 8 |
| 2019-07-11 | Bronx | 247 | 38 | 24.4218 | 18.5333 | 0.047474 | 0.545201 | 0.79 | 80 | 129 | 63 |
| 2019-07-11 | Brooklyn | 1982 | 1333 | 18.567 | 14.3167 | 0.048017 | 0.413792 | 0.79 | 80 | 298 | 151 |
| 2019-07-11 | Manhattan | 210302 | 208338 | 14.7345 | 12.05 | 0.102315 | 0.409931 | 0.79 | 80 | 383 | 86 |
| 2019-07-11 | Queens | 12773 | 12111 | 35.5707 | 34.35 | 0.068014 | 0.36247 | 0.79 | 80 | 222 | 130 |
| 2019-07-11 | Staten Island | 11 | 0 | 23.4606 | 7.5167 | null | null | 0.79 | 80 | 45 | 13 |
| 2019-07-12 | Bronx | 295 | 51 | 21.6029 | 16.9667 | 0.087581 | 0.679812 | 0 | 79.5 | 130 | 75 |
| 2019-07-12 | Brooklyn | 2003 | 1307 | 18.0227 | 14.2 | 0.025616 | 0.46351 | 0 | 79.5 | 282 | 142 |
| 2019-07-12 | EWR | 1 | 1 | 0.05 | 0.05 | -1.921813 | null | 0 | 79.5 | null | 0 |