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-04-11 | EWR | 2 | 1 | 21.1667 | 21.1667 | -0.057158 | null | 0 | 47.5 | null | 0 |
| 2019-04-11 | Manhattan | 240100 | 237567 | 13.8082 | 11.4167 | 0.037305 | 0.390006 | 0 | 47.5 | 326 | 70 |
| 2019-04-11 | Queens | 15750 | 14960 | 34.84 | 34.2667 | 0.043449 | 0.363556 | 0 | 47.5 | 194 | 108 |
| 2019-04-11 | Staten Island | 9 | 2 | 31.1111 | 16.1833 | -0.270449 | 0.063119 | 0 | 47.5 | 28 | 2 |
| 2019-04-12 | Bronx | 428 | 84 | 24.7625 | 20.3917 | -0.005429 | 0.651914 | 0.63 | 57 | 126 | 75 |
| 2019-04-12 | Brooklyn | 3077 | 2088 | 17.5479 | 13.9 | 0.042886 | 0.426027 | 0.63 | 57 | 197 | 159 |
| 2019-04-12 | EWR | 4 | 2 | 0.1958 | 0.1583 | -1.145256 | 1.56417 | 0.63 | 57 | null | 0 |
| 2019-04-12 | Manhattan | 244783 | 241939 | 13.6373 | 11.1833 | 0.049495 | 0.394598 | 0.63 | 57 | 268 | 92 |
| 2019-04-12 | Queens | 15675 | 14844 | 36.9017 | 36.15 | 0.089424 | 0.373082 | 0.63 | 57 | 183 | 114 |
| 2019-04-12 | Staten Island | 12 | 0 | 25.7542 | 17.4917 | null | null | 0.63 | 57 | 24 | 8 |
| 2019-04-13 | Bronx | 390 | 64 | 19.983 | 15.7417 | 0.048387 | 0.652255 | 0.24 | 68 | 111 | 58 |
| 2019-04-13 | Brooklyn | 3803 | 2399 | 16.5888 | 14.3333 | 0.043039 | 0.426096 | 0.24 | 68 | 256 | 110 |
| 2019-04-13 | EWR | 1 | 0 | 42.25 | 42.25 | null | null | 0.24 | 68 | null | 0 |
| 2019-04-13 | Manhattan | 231127 | 227710 | 12.7238 | 10.5667 | -0.04983 | 0.420391 | 0.24 | 68 | 366 | 91 |
| 2019-04-13 | Queens | 13638 | 12465 | 30.9771 | 30.0833 | 0.000076 | 0.389541 | 0.24 | 68 | 261 | 132 |
| 2019-04-13 | Staten Island | 13 | 2 | 26.5628 | 18.75 | -0.04344 | 0.049732 | 0.24 | 68 | 29 | 3 |
| 2019-04-14 | Bronx | 331 | 55 | 18.3797 | 14.15 | -0.065485 | 0.644777 | 0.01 | 66.5 | 86 | 48 |
| 2019-04-14 | Brooklyn | 3198 | 1891 | 15.0532 | 13.25 | -0.052253 | 0.463941 | 0.01 | 66.5 | 258 | 99 |
| 2019-04-14 | EWR | 3 | 2 | 7.2444 | 0.0667 | -1.530623 | 0.553225 | 0.01 | 66.5 | null | 0 |
| 2019-04-14 | Manhattan | 193692 | 190486 | 11.8795 | 9.6833 | -0.133946 | 0.416626 | 0.01 | 66.5 | 349 | 61 |
| 2019-04-14 | Queens | 14875 | 13937 | 28.4808 | 27.5833 | -0.105509 | 0.372003 | 0.01 | 66.5 | 230 | 78 |
| 2019-04-14 | Staten Island | 14 | 0 | 19.6155 | 13.3583 | null | null | 0.01 | 66.5 | 41 | 6 |
| 2019-04-15 | Bronx | 310 | 51 | 24.1218 | 18.0667 | 0.04603 | 0.81279 | 0.96 | 55.5 | 127 | 71 |
| 2019-04-15 | Brooklyn | 2714 | 1823 | 18.1264 | 14.625 | -0.002949 | 0.46713 | 0.96 | 55.5 | 207 | 142 |
| 2019-04-15 | Manhattan | 213969 | 211745 | 12.6833 | 10.2667 | -0.042333 | 0.399812 | 0.96 | 55.5 | 313 | 74 |