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-09-27 | Staten Island | 8 | 1 | 61.6938 | 58.9917 | 0.049494 | null | 0 | 67.5 | 16 | 11 |
| 2019-09-28 | Bronx | 222 | 52 | 17.8735 | 14.175 | 0.195973 | 0.843279 | 0 | 73.5 | 113 | 51 |
| 2019-09-28 | Brooklyn | 2634 | 1628 | 15.9021 | 13.275 | 0.017195 | 0.449061 | 0 | 73.5 | 277 | 112 |
| 2019-09-28 | EWR | 2 | 1 | 24.0917 | 24.0917 | 3.731881 | null | 0 | 73.5 | null | 0 |
| 2019-09-28 | Manhattan | 205769 | 203019 | 12.9178 | 10.8667 | -0.028415 | 0.40684 | 0 | 73.5 | 372 | 71 |
| 2019-09-28 | Queens | 11417 | 10627 | 29.5207 | 29.1333 | -0.039965 | 0.404215 | 0 | 73.5 | 239 | 108 |
| 2019-09-28 | Staten Island | 6 | 0 | 59.5222 | 73.8333 | null | null | 0 | 73.5 | 36 | 6 |
| 2019-09-29 | Bronx | 195 | 39 | 16.2752 | 13.7333 | 0.266435 | 0.865263 | 0 | 72.5 | 69 | 56 |
| 2019-09-29 | Brooklyn | 2510 | 1515 | 16.2166 | 13.8 | 0.016585 | 0.466693 | 0 | 72.5 | 238 | 99 |
| 2019-09-29 | EWR | 3 | 2 | 1.0722 | 1.25 | 1.222843 | 0.231155 | 0 | 72.5 | null | 0 |
| 2019-09-29 | Manhattan | 170060 | 167451 | 11.8387 | 9.7333 | -0.147566 | 0.398501 | 0 | 72.5 | 317 | 62 |
| 2019-09-29 | Queens | 14404 | 13592 | 28.9741 | 27.4167 | -0.084245 | 0.393226 | 0 | 72.5 | 225 | 83 |
| 2019-09-29 | Staten Island | 6 | 2 | 50.8611 | 57.65 | -0.006503 | 0.147467 | 0 | 72.5 | 36 | 11 |
| 2019-09-30 | Bronx | 176 | 31 | 18.3404 | 13.9333 | -0.072156 | 0.447087 | 0 | 65.5 | 67 | 46 |
| 2019-09-30 | Brooklyn | 1325 | 875 | 14.4681 | 12.55 | -0.095278 | 0.400903 | 0 | 65.5 | 154 | 89 |
| 2019-09-30 | EWR | 1 | 1 | 0.1667 | 0.1667 | -0.71784 | null | 0 | 65.5 | null | 0 |
| 2019-09-30 | Manhattan | 153692 | 152313 | 11.5535 | 9.6667 | -0.136033 | 0.374006 | 0 | 65.5 | 222 | 66 |
| 2019-09-30 | Queens | 14391 | 13764 | 27.9821 | 27.7333 | -0.131612 | 0.372216 | 0 | 65.5 | 116 | 81 |
| 2019-09-30 | Staten Island | 5 | 2 | 56.5333 | 64.8167 | 0.614729 | 0.007946 | 0 | 65.5 | 15 | 4 |
| 2019-10-01 | Bronx | 215 | 32 | 17.5567 | 14.35 | -0.085573 | 0.663633 | 0 | 72 | 74 | 56 |
| 2019-10-01 | Brooklyn | 1615 | 1114 | 15.4694 | 13.0833 | -0.094583 | 0.480668 | 0 | 72 | 181 | 100 |
| 2019-10-01 | EWR | 1 | 0 | 47.65 | 47.65 | null | null | 0 | 72 | null | 0 |
| 2019-10-01 | Manhattan | 181544 | 180088 | 12.2694 | 10.4833 | -0.061689 | 0.372667 | 0 | 72 | 275 | 60 |
| 2019-10-01 | Queens | 14590 | 13944 | 30.1423 | 29.5167 | -0.071626 | 0.354498 | 0 | 72 | 139 | 73 |
| 2019-10-01 | Staten Island | 5 | 2 | 41.5967 | 42.4167 | -0.027768 | 0.099358 | 0 | 72 | 15 | 6 |