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-12-22 | Queens | 10630 | 9958 | 28.5928 | 25.7 | -0.074369 | 0.422838 | 0 | 38 | 16 | 117 |
| 2019-12-22 | Staten Island | 7 | 1 | 35.5952 | 29.35 | -0.326582 | null | 0 | 38 | 3 | 8 |
| 2019-12-23 | Bronx | 186 | 32 | 19.15 | 13.8667 | -0.363953 | 0.549493 | 0 | 49 | 1 | 67 |
| 2019-12-23 | Brooklyn | 1441 | 955 | 17.022 | 13.4833 | -0.028107 | 0.416269 | 0 | 49 | 6 | 133 |
| 2019-12-23 | EWR | 4 | 2 | 15.5875 | 0.2833 | -1.060917 | 0.495074 | 0 | 49 | null | 0 |
| 2019-12-23 | Manhattan | 156204 | 154615 | 13.1904 | 10.6833 | -0.024774 | 0.41426 | 0 | 49 | 41 | 65 |
| 2019-12-23 | Queens | 10571 | 9984 | 32.3042 | 29.7333 | 0.024995 | 0.390573 | 0 | 49 | 4 | 123 |
| 2019-12-23 | Staten Island | 10 | 1 | 52.2367 | 35.8 | 0.332473 | null | 0 | 49 | 2 | 9 |
| 2019-12-24 | Bronx | 306 | 60 | 14.8165 | 12.2667 | -0.080898 | 0.506208 | 0 | 41.5 | 1 | 0 |
| 2019-12-24 | Brooklyn | 1296 | 800 | 15.2318 | 12.9167 | -0.122773 | 0.522392 | 0 | 41.5 | 6 | 0 |
| 2019-12-24 | EWR | 2 | 0 | 44.9333 | 44.9333 | null | null | 0 | 41.5 | null | 0 |
| 2019-12-24 | Manhattan | 143339 | 141240 | 10.6029 | 8.75 | -0.204196 | 0.395972 | 0 | 41.5 | 35 | 0 |
| 2019-12-24 | Queens | 8107 | 7453 | 25.4382 | 24.2 | -0.122202 | 0.396884 | 0 | 41.5 | 8 | 0 |
| 2019-12-24 | Staten Island | 7 | 0 | 38.0595 | 44.3167 | null | null | 0 | 41.5 | 2 | 0 |
| 2019-12-25 | Bronx | 250 | 32 | 14.3453 | 12.6083 | -0.154268 | 0.550825 | 0 | 39.5 | 1 | 0 |
| 2019-12-25 | Brooklyn | 901 | 479 | 15.5996 | 13.1667 | -0.204215 | 0.498083 | 0 | 39.5 | 4 | 0 |
| 2019-12-25 | Manhattan | 85929 | 84245 | 10.8255 | 8.9833 | -0.262379 | 0.432018 | 0 | 39.5 | 34 | 0 |
| 2019-12-25 | Queens | 7904 | 7325 | 23.139 | 22.45 | -0.265392 | 0.390282 | 0 | 39.5 | 5 | 0 |
| 2019-12-25 | Staten Island | 6 | 0 | 46.625 | 42.1583 | null | null | 0 | 39.5 | 2 | 0 |
| 2019-12-26 | Bronx | 112 | 21 | 17.5339 | 12.8667 | -0.08753 | 0.381923 | 0 | 41 | 3 | 0 |
| 2019-12-26 | Brooklyn | 1014 | 669 | 15.4449 | 13.275 | -0.121726 | 0.404709 | 0 | 41 | 4 | 0 |
| 2019-12-26 | EWR | 1 | 1 | 0.35 | 0.35 | 0.241162 | null | 0 | 41 | null | 0 |
| 2019-12-26 | Manhattan | 123467 | 122129 | 12.0875 | 10.0667 | -0.138971 | 0.411986 | 0 | 41 | 39 | 0 |
| 2019-12-26 | Queens | 12946 | 12396 | 28.6966 | 27.05 | -0.132072 | 0.347751 | 0 | 41 | 6 | 0 |
| 2019-12-26 | Staten Island | 7 | 1 | 36.219 | 41.75 | -0.104826 | null | 0 | 41 | 2 | 0 |