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-07-03 | Staten Island | 9 | 2 | 38.2259 | 21.1667 | -0.002525 | 0.063856 | 0 | 81 | 31 | 10 |
| 2019-07-04 | Bronx | 248 | 38 | 15.3214 | 12.5 | -0.274273 | 0.851121 | 0 | 82 | 101 | 45 |
| 2019-07-04 | Brooklyn | 1746 | 1027 | 17.1845 | 13.8417 | 0.013145 | 0.536459 | 0 | 82 | 220 | 92 |
| 2019-07-04 | EWR | 1 | 0 | 74.9833 | 74.9833 | null | null | 0 | 82 | null | 0 |
| 2019-07-04 | Manhattan | 104323 | 102507 | 10.3958 | 8.2667 | -0.304636 | 0.437162 | 0 | 82 | 265 | 31 |
| 2019-07-04 | Queens | 9454 | 8753 | 24.298 | 22.9 | -0.250745 | 0.445349 | 0 | 82 | 175 | 88 |
| 2019-07-04 | Staten Island | 5 | 2 | 46.75 | 56.4667 | 0.180551 | 0.196403 | 0 | 82 | 33 | 4 |
| 2019-07-05 | Bronx | 253 | 51 | 15.6267 | 11.9833 | -0.184719 | 0.601479 | 0 | 79 | 110 | 61 |
| 2019-07-05 | Brooklyn | 1700 | 971 | 15.3153 | 13.3833 | -0.092249 | 0.47195 | 0 | 79 | 242 | 141 |
| 2019-07-05 | EWR | 2 | 1 | 12.1333 | 12.1333 | -0.955511 | null | 0 | 79 | null | 0 |
| 2019-07-05 | Manhattan | 120431 | 118665 | 10.9 | 9.25 | -0.210553 | 0.391714 | 0 | 79 | 245 | 52 |
| 2019-07-05 | Queens | 10144 | 9447 | 25.035 | 24.2417 | -0.202815 | 0.370863 | 0 | 79 | 188 | 115 |
| 2019-07-05 | Staten Island | 4 | 1 | 31.7917 | 32.2333 | -0.005975 | null | 0 | 79 | 24 | 6 |
| 2019-07-06 | Bronx | 233 | 40 | 15.4308 | 12.2167 | 0.109182 | 0.685758 | 0 | 83 | 172 | 52 |
| 2019-07-06 | Brooklyn | 1534 | 877 | 14.3868 | 12.4417 | -0.12142 | 0.462396 | 0 | 83 | 316 | 96 |
| 2019-07-06 | EWR | 1 | 1 | 0.5167 | 0.5167 | 0.175891 | null | 0 | 83 | null | 0 |
| 2019-07-06 | Manhattan | 130947 | 129043 | 11.2476 | 9.5333 | -0.198774 | 0.409628 | 0 | 83 | 352 | 46 |
| 2019-07-06 | Queens | 10944 | 10228 | 24.7835 | 23.9167 | -0.193704 | 0.369166 | 0 | 83 | 311 | 96 |
| 2019-07-06 | Staten Island | 6 | 0 | 35.3139 | 31.3167 | null | null | 0 | 83 | 32 | 10 |
| 2019-07-07 | Bronx | 251 | 49 | 16.4547 | 12.7 | 0.006822 | 0.481838 | 0 | 79 | 128 | 35 |
| 2019-07-07 | Brooklyn | 1743 | 975 | 14.6835 | 12.3833 | -0.136967 | 0.446923 | 0 | 79 | 302 | 93 |
| 2019-07-07 | EWR | 1 | 0 | 64.5 | 64.5 | null | null | 0 | 79 | null | 0 |
| 2019-07-07 | Manhattan | 122738 | 120781 | 11.1601 | 9.2333 | -0.23499 | 0.399125 | 0 | 79 | 321 | 50 |
| 2019-07-07 | Queens | 17972 | 17002 | 29.2455 | 28.2333 | -0.089225 | 0.362034 | 0 | 79 | 282 | 93 |
| 2019-07-07 | Staten Island | 4 | 2 | 39.0917 | 33.4667 | -0.050539 | 0.071473 | 0 | 79 | 37 | 3 |