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-28 | Staten Island | 3 | 1 | 52.7833 | 58.6667 | -0.122209 | null | 0.08 | 70.5 | 23 | 13 |
| 2019-08-29 | Bronx | 196 | 28 | 20.0723 | 15.375 | -0.03174 | 0.855558 | 0 | 73 | 89 | 57 |
| 2019-08-29 | Brooklyn | 1700 | 1171 | 15.8446 | 13.4333 | -0.022368 | 0.430479 | 0 | 73 | 164 | 133 |
| 2019-08-29 | EWR | 1 | 0 | 0.25 | 0.25 | null | null | 0 | 73 | null | 0 |
| 2019-08-29 | Manhattan | 168086 | 166293 | 12.9982 | 10.6667 | -0.051069 | 0.376411 | 0 | 73 | 281 | 71 |
| 2019-08-29 | Queens | 15308 | 14536 | 34.5892 | 33.5333 | 0.078012 | 0.386591 | 0 | 73 | 131 | 106 |
| 2019-08-29 | Staten Island | 6 | 2 | 25.8167 | 19.6 | -0.115068 | 0.344842 | 0 | 73 | 20 | 5 |
| 2019-08-30 | Bronx | 237 | 43 | 19.6831 | 15.55 | 0.013032 | 0.715785 | 0 | 76.5 | 84 | 55 |
| 2019-08-30 | Brooklyn | 1956 | 1269 | 16.4707 | 14.325 | -0.023346 | 0.479494 | 0 | 76.5 | 146 | 141 |
| 2019-08-30 | EWR | 3 | 3 | 0.4 | 0.0833 | -0.390061 | 1.412767 | 0 | 76.5 | null | 0 |
| 2019-08-30 | Manhattan | 159804 | 157612 | 12.394 | 10.2 | -0.093595 | 0.386315 | 0 | 76.5 | 189 | 62 |
| 2019-08-30 | Queens | 15306 | 14453 | 33.6678 | 32.3583 | 0.032569 | 0.361939 | 0 | 76.5 | 120 | 129 |
| 2019-08-30 | Staten Island | 4 | 2 | 69.2458 | 84.5917 | -0.002513 | 0.127869 | 0 | 76.5 | 20 | 9 |
| 2019-08-31 | Bronx | 260 | 50 | 16.6587 | 13.9333 | -0.155932 | 0.698644 | 0 | 75 | 119 | 45 |
| 2019-08-31 | Brooklyn | 1828 | 1068 | 14.9872 | 12.9667 | -0.066149 | 0.465984 | 0 | 75 | 173 | 113 |
| 2019-08-31 | EWR | 1 | 0 | 33.6167 | 33.6167 | null | null | 0 | 75 | null | 0 |
| 2019-08-31 | Manhattan | 138739 | 136285 | 11.4348 | 9.7 | -0.182756 | 0.401711 | 0 | 75 | 240 | 53 |
| 2019-08-31 | Queens | 12048 | 11149 | 27.4607 | 26.1 | -0.122978 | 0.407653 | 0 | 75 | 233 | 115 |
| 2019-08-31 | Staten Island | 8 | 1 | 38.1812 | 37.45 | -0.117578 | null | 0 | 75 | 27 | 13 |
| 2019-09-01 | Bronx | 275 | 32 | 15.4948 | 13.1 | -0.329491 | 0.665021 | 0 | 70.5 | 56 | 60 |
| 2019-09-01 | Brooklyn | 2076 | 1195 | 15.1147 | 12.9833 | -0.060591 | 0.532638 | 0 | 70.5 | 149 | 103 |
| 2019-09-01 | EWR | 1 | 0 | 55.1 | 55.1 | null | null | 0 | 70.5 | null | 0 |
| 2019-09-01 | Manhattan | 123977 | 121700 | 11.8683 | 9.8833 | -0.172214 | 0.41628 | 0 | 70.5 | 166 | 41 |
| 2019-09-01 | Queens | 12892 | 12028 | 27.0177 | 26.0167 | -0.136029 | 0.379235 | 0 | 70.5 | 161 | 88 |
| 2019-09-01 | Staten Island | 4 | 0 | 54.5958 | 58.3917 | null | null | 0 | 70.5 | 20 | 7 |