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-10-02 | Bronx | 195 | 37 | 24.3591 | 18.1 | 0.063077 | 0.955992 | 0.03 | 78 | 82 | 62 |
| 2019-10-02 | Brooklyn | 2111 | 1493 | 16.5196 | 13.7833 | 0.007746 | 0.426118 | 0.03 | 78 | 200 | 143 |
| 2019-10-02 | EWR | 3 | 1 | 52.95 | 55.4833 | 0.41871 | null | 0.03 | 78 | null | 0 |
| 2019-10-02 | Manhattan | 211764 | 209933 | 14.4224 | 12 | 0.087309 | 0.397054 | 0.03 | 78 | 293 | 93 |
| 2019-10-02 | Queens | 15240 | 14623 | 38.5984 | 37.0667 | 0.107564 | 0.373532 | 0.03 | 78 | 153 | 126 |
| 2019-10-02 | Staten Island | 5 | 2 | 50.41 | 44.8667 | -0.021172 | 0.3205 | 0.03 | 78 | 16 | 12 |
| 2019-10-03 | Bronx | 199 | 37 | 22.4167 | 16.75 | 0.083445 | 0.782233 | 0.34 | 58 | 88 | 85 |
| 2019-10-03 | Brooklyn | 2224 | 1519 | 17.3921 | 13.9417 | 0.036631 | 0.459922 | 0.34 | 58 | 180 | 138 |
| 2019-10-03 | EWR | 2 | 2 | 0.2667 | 0.2667 | -0.760888 | 1.051028 | 0.34 | 58 | null | 0 |
| 2019-10-03 | Manhattan | 225203 | 223328 | 15.4373 | 12.7 | 0.170844 | 0.409429 | 0.34 | 58 | 299 | 100 |
| 2019-10-03 | Queens | 14303 | 13718 | 41.6434 | 39.7833 | 0.184702 | 0.388538 | 0.34 | 58 | 139 | 114 |
| 2019-10-03 | Staten Island | 6 | 2 | 58.2833 | 47.9083 | 0.361888 | 0.478482 | 0.34 | 58 | 18 | 19 |
| 2019-10-04 | Bronx | 241 | 52 | 22.1676 | 18.2667 | 0.144429 | 0.653746 | 0 | 58 | 77 | 66 |
| 2019-10-04 | Brooklyn | 2791 | 1957 | 17.2475 | 14 | 0.049957 | 0.422247 | 0 | 58 | 163 | 160 |
| 2019-10-04 | EWR | 4 | 2 | 13.2958 | 0.3083 | -0.365444 | 0.056599 | 0 | 58 | null | 0 |
| 2019-10-04 | Manhattan | 219376 | 217320 | 14.3119 | 11.8 | 0.08059 | 0.395387 | 0 | 58 | 294 | 91 |
| 2019-10-04 | Queens | 15384 | 14688 | 36.2462 | 35.35 | 0.099787 | 0.367898 | 0 | 58 | 150 | 130 |
| 2019-10-04 | Staten Island | 5 | 2 | 45.6267 | 55.5 | -0.158376 | 0.029611 | 0 | 58 | 14 | 8 |
| 2019-10-05 | Bronx | 277 | 69 | 17.9596 | 14.8667 | -0.178071 | 0.607298 | 0 | 53 | 103 | 50 |
| 2019-10-05 | Brooklyn | 2572 | 1678 | 15.1842 | 12.9333 | 0.003457 | 0.460092 | 0 | 53 | 277 | 103 |
| 2019-10-05 | EWR | 1 | 0 | 0.75 | 0.75 | null | null | 0 | 53 | null | 0 |
| 2019-10-05 | Manhattan | 207972 | 205292 | 13.3704 | 11.1 | 0.017631 | 0.410432 | 0 | 53 | 377 | 82 |
| 2019-10-05 | Queens | 11676 | 10880 | 28.3312 | 27.4 | -0.071776 | 0.401933 | 0 | 53 | 231 | 96 |
| 2019-10-05 | Staten Island | 3 | 0 | 75.3722 | 67.2667 | null | null | 0 | 53 | 31 | 10 |
| 2019-10-06 | Bronx | 217 | 39 | 14.6806 | 12.05 | -0.196433 | 0.553941 | 0.01 | 63.5 | 70 | 60 |