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-04-02 | Staten Island | 6 | 3 | 43.2417 | 49.6417 | -0.226218 | 0.268107 | 0 | 45.5 | 20 | 6 |
| 2019-04-03 | Bronx | 580 | 101 | 28.2947 | 25.3333 | -0.044259 | 0.649713 | 0 | 54 | 114 | 60 |
| 2019-04-03 | Brooklyn | 3174 | 1933 | 20.0952 | 15.6667 | 0.016171 | 0.455457 | 0 | 54 | 188 | 135 |
| 2019-04-03 | Manhattan | 229765 | 227167 | 13.5269 | 11.2 | 0.010948 | 0.383579 | 0 | 54 | 273 | 74 |
| 2019-04-03 | Queens | 15906 | 14983 | 33.2678 | 31.95 | -0.006691 | 0.34148 | 0 | 54 | 173 | 113 |
| 2019-04-03 | Staten Island | 7 | 1 | 40.6 | 29.1167 | 0.361511 | null | 0 | 54 | 21 | 10 |
| 2019-04-04 | Bronx | 484 | 79 | 28.6525 | 23.8583 | -0.031565 | 0.722591 | 0 | 52 | 111 | 71 |
| 2019-04-04 | Brooklyn | 3232 | 1999 | 19.6518 | 15.15 | -0.007905 | 0.440677 | 0 | 52 | 196 | 133 |
| 2019-04-04 | EWR | 4 | 3 | 6.4792 | 0.4917 | -0.806855 | 1.538239 | 0 | 52 | null | 0 |
| 2019-04-04 | Manhattan | 241447 | 238458 | 14.1556 | 11.5333 | 0.046322 | 0.385327 | 0 | 52 | 279 | 89 |
| 2019-04-04 | Queens | 16728 | 15691 | 37.0646 | 35.7833 | 0.113584 | 0.379947 | 0 | 52 | 170 | 118 |
| 2019-04-04 | Staten Island | 10 | 2 | 27.2633 | 24.95 | -0.137669 | 0.001216 | 0 | 52 | 20 | 7 |
| 2019-04-05 | Bronx | 547 | 77 | 27.5058 | 22.9333 | -0.072693 | 0.545318 | 0.2 | 41.5 | 111 | 76 |
| 2019-04-05 | Brooklyn | 3607 | 2230 | 19.9899 | 15.3833 | 0.048682 | 0.493408 | 0.2 | 41.5 | 178 | 151 |
| 2019-04-05 | EWR | 1 | 1 | 0.35 | 0.35 | 0.336472 | null | 0.2 | 41.5 | null | 0 |
| 2019-04-05 | Manhattan | 256642 | 253653 | 14.0909 | 11.4833 | 0.083105 | 0.395019 | 0.2 | 41.5 | 254 | 103 |
| 2019-04-05 | Queens | 15574 | 14615 | 38.0921 | 36.9667 | 0.119907 | 0.378759 | 0.2 | 41.5 | 162 | 123 |
| 2019-04-05 | Staten Island | 8 | 1 | 39.7042 | 36.4917 | -0.13814 | null | 0.2 | 41.5 | 18 | 6 |
| 2019-04-06 | Bronx | 413 | 49 | 20.9918 | 17.8333 | -0.120738 | 0.524535 | 0 | 53.5 | 104 | 54 |
| 2019-04-06 | Brooklyn | 3961 | 2383 | 17.6999 | 14.95 | 0.050818 | 0.459996 | 0 | 53.5 | 213 | 97 |
| 2019-04-06 | EWR | 1 | 0 | 0.05 | 0.05 | null | null | 0 | 53.5 | null | 0 |
| 2019-04-06 | Manhattan | 230295 | 227084 | 12.728 | 10.6333 | -0.040052 | 0.411759 | 0 | 53.5 | 332 | 78 |
| 2019-04-06 | Queens | 12213 | 11154 | 30.3217 | 28.6 | -0.043245 | 0.393724 | 0 | 53.5 | 228 | 123 |
| 2019-04-06 | Staten Island | 4 | 2 | 35.0292 | 34.4 | -0.081796 | 0.204417 | 0 | 53.5 | 21 | 15 |
| 2019-04-07 | Bronx | 447 | 67 | 19.7191 | 16.2833 | -0.015312 | 0.610484 | 0 | 58.5 | 73 | 61 |