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-07-25 | Brooklyn | 2090 | 1386 | 17.3984 | 14.45 | 0.009056 | 0.444623 | 0 | 77 | 310 | 127 |
| 2019-07-25 | EWR | 4 | 2 | 0.5708 | 0.2333 | -0.72051 | 0.647915 | 0 | 77 | null | 0 |
| 2019-07-25 | Manhattan | 205984 | 203881 | 14.402 | 11.9333 | 0.055271 | 0.384516 | 0 | 77 | 391 | 79 |
| 2019-07-25 | Queens | 14685 | 13984 | 37.3171 | 36 | 0.110809 | 0.375346 | 0 | 77 | 227 | 109 |
| 2019-07-25 | Staten Island | 7 | 1 | 51.2524 | 56.6833 | 0.128031 | null | 0 | 77 | 50 | 5 |
| 2019-07-26 | Bronx | 282 | 61 | 22.6316 | 17.225 | 0.042158 | 0.589693 | 0 | 78.5 | 129 | 70 |
| 2019-07-26 | Brooklyn | 2172 | 1403 | 18.5016 | 15.0417 | 0.025414 | 0.474643 | 0 | 78.5 | 292 | 132 |
| 2019-07-26 | EWR | 2 | 2 | 0.1167 | 0.1167 | -0.911266 | 0.71531 | 0 | 78.5 | null | 0 |
| 2019-07-26 | Manhattan | 186828 | 184612 | 14.1611 | 11.55 | 0.042099 | 0.405168 | 0 | 78.5 | 313 | 93 |
| 2019-07-26 | Queens | 14238 | 13509 | 37.1058 | 35.3333 | 0.124589 | 0.385131 | 0 | 78.5 | 203 | 108 |
| 2019-07-26 | Staten Island | 7 | 0 | 46.3452 | 17.4833 | null | null | 0 | 78.5 | 34 | 9 |
| 2019-07-27 | Bronx | 202 | 44 | 17.7532 | 13.2917 | -0.047148 | 0.65323 | 0 | 78.5 | 232 | 62 |
| 2019-07-27 | Brooklyn | 2302 | 1400 | 15.6159 | 13.4833 | -0.009089 | 0.463204 | 0 | 78.5 | 458 | 116 |
| 2019-07-27 | Manhattan | 169413 | 166704 | 12.2628 | 10.3 | -0.101217 | 0.402721 | 0 | 78.5 | 420 | 74 |
| 2019-07-27 | Queens | 11340 | 10541 | 28.7309 | 27.6667 | -0.073785 | 0.399045 | 0 | 78.5 | 396 | 120 |
| 2019-07-27 | Staten Island | 10 | 0 | 46.1983 | 51.925 | null | null | 0 | 78.5 | 57 | 4 |
| 2019-07-28 | Bronx | 307 | 53 | 15.8685 | 13.3333 | 0.008488 | 0.824025 | 0.01 | 79.5 | 141 | 68 |
| 2019-07-28 | Brooklyn | 2244 | 1279 | 15.8945 | 13.4167 | -0.043703 | 0.432615 | 0.01 | 79.5 | 339 | 121 |
| 2019-07-28 | EWR | 1 | 0 | 103.05 | 103.05 | null | null | 0.01 | 79.5 | null | 0 |
| 2019-07-28 | Manhattan | 148414 | 146066 | 11.6676 | 9.6667 | -0.173582 | 0.398133 | 0.01 | 79.5 | 345 | 57 |
| 2019-07-28 | Queens | 14752 | 13916 | 31.0241 | 29.05 | -0.036031 | 0.394711 | 0.01 | 79.5 | 323 | 114 |
| 2019-07-28 | Staten Island | 6 | 0 | 46.2389 | 42.8 | null | null | 0.01 | 79.5 | 51 | 6 |
| 2019-07-29 | Bronx | 209 | 34 | 22.5679 | 17.3167 | 0.062199 | 0.539552 | 0 | 81.5 | 120 | 64 |
| 2019-07-29 | Brooklyn | 1623 | 1049 | 17.0051 | 14.2667 | -0.056127 | 0.407783 | 0 | 81.5 | 274 | 151 |
| 2019-07-29 | EWR | 2 | 1 | 0.3 | 0.3 | 0.077962 | null | 0 | 81.5 | null | 0 |