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-03-29 | EWR | 3 | 1 | 0.6722 | 0.3333 | 0.105361 | null | 0 | 54 | null | 0 |
| 2019-03-29 | Manhattan | 223608 | 220724 | 13.4472 | 11.1833 | 0.012947 | 0.384492 | 0 | 54 | 182 | 91 |
| 2019-03-29 | Queens | 15205 | 14228 | 34.8892 | 34.0833 | 0.043271 | 0.352224 | 0 | 54 | 138 | 103 |
| 2019-03-29 | Staten Island | 6 | 0 | 49.9472 | 51.275 | null | null | 0 | 54 | 15 | 7 |
| 2019-03-30 | Bronx | 494 | 72 | 21.3122 | 17.125 | -0.074324 | 0.588308 | 0 | 61 | 83 | 59 |
| 2019-03-30 | Brooklyn | 4018 | 2453 | 16.8083 | 14.1917 | 0.007963 | 0.422593 | 0 | 61 | 174 | 114 |
| 2019-03-30 | EWR | 1 | 1 | 0.45 | 0.45 | 0.587787 | null | 0 | 61 | null | 0 |
| 2019-03-30 | Manhattan | 219315 | 215950 | 12.8272 | 10.7167 | -0.035786 | 0.419266 | 0 | 61 | 253 | 58 |
| 2019-03-30 | Queens | 13049 | 11965 | 29.4566 | 29.3 | -0.064145 | 0.390913 | 0 | 61 | 169 | 98 |
| 2019-03-30 | Staten Island | 11 | 0 | 21.55 | 13.3 | null | null | 0 | 61 | 15 | 8 |
| 2019-03-31 | Bronx | 435 | 59 | 18.229 | 14.7833 | -0.094785 | 0.588358 | 0.06 | 52 | 65 | 43 |
| 2019-03-31 | Brooklyn | 3092 | 1665 | 15.51 | 13.15 | -0.059638 | 0.441618 | 0.06 | 52 | 174 | 99 |
| 2019-03-31 | Manhattan | 189973 | 186946 | 11.2692 | 9.3167 | -0.150791 | 0.399394 | 0.06 | 52 | 255 | 42 |
| 2019-03-31 | Queens | 17005 | 15938 | 28.9481 | 27.8667 | -0.099393 | 0.37099 | 0.06 | 52 | 165 | 91 |
| 2019-03-31 | Staten Island | 8 | 2 | 29.9458 | 21.675 | -0.139006 | 0.0854 | 0.06 | 52 | 17 | 7 |
| 2019-04-01 | Bronx | 530 | 76 | 26.0324 | 22.2 | -0.091417 | 0.573832 | 0 | 39.5 | 104 | 74 |
| 2019-04-01 | Brooklyn | 2736 | 1597 | 19.7173 | 15.6833 | -0.039874 | 0.421833 | 0 | 39.5 | 180 | 132 |
| 2019-04-01 | EWR | 1 | 1 | 0.3 | 0.3 | 0.182322 | null | 0 | 39.5 | null | 0 |
| 2019-04-01 | Manhattan | 198452 | 196116 | 12.1415 | 10 | -0.079732 | 0.38595 | 0 | 39.5 | 234 | 54 |
| 2019-04-01 | Queens | 18152 | 17170 | 32.2862 | 30.6167 | -0.066282 | 0.349276 | 0 | 39.5 | 158 | 116 |
| 2019-04-01 | Staten Island | 4 | 2 | 38.3458 | 41.8083 | 0.107794 | 0.460141 | 0 | 39.5 | 17 | 6 |
| 2019-04-02 | Bronx | 470 | 74 | 28.3522 | 25.6333 | -0.053901 | 0.64404 | 0 | 45.5 | 104 | 56 |
| 2019-04-02 | Brooklyn | 2671 | 1605 | 19.6439 | 15.0333 | -0.024427 | 0.46139 | 0 | 45.5 | 176 | 138 |
| 2019-04-02 | Manhattan | 224150 | 221669 | 12.9244 | 10.8167 | -0.01298 | 0.381112 | 0 | 45.5 | 238 | 55 |
| 2019-04-02 | Queens | 16696 | 15825 | 30.9703 | 29.9833 | -0.075888 | 0.307232 | 0 | 45.5 | 156 | 94 |