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-02-14 | Bronx | 561 | 89 | 28.8981 | 24.4333 | 0.073906 | 0.650611 | 0 | 39.5 | 6 | 62 |
| 2019-02-14 | Brooklyn | 3188 | 1951 | 20.9129 | 16.7 | 0.00574 | 0.478094 | 0 | 39.5 | 25 | 138 |
| 2019-02-14 | Manhattan | 237388 | 234467 | 13.7071 | 11.1667 | 0.038268 | 0.392522 | 0 | 39.5 | 64 | 97 |
| 2019-02-14 | Queens | 14297 | 13292 | 37.3096 | 36.8 | 0.091926 | 0.366114 | 0 | 39.5 | 13 | 123 |
| 2019-02-14 | Staten Island | 8 | 3 | 33.8833 | 39.1417 | -0.546701 | 0.998666 | 0 | 39.5 | 2 | 22 |
| 2019-02-15 | Bronx | 557 | 98 | 26.9541 | 23.6167 | -0.046865 | 0.678793 | 0 | 50.5 | 5 | 70 |
| 2019-02-15 | Brooklyn | 3188 | 1872 | 19.9371 | 15.9167 | 0.002547 | 0.463921 | 0 | 50.5 | 21 | 130 |
| 2019-02-15 | EWR | 3 | 2 | 0.1556 | 0.15 | -1.002216 | 0.6009 | 0 | 50.5 | null | 0 |
| 2019-02-15 | Manhattan | 222628 | 219527 | 13.4742 | 11.05 | 0.00505 | 0.387984 | 0 | 50.5 | 53 | 79 |
| 2019-02-15 | Queens | 15052 | 14036 | 37.3756 | 36.3 | 0.063662 | 0.36748 | 0 | 50.5 | 11 | 97 |
| 2019-02-15 | Staten Island | 10 | 1 | 40.6867 | 35.1 | 0 | null | 0 | 50.5 | 2 | 9 |
| 2019-02-16 | Bronx | 376 | 57 | 19.8547 | 15.9 | -0.095794 | 0.568656 | 0 | 39.5 | 11 | 62 |
| 2019-02-16 | Brooklyn | 3291 | 1908 | 16.2454 | 13.8167 | -0.020076 | 0.448189 | 0 | 39.5 | 40 | 106 |
| 2019-02-16 | EWR | 2 | 0 | 0.125 | 0.125 | null | null | 0 | 39.5 | null | 0 |
| 2019-02-16 | Manhattan | 212097 | 208954 | 12.0373 | 10.15 | -0.084882 | 0.41487 | 0 | 39.5 | 77 | 84 |
| 2019-02-16 | Queens | 10839 | 9794 | 27.3508 | 26.1333 | -0.149416 | 0.414951 | 0 | 39.5 | 24 | 93 |
| 2019-02-16 | Staten Island | 8 | 0 | 40.4583 | 36.875 | null | null | 0 | 39.5 | 8 | 15 |
| 2019-02-17 | Bronx | 458 | 61 | 18.6518 | 16.2583 | -0.025909 | 1.106096 | 0.04 | 32 | 5 | 28 |
| 2019-02-17 | Brooklyn | 2867 | 1584 | 15.7826 | 13.3 | -0.076273 | 0.475571 | 0.04 | 32 | 44 | 101 |
| 2019-02-17 | Manhattan | 184341 | 181511 | 11.3686 | 9.5167 | -0.155752 | 0.410188 | 0.04 | 32 | 86 | 60 |
| 2019-02-17 | Queens | 11838 | 10792 | 26.0581 | 25.35 | -0.185723 | 0.387738 | 0.04 | 32 | 27 | 77 |
| 2019-02-17 | Staten Island | 10 | 0 | 40.95 | 33.775 | null | null | 0.04 | 32 | 7 | 14 |
| 2019-02-18 | Bronx | 257 | 34 | 18.6044 | 16.3 | -0.416927 | 0.706682 | 0.09 | 34 | 8 | 41 |
| 2019-02-18 | Brooklyn | 1880 | 1016 | 15.5405 | 12.7417 | -0.181039 | 0.470989 | 0.09 | 34 | 21 | 84 |
| 2019-02-18 | EWR | 1 | 1 | 0.1167 | 0.1167 | -1.074515 | null | 0.09 | 34 | null | 0 |