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-05-16 | Queens | 16479 | 15675 | 40.6855 | 40.0667 | 0.173384 | 0.389148 | 0.12 | 62.5 | 235 | 108 |
| 2019-05-16 | Staten Island | 11 | 1 | 37.047 | 24.0333 | 0.146093 | null | 0.12 | 62.5 | 40 | 11 |
| 2019-05-17 | Bronx | 354 | 66 | 24.9169 | 19.6583 | -0.035176 | 0.485231 | 0.03 | 68 | 142 | 79 |
| 2019-05-17 | Brooklyn | 3436 | 2288 | 19.2504 | 14.8417 | 0.07258 | 0.477443 | 0.03 | 68 | 228 | 136 |
| 2019-05-17 | EWR | 3 | 2 | 9.8722 | 2.4833 | 1.612228 | 1.115854 | 0.03 | 68 | null | 0 |
| 2019-05-17 | Manhattan | 235272 | 232464 | 14.3913 | 11.5333 | 0.063539 | 0.407852 | 0.03 | 68 | 345 | 88 |
| 2019-05-17 | Queens | 16704 | 15910 | 43.503 | 42.4 | 0.214371 | 0.410865 | 0.03 | 68 | 222 | 145 |
| 2019-05-17 | Staten Island | 9 | 2 | 24.9778 | 17.6833 | 0.017746 | 0.247518 | 0.03 | 68 | 28 | 11 |
| 2019-05-18 | Bronx | 414 | 64 | 19.8811 | 15.6333 | 0.007425 | 0.422033 | 0 | 65.5 | 166 | 77 |
| 2019-05-18 | Brooklyn | 3873 | 2333 | 16.7167 | 14.2167 | 0.016289 | 0.425889 | 0 | 65.5 | 326 | 133 |
| 2019-05-18 | EWR | 2 | 1 | 15.6417 | 15.6417 | -1.047319 | null | 0 | 65.5 | null | 0 |
| 2019-05-18 | Manhattan | 224220 | 220583 | 13.2423 | 10.8667 | -0.019331 | 0.423087 | 0 | 65.5 | 470 | 65 |
| 2019-05-18 | Queens | 14027 | 12938 | 32.8862 | 31.9833 | 0.024683 | 0.377147 | 0 | 65.5 | 321 | 127 |
| 2019-05-18 | Staten Island | 10 | 0 | 37.6167 | 13.4083 | null | null | 0 | 65.5 | 40 | 14 |
| 2019-05-19 | Bronx | 401 | 48 | 17.6795 | 14.3167 | -0.107748 | 0.766877 | 0.06 | 68 | 123 | 64 |
| 2019-05-19 | Brooklyn | 3270 | 1921 | 15.7114 | 13.9 | -0.044308 | 0.421664 | 0.06 | 68 | 321 | 112 |
| 2019-05-19 | EWR | 1 | 1 | 0.1167 | 0.1167 | -0.944462 | null | 0.06 | 68 | null | 0 |
| 2019-05-19 | Manhattan | 188639 | 185306 | 12.3322 | 10.0667 | -0.118131 | 0.410206 | 0.06 | 68 | 430 | 64 |
| 2019-05-19 | Queens | 17433 | 16380 | 31.4326 | 29.1667 | -0.039915 | 0.388722 | 0.06 | 68 | 288 | 95 |
| 2019-05-19 | Staten Island | 6 | 2 | 33.7583 | 20.7167 | 0.315007 | 0.214989 | 0.06 | 68 | 48 | 5 |
| 2019-05-20 | Bronx | 275 | 51 | 24.4873 | 19.25 | -0.016395 | 0.399756 | 0 | 75.5 | 135 | 83 |
| 2019-05-20 | Brooklyn | 2164 | 1372 | 18.7999 | 14.6917 | -0.034838 | 0.464558 | 0 | 75.5 | 233 | 146 |
| 2019-05-20 | EWR | 3 | 2 | 0.1611 | 0.1667 | -0.293893 | 0.157786 | 0 | 75.5 | null | 0 |
| 2019-05-20 | Manhattan | 203972 | 201864 | 13.2534 | 10.7 | -0.035401 | 0.389722 | 0 | 75.5 | 336 | 86 |
| 2019-05-20 | Queens | 18761 | 17844 | 34.5957 | 32.6333 | 0.019411 | 0.365579 | 0 | 75.5 | 192 | 126 |