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-08-16 | Bronx | 241 | 45 | 18.3887 | 14.25 | -0.223477 | 0.941942 | 0 | 73.5 | 124 | 59 |
| 2019-08-16 | Brooklyn | 1785 | 1212 | 16.1592 | 13.5 | -0.01783 | 0.474377 | 0 | 73.5 | 276 | 121 |
| 2019-08-16 | EWR | 3 | 1 | 13.9778 | 0.2167 | -0.325422 | null | 0 | 73.5 | null | 0 |
| 2019-08-16 | Manhattan | 172590 | 170557 | 13.1701 | 10.9667 | -0.026435 | 0.389127 | 0 | 73.5 | 310 | 70 |
| 2019-08-16 | Queens | 13600 | 12961 | 32.0279 | 30.9 | 0.023645 | 0.385469 | 0 | 73.5 | 200 | 95 |
| 2019-08-16 | Staten Island | 4 | 2 | 42.0417 | 39.7833 | -0.048939 | 0.002913 | 0 | 73.5 | 36 | 5 |
| 2019-08-17 | Bronx | 250 | 51 | 16.9788 | 13.0583 | -0.10096 | 0.566497 | 0 | 80 | 231 | 55 |
| 2019-08-17 | Brooklyn | 1939 | 1182 | 15.6544 | 13.5667 | -0.021637 | 0.463876 | 0 | 80 | 466 | 105 |
| 2019-08-17 | EWR | 1 | 0 | 40.75 | 40.75 | null | null | 0 | 80 | null | 0 |
| 2019-08-17 | Manhattan | 162262 | 159594 | 12.4388 | 10.4667 | -0.093581 | 0.401783 | 0 | 80 | 430 | 82 |
| 2019-08-17 | Queens | 11502 | 10729 | 27.3917 | 26.2667 | -0.088286 | 0.407353 | 0 | 80 | 422 | 114 |
| 2019-08-17 | Staten Island | 6 | 0 | 43.3472 | 35.6 | null | null | 0 | 80 | 44 | 12 |
| 2019-08-18 | Bronx | 238 | 35 | 15.4005 | 12.1917 | -0.054778 | 0.506322 | 0.64 | 80 | 135 | 47 |
| 2019-08-18 | Brooklyn | 1872 | 1072 | 14.6659 | 12.7333 | -0.099093 | 0.476761 | 0.64 | 80 | 313 | 110 |
| 2019-08-18 | EWR | 2 | 2 | 0.4417 | 0.4417 | 0.189745 | 0.26834 | 0.64 | 80 | null | 0 |
| 2019-08-18 | Manhattan | 144479 | 142063 | 11.7138 | 9.7167 | -0.167725 | 0.40487 | 0.64 | 80 | 359 | 65 |
| 2019-08-18 | Queens | 13125 | 12314 | 28.2591 | 26.8333 | -0.091225 | 0.384099 | 0.64 | 80 | 322 | 78 |
| 2019-08-18 | Staten Island | 5 | 2 | 49.1367 | 66.95 | 0.13751 | 0.17256 | 0.64 | 80 | 34 | 8 |
| 2019-08-19 | Bronx | 158 | 36 | 16.6653 | 14.2833 | -0.296949 | 0.89861 | 0 | 81 | 103 | 64 |
| 2019-08-19 | Brooklyn | 1372 | 919 | 16.6027 | 13.5083 | -0.079611 | 0.439936 | 0 | 81 | 242 | 113 |
| 2019-08-19 | EWR | 2 | 1 | 0.9333 | 0.9333 | -0.131028 | null | 0 | 81 | null | 0 |
| 2019-08-19 | Manhattan | 154001 | 152470 | 12.1379 | 9.95 | -0.120139 | 0.384693 | 0 | 81 | 314 | 75 |
| 2019-08-19 | Queens | 17076 | 16279 | 32.0774 | 30.7333 | 0.017081 | 0.34491 | 0 | 81 | 180 | 109 |
| 2019-08-19 | Staten Island | 5 | 1 | 43.66 | 41.55 | 0.146317 | null | 0 | 81 | 34 | 10 |
| 2019-08-20 | Bronx | 153 | 32 | 19.1385 | 14.3333 | -0.258631 | 0.59854 | 0 | 81.5 | 112 | 62 |