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-04-24 | Staten Island | 7 | 1 | 28.4262 | 28.5833 | -0.394096 | null | 0 | 62 | 36 | 8 |
| 2019-04-25 | Bronx | 258 | 51 | 20.6661 | 15.8833 | -0.036153 | 0.77013 | 0.02 | 57 | 128 | 52 |
| 2019-04-25 | Brooklyn | 2429 | 1729 | 15.6584 | 12.8167 | -0.038295 | 0.42934 | 0.02 | 57 | 208 | 85 |
| 2019-04-25 | EWR | 1 | 1 | 0.05 | 0.05 | -1.791759 | null | 0.02 | 57 | null | 0 |
| 2019-04-25 | Manhattan | 232962 | 230717 | 13.9821 | 11.6333 | 0.049729 | 0.397331 | 0.02 | 57 | 347 | 100 |
| 2019-04-25 | Queens | 16102 | 15430 | 34.8174 | 34.0833 | 0.027532 | 0.367327 | 0.02 | 57 | 205 | 92 |
| 2019-04-25 | Staten Island | 6 | 1 | 32.1472 | 18.9833 | -0.003292 | null | 0.02 | 57 | 35 | 12 |
| 2019-04-26 | Bronx | 235 | 40 | 20.473 | 16.7667 | 0.031387 | 0.852206 | 1.03 | 55 | 127 | 51 |
| 2019-04-26 | Brooklyn | 2336 | 1598 | 15.5711 | 12.7583 | -0.039919 | 0.470566 | 1.03 | 55 | 202 | 96 |
| 2019-04-26 | EWR | 2 | 2 | 0.3 | 0.3 | 0.058403 | 0.140326 | 1.03 | 55 | null | 0 |
| 2019-04-26 | Manhattan | 220486 | 218083 | 14.1362 | 11.4167 | 0.083635 | 0.435104 | 1.03 | 55 | 293 | 77 |
| 2019-04-26 | Queens | 14686 | 13953 | 32.0104 | 30.5667 | -0.023033 | 0.364827 | 1.03 | 55 | 181 | 106 |
| 2019-04-26 | Staten Island | 9 | 0 | 34.7352 | 26.3 | null | null | 1.03 | 55 | 26 | 6 |
| 2019-04-27 | Bronx | 238 | 38 | 17.7751 | 13.2167 | -0.103286 | 0.535437 | 0.07 | 52.5 | 129 | 51 |
| 2019-04-27 | Brooklyn | 2948 | 1880 | 15.1871 | 12.5583 | -0.013896 | 0.429274 | 0.07 | 52.5 | 258 | 104 |
| 2019-04-27 | EWR | 1 | 1 | 1.15 | 1.15 | 1.316336 | null | 0.07 | 52.5 | null | 0 |
| 2019-04-27 | Manhattan | 220261 | 217265 | 12.8272 | 10.5 | -0.030099 | 0.436165 | 0.07 | 52.5 | 398 | 75 |
| 2019-04-27 | Queens | 14218 | 13298 | 27.8325 | 26.8 | -0.110518 | 0.369583 | 0.07 | 52.5 | 272 | 102 |
| 2019-04-27 | Staten Island | 7 | 1 | 40.5476 | 39.8333 | -0.248229 | null | 0.07 | 52.5 | 35 | 10 |
| 2019-04-28 | Bronx | 251 | 42 | 15.3173 | 13.5 | -0.152565 | 0.793482 | 0.01 | 49 | 101 | 30 |
| 2019-04-28 | Brooklyn | 2873 | 1741 | 14.2376 | 12.0667 | -0.087701 | 0.435673 | 0.01 | 49 | 272 | 80 |
| 2019-04-28 | Manhattan | 189208 | 186310 | 11.3718 | 9.4333 | -0.160539 | 0.406195 | 0.01 | 49 | 383 | 65 |
| 2019-04-28 | Queens | 16572 | 15666 | 26.2365 | 25.7167 | -0.185871 | 0.349169 | 0.01 | 49 | 257 | 75 |
| 2019-04-28 | Staten Island | 8 | 0 | 28.8375 | 22.0833 | null | null | 0.01 | 49 | 45 | 3 |
| 2019-04-29 | Bronx | 230 | 48 | 21.858 | 16.5083 | -0.08527 | 0.803519 | 0.01 | 50.5 | 139 | 69 |