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-06 | EWR | 2 | 2 | 2.6833 | 2.6833 | 0.909628 | 2.897812 | 0.32 | 62.5 | null | 0 |
| 2019-09-06 | Manhattan | 208712 | 206667 | 14.695 | 11.9833 | 0.11236 | 0.407061 | 0.32 | 62.5 | 212 | 90 |
| 2019-09-06 | Queens | 13519 | 12853 | 39.4916 | 36.0333 | 0.154785 | 0.415735 | 0.32 | 62.5 | 126 | 117 |
| 2019-09-06 | Staten Island | 8 | 2 | 44.2917 | 35.7 | -0.281037 | 0.002437 | 0.32 | 62.5 | 13 | 10 |
| 2019-09-07 | Bronx | 186 | 44 | 17.0475 | 13.0167 | 0.02915 | 0.440683 | 0.02 | 65.5 | 104 | 48 |
| 2019-09-07 | Brooklyn | 2457 | 1543 | 15.9748 | 13.7667 | 0.00191 | 0.463255 | 0.02 | 65.5 | 339 | 100 |
| 2019-09-07 | EWR | 2 | 0 | 0.525 | 0.525 | null | null | 0.02 | 65.5 | null | 0 |
| 2019-09-07 | Manhattan | 189147 | 186675 | 13.2213 | 10.9833 | 0.007294 | 0.422738 | 0.02 | 65.5 | 342 | 76 |
| 2019-09-07 | Queens | 11523 | 10754 | 30.3054 | 29.5333 | -0.044292 | 0.40246 | 0.02 | 65.5 | 265 | 97 |
| 2019-09-07 | Staten Island | 5 | 1 | 62.1367 | 68.2 | 0.010625 | null | 0.02 | 65.5 | 39 | 7 |
| 2019-09-08 | Bronx | 214 | 33 | 14.6204 | 12.275 | 0.082947 | 0.537416 | 0 | 70 | 79 | 55 |
| 2019-09-08 | Brooklyn | 2425 | 1457 | 15.2997 | 13.3 | -0.028611 | 0.460465 | 0 | 70 | 237 | 106 |
| 2019-09-08 | Manhattan | 163595 | 161028 | 12.3245 | 10.0167 | -0.10989 | 0.421236 | 0 | 70 | 287 | 56 |
| 2019-09-08 | Queens | 15427 | 14575 | 31.9788 | 29.7167 | -0.030056 | 0.383682 | 0 | 70 | 238 | 80 |
| 2019-09-08 | Staten Island | 4 | 2 | 56.9167 | 59.6167 | 0.101744 | 0.079251 | 0 | 70 | 35 | 0 |
| 2019-09-09 | Bronx | 214 | 42 | 20.2474 | 15.0417 | 0.188855 | 0.410086 | 0 | 71 | 60 | 64 |
| 2019-09-09 | Brooklyn | 1722 | 1150 | 16.9142 | 14.5333 | -0.032664 | 0.436973 | 0 | 71 | 141 | 124 |
| 2019-09-09 | EWR | 1 | 1 | 0.1833 | 0.1833 | -0.310155 | null | 0 | 71 | null | 0 |
| 2019-09-09 | Manhattan | 182940 | 181255 | 12.9054 | 10.7333 | -0.041409 | 0.383177 | 0 | 71 | 213 | 74 |
| 2019-09-09 | Queens | 15183 | 14508 | 34.0896 | 33.3333 | 0.013488 | 0.371178 | 0 | 71 | 112 | 118 |
| 2019-09-09 | Staten Island | 7 | 2 | 42.9048 | 31.65 | 0.031681 | 0.067858 | 0 | 71 | 18 | 8 |
| 2019-09-10 | Bronx | 218 | 47 | 23.457 | 17.4333 | 0.346112 | 0.893422 | 0.01 | 71 | 68 | 46 |
| 2019-09-10 | Brooklyn | 1985 | 1370 | 17.4341 | 14.7167 | 0.022412 | 0.414688 | 0.01 | 71 | 151 | 116 |
| 2019-09-10 | Manhattan | 205911 | 204335 | 14.0439 | 11.65 | 0.049141 | 0.400423 | 0.01 | 71 | 255 | 88 |
| 2019-09-10 | Queens | 13719 | 13203 | 36.2634 | 34.4667 | 0.062438 | 0.40683 | 0.01 | 71 | 124 | 137 |