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-29 | Brooklyn | 2008 | 1389 | 16.7513 | 13.6333 | -0.035731 | 0.40568 | 0.01 | 50.5 | 220 | 114 |
| 2019-04-29 | EWR | 1 | 1 | 0.4333 | 0.4333 | 0.367725 | null | 0.01 | 50.5 | null | 0 |
| 2019-04-29 | Manhattan | 194893 | 193023 | 12.2512 | 10.2167 | -0.076156 | 0.384624 | 0.01 | 50.5 | 322 | 63 |
| 2019-04-29 | Queens | 18121 | 17384 | 31.3542 | 30.0667 | -0.08882 | 0.328693 | 0.01 | 50.5 | 189 | 120 |
| 2019-04-29 | Staten Island | 2 | 0 | 71.8917 | 71.8917 | null | null | 0.01 | 50.5 | 30 | 9 |
| 2019-04-30 | Bronx | 212 | 37 | 22.4781 | 15.55 | -0.150952 | 0.575023 | 0.04 | 54 | 140 | 68 |
| 2019-04-30 | Brooklyn | 2021 | 1400 | 16.4783 | 13.3333 | -0.052393 | 0.455514 | 0.04 | 54 | 223 | 103 |
| 2019-04-30 | EWR | 1 | 1 | 0.4833 | 0.4833 | 0.109199 | null | 0.04 | 54 | null | 0 |
| 2019-04-30 | Manhattan | 220635 | 218576 | 13.2052 | 11.0833 | 0.001356 | 0.392131 | 0.04 | 54 | 319 | 63 |
| 2019-04-30 | Queens | 17146 | 16466 | 34.5942 | 32.725 | -0.006269 | 0.357088 | 0.04 | 54 | 200 | 125 |
| 2019-04-30 | Staten Island | 4 | 0 | 37.4083 | 37.2667 | null | null | 0.04 | 54 | 34 | 8 |
| 2019-05-01 | Bronx | 227 | 56 | 19.3856 | 14.65 | -0.124757 | 0.630098 | 0 | 53 | 145 | 60 |
| 2019-05-01 | Brooklyn | 2243 | 1591 | 15.9345 | 13.05 | -0.000722 | 0.416904 | 0 | 53 | 237 | 127 |
| 2019-05-01 | EWR | 1 | 1 | 0.4833 | 0.4833 | 0.563935 | null | 0 | 53 | null | 0 |
| 2019-05-01 | Manhattan | 235497 | 233010 | 13.5272 | 11.2667 | 0.026272 | 0.395644 | 0 | 53 | 360 | 103 |
| 2019-05-01 | Queens | 16756 | 16114 | 35.5617 | 34.6 | 0.032097 | 0.368746 | 0 | 53 | 212 | 102 |
| 2019-05-01 | Staten Island | 2 | 1 | 43.2833 | 43.2833 | 0.410111 | null | 0 | 53 | 35 | 5 |
| 2019-05-02 | Bronx | 238 | 50 | 19.7176 | 14.4 | -0.178698 | 0.874103 | 0.01 | 64 | 136 | 57 |
| 2019-05-02 | Brooklyn | 2685 | 1933 | 16.8457 | 13.4667 | 0.02356 | 0.489075 | 0.01 | 64 | 245 | 137 |
| 2019-05-02 | EWR | 2 | 2 | 0.3083 | 0.3083 | 0.235002 | 0.647915 | 0.01 | 64 | null | 0 |
| 2019-05-02 | Manhattan | 242913 | 240424 | 14.1684 | 11.6 | 0.05659 | 0.393984 | 0.01 | 64 | 382 | 84 |
| 2019-05-02 | Queens | 16545 | 15882 | 37.1953 | 36.5333 | 0.090804 | 0.369774 | 0.01 | 64 | 215 | 136 |
| 2019-05-02 | Staten Island | 5 | 2 | 55.19 | 34.2167 | 0.024345 | 0.092548 | 0.01 | 64 | 34 | 10 |
| 2019-05-03 | Bronx | 293 | 58 | 21.2437 | 17.3 | 0.10848 | 0.53558 | 0.06 | 53 | 151 | 78 |
| 2019-05-03 | Brooklyn | 2770 | 1937 | 17.0945 | 13.7083 | 0.028709 | 0.46072 | 0.06 | 53 | 221 | 152 |