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-05-12 | EWR | 1 | 1 | 0.1167 | 0.1167 | -0.579818 | null | 1.32 | 51 | null | 0 |
| 2019-05-12 | Manhattan | 193323 | 190762 | 11.4131 | 9.2333 | -0.140081 | 0.408534 | 1.32 | 51 | 357 | 65 |
| 2019-05-12 | Queens | 16474 | 15592 | 31.0723 | 29.4167 | -0.060644 | 0.37333 | 1.32 | 51 | 267 | 99 |
| 2019-05-12 | Staten Island | 8 | 2 | 28.7896 | 17.9333 | 0.082505 | 0.055946 | 1.32 | 51 | 24 | 6 |
| 2019-05-13 | Bronx | 281 | 41 | 25.1195 | 18.9333 | 0.019845 | 0.487352 | 0.7 | 45 | 140 | 66 |
| 2019-05-13 | Brooklyn | 2112 | 1406 | 18.4421 | 13.875 | -0.014381 | 0.468288 | 0.7 | 45 | 224 | 122 |
| 2019-05-13 | EWR | 2 | 2 | 2.3083 | 2.3083 | 1.138567 | 2.111051 | 0.7 | 45 | null | 0 |
| 2019-05-13 | Manhattan | 209078 | 207193 | 13.6114 | 10.9167 | 0.028546 | 0.41585 | 0.7 | 45 | 342 | 81 |
| 2019-05-13 | Queens | 17197 | 16541 | 38.1903 | 35.4 | 0.077763 | 0.355908 | 0.7 | 45 | 201 | 118 |
| 2019-05-13 | Staten Island | 2 | 1 | 18.475 | 18.475 | 0.272927 | null | 0.7 | 45 | 31 | 5 |
| 2019-05-14 | Bronx | 276 | 53 | 26.3447 | 21.7917 | 0.070578 | 0.497657 | 0.3 | 48 | 150 | 58 |
| 2019-05-14 | Brooklyn | 2281 | 1493 | 18.899 | 14.6 | -0.013772 | 0.411945 | 0.3 | 48 | 245 | 145 |
| 2019-05-14 | Manhattan | 227742 | 225672 | 13.8002 | 11.4667 | 0.05954 | 0.390883 | 0.3 | 48 | 354 | 87 |
| 2019-05-14 | Queens | 15851 | 15057 | 34.6037 | 33.2333 | 0.025241 | 0.340913 | 0.3 | 48 | 216 | 115 |
| 2019-05-14 | Staten Island | 3 | 0 | 64.8444 | 62.3 | null | null | 0.3 | 48 | 36 | 9 |
| 2019-05-15 | Bronx | 323 | 50 | 26.1781 | 20.7 | 0.048379 | 0.584666 | 0.01 | 56.5 | 151 | 74 |
| 2019-05-15 | Brooklyn | 2605 | 1690 | 19.3104 | 15 | 0.018748 | 0.422299 | 0.01 | 56.5 | 243 | 122 |
| 2019-05-15 | EWR | 1 | 1 | 0.2 | 0.2 | -0.432864 | null | 0.01 | 56.5 | null | 0 |
| 2019-05-15 | Manhattan | 224569 | 222298 | 14.6446 | 11.8333 | 0.07546 | 0.408674 | 0.01 | 56.5 | 385 | 86 |
| 2019-05-15 | Queens | 15871 | 15152 | 39.0885 | 37.85 | 0.121529 | 0.391262 | 0.01 | 56.5 | 224 | 131 |
| 2019-05-15 | Staten Island | 6 | 2 | 26.4028 | 29.8333 | -0.049821 | 0.041272 | 0.01 | 56.5 | 38 | 13 |
| 2019-05-16 | Bronx | 280 | 48 | 28.0935 | 23.6417 | -0.032466 | 0.503457 | 0.12 | 62.5 | 147 | 56 |
| 2019-05-16 | Brooklyn | 2876 | 1934 | 19.7182 | 14.7167 | 0.057586 | 0.487329 | 0.12 | 62.5 | 256 | 144 |
| 2019-05-16 | EWR | 1 | 1 | 0.6 | 0.6 | 0.563094 | null | 0.12 | 62.5 | null | 0 |
| 2019-05-16 | Manhattan | 228280 | 225797 | 15.4263 | 12.2167 | 0.114337 | 0.425745 | 0.12 | 62.5 | 401 | 96 |