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-08-24 | Manhattan | 155948 | 153331 | 12.2068 | 10.2833 | -0.115442 | 0.402863 | 0 | 70 | 407 | 62 |
| 2019-08-24 | Queens | 11887 | 11080 | 29.414 | 27.8833 | -0.060686 | 0.375787 | 0 | 70 | 415 | 103 |
| 2019-08-24 | Staten Island | 6 | 1 | 68.8139 | 65.7417 | 0.177192 | null | 0 | 70 | 51 | 12 |
| 2019-08-25 | Bronx | 201 | 26 | 14.588 | 11.45 | -0.041212 | 0.590669 | 0 | 70 | 135 | 51 |
| 2019-08-25 | Brooklyn | 2026 | 1218 | 14.8844 | 12.875 | -0.075237 | 0.482053 | 0 | 70 | 311 | 87 |
| 2019-08-25 | EWR | 1 | 1 | 1.6333 | 1.6333 | 1.876917 | null | 0 | 70 | null | 0 |
| 2019-08-25 | Manhattan | 136305 | 134068 | 11.7721 | 9.8667 | -0.171108 | 0.395341 | 0 | 70 | 310 | 58 |
| 2019-08-25 | Queens | 15134 | 14328 | 29.3346 | 28.0333 | -0.069773 | 0.38243 | 0 | 70 | 274 | 104 |
| 2019-08-25 | Staten Island | 3 | 2 | 58.2222 | 64.8 | 0.05974 | 0.052316 | 0 | 70 | 28 | 7 |
| 2019-08-26 | Bronx | 168 | 29 | 19.679 | 16.0333 | -0.210068 | 0.66473 | 0 | 67.5 | 82 | 51 |
| 2019-08-26 | Brooklyn | 1305 | 852 | 15.608 | 13.5667 | -0.111092 | 0.469013 | 0 | 67.5 | 173 | 118 |
| 2019-08-26 | EWR | 1 | 0 | 25.1667 | 25.1667 | null | null | 0 | 67.5 | null | 0 |
| 2019-08-26 | Manhattan | 143143 | 141600 | 11.9336 | 9.9667 | -0.131184 | 0.371702 | 0 | 67.5 | 262 | 68 |
| 2019-08-26 | Queens | 15583 | 14786 | 30.4611 | 29.5167 | -0.052785 | 0.348271 | 0 | 67.5 | 142 | 92 |
| 2019-08-26 | Staten Island | 4 | 2 | 43.2375 | 43.575 | 0.018933 | 0.058728 | 0 | 67.5 | 25 | 5 |
| 2019-08-27 | Bronx | 169 | 37 | 19.9444 | 15.3833 | -0.145 | 0.568298 | 0 | 68.5 | 87 | 49 |
| 2019-08-27 | Brooklyn | 1444 | 913 | 16.1718 | 14.1833 | -0.053613 | 0.43218 | 0 | 68.5 | 170 | 109 |
| 2019-08-27 | EWR | 3 | 3 | 0.9222 | 0.6333 | 0.827108 | 0.745239 | 0 | 68.5 | null | 0 |
| 2019-08-27 | Manhattan | 161899 | 160251 | 12.2949 | 10.3667 | -0.085637 | 0.365149 | 0 | 68.5 | 267 | 66 |
| 2019-08-27 | Queens | 14239 | 13565 | 31.1647 | 29.9167 | -0.042391 | 0.340612 | 0 | 68.5 | 143 | 92 |
| 2019-08-27 | Staten Island | 5 | 2 | 40.6333 | 38.4333 | 0.069299 | 0.044148 | 0 | 68.5 | 22 | 9 |
| 2019-08-28 | Bronx | 164 | 30 | 21.34 | 17.0583 | -0.422955 | 1.333669 | 0.08 | 70.5 | 90 | 41 |
| 2019-08-28 | Brooklyn | 1598 | 1069 | 16.0969 | 12.9917 | -0.038481 | 0.448589 | 0.08 | 70.5 | 177 | 120 |
| 2019-08-28 | Manhattan | 174727 | 173069 | 12.857 | 10.6667 | -0.044551 | 0.377415 | 0.08 | 70.5 | 295 | 76 |
| 2019-08-28 | Queens | 14363 | 13644 | 32.854 | 31.9667 | 0.036526 | 0.366493 | 0.08 | 70.5 | 150 | 88 |