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-09-23 | Queens | 15983 | 15339 | 40.3341 | 36.3333 | 0.127411 | 0.396414 | 0.11 | 79.5 | 124 | 111 |
| 2019-09-23 | Staten Island | 7 | 2 | 40.5095 | 41.3667 | -0.115821 | 0.072867 | 0.11 | 79.5 | 19 | 9 |
| 2019-09-24 | Bronx | 173 | 35 | 20.6872 | 15.1 | 0.076795 | 0.430711 | 0 | 69.5 | 81 | 71 |
| 2019-09-24 | Brooklyn | 2123 | 1405 | 17.0483 | 13.6667 | -0.015281 | 0.483711 | 0 | 69.5 | 173 | 129 |
| 2019-09-24 | EWR | 3 | 2 | 0.2056 | 0.2 | -0.470122 | 0.428603 | 0 | 69.5 | null | 0 |
| 2019-09-24 | Manhattan | 181745 | 180001 | 15.0661 | 11.95 | 0.116081 | 0.454394 | 0 | 69.5 | 296 | 82 |
| 2019-09-24 | Queens | 13891 | 13298 | 37.8711 | 35.45 | 0.09948 | 0.390055 | 0 | 69.5 | 138 | 111 |
| 2019-09-24 | Staten Island | 9 | 2 | 60.5093 | 59.4167 | -0.005864 | 0.00196 | 0 | 69.5 | 21 | 6 |
| 2019-09-25 | Bronx | 193 | 40 | 22.6122 | 17.5 | 0.058151 | 0.380761 | 0 | 68.5 | 84 | 63 |
| 2019-09-25 | Brooklyn | 1961 | 1283 | 17.0728 | 14.2833 | -0.006223 | 0.471704 | 0 | 68.5 | 197 | 118 |
| 2019-09-25 | EWR | 3 | 3 | 0.1667 | 0.1667 | -0.743171 | 1.120146 | 0 | 68.5 | null | 0 |
| 2019-09-25 | Manhattan | 187469 | 185645 | 15.6452 | 12.3 | 0.154391 | 0.480971 | 0 | 68.5 | 325 | 78 |
| 2019-09-25 | Queens | 14078 | 13493 | 40.9564 | 37.8167 | 0.158407 | 0.416994 | 0 | 68.5 | 151 | 109 |
| 2019-09-25 | Staten Island | 6 | 1 | 50.1528 | 44.2083 | -0.169548 | null | 0 | 68.5 | 18 | 10 |
| 2019-09-26 | Bronx | 195 | 45 | 21.7522 | 16.1 | 0.025262 | 0.803374 | 0.02 | 73 | 82 | 69 |
| 2019-09-26 | Brooklyn | 2204 | 1511 | 17.7984 | 14.4417 | 0.039818 | 0.480916 | 0.02 | 73 | 182 | 144 |
| 2019-09-26 | EWR | 6 | 6 | 0.8389 | 0.225 | -0.288969 | 1.604631 | 0.02 | 73 | null | 0 |
| 2019-09-26 | Manhattan | 205727 | 203685 | 15.1344 | 12 | 0.114146 | 0.426804 | 0.02 | 73 | 313 | 76 |
| 2019-09-26 | Queens | 15390 | 14716 | 43.0653 | 40.2333 | 0.221502 | 0.416649 | 0.02 | 73 | 142 | 99 |
| 2019-09-26 | Staten Island | 7 | 1 | 61.2 | 53.2167 | -0.10017 | null | 0.02 | 73 | 18 | 11 |
| 2019-09-27 | Bronx | 199 | 45 | 21.9964 | 16.6167 | 0.019685 | 0.513479 | 0 | 67.5 | 76 | 78 |
| 2019-09-27 | Brooklyn | 2371 | 1594 | 17.6199 | 14.2667 | 0.036789 | 0.478215 | 0 | 67.5 | 164 | 167 |
| 2019-09-27 | EWR | 2 | 1 | 1.2917 | 1.2917 | 1.765784 | null | 0 | 67.5 | null | 0 |
| 2019-09-27 | Manhattan | 204529 | 202381 | 14.6613 | 11.9333 | 0.096049 | 0.403478 | 0 | 67.5 | 319 | 68 |
| 2019-09-27 | Queens | 15782 | 15057 | 39.9076 | 38.75 | 0.176431 | 0.387205 | 0 | 67.5 | 146 | 129 |