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-02-09 | Staten Island | 5 | 1 | 62.6933 | 56.3 | -0.020801 | null | 0 | 27.5 | 6 | 9 |
| 2019-02-10 | Bronx | 420 | 44 | 18.1356 | 15.3 | -0.220474 | 0.470546 | 0 | 29 | 5 | 35 |
| 2019-02-10 | Brooklyn | 3047 | 1602 | 15.6742 | 13.5167 | -0.091613 | 0.485885 | 0 | 29 | 44 | 99 |
| 2019-02-10 | EWR | 2 | 2 | 0.5083 | 0.5083 | 0.015318 | 2.14875 | 0 | 29 | null | 0 |
| 2019-02-10 | Manhattan | 189622 | 186805 | 11.2405 | 9.35 | -0.154405 | 0.413716 | 0 | 29 | 84 | 67 |
| 2019-02-10 | Queens | 14594 | 13658 | 27.4472 | 26.7 | -0.169634 | 0.376905 | 0 | 29 | 26 | 77 |
| 2019-02-10 | Staten Island | 5 | 0 | 31.71 | 23.9167 | null | null | 0 | 29 | 9 | 7 |
| 2019-02-11 | Bronx | 463 | 68 | 26.0023 | 21.85 | 0.061997 | 0.477591 | 0 | 34 | 5 | 67 |
| 2019-02-11 | Brooklyn | 2421 | 1387 | 19.848 | 15.9333 | -0.057561 | 0.497898 | 0 | 34 | 23 | 123 |
| 2019-02-11 | EWR | 2 | 2 | 0.8917 | 0.8917 | -0.230517 | 2.820092 | 0 | 34 | null | 0 |
| 2019-02-11 | Manhattan | 202283 | 199856 | 12.1632 | 10.0833 | -0.075871 | 0.387445 | 0 | 34 | 60 | 65 |
| 2019-02-11 | Queens | 16052 | 15128 | 31.5709 | 29.5167 | -0.087712 | 0.345849 | 0 | 34 | 11 | 108 |
| 2019-02-11 | Staten Island | 6 | 2 | 31.4472 | 25.15 | 0.04503 | 0.391376 | 0 | 34 | 2 | 16 |
| 2019-02-12 | Bronx | 373 | 64 | 23.8807 | 22.0167 | -0.124527 | 0.662142 | 0.75 | 31 | 4 | 73 |
| 2019-02-12 | Brooklyn | 2173 | 1360 | 17.7105 | 13.8333 | -0.082562 | 0.454198 | 0.75 | 31 | 27 | 145 |
| 2019-02-12 | EWR | 2 | 1 | 14.7417 | 14.7417 | 2.33289 | null | 0.75 | 31 | null | 0 |
| 2019-02-12 | Manhattan | 209928 | 207803 | 12.1168 | 10.1833 | -0.019668 | 0.399609 | 0.75 | 31 | 54 | 78 |
| 2019-02-12 | Queens | 10687 | 9932 | 27.0457 | 26.6167 | -0.157135 | 0.354874 | 0.75 | 31 | 7 | 134 |
| 2019-02-12 | Staten Island | 7 | 1 | 37.4857 | 35.6333 | 0.470535 | null | 0.75 | 31 | 2 | 25 |
| 2019-02-13 | Bronx | 475 | 85 | 29.6088 | 24 | 0.097752 | 0.75163 | 0.08 | 37 | 6 | 68 |
| 2019-02-13 | Brooklyn | 2820 | 1641 | 20.1194 | 15.7833 | -0.017971 | 0.467197 | 0.08 | 37 | 27 | 145 |
| 2019-02-13 | EWR | 2 | 1 | 14.0167 | 14.0167 | 1.330725 | null | 0.08 | 37 | null | 0 |
| 2019-02-13 | Manhattan | 234520 | 231919 | 13.2337 | 10.9 | 0.004751 | 0.388172 | 0.08 | 37 | 67 | 72 |
| 2019-02-13 | Queens | 14723 | 13790 | 34.6826 | 32.8 | 0.029625 | 0.360852 | 0.08 | 37 | 8 | 112 |
| 2019-02-13 | Staten Island | 8 | 0 | 39.4625 | 36.0833 | null | null | 0.08 | 37 | 2 | 14 |