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-06-21 | Bronx | 321 | 66 | 24.9505 | 20.75 | 0.020794 | 0.427716 | 0.53 | 71 | 125 | 58 |
| 2019-06-21 | Brooklyn | 2989 | 1896 | 19.8135 | 15.45 | 0.073402 | 0.509181 | 0.53 | 71 | 254 | 155 |
| 2019-06-21 | EWR | 4 | 3 | 0.2542 | 0.1167 | -0.656327 | 1.327253 | 0.53 | 71 | null | 0 |
| 2019-06-21 | Manhattan | 213223 | 210677 | 14.2966 | 11.4833 | 0.057599 | 0.406131 | 0.53 | 71 | 341 | 100 |
| 2019-06-21 | Queens | 17671 | 16652 | 38.278 | 35.7167 | 0.159242 | 0.392285 | 0.53 | 71 | 208 | 142 |
| 2019-06-21 | Staten Island | 8 | 2 | 45.0646 | 25.0917 | 0.247445 | 0.098562 | 0.53 | 71 | 29 | 16 |
| 2019-06-22 | Bronx | 271 | 39 | 17.4849 | 13.9167 | -0.233473 | 0.920068 | 0 | 70 | 202 | 64 |
| 2019-06-22 | Brooklyn | 2807 | 1771 | 15.7606 | 13.4667 | -0.014722 | 0.43119 | 0 | 70 | 405 | 132 |
| 2019-06-22 | EWR | 1 | 1 | 11.8333 | 11.8333 | 3.54484 | null | 0 | 70 | null | 0 |
| 2019-06-22 | Manhattan | 191646 | 188766 | 12.777 | 10.7333 | -0.0538 | 0.40641 | 0 | 70 | 457 | 73 |
| 2019-06-22 | Queens | 13960 | 13026 | 32.4722 | 31.5167 | 0.009379 | 0.400921 | 0 | 70 | 395 | 119 |
| 2019-06-22 | Staten Island | 5 | 0 | 20.5033 | 7.95 | null | null | 0 | 70 | 55 | 7 |
| 2019-06-23 | Bronx | 382 | 71 | 16.1771 | 13.2167 | 0.123202 | 0.628569 | 0 | 73.5 | 134 | 67 |
| 2019-06-23 | Brooklyn | 2760 | 1624 | 15.5593 | 13.6667 | -0.042723 | 0.467846 | 0 | 73.5 | 343 | 127 |
| 2019-06-23 | EWR | 4 | 4 | 4.3083 | 2.0667 | 2.028072 | 1.005676 | 0 | 73.5 | null | 0 |
| 2019-06-23 | Manhattan | 168030 | 165244 | 11.744 | 9.75 | -0.169541 | 0.399695 | 0 | 73.5 | 398 | 54 |
| 2019-06-23 | Queens | 17070 | 16095 | 32.7272 | 30.125 | -0.001606 | 0.405471 | 0 | 73.5 | 339 | 93 |
| 2019-06-23 | Staten Island | 11 | 2 | 29.5621 | 12.7833 | 0.215484 | 0.321104 | 0 | 73.5 | 50 | 5 |
| 2019-06-24 | Bronx | 260 | 36 | 21.6958 | 17.4083 | -0.088699 | 0.912847 | 0 | 75.5 | 95 | 88 |
| 2019-06-24 | Brooklyn | 1866 | 1165 | 18.147 | 14.7667 | -0.044366 | 0.432919 | 0 | 75.5 | 209 | 181 |
| 2019-06-24 | EWR | 4 | 4 | 1.0333 | 0.475 | 0.259333 | 1.504529 | 0 | 75.5 | null | 0 |
| 2019-06-24 | Manhattan | 186318 | 184272 | 13.1804 | 10.7167 | -0.045563 | 0.389827 | 0 | 75.5 | 278 | 75 |
| 2019-06-24 | Queens | 17125 | 16340 | 36.6214 | 34.2667 | 0.063449 | 0.366246 | 0 | 75.5 | 164 | 133 |
| 2019-06-24 | Staten Island | 6 | 2 | 50.525 | 47.7333 | 0.004761 | 0.021362 | 0 | 75.5 | 28 | 10 |
| 2019-06-25 | Bronx | 289 | 56 | 23.4345 | 19.1833 | 0.237786 | 1.173735 | 0.86 | 78 | 96 | 56 |