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-03-07 | Queens | 16163 | 15322 | 35.3179 | 34.55 | 0.05647 | 0.371399 | 0 | 25 | 15 | 88 |
| 2019-03-07 | Staten Island | 10 | 1 | 42.9033 | 49.1167 | 0.030747 | null | 0 | 25 | 4 | 16 |
| 2019-03-08 | Bronx | 554 | 88 | 25.8159 | 21.525 | 0.07603 | 0.618079 | 0 | 31.5 | 10 | 62 |
| 2019-03-08 | Brooklyn | 3427 | 2189 | 19.1359 | 15.15 | 0.020044 | 0.445138 | 0 | 31.5 | 26 | 129 |
| 2019-03-08 | EWR | 1 | 1 | 1.9833 | 1.9833 | 1.429219 | null | 0 | 31.5 | null | 0 |
| 2019-03-08 | Manhattan | 249579 | 246522 | 13.7432 | 11.3 | 0.047825 | 0.388463 | 0 | 31.5 | 74 | 85 |
| 2019-03-08 | Queens | 15699 | 14831 | 35.5927 | 35.0167 | 0.06528 | 0.352655 | 0 | 31.5 | 13 | 102 |
| 2019-03-08 | Staten Island | 8 | 0 | 48.3792 | 44.3917 | null | null | 0 | 31.5 | 3 | 25 |
| 2019-03-09 | Bronx | 413 | 66 | 19.3372 | 15.4333 | -0.181972 | 0.663725 | 0 | 41.5 | 13 | 66 |
| 2019-03-09 | Brooklyn | 3921 | 2418 | 16.153 | 13.5167 | 0.011319 | 0.459887 | 0 | 41.5 | 43 | 99 |
| 2019-03-09 | Manhattan | 241193 | 237862 | 12.8808 | 10.7 | -0.01832 | 0.415106 | 0 | 41.5 | 105 | 64 |
| 2019-03-09 | Queens | 12233 | 11294 | 29.2072 | 28.8 | -0.084586 | 0.398411 | 0 | 41.5 | 30 | 99 |
| 2019-03-09 | Staten Island | 8 | 0 | 37.6167 | 29.8 | null | null | 0 | 41.5 | 7 | 10 |
| 2019-03-10 | Bronx | 392 | 60 | 18.0565 | 14.625 | -0.086252 | 0.529438 | 0.54 | 39 | 8 | 46 |
| 2019-03-10 | Brooklyn | 3057 | 1729 | 15.859 | 12.8333 | -0.059035 | 0.557815 | 0.54 | 39 | 54 | 94 |
| 2019-03-10 | EWR | 4 | 1 | 15.325 | 0.2333 | -1.504077 | null | 0.54 | 39 | null | 0 |
| 2019-03-10 | Manhattan | 196843 | 193530 | 11.9835 | 9.4333 | -0.126844 | 0.449994 | 0.54 | 39 | 89 | 63 |
| 2019-03-10 | Queens | 16052 | 15078 | 27.6013 | 27.1167 | -0.127577 | 0.365979 | 0.54 | 39 | 33 | 88 |
| 2019-03-10 | Staten Island | 5 | 0 | 24.79 | 28.1 | null | null | 0.54 | 39 | 10 | 14 |
| 2019-03-11 | Bronx | 366 | 59 | 26.3449 | 22.6583 | -0.0218 | 0.52196 | 0 | 46 | 10 | 69 |
| 2019-03-11 | Brooklyn | 2508 | 1550 | 18.8784 | 14.9833 | -0.065662 | 0.455374 | 0 | 46 | 32 | 124 |
| 2019-03-11 | EWR | 1 | 1 | 0.0333 | 0.0333 | -2.197225 | null | 0 | 46 | null | 0 |
| 2019-03-11 | Manhattan | 202206 | 199995 | 12.4896 | 10.2833 | -0.062564 | 0.385789 | 0 | 46 | 78 | 79 |
| 2019-03-11 | Queens | 17601 | 16666 | 32.8411 | 31.4167 | -0.024664 | 0.344241 | 0 | 46 | 13 | 120 |
| 2019-03-11 | Staten Island | 7 | 0 | 45.3762 | 45.8833 | null | null | 0 | 46 | 4 | 10 |