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-12-05 | Staten Island | 7 | 2 | 45.0524 | 41.1 | -0.200101 | 0.103544 | 0 | 39 | 3 | 13 |
| 2019-12-06 | Bronx | 171 | 44 | 21.0146 | 14.7 | 0.105023 | 0.81077 | 0 | 42 | 9 | 56 |
| 2019-12-06 | Brooklyn | 2265 | 1649 | 16.1539 | 13.4667 | 0.028274 | 0.430274 | 0 | 42 | 7 | 121 |
| 2019-12-06 | EWR | 1 | 0 | 0.2667 | 0.2667 | null | null | 0 | 42 | null | 0 |
| 2019-12-06 | Manhattan | 240666 | 238307 | 14.4771 | 12.0667 | 0.1048 | 0.398869 | 0 | 42 | 45 | 76 |
| 2019-12-06 | Queens | 15183 | 14603 | 38.9968 | 37.3333 | 0.123565 | 0.385158 | 0 | 42 | 4 | 101 |
| 2019-12-06 | Staten Island | 7 | 2 | 48.8238 | 43.9 | -0.093044 | 0.045998 | 0 | 42 | 4 | 13 |
| 2019-12-07 | Bronx | 164 | 33 | 15.9035 | 11.625 | -0.148561 | 0.657027 | 0 | 34 | 12 | 64 |
| 2019-12-07 | Brooklyn | 2735 | 1806 | 15.6856 | 13.3167 | 0.006012 | 0.435179 | 0 | 34 | 22 | 99 |
| 2019-12-07 | Manhattan | 238526 | 235859 | 13.8914 | 11.4833 | 0.059643 | 0.443992 | 0 | 34 | 74 | 79 |
| 2019-12-07 | Queens | 11518 | 10765 | 31.8786 | 29.7667 | -0.019966 | 0.411197 | 0 | 34 | 17 | 104 |
| 2019-12-07 | Staten Island | 4 | 0 | 59.5625 | 66.25 | null | null | 0 | 34 | 8 | 7 |
| 2019-12-08 | Bronx | 155 | 37 | 15.3309 | 10.5167 | -0.12329 | 0.52803 | 0 | 37 | 14 | 41 |
| 2019-12-08 | Brooklyn | 2245 | 1428 | 15.0011 | 12.85 | -0.044112 | 0.47775 | 0 | 37 | 14 | 113 |
| 2019-12-08 | EWR | 4 | 2 | 0.4625 | 0.3167 | -0.738251 | 1.673809 | 0 | 37 | null | 0 |
| 2019-12-08 | Manhattan | 190792 | 188307 | 12.579 | 10.3333 | -0.070126 | 0.414829 | 0 | 37 | 57 | 46 |
| 2019-12-08 | Queens | 15665 | 14877 | 29.0764 | 27.8333 | -0.091244 | 0.381156 | 0 | 37 | 22 | 93 |
| 2019-12-08 | Staten Island | 2 | 2 | 42.075 | 42.075 | -0.049147 | 0.069504 | 0 | 37 | 8 | 6 |
| 2019-12-09 | Bronx | 149 | 31 | 20.8453 | 14.2333 | 0.009844 | 0.580448 | 1.57 | 48.5 | 2 | 79 |
| 2019-12-09 | Brooklyn | 1691 | 1247 | 17.4899 | 13.5833 | 0.0593 | 0.471462 | 1.57 | 48.5 | 5 | 150 |
| 2019-12-09 | EWR | 3 | 2 | 2.0556 | 1.35 | 0.509068 | 2.531445 | 1.57 | 48.5 | null | 0 |
| 2019-12-09 | Manhattan | 193138 | 191515 | 14.6185 | 11.75 | 0.094998 | 0.419489 | 1.57 | 48.5 | 28 | 95 |
| 2019-12-09 | Queens | 15897 | 15300 | 40.6911 | 37.0167 | 0.144773 | 0.411097 | 1.57 | 48.5 | 5 | 148 |
| 2019-12-09 | Staten Island | 5 | 2 | 61.2433 | 54.9 | -0.095092 | 0.13448 | 1.57 | 48.5 | 2 | 6 |
| 2019-12-10 | Bronx | 151 | 30 | 20.233 | 14.0667 | 0.188615 | 0.42591 | 0.13 | 48.5 | 1 | 72 |