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-11-22 | Manhattan | 216648 | 214616 | 13.7628 | 11.4667 | 0.064821 | 0.388323 | 0.07 | 45.5 | 142 | 83 |
| 2019-11-22 | Queens | 13267 | 12674 | 36.8972 | 34.8833 | 0.103793 | 0.383698 | 0.07 | 45.5 | 77 | 102 |
| 2019-11-22 | Staten Island | 5 | 2 | 48.3 | 37.0333 | 0.251009 | 0.081182 | 0.07 | 45.5 | 9 | 9 |
| 2019-11-23 | Bronx | 171 | 28 | 15.6201 | 12.6667 | -0.302836 | 0.666182 | 0.03 | 39.5 | 56 | 42 |
| 2019-11-23 | Brooklyn | 2264 | 1498 | 15.6011 | 13.4083 | 0.009696 | 0.443801 | 0.03 | 39.5 | 177 | 125 |
| 2019-11-23 | EWR | 1 | 1 | 16.9667 | 16.9667 | 3.575691 | null | 0.03 | 39.5 | null | 0 |
| 2019-11-23 | Manhattan | 213996 | 211697 | 12.4764 | 10.55 | -0.033356 | 0.40409 | 0.03 | 39.5 | 188 | 62 |
| 2019-11-23 | Queens | 10674 | 9917 | 28.0612 | 26.9833 | -0.082156 | 0.411978 | 0.03 | 39.5 | 122 | 98 |
| 2019-11-23 | Staten Island | 5 | 0 | 58.46 | 59.6333 | null | null | 0.03 | 39.5 | 16 | 10 |
| 2019-11-24 | Bronx | 156 | 31 | 16.3016 | 12.325 | -0.241845 | 0.851745 | 0.9 | 43 | 42 | 57 |
| 2019-11-24 | Brooklyn | 1886 | 1136 | 14.2776 | 12.3333 | -0.078946 | 0.46018 | 0.9 | 43 | 159 | 97 |
| 2019-11-24 | Manhattan | 177871 | 175609 | 11.509 | 9.5667 | -0.120366 | 0.400715 | 0.9 | 43 | 159 | 61 |
| 2019-11-24 | Queens | 12727 | 12069 | 26.2138 | 25.4833 | -0.152062 | 0.373722 | 0.9 | 43 | 107 | 117 |
| 2019-11-24 | Staten Island | 7 | 2 | 31.169 | 19.3333 | -0.023984 | 0.033919 | 0.9 | 43 | 16 | 14 |
| 2019-11-25 | Bronx | 159 | 41 | 21.0382 | 15 | 0.013838 | 0.468544 | 0 | 46 | 35 | 60 |
| 2019-11-25 | Brooklyn | 1534 | 1053 | 16.994 | 13.9667 | -0.03951 | 0.438556 | 0 | 46 | 96 | 149 |
| 2019-11-25 | EWR | 1 | 1 | 0.0667 | 0.0667 | -1.139434 | null | 0 | 46 | null | 0 |
| 2019-11-25 | Manhattan | 184829 | 183319 | 13.0421 | 10.9667 | 0.000216 | 0.384412 | 0 | 46 | 115 | 68 |
| 2019-11-25 | Queens | 11526 | 10981 | 31.2559 | 29.65 | -0.015998 | 0.364415 | 0 | 46 | 58 | 119 |
| 2019-11-25 | Staten Island | 4 | 2 | 61.15 | 55.575 | 0.385654 | 0.609566 | 0 | 46 | 9 | 12 |
| 2019-11-26 | Bronx | 165 | 31 | 21.4827 | 16.2333 | -0.070827 | 0.522947 | 0 | 52.5 | 35 | 83 |
| 2019-11-26 | Brooklyn | 1833 | 1269 | 18.3088 | 14.1667 | 0.023448 | 0.495593 | 0 | 52.5 | 98 | 134 |
| 2019-11-26 | EWR | 1 | 0 | 88.4 | 88.4 | null | null | 0 | 52.5 | null | 0 |
| 2019-11-26 | Manhattan | 196819 | 195189 | 14.6283 | 11.9833 | 0.092739 | 0.404501 | 0 | 52.5 | 120 | 86 |
| 2019-11-26 | Queens | 11737 | 11185 | 37.3766 | 35.7333 | 0.126575 | 0.377264 | 0 | 52.5 | 66 | 124 |