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-11-05 | Manhattan | 201075 | 199491 | 13.3712 | 11.4333 | 0.018906 | 0.38261 | 0 | 56 | 206 | 48 |
| 2019-11-05 | Queens | 13084 | 12560 | 31.7085 | 30.7833 | -0.045089 | 0.364949 | 0 | 56 | 103 | 90 |
| 2019-11-05 | Staten Island | 5 | 2 | 23.2867 | 17.2833 | -0.120346 | 0.006492 | 0 | 56 | 11 | 8 |
| 2019-11-06 | Bronx | 160 | 29 | 24.2292 | 21.2083 | 0.07904 | 0.404063 | 0 | 49.5 | 53 | 63 |
| 2019-11-06 | Brooklyn | 1793 | 1225 | 17.1805 | 14 | -0.000339 | 0.481035 | 0 | 49.5 | 156 | 129 |
| 2019-11-06 | EWR | 3 | 2 | 0.1833 | 0.2333 | -0.877696 | 0.885837 | 0 | 49.5 | null | 0 |
| 2019-11-06 | Manhattan | 214090 | 212311 | 14.5143 | 12.2 | 0.08071 | 0.385006 | 0 | 49.5 | 228 | 82 |
| 2019-11-06 | Queens | 13893 | 13303 | 36.8349 | 35.0167 | 0.07968 | 0.375717 | 0 | 49.5 | 117 | 118 |
| 2019-11-06 | Staten Island | 8 | 2 | 45.4688 | 39.0417 | -0.114717 | 0.004045 | 0 | 49.5 | 13 | 9 |
| 2019-11-07 | Bronx | 156 | 36 | 21.3043 | 16.4583 | -0.00268 | 0.601031 | 0.1 | 49 | 52 | 66 |
| 2019-11-07 | Brooklyn | 2079 | 1479 | 17.04 | 13.85 | 0.031085 | 0.473949 | 0.1 | 49 | 149 | 157 |
| 2019-11-07 | EWR | 2 | 2 | 0.2 | 0.2 | -0.565837 | 0.71938 | 0.1 | 49 | null | 0 |
| 2019-11-07 | Manhattan | 225430 | 223468 | 15.1874 | 12.4833 | 0.129273 | 0.39939 | 0.1 | 49 | 226 | 88 |
| 2019-11-07 | Queens | 15324 | 14743 | 39.7756 | 38.6833 | 0.146618 | 0.381851 | 0.1 | 49 | 106 | 123 |
| 2019-11-07 | Staten Island | 7 | 2 | 56.6286 | 51.45 | -0.197362 | 0.069183 | 0.1 | 49 | 12 | 4 |
| 2019-11-08 | Bronx | 160 | 36 | 22.5649 | 17.3167 | -0.007421 | 0.456808 | 0 | 35 | 50 | 76 |
| 2019-11-08 | Brooklyn | 2070 | 1445 | 16.7619 | 13.575 | 0.013693 | 0.412838 | 0 | 35 | 122 | 131 |
| 2019-11-08 | EWR | 2 | 1 | 0.325 | 0.325 | 0.693147 | null | 0 | 35 | null | 0 |
| 2019-11-08 | Manhattan | 234929 | 233011 | 14.4908 | 12.0667 | 0.112637 | 0.395291 | 0 | 35 | 222 | 94 |
| 2019-11-08 | Queens | 15688 | 15037 | 38.6121 | 37.8333 | 0.123433 | 0.370734 | 0 | 35 | 100 | 122 |
| 2019-11-08 | Staten Island | 7 | 2 | 42.8738 | 29.3 | -0.029205 | 0.085147 | 0 | 35 | 10 | 10 |
| 2019-11-09 | Bronx | 145 | 26 | 18.1967 | 12.1833 | -0.132575 | 0.605044 | 0 | 34 | 62 | 45 |
| 2019-11-09 | Brooklyn | 2499 | 1630 | 15.2801 | 13.25 | -0.013422 | 0.439295 | 0 | 34 | 204 | 96 |
| 2019-11-09 | Manhattan | 216985 | 214541 | 13.7181 | 11.5167 | 0.047847 | 0.4244 | 0 | 34 | 268 | 80 |
| 2019-11-09 | Queens | 11910 | 11152 | 30.1753 | 29.3833 | -0.059562 | 0.392177 | 0 | 34 | 163 | 108 |