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-04-20 | Bronx | 292 | 64 | 14.5149 | 11.3667 | 0.029169 | 0.566738 | 0.7 | 59.5 | 121 | 52 |
| 2019-04-20 | Brooklyn | 2618 | 1653 | 13.9873 | 11.9333 | -0.068586 | 0.443683 | 0.7 | 59.5 | 245 | 89 |
| 2019-04-20 | Manhattan | 186757 | 184238 | 11.6381 | 9.7833 | -0.114389 | 0.408288 | 0.7 | 59.5 | 371 | 57 |
| 2019-04-20 | Queens | 10441 | 9569 | 24.2438 | 23.4833 | -0.182628 | 0.391752 | 0.7 | 59.5 | 262 | 100 |
| 2019-04-20 | Staten Island | 13 | 2 | 21.8833 | 15.9833 | -0.292282 | 0.043104 | 0.7 | 59.5 | 30 | 8 |
| 2019-04-21 | Bronx | 409 | 63 | 17.9886 | 14.6167 | -0.208232 | 0.786801 | 0 | 59.5 | 85 | 47 |
| 2019-04-21 | Brooklyn | 2889 | 1633 | 14.5691 | 12.3333 | -0.127177 | 0.469348 | 0 | 59.5 | 233 | 86 |
| 2019-04-21 | Manhattan | 158002 | 155393 | 10.8566 | 9.0667 | -0.237848 | 0.401953 | 0 | 59.5 | 336 | 54 |
| 2019-04-21 | Queens | 13669 | 12696 | 25.6505 | 24.3667 | -0.168525 | 0.388086 | 0 | 59.5 | 236 | 86 |
| 2019-04-21 | Staten Island | 5 | 0 | 23.08 | 16.15 | null | null | 0 | 59.5 | 26 | 3 |
| 2019-04-22 | Bronx | 266 | 54 | 18.9216 | 14.0667 | -0.01262 | 0.979847 | 0.24 | 58 | 118 | 40 |
| 2019-04-22 | Brooklyn | 1612 | 1065 | 16.0597 | 13.1167 | -0.085201 | 0.467098 | 0.24 | 58 | 204 | 119 |
| 2019-04-22 | Manhattan | 181935 | 180211 | 12.7761 | 10.4333 | -0.052944 | 0.396045 | 0.24 | 58 | 303 | 62 |
| 2019-04-22 | Queens | 16069 | 15365 | 32.9527 | 30.6 | -0.030898 | 0.376044 | 0.24 | 58 | 182 | 112 |
| 2019-04-22 | Staten Island | 5 | 2 | 38.2133 | 35.7167 | 0.285417 | 0.013397 | 0.24 | 58 | 30 | 7 |
| 2019-04-23 | Bronx | 276 | 53 | 19.0004 | 15.1917 | -0.259525 | 0.8574 | 0.08 | 66.5 | 125 | 72 |
| 2019-04-23 | Brooklyn | 2197 | 1449 | 16.8429 | 13.75 | -0.029539 | 0.421487 | 0.08 | 66.5 | 207 | 120 |
| 2019-04-23 | EWR | 1 | 1 | 2.8 | 2.8 | 1.77406 | null | 0.08 | 66.5 | null | 0 |
| 2019-04-23 | Manhattan | 203671 | 201758 | 12.9895 | 10.9667 | -0.022958 | 0.381194 | 0.08 | 66.5 | 313 | 71 |
| 2019-04-23 | Queens | 16045 | 15358 | 31.3832 | 30.7333 | -0.057123 | 0.333073 | 0.08 | 66.5 | 196 | 122 |
| 2019-04-23 | Staten Island | 6 | 1 | 19.5472 | 5.425 | -0.110211 | null | 0.08 | 66.5 | 32 | 7 |
| 2019-04-24 | Bronx | 283 | 43 | 21.8836 | 16.45 | -0.228188 | 0.735847 | 0 | 62 | 129 | 61 |
| 2019-04-24 | Brooklyn | 2306 | 1510 | 16.4277 | 13.675 | -0.02638 | 0.453672 | 0 | 62 | 224 | 108 |
| 2019-04-24 | Manhattan | 210303 | 208189 | 13.5166 | 11.3833 | 0.014375 | 0.388887 | 0 | 62 | 346 | 68 |
| 2019-04-24 | Queens | 15408 | 14719 | 32.1053 | 30.8583 | -0.028019 | 0.361599 | 0 | 62 | 199 | 92 |