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-08-11 | Queens | 15150 | 14325 | 28.8754 | 27.6667 | -0.092348 | 0.376694 | 0 | 71.5 | 340 | 94 |
| 2019-08-11 | Staten Island | 4 | 2 | 58.0292 | 48.7417 | 0.423231 | 0.307772 | 0 | 71.5 | 51 | 4 |
| 2019-08-12 | Bronx | 236 | 38 | 17.8909 | 15.4583 | 0.010139 | 0.463533 | 0 | 76.5 | 111 | 69 |
| 2019-08-12 | Brooklyn | 1530 | 996 | 15.7151 | 13.1333 | -0.077261 | 0.419184 | 0 | 76.5 | 266 | 122 |
| 2019-08-12 | EWR | 4 | 4 | 0.9708 | 0.9833 | 0.307652 | 1.344454 | 0 | 76.5 | null | 0 |
| 2019-08-12 | Manhattan | 158295 | 156750 | 11.8461 | 9.8667 | -0.14432 | 0.370048 | 0 | 76.5 | 299 | 61 |
| 2019-08-12 | Queens | 15332 | 14709 | 31.749 | 30.975 | -0.037497 | 0.354935 | 0 | 76.5 | 173 | 125 |
| 2019-08-12 | Staten Island | 5 | 2 | 64.0667 | 60.85 | 0.530596 | 0.185875 | 0 | 76.5 | 35 | 9 |
| 2019-08-13 | Bronx | 177 | 38 | 17.7113 | 14 | -0.121868 | 0.707756 | 0.07 | 75 | 122 | 42 |
| 2019-08-13 | Brooklyn | 1432 | 953 | 15.7936 | 13.425 | -0.052614 | 0.412082 | 0.07 | 75 | 271 | 107 |
| 2019-08-13 | EWR | 4 | 3 | 2.3375 | 0.3083 | -0.741991 | 0.609873 | 0.07 | 75 | null | 0 |
| 2019-08-13 | Manhattan | 179623 | 178100 | 12.6088 | 10.7167 | -0.060312 | 0.372466 | 0.07 | 75 | 333 | 69 |
| 2019-08-13 | Queens | 12560 | 12047 | 29.7761 | 29.1333 | -0.078425 | 0.367634 | 0.07 | 75 | 199 | 82 |
| 2019-08-13 | Staten Island | 7 | 1 | 55.9976 | 65.1833 | 0.290487 | null | 0.07 | 75 | 39 | 7 |
| 2019-08-14 | Bronx | 181 | 30 | 19.9762 | 14.1333 | 0.137395 | 0.634283 | 0 | 78.5 | 122 | 61 |
| 2019-08-14 | Brooklyn | 1627 | 1058 | 16.3309 | 13.4333 | -0.04397 | 0.425113 | 0 | 78.5 | 281 | 125 |
| 2019-08-14 | EWR | 3 | 3 | 0.9333 | 1.2667 | 0.463798 | 1.38543 | 0 | 78.5 | null | 0 |
| 2019-08-14 | Manhattan | 184652 | 182982 | 13.1952 | 11.0333 | -0.021761 | 0.377679 | 0 | 78.5 | 350 | 61 |
| 2019-08-14 | Queens | 13198 | 12649 | 33.7751 | 31.5333 | 0.038239 | 0.373158 | 0 | 78.5 | 203 | 105 |
| 2019-08-14 | Staten Island | 5 | 2 | 38.5033 | 27.3667 | 0.173029 | 0.047218 | 0 | 78.5 | 40 | 8 |
| 2019-08-15 | Bronx | 191 | 45 | 20.2955 | 16.0333 | 0.051085 | 0.519802 | 0 | 77.5 | 125 | 53 |
| 2019-08-15 | Brooklyn | 1918 | 1296 | 17.2871 | 14.4833 | -0.008737 | 0.459307 | 0 | 77.5 | 288 | 114 |
| 2019-08-15 | Manhattan | 187524 | 185608 | 13.4817 | 11.25 | -0.007866 | 0.372198 | 0 | 77.5 | 362 | 85 |
| 2019-08-15 | Queens | 13701 | 13099 | 31.9651 | 31.45 | 0.00723 | 0.3564 | 0 | 77.5 | 208 | 109 |
| 2019-08-15 | Staten Island | 2 | 0 | 63.1083 | 63.1083 | null | null | 0 | 77.5 | 38 | 4 |