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-10-19 | Brooklyn | 2813 | 1745 | 16.2085 | 13.5 | 0.014213 | 0.453229 | 0 | 51.5 | 250 | 102 |
| 2019-10-19 | EWR | 2 | 2 | 0.5833 | 0.5833 | 0.007788 | 0.918732 | 0 | 51.5 | null | 0 |
| 2019-10-19 | Manhattan | 211674 | 209028 | 13.5363 | 11.1833 | 0.008623 | 0.423251 | 0 | 51.5 | 368 | 66 |
| 2019-10-19 | Queens | 12428 | 11591 | 29.7407 | 28.6333 | -0.039529 | 0.398095 | 0 | 51.5 | 222 | 107 |
| 2019-10-19 | Staten Island | 6 | 0 | 52.0972 | 55.7 | null | null | 0 | 51.5 | 28 | 7 |
| 2019-10-20 | Bronx | 168 | 22 | 15.0408 | 12.4583 | -0.27425 | 0.907384 | 0.54 | 54 | 64 | 43 |
| 2019-10-20 | Brooklyn | 2223 | 1388 | 14.447 | 12.4 | -0.073994 | 0.463454 | 0.54 | 54 | 221 | 92 |
| 2019-10-20 | EWR | 1 | 0 | 26.8833 | 26.8833 | null | null | 0.54 | 54 | null | 0 |
| 2019-10-20 | Manhattan | 183294 | 180906 | 12.4471 | 10.2 | -0.087539 | 0.406929 | 0.54 | 54 | 311 | 65 |
| 2019-10-20 | Queens | 15729 | 14940 | 30.4143 | 28.7167 | -0.073261 | 0.384147 | 0.54 | 54 | 208 | 93 |
| 2019-10-20 | Staten Island | 7 | 2 | 37.5595 | 29.6 | -0.015058 | 0.035172 | 0.54 | 54 | 31 | 5 |
| 2019-10-21 | Bronx | 156 | 41 | 19.7859 | 15.1333 | -0.296259 | 0.970986 | 0 | 59 | 71 | 61 |
| 2019-10-21 | Brooklyn | 1464 | 1052 | 15.8742 | 13.6417 | -0.0456 | 0.454219 | 0 | 59 | 159 | 128 |
| 2019-10-21 | Manhattan | 180881 | 179355 | 12.792 | 10.8167 | -0.042944 | 0.377709 | 0 | 59 | 233 | 43 |
| 2019-10-21 | Queens | 16113 | 15481 | 31.2586 | 30.0833 | -0.049753 | 0.352488 | 0 | 59 | 116 | 120 |
| 2019-10-21 | Staten Island | 9 | 2 | 37.9074 | 34.1833 | -0.140881 | 0.15647 | 0 | 59 | 15 | 6 |
| 2019-10-22 | Bronx | 136 | 35 | 19.1545 | 14.1167 | -0.081207 | 0.403445 | 0.57 | 59 | 80 | 63 |
| 2019-10-22 | Brooklyn | 1592 | 1166 | 15.4629 | 12.6667 | -0.02145 | 0.45981 | 0.57 | 59 | 180 | 95 |
| 2019-10-22 | EWR | 1 | 1 | 0.05 | 0.05 | -1.504077 | null | 0.57 | 59 | null | 0 |
| 2019-10-22 | Manhattan | 209391 | 207819 | 13.7675 | 11.7 | 0.06066 | 0.384462 | 0.57 | 59 | 266 | 68 |
| 2019-10-22 | Queens | 14149 | 13606 | 32.8343 | 32.1167 | -0.010524 | 0.363453 | 0.57 | 59 | 138 | 113 |
| 2019-10-22 | Staten Island | 9 | 2 | 37.4611 | 39 | -0.039054 | 0.203638 | 0.57 | 59 | 16 | 8 |
| 2019-10-23 | Bronx | 184 | 39 | 21.11 | 16.0667 | -0.292908 | 1.090231 | 0.01 | 59.5 | 79 | 62 |
| 2019-10-23 | Brooklyn | 2034 | 1487 | 16.9971 | 14.3667 | 0.017125 | 0.449622 | 0.01 | 59.5 | 196 | 125 |
| 2019-10-23 | Manhattan | 211558 | 209774 | 14.482 | 12.0667 | 0.076132 | 0.383965 | 0.01 | 59.5 | 278 | 90 |