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-10 | Queens | 15150 | 14554 | 37.2777 | 36.0333 | 0.0918 | 0.388492 | 0 | 62 | 142 | 116 |
| 2019-10-10 | Staten Island | 11 | 2 | 56.6091 | 55.1667 | -0.03306 | 0.081467 | 0 | 62 | 18 | 14 |
| 2019-10-11 | Bronx | 190 | 43 | 19.9318 | 15.5917 | 0.010132 | 0.548762 | 0 | 59.5 | 83 | 65 |
| 2019-10-11 | Brooklyn | 2223 | 1577 | 17.4505 | 14.45 | 0.051027 | 0.425333 | 0 | 59.5 | 157 | 126 |
| 2019-10-11 | EWR | 1 | 1 | 0.65 | 0.65 | 0.405465 | null | 0 | 59.5 | null | 0 |
| 2019-10-11 | Manhattan | 215286 | 213210 | 14.4541 | 12.0167 | 0.083499 | 0.392556 | 0 | 59.5 | 305 | 73 |
| 2019-10-11 | Queens | 15858 | 15239 | 38.1105 | 36.3667 | 0.117361 | 0.387174 | 0 | 59.5 | 147 | 109 |
| 2019-10-11 | Staten Island | 8 | 2 | 51.525 | 45.175 | -0.029316 | 0.05702 | 0 | 59.5 | 15 | 5 |
| 2019-10-12 | Bronx | 155 | 34 | 17.48 | 14.9333 | 0.235769 | 0.752645 | 0 | 61 | 98 | 54 |
| 2019-10-12 | Brooklyn | 2363 | 1503 | 15.5242 | 13.35 | -0.027781 | 0.453943 | 0 | 61 | 261 | 93 |
| 2019-10-12 | EWR | 1 | 0 | 2.3667 | 2.3667 | null | null | 0 | 61 | null | 0 |
| 2019-10-12 | Manhattan | 200543 | 198090 | 13.3163 | 11.2333 | -0.00629 | 0.416015 | 0 | 61 | 357 | 59 |
| 2019-10-12 | Queens | 12131 | 11311 | 28.1778 | 27.2 | -0.089888 | 0.389029 | 0 | 61 | 226 | 104 |
| 2019-10-12 | Staten Island | 6 | 0 | 27.2167 | 21.6167 | null | null | 0 | 61 | 27 | 6 |
| 2019-10-13 | Bronx | 149 | 17 | 16.9311 | 12.55 | -0.350989 | 0.949394 | 0 | 60 | 65 | 51 |
| 2019-10-13 | Brooklyn | 2204 | 1375 | 15.2264 | 13.2667 | -0.05782 | 0.470939 | 0 | 60 | 231 | 74 |
| 2019-10-13 | EWR | 2 | 2 | 2.0417 | 2.0417 | 1.512027 | 1.80221 | 0 | 60 | null | 0 |
| 2019-10-13 | Manhattan | 168805 | 166312 | 12.9345 | 10.5667 | -0.068608 | 0.42939 | 0 | 60 | 295 | 62 |
| 2019-10-13 | Queens | 14891 | 14163 | 28.7315 | 27.2 | -0.105997 | 0.366857 | 0 | 60 | 215 | 87 |
| 2019-10-13 | Staten Island | 6 | 2 | 44.7722 | 53.45 | -0.059272 | 0.206198 | 0 | 60 | 34 | 9 |
| 2019-10-14 | Bronx | 126 | 25 | 17.5103 | 14.2417 | -0.442314 | 0.897332 | 0 | 65 | 70 | 35 |
| 2019-10-14 | Brooklyn | 1377 | 931 | 14.3368 | 12.5167 | -0.161557 | 0.422118 | 0 | 65 | 162 | 86 |
| 2019-10-14 | Manhattan | 153796 | 152326 | 11.8844 | 9.7167 | -0.146041 | 0.400556 | 0 | 65 | 234 | 58 |
| 2019-10-14 | Queens | 16509 | 15825 | 28.1456 | 27.6833 | -0.13849 | 0.376952 | 0 | 65 | 116 | 81 |
| 2019-10-14 | Staten Island | 11 | 2 | 37.6742 | 25.3333 | -0.002843 | 0.02271 | 0 | 65 | 16 | 11 |