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-11-26 | Staten Island | 6 | 2 | 35.9139 | 22.3167 | 0.106521 | 0.072218 | 0 | 52.5 | 8 | 13 |
| 2019-11-27 | Bronx | 221 | 49 | 18.5505 | 13.9167 | 0.06386 | 0.42893 | 0.04 | 54 | 38 | 73 |
| 2019-11-27 | Brooklyn | 1459 | 983 | 16.135 | 12.6167 | -0.045519 | 0.456572 | 0.04 | 54 | 98 | 112 |
| 2019-11-27 | EWR | 1 | 1 | 0.3833 | 0.3833 | 0.115069 | null | 0.04 | 54 | null | 0 |
| 2019-11-27 | Manhattan | 182083 | 180161 | 13.1924 | 10.9 | 0.018086 | 0.42143 | 0.04 | 54 | 140 | 64 |
| 2019-11-27 | Queens | 11882 | 11291 | 33.2477 | 31.35 | 0.025582 | 0.379097 | 0.04 | 54 | 78 | 116 |
| 2019-11-27 | Staten Island | 8 | 2 | 34.0771 | 29.7583 | -0.04995 | 0.092548 | 0.04 | 54 | 11 | 10 |
| 2019-11-28 | Bronx | 392 | 32 | 16.7402 | 14.2167 | 0.128685 | 0.783895 | 0 | 45 | 29 | 54 |
| 2019-11-28 | Brooklyn | 1347 | 710 | 15.0436 | 13.0833 | -0.163472 | 0.458213 | 0 | 45 | 86 | 72 |
| 2019-11-28 | Manhattan | 118563 | 116260 | 10.8331 | 8.75 | -0.219531 | 0.435675 | 0 | 45 | 107 | 37 |
| 2019-11-28 | Queens | 8474 | 7843 | 23.9196 | 23 | -0.24069 | 0.441775 | 0 | 45 | 57 | 70 |
| 2019-11-28 | Staten Island | 7 | 1 | 36.8286 | 38.6 | -0.286749 | null | 0 | 45 | 9 | 13 |
| 2019-11-29 | Bronx | 198 | 30 | 15.9285 | 12.3333 | -0.347826 | 0.604083 | 0 | 35 | 26 | 55 |
| 2019-11-29 | Brooklyn | 1062 | 659 | 14.0592 | 12.1833 | -0.140918 | 0.459903 | 0 | 35 | 67 | 91 |
| 2019-11-29 | Manhattan | 142560 | 141165 | 11.167 | 9.5167 | -0.17318 | 0.411433 | 0 | 35 | 90 | 44 |
| 2019-11-29 | Queens | 10623 | 10081 | 25.6138 | 24.9 | -0.220356 | 0.368153 | 0 | 35 | 54 | 101 |
| 2019-11-29 | Staten Island | 8 | 1 | 37.8729 | 29.5333 | 0.087933 | null | 0 | 35 | 7 | 7 |
| 2019-11-30 | Bronx | 148 | 28 | 16.8467 | 10.3083 | -0.099258 | 0.481787 | 0 | 37 | 24 | 50 |
| 2019-11-30 | Brooklyn | 1361 | 853 | 14.5291 | 12.4167 | -0.134151 | 0.465542 | 0 | 37 | 97 | 89 |
| 2019-11-30 | Manhattan | 163119 | 161260 | 12.1984 | 10.3 | -0.107448 | 0.414348 | 0 | 37 | 106 | 49 |
| 2019-11-30 | Queens | 14735 | 14030 | 29.6713 | 27.4333 | -0.068693 | 0.374753 | 0 | 37 | 68 | 96 |
| 2019-11-30 | Staten Island | 5 | 0 | 57.36 | 54.55 | null | null | 0 | 37 | 12 | 12 |
| 2019-12-01 | Bronx | 151 | 22 | 14.7345 | 12.5333 | -0.06296 | 0.724216 | 0.62 | 34.5 | 6 | 36 |
| 2019-12-01 | Brooklyn | 1367 | 830 | 13.7277 | 11.1833 | -0.122067 | 0.420951 | 0.62 | 34.5 | 17 | 99 |
| 2019-12-01 | EWR | 1 | 0 | 33.5833 | 33.5833 | null | null | 0.62 | 34.5 | null | 0 |