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-06-29 | Manhattan | 189047 | 186265 | 12.9306 | 10.8 | -0.015105 | 0.411182 | 0.08 | 81.5 | 423 | 65 |
| 2019-06-29 | Queens | 11928 | 11041 | 29.0856 | 27.3 | -0.029758 | 0.413675 | 0.08 | 81.5 | 368 | 128 |
| 2019-06-29 | Staten Island | 15 | 0 | 21.3567 | 9.6333 | null | null | 0.08 | 81.5 | 49 | 15 |
| 2019-06-30 | Bronx | 303 | 44 | 17.2562 | 14.0667 | -0.008143 | 0.537803 | 0.06 | 76 | 131 | 55 |
| 2019-06-30 | Brooklyn | 2299 | 1247 | 16.4744 | 13.85 | -0.029306 | 0.506213 | 0.06 | 76 | 306 | 120 |
| 2019-06-30 | EWR | 5 | 2 | 6.4067 | 1.3 | 0.805848 | 0.75015 | 0.06 | 76 | null | 0 |
| 2019-06-30 | Manhattan | 139635 | 136987 | 13.3912 | 10.6 | -0.005457 | 0.473039 | 0.06 | 76 | 356 | 76 |
| 2019-06-30 | Queens | 14860 | 13949 | 30.3613 | 27.95 | -0.038738 | 0.420068 | 0.06 | 76 | 285 | 110 |
| 2019-06-30 | Staten Island | 4 | 2 | 57.1042 | 47.75 | 0.196577 | 0.16955 | 0.06 | 76 | 48 | 5 |
| 2019-07-01 | Bronx | 253 | 57 | 20.2955 | 16.2833 | -0.115708 | 0.530615 | 0 | 75 | 94 | 69 |
| 2019-07-01 | Brooklyn | 1871 | 1073 | 18.1948 | 15.4167 | -0.045745 | 0.421236 | 0 | 75 | 242 | 152 |
| 2019-07-01 | EWR | 1 | 1 | 1.7667 | 1.7667 | 1.773067 | null | 0 | 75 | null | 0 |
| 2019-07-01 | Manhattan | 165125 | 163089 | 12.5313 | 10.2667 | -0.074403 | 0.382852 | 0 | 75 | 274 | 74 |
| 2019-07-01 | Queens | 13223 | 12444 | 32.1707 | 31.2333 | -0.014079 | 0.382467 | 0 | 75 | 168 | 109 |
| 2019-07-01 | Staten Island | 7 | 2 | 46.1405 | 30.5 | 0.399336 | 0.021155 | 0 | 75 | 25 | 14 |
| 2019-07-02 | Bronx | 288 | 54 | 21.6661 | 17.3417 | -0.056367 | 0.427668 | 0.02 | 78 | 106 | 63 |
| 2019-07-02 | Brooklyn | 1892 | 1101 | 18.4586 | 14.725 | -0.059534 | 0.478349 | 0.02 | 78 | 258 | 141 |
| 2019-07-02 | EWR | 1 | 1 | 0.3667 | 0.3667 | 0.382992 | null | 0.02 | 78 | null | 0 |
| 2019-07-02 | Manhattan | 173386 | 171493 | 12.8422 | 10.5333 | -0.040583 | 0.386862 | 0.02 | 78 | 294 | 65 |
| 2019-07-02 | Queens | 10758 | 10052 | 30.5455 | 29.5 | -0.023856 | 0.387991 | 0.02 | 78 | 176 | 111 |
| 2019-07-02 | Staten Island | 4 | 2 | 51.9167 | 48.2833 | 0.130025 | 0.244124 | 0.02 | 78 | 30 | 9 |
| 2019-07-03 | Bronx | 298 | 57 | 21.3324 | 16.875 | -0.145641 | 0.604582 | 0 | 81 | 109 | 64 |
| 2019-07-03 | Brooklyn | 1916 | 1127 | 18.4314 | 14.9667 | 0.003279 | 0.475023 | 0 | 81 | 252 | 144 |
| 2019-07-03 | Manhattan | 155096 | 153284 | 13.8392 | 10.8333 | 0.015112 | 0.445985 | 0 | 81 | 305 | 94 |
| 2019-07-03 | Queens | 11450 | 10690 | 32.789 | 30.75 | 0.024588 | 0.372238 | 0 | 81 | 186 | 126 |