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-03-16 | EWR | 2 | 1 | 0.65 | 0.65 | 0.074108 | null | 0 | 47.5 | null | 0 |
| 2019-03-16 | Manhattan | 236613 | 233015 | 13.1809 | 10.7667 | 0.001071 | 0.435171 | 0 | 47.5 | 76 | 75 |
| 2019-03-16 | Queens | 14355 | 13236 | 28.5464 | 26.8833 | -0.056017 | 0.392713 | 0 | 47.5 | 22 | 99 |
| 2019-03-16 | Staten Island | 3 | 0 | 36.8056 | 20.2833 | null | null | 0 | 47.5 | 5 | 14 |
| 2019-03-17 | Bronx | 457 | 55 | 18.3128 | 14.9 | -0.083713 | 0.560895 | 0 | 39.5 | 39 | 46 |
| 2019-03-17 | Brooklyn | 3614 | 1979 | 16.5116 | 13.4333 | -0.03463 | 0.541922 | 0 | 39.5 | 132 | 85 |
| 2019-03-17 | EWR | 2 | 1 | 19.5583 | 19.5583 | -0.057158 | null | 0 | 39.5 | null | 0 |
| 2019-03-17 | Manhattan | 191193 | 187412 | 11.8412 | 9.5167 | -0.131071 | 0.42167 | 0 | 39.5 | 130 | 55 |
| 2019-03-17 | Queens | 16869 | 15731 | 27.7851 | 27.2 | -0.118688 | 0.369761 | 0 | 39.5 | 105 | 68 |
| 2019-03-17 | Staten Island | 5 | 0 | 30.4 | 42.3 | null | null | 0 | 39.5 | 15 | 7 |
| 2019-03-18 | Bronx | 398 | 65 | 25.5578 | 22.7833 | 0.026266 | 0.470678 | 0 | 39 | 67 | 63 |
| 2019-03-18 | Brooklyn | 2376 | 1381 | 19.1826 | 15.3167 | -0.057614 | 0.410581 | 0 | 39 | 116 | 128 |
| 2019-03-18 | EWR | 1 | 1 | 0.05 | 0.05 | -1.819158 | null | 0 | 39 | null | 0 |
| 2019-03-18 | Manhattan | 189631 | 187236 | 11.9968 | 9.8667 | -0.115405 | 0.376353 | 0 | 39 | 130 | 67 |
| 2019-03-18 | Queens | 17000 | 16062 | 31.799 | 30.4833 | -0.058137 | 0.345974 | 0 | 39 | 102 | 125 |
| 2019-03-18 | Staten Island | 11 | 2 | 28.1636 | 23.8 | -0.051003 | 0.28466 | 0 | 39 | 19 | 9 |
| 2019-03-19 | Bronx | 452 | 79 | 26.5916 | 23.9667 | -0.076453 | 0.455666 | 0 | 43 | 71 | 72 |
| 2019-03-19 | Brooklyn | 2606 | 1517 | 20.1289 | 15.8083 | -0.037423 | 0.437985 | 0 | 43 | 107 | 108 |
| 2019-03-19 | Manhattan | 206161 | 203560 | 12.7553 | 10.5833 | -0.04755 | 0.37615 | 0 | 43 | 134 | 75 |
| 2019-03-19 | Queens | 15926 | 15031 | 30.969 | 29.7833 | -0.069993 | 0.3116 | 0 | 43 | 113 | 107 |
| 2019-03-19 | Staten Island | 8 | 2 | 35.6646 | 32 | 0.135149 | 0.053913 | 0 | 43 | 17 | 10 |
| 2019-03-20 | Bronx | 466 | 91 | 25.3533 | 22.0917 | -0.186402 | 0.637784 | 0 | 45 | 73 | 69 |
| 2019-03-20 | Brooklyn | 2659 | 1563 | 18.959 | 14.7667 | -0.063095 | 0.441977 | 0 | 45 | 116 | 116 |
| 2019-03-20 | EWR | 1 | 1 | 0.2333 | 0.2333 | 0.036368 | null | 0 | 45 | null | 0 |
| 2019-03-20 | Manhattan | 216895 | 214249 | 13.0672 | 10.7667 | -0.028885 | 0.375756 | 0 | 45 | 151 | 74 |