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-06-25 | Brooklyn | 2255 | 1425 | 17.6403 | 13.5833 | 0.002027 | 0.448928 | 0.86 | 78 | 232 | 139 |
| 2019-06-25 | EWR | 4 | 3 | 3.0458 | 0.3833 | 1.056104 | 2.427165 | 0.86 | 78 | null | 0 |
| 2019-06-25 | Manhattan | 209490 | 207455 | 13.5737 | 11.2 | 0.014527 | 0.387494 | 0.86 | 78 | 304 | 97 |
| 2019-06-25 | Queens | 15406 | 14644 | 34.0079 | 31.8167 | 0.052663 | 0.368066 | 0.86 | 78 | 175 | 120 |
| 2019-06-25 | Staten Island | 9 | 1 | 31.1889 | 19.0167 | -0.062328 | null | 0.86 | 78 | 31 | 11 |
| 2019-06-26 | Bronx | 286 | 44 | 26.1287 | 19.425 | 0.038214 | 0.61741 | 0 | 79.5 | 107 | 68 |
| 2019-06-26 | Brooklyn | 2421 | 1584 | 18.5895 | 15 | 0.024471 | 0.393726 | 0 | 79.5 | 226 | 158 |
| 2019-06-26 | EWR | 1 | 0 | 4.1 | 4.1 | null | null | 0 | 79.5 | null | 0 |
| 2019-06-26 | Manhattan | 217268 | 215080 | 14.5575 | 11.8333 | 0.065494 | 0.402324 | 0 | 79.5 | 335 | 104 |
| 2019-06-26 | Queens | 15320 | 14603 | 39.4634 | 38.3833 | 0.158312 | 0.378586 | 0 | 79.5 | 188 | 169 |
| 2019-06-26 | Staten Island | 5 | 2 | 66.62 | 82.1833 | 0.116731 | 0.392802 | 0 | 79.5 | 34 | 8 |
| 2019-06-27 | Bronx | 247 | 46 | 23.6691 | 20.3167 | -0.144938 | 0.545032 | 0 | 80 | 98 | 60 |
| 2019-06-27 | Brooklyn | 2722 | 1804 | 19.6904 | 15.2167 | 0.082046 | 0.480743 | 0 | 80 | 236 | 181 |
| 2019-06-27 | EWR | 2 | 2 | 0.4167 | 0.4167 | 0.220115 | 0.41875 | 0 | 80 | null | 0 |
| 2019-06-27 | Manhattan | 220338 | 217980 | 15.1141 | 12.0167 | 0.087679 | 0.407262 | 0 | 80 | 350 | 103 |
| 2019-06-27 | Queens | 15842 | 15093 | 38.9503 | 36.2167 | 0.144579 | 0.378456 | 0 | 80 | 186 | 132 |
| 2019-06-27 | Staten Island | 5 | 2 | 65.9767 | 76.5 | -0.019419 | 0.110351 | 0 | 80 | 35 | 7 |
| 2019-06-28 | Bronx | 334 | 60 | 23.5239 | 17.3333 | 0.097766 | 0.723911 | 0 | 81 | 98 | 63 |
| 2019-06-28 | Brooklyn | 2539 | 1596 | 18.2766 | 15.0333 | 0.034086 | 0.474725 | 0 | 81 | 225 | 161 |
| 2019-06-28 | EWR | 1 | 1 | 0.7667 | 0.7667 | 1.120591 | null | 0 | 81 | null | 0 |
| 2019-06-28 | Manhattan | 209579 | 207122 | 14.0789 | 11.3667 | 0.045583 | 0.406921 | 0 | 81 | 287 | 103 |
| 2019-06-28 | Queens | 15263 | 14438 | 37.8652 | 36.0833 | 0.139153 | 0.378687 | 0 | 81 | 180 | 149 |
| 2019-06-28 | Staten Island | 6 | 1 | 50.8806 | 57.4333 | 0.048064 | null | 0 | 81 | 24 | 11 |
| 2019-06-29 | Bronx | 309 | 78 | 16.3676 | 12.4833 | -0.003788 | 0.458339 | 0.08 | 81.5 | 203 | 68 |
| 2019-06-29 | Brooklyn | 2428 | 1474 | 16.3411 | 13.775 | 0.050007 | 0.439853 | 0.08 | 81.5 | 358 | 142 |