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-12-10 | Brooklyn | 1799 | 1308 | 16.8843 | 13.5333 | 0.026573 | 0.448383 | 0.13 | 48.5 | 6 | 137 |
| 2019-12-10 | EWR | 1 | 0 | 0.0833 | 0.0833 | null | null | 0.13 | 48.5 | null | 0 |
| 2019-12-10 | Manhattan | 215210 | 213417 | 15.1431 | 12.2833 | 0.128194 | 0.419678 | 0.13 | 48.5 | 27 | 89 |
| 2019-12-10 | Queens | 14559 | 14033 | 38.716 | 35.75 | 0.121041 | 0.406114 | 0.13 | 48.5 | 6 | 132 |
| 2019-12-10 | Staten Island | 7 | 2 | 70.3048 | 62.4333 | -0.021452 | 0.078843 | 0.13 | 48.5 | 2 | 8 |
| 2019-12-11 | Bronx | 119 | 27 | 21.637 | 13.8833 | 0.071377 | 0.77138 | 0.26 | 35.5 | 4 | 53 |
| 2019-12-11 | Brooklyn | 2248 | 1678 | 16.2871 | 13.2333 | -0.006908 | 0.448588 | 0.26 | 35.5 | 9 | 108 |
| 2019-12-11 | EWR | 1 | 1 | 1.1667 | 1.1667 | 1.722767 | null | 0.26 | 35.5 | null | 0 |
| 2019-12-11 | Manhattan | 234517 | 232510 | 14.4482 | 11.9667 | 0.095972 | 0.406422 | 0.26 | 35.5 | 39 | 79 |
| 2019-12-11 | Queens | 13862 | 13337 | 35.4308 | 33.0833 | 0.051896 | 0.387572 | 0.26 | 35.5 | 8 | 137 |
| 2019-12-11 | Staten Island | 6 | 2 | 51.5778 | 48.8917 | -0.22143 | 0.222439 | 0.26 | 35.5 | 3 | 13 |
| 2019-12-12 | Bronx | 158 | 31 | 25.2978 | 17.875 | -0.033363 | 0.646427 | 0 | 31 | 10 | 60 |
| 2019-12-12 | Brooklyn | 2535 | 1882 | 17.0013 | 13.55 | 0.056626 | 0.446242 | 0 | 31 | 18 | 119 |
| 2019-12-12 | EWR | 1 | 1 | 0.4 | 0.4 | 0.287682 | null | 0 | 31 | null | 0 |
| 2019-12-12 | Manhattan | 241890 | 239505 | 15.676 | 12.7667 | 0.15459 | 0.417148 | 0 | 31 | 35 | 92 |
| 2019-12-12 | Queens | 16212 | 15616 | 43.3352 | 40.8833 | 0.209286 | 0.425714 | 0 | 31 | 11 | 109 |
| 2019-12-12 | Staten Island | 7 | 1 | 44.2952 | 26.05 | 0.049803 | null | 0 | 31 | 5 | 5 |
| 2019-12-13 | Bronx | 181 | 40 | 22.3099 | 15.6 | -0.023005 | 0.728961 | 0.81 | 40.5 | 2 | 95 |
| 2019-12-13 | Brooklyn | 2681 | 1949 | 17.0407 | 13.7833 | 0.081563 | 0.443628 | 0.81 | 40.5 | 6 | 156 |
| 2019-12-13 | EWR | 2 | 1 | 4.2417 | 4.2417 | 3.283414 | null | 0.81 | 40.5 | null | 0 |
| 2019-12-13 | Manhattan | 243356 | 240652 | 15.7371 | 12.8333 | 0.187952 | 0.422397 | 0.81 | 40.5 | 34 | 107 |
| 2019-12-13 | Queens | 14458 | 13864 | 43.5297 | 41.8917 | 0.218196 | 0.419257 | 0.81 | 40.5 | 6 | 122 |
| 2019-12-13 | Staten Island | 8 | 1 | 38.5604 | 30.05 | 0.054649 | null | 0.81 | 40.5 | 5 | 11 |
| 2019-12-14 | Bronx | 145 | 23 | 17.4362 | 13.4333 | -0.261495 | 0.536475 | 1.16 | 50.5 | 10 | 73 |
| 2019-12-14 | Brooklyn | 3502 | 2347 | 15.9197 | 13.6083 | 0.047773 | 0.464736 | 1.16 | 50.5 | 19 | 113 |