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-07 | EWR | 2 | 1 | 1.6583 | 1.6583 | -0.325422 | null | 1.18 | 76.5 | null | 0 |
| 2019-08-07 | Manhattan | 192251 | 190544 | 14.1909 | 11.8 | 0.06579 | 0.403043 | 1.18 | 76.5 | 372 | 61 |
| 2019-08-07 | Queens | 12366 | 11787 | 31.5018 | 29.3083 | 0.006984 | 0.362036 | 1.18 | 76.5 | 203 | 115 |
| 2019-08-07 | Staten Island | 6 | 2 | 55.4444 | 59.825 | 0.422998 | 0.353385 | 1.18 | 76.5 | 42 | 7 |
| 2019-08-08 | Bronx | 220 | 42 | 21.7742 | 16.9917 | 0.046442 | 0.505451 | 0.2 | 75.5 | 130 | 67 |
| 2019-08-08 | Brooklyn | 1883 | 1255 | 17.1868 | 13.8667 | 0.019268 | 0.477077 | 0.2 | 75.5 | 304 | 141 |
| 2019-08-08 | EWR | 4 | 1 | 31.3125 | 26.6167 | 0.070618 | null | 0.2 | 75.5 | null | 0 |
| 2019-08-08 | Manhattan | 195520 | 193504 | 14.2833 | 11.6 | 0.038166 | 0.392502 | 0.2 | 75.5 | 378 | 98 |
| 2019-08-08 | Queens | 16044 | 15276 | 34.8153 | 32.4667 | 0.079055 | 0.363039 | 0.2 | 75.5 | 212 | 122 |
| 2019-08-08 | Staten Island | 5 | 2 | 54.8667 | 60.1833 | 0.283793 | 0.16479 | 0.2 | 75.5 | 45 | 6 |
| 2019-08-09 | Bronx | 233 | 33 | 19.5675 | 16.9 | -0.133559 | 0.80941 | 0.08 | 75.5 | 126 | 67 |
| 2019-08-09 | Brooklyn | 1756 | 1150 | 16.9701 | 13.9917 | -0.023741 | 0.441736 | 0.08 | 75.5 | 278 | 138 |
| 2019-08-09 | Manhattan | 178094 | 176032 | 13.6034 | 11.0667 | -0.004915 | 0.399947 | 0.08 | 75.5 | 301 | 70 |
| 2019-08-09 | Queens | 16047 | 15326 | 35.9828 | 33.5833 | 0.114287 | 0.378175 | 0.08 | 75.5 | 188 | 121 |
| 2019-08-09 | Staten Island | 5 | 2 | 61.88 | 63.0667 | 0.229657 | 0.046473 | 0.08 | 75.5 | 33 | 13 |
| 2019-08-10 | Bronx | 273 | 57 | 16.5092 | 13.2 | 0.002715 | 0.521316 | 0 | 73.5 | 222 | 73 |
| 2019-08-10 | Brooklyn | 2049 | 1291 | 15.7565 | 13.35 | -0.01892 | 0.448681 | 0 | 73.5 | 442 | 120 |
| 2019-08-10 | EWR | 2 | 2 | 18.2583 | 18.2583 | 2.473131 | 3.279533 | 0 | 73.5 | null | 0 |
| 2019-08-10 | Manhattan | 158320 | 155931 | 12.0462 | 10.1 | -0.122454 | 0.398291 | 0 | 73.5 | 415 | 62 |
| 2019-08-10 | Queens | 12505 | 11698 | 28.9774 | 27.65 | -0.064775 | 0.418134 | 0 | 73.5 | 401 | 114 |
| 2019-08-10 | Staten Island | 11 | 2 | 41.4197 | 23.3333 | 0.45824 | 0.191505 | 0 | 73.5 | 55 | 10 |
| 2019-08-11 | Bronx | 248 | 39 | 14.2363 | 12.275 | -0.228382 | 0.648491 | 0 | 71.5 | 149 | 45 |
| 2019-08-11 | Brooklyn | 2302 | 1336 | 14.5312 | 12.725 | -0.098755 | 0.459676 | 0 | 71.5 | 322 | 93 |
| 2019-08-11 | EWR | 2 | 2 | 0.3833 | 0.3833 | 0.192723 | 0.588124 | 0 | 71.5 | null | 0 |
| 2019-08-11 | Manhattan | 130845 | 128618 | 11.4236 | 9.3667 | -0.210373 | 0.404042 | 0 | 71.5 | 347 | 62 |