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-09-15 | Bronx | 212 | 41 | 15.878 | 12.6583 | -0.091462 | 0.816359 | 0 | 75 | 79 | 63 |
| 2019-09-15 | Brooklyn | 2527 | 1516 | 15.8592 | 14.1333 | -0.017883 | 0.509814 | 0 | 75 | 272 | 135 |
| 2019-09-15 | EWR | 1 | 1 | 0.0833 | 0.0833 | -1.308333 | null | 0 | 75 | null | 0 |
| 2019-09-15 | Manhattan | 172907 | 170351 | 12.7008 | 10.3833 | -0.077959 | 0.419757 | 0 | 75 | 334 | 79 |
| 2019-09-15 | Queens | 15985 | 15188 | 31.6626 | 30.35 | -0.031572 | 0.371218 | 0 | 75 | 235 | 104 |
| 2019-09-15 | Staten Island | 11 | 2 | 28.3848 | 16.6667 | -0.078738 | 0.155961 | 0 | 75 | 36 | 6 |
| 2019-09-16 | Bronx | 216 | 47 | 20.1282 | 15.85 | 0.176831 | 0.510984 | 0 | 72.5 | 71 | 68 |
| 2019-09-16 | Brooklyn | 1783 | 1210 | 17.6458 | 14.5667 | 0.013412 | 0.435342 | 0 | 72.5 | 160 | 137 |
| 2019-09-16 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.417066 | null | 0 | 72.5 | null | 0 |
| 2019-09-16 | Manhattan | 187496 | 185759 | 13.2855 | 11 | -0.013145 | 0.386636 | 0 | 72.5 | 234 | 81 |
| 2019-09-16 | Queens | 15803 | 15167 | 36.2862 | 33.7167 | 0.042819 | 0.368401 | 0 | 72.5 | 116 | 121 |
| 2019-09-16 | Staten Island | 5 | 2 | 71.59 | 67.6167 | 0.0261 | 0.139585 | 0 | 72.5 | 18 | 7 |
| 2019-09-17 | Bronx | 176 | 38 | 19.9399 | 15.8 | 0.158347 | 0.527354 | 0 | 69 | 77 | 65 |
| 2019-09-17 | Brooklyn | 1840 | 1259 | 18.8032 | 14.7833 | 0.088899 | 0.479478 | 0 | 69 | 176 | 122 |
| 2019-09-17 | EWR | 1 | 0 | 22.35 | 22.35 | null | null | 0 | 69 | null | 0 |
| 2019-09-17 | Manhattan | 204518 | 202838 | 13.8159 | 11.45 | 0.025754 | 0.381448 | 0 | 69 | 275 | 87 |
| 2019-09-17 | Queens | 13810 | 13226 | 35.5778 | 34.1667 | 0.070018 | 0.379332 | 0 | 69 | 131 | 125 |
| 2019-09-17 | Staten Island | 6 | 2 | 62.425 | 59.3333 | -0.098781 | 0.000638 | 0 | 69 | 20 | 5 |
| 2019-09-18 | Bronx | 268 | 46 | 23.057 | 16.8083 | -0.093532 | 0.953709 | 0 | 63 | 84 | 63 |
| 2019-09-18 | Brooklyn | 1983 | 1352 | 16.7695 | 13.5667 | -0.002062 | 0.437758 | 0 | 63 | 184 | 148 |
| 2019-09-18 | EWR | 1 | 1 | 4.65 | 4.65 | 2.610787 | null | 0 | 63 | null | 0 |
| 2019-09-18 | Manhattan | 211083 | 209194 | 14.1963 | 11.8833 | 0.057243 | 0.386435 | 0 | 63 | 279 | 92 |
| 2019-09-18 | Queens | 14389 | 13819 | 35.8906 | 35.05 | 0.067729 | 0.373548 | 0 | 63 | 149 | 95 |
| 2019-09-18 | Staten Island | 9 | 1 | 41.2204 | 27.6667 | 0.033929 | null | 0 | 63 | 17 | 10 |
| 2019-09-19 | Bronx | 179 | 42 | 21.6596 | 15.6833 | -0.021518 | 0.642898 | 0 | 61 | 79 | 51 |