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-05-03 | EWR | 4 | 3 | 13.9833 | 0.9083 | 0.308361 | 1.631041 | 0.06 | 53 | null | 0 |
| 2019-05-03 | Manhattan | 240533 | 237899 | 13.7673 | 11.3167 | 0.035531 | 0.394607 | 0.06 | 53 | 320 | 87 |
| 2019-05-03 | Queens | 16333 | 15652 | 37.0197 | 35.0333 | 0.095079 | 0.380948 | 0.06 | 53 | 198 | 125 |
| 2019-05-03 | Staten Island | 6 | 2 | 44.7389 | 40.9583 | 0.077303 | 0.181236 | 0.06 | 53 | 27 | 3 |
| 2019-05-04 | Bronx | 267 | 66 | 17.0912 | 13.7833 | -0.064229 | 0.822896 | 0.11 | 62 | 148 | 59 |
| 2019-05-04 | Brooklyn | 3120 | 1996 | 15.9353 | 13.5417 | 0.011897 | 0.435134 | 0.11 | 62 | 284 | 116 |
| 2019-05-04 | Manhattan | 235916 | 232746 | 12.3765 | 10.3667 | -0.055613 | 0.409725 | 0.11 | 62 | 455 | 67 |
| 2019-05-04 | Queens | 12636 | 11773 | 28.8028 | 28.2333 | -0.074904 | 0.405771 | 0.11 | 62 | 291 | 101 |
| 2019-05-04 | Staten Island | 5 | 2 | 38.0767 | 23.7667 | 0.257768 | 0.140408 | 0.11 | 62 | 37 | 6 |
| 2019-05-05 | Bronx | 312 | 46 | 16.5439 | 12.3833 | -0.004495 | 0.610538 | 1.31 | 54.5 | 108 | 56 |
| 2019-05-05 | Brooklyn | 3128 | 1895 | 15.5059 | 12.8917 | -0.029655 | 0.469553 | 1.31 | 54.5 | 294 | 113 |
| 2019-05-05 | Manhattan | 202578 | 199509 | 11.365 | 9.1833 | -0.147699 | 0.414425 | 1.31 | 54.5 | 397 | 66 |
| 2019-05-05 | Queens | 17058 | 16162 | 30.7032 | 29.1 | -0.054739 | 0.401553 | 1.31 | 54.5 | 275 | 91 |
| 2019-05-05 | Staten Island | 4 | 2 | 34.4792 | 18.3667 | 0.083654 | 0.118304 | 1.31 | 54.5 | 39 | 11 |
| 2019-05-06 | Bronx | 247 | 32 | 21.4922 | 16.4833 | 0.066002 | 0.811766 | 0 | 62.5 | 141 | 51 |
| 2019-05-06 | Brooklyn | 2006 | 1332 | 18.0255 | 14.0667 | -0.013696 | 0.44061 | 0 | 62.5 | 235 | 135 |
| 2019-05-06 | EWR | 3 | 3 | 1.1722 | 0.3333 | 0.626924 | 1.518386 | 0 | 62.5 | null | 0 |
| 2019-05-06 | Manhattan | 194923 | 192966 | 13.0038 | 10.5833 | -0.04681 | 0.39632 | 0 | 62.5 | 339 | 90 |
| 2019-05-06 | Queens | 17577 | 16825 | 34.217 | 32.4 | 0.003778 | 0.348809 | 0 | 62.5 | 204 | 116 |
| 2019-05-06 | Staten Island | 7 | 1 | 35.3571 | 21.2333 | -0.032397 | null | 0 | 62.5 | 30 | 18 |
| 2019-05-07 | Bronx | 280 | 48 | 24.1237 | 19.3583 | -0.025266 | 0.749955 | 0.11 | 61 | 145 | 75 |
| 2019-05-07 | Brooklyn | 2437 | 1632 | 17.7087 | 13.8 | -0.028213 | 0.423119 | 0.11 | 61 | 233 | 153 |
| 2019-05-07 | Manhattan | 219158 | 216900 | 13.3154 | 11.1167 | 0.010778 | 0.389792 | 0.11 | 61 | 352 | 86 |
| 2019-05-07 | Queens | 15043 | 14326 | 34.2693 | 33.6667 | 0.007348 | 0.352808 | 0.11 | 61 | 207 | 107 |
| 2019-05-07 | Staten Island | 6 | 2 | 58.4306 | 61.275 | 0.07914 | 0.239523 | 0.11 | 61 | 39 | 14 |