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-12-01 | Manhattan | 152158 | 150187 | 11.608 | 9.5333 | -0.139043 | 0.411452 | 0.62 | 34.5 | 36 | 56 |
| 2019-12-01 | Queens | 17878 | 17000 | 28.6312 | 27.35 | -0.131451 | 0.359141 | 0.62 | 34.5 | 18 | 82 |
| 2019-12-01 | Staten Island | 6 | 2 | 33.0556 | 29.2583 | 0.127725 | 0.018487 | 0.62 | 34.5 | 4 | 7 |
| 2019-12-02 | Bronx | 117 | 28 | 18.5405 | 14.0833 | 0.189962 | 0.643288 | 0.48 | 34 | 3 | 53 |
| 2019-12-02 | Brooklyn | 1242 | 858 | 15.7329 | 12.4167 | -0.072511 | 0.436632 | 0.48 | 34 | 3 | 136 |
| 2019-12-02 | EWR | 2 | 1 | 18.1167 | 18.1167 | -1.791759 | null | 0.48 | 34 | null | 0 |
| 2019-12-02 | Manhattan | 175336 | 173989 | 12.4945 | 10.3167 | -0.026854 | 0.396373 | 0.48 | 34 | 37 | 72 |
| 2019-12-02 | Queens | 18558 | 17819 | 34.0178 | 31.2833 | 0.032791 | 0.369756 | 0.48 | 34 | 4 | 113 |
| 2019-12-02 | Staten Island | 7 | 1 | 54.8524 | 49.25 | 0.048993 | null | 0.48 | 34 | 2 | 12 |
| 2019-12-03 | Bronx | 138 | 31 | 21.1211 | 13.1417 | -0.041576 | 0.486864 | 0.02 | 33 | 1 | 70 |
| 2019-12-03 | Brooklyn | 1745 | 1251 | 15.8921 | 12.9333 | -0.059333 | 0.455991 | 0.02 | 33 | 3 | 124 |
| 2019-12-03 | EWR | 2 | 2 | 2.2667 | 2.2667 | 2.160004 | 0.360039 | 0.02 | 33 | null | 0 |
| 2019-12-03 | Manhattan | 214190 | 212546 | 13.7231 | 11.4167 | 0.048199 | 0.38997 | 0.02 | 33 | 44 | 74 |
| 2019-12-03 | Queens | 18352 | 17678 | 36.7254 | 33.8667 | 0.113449 | 0.354893 | 0.02 | 33 | 4 | 116 |
| 2019-12-03 | Staten Island | 6 | 2 | 45.0861 | 37.0167 | -0.033201 | 0.020223 | 0.02 | 33 | 3 | 5 |
| 2019-12-04 | Bronx | 176 | 44 | 19.8829 | 15.2833 | 0.102846 | 0.589755 | 0 | 35.5 | 2 | 59 |
| 2019-12-04 | Brooklyn | 1780 | 1302 | 16.2607 | 13.05 | -0.002275 | 0.428265 | 0 | 35.5 | 3 | 128 |
| 2019-12-04 | EWR | 1 | 1 | 5.7833 | 5.7833 | 2.8289 | null | 0 | 35.5 | null | 0 |
| 2019-12-04 | Manhattan | 217954 | 216062 | 14.6589 | 12.1333 | 0.105176 | 0.411567 | 0 | 35.5 | 43 | 62 |
| 2019-12-04 | Queens | 15932 | 15316 | 39.0266 | 36.1833 | 0.128297 | 0.385207 | 0 | 35.5 | 7 | 97 |
| 2019-12-04 | Staten Island | 5 | 1 | 55.7367 | 36.9333 | -0.056008 | null | 0 | 35.5 | 2 | 9 |
| 2019-12-05 | Bronx | 156 | 39 | 21.9216 | 14.4917 | -0.042791 | 0.711437 | 0 | 39 | 5 | 62 |
| 2019-12-05 | Brooklyn | 2278 | 1649 | 16.9073 | 13.8917 | -0.007703 | 0.436036 | 0 | 39 | 7 | 112 |
| 2019-12-05 | Manhattan | 236705 | 234464 | 14.9332 | 12.25 | 0.109653 | 0.396799 | 0 | 39 | 39 | 75 |
| 2019-12-05 | Queens | 16260 | 15659 | 42.1229 | 39.55 | 0.184915 | 0.382161 | 0 | 39 | 6 | 128 |