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-01 | Brooklyn | 3061 | 1906 | 18.8792 | 15.1 | -0.018828 | 0.511911 | 0 | 16 | 21 | 137 |
| 2019-02-01 | EWR | 2 | 2 | 0.6333 | 0.6333 | 1.02035 | 0.166146 | 0 | 16 | null | 0 |
| 2019-02-01 | Manhattan | 260425 | 257446 | 12.6696 | 10.4167 | 0.008816 | 0.407786 | 0 | 16 | 55 | 74 |
| 2019-02-01 | Queens | 13915 | 12975 | 32.6342 | 31.1333 | -0.040618 | 0.376936 | 0 | 16 | 9 | 116 |
| 2019-02-01 | Staten Island | 10 | 1 | 33.64 | 32.2917 | 0 | null | 0 | 16 | 1 | 20 |
| 2019-02-02 | Bronx | 416 | 76 | 18.2593 | 14.2167 | -0.267111 | 0.97501 | 0 | 25 | 12 | 70 |
| 2019-02-02 | Brooklyn | 3427 | 2002 | 15.9551 | 13.2667 | -0.057653 | 0.502334 | 0 | 25 | 44 | 129 |
| 2019-02-02 | EWR | 2 | 2 | 0.2083 | 0.2083 | -0.858826 | 0.912524 | 0 | 25 | null | 0 |
| 2019-02-02 | Manhattan | 234713 | 231675 | 11.6919 | 9.7333 | -0.080373 | 0.428721 | 0 | 25 | 80 | 54 |
| 2019-02-02 | Queens | 10448 | 9438 | 26.9409 | 26.3 | -0.178706 | 0.434544 | 0 | 25 | 23 | 104 |
| 2019-02-02 | Staten Island | 14 | 2 | 26.1833 | 22.15 | -0.236117 | 0.378529 | 0 | 25 | 4 | 18 |
| 2019-02-03 | Bronx | 476 | 69 | 17.0981 | 14.4667 | -0.146942 | 0.758243 | 0 | 43 | 5 | 44 |
| 2019-02-03 | Brooklyn | 3483 | 1888 | 16.0184 | 13.8667 | -0.093915 | 0.469101 | 0 | 43 | 42 | 101 |
| 2019-02-03 | EWR | 1 | 1 | 1.0667 | 1.0667 | 1.268511 | null | 0 | 43 | null | 0 |
| 2019-02-03 | Manhattan | 189417 | 186373 | 10.8076 | 9.0667 | -0.184525 | 0.400047 | 0 | 43 | 79 | 52 |
| 2019-02-03 | Queens | 14049 | 12923 | 26.239 | 25.7833 | -0.223593 | 0.350654 | 0 | 43 | 27 | 104 |
| 2019-02-03 | Staten Island | 9 | 0 | 23.5333 | 7.1 | null | null | 0 | 43 | 7 | 12 |
| 2019-02-04 | Bronx | 558 | 72 | 25.4099 | 21.75 | -0.014388 | 0.675556 | 0 | 51 | 5 | 75 |
| 2019-02-04 | Brooklyn | 2548 | 1503 | 19.3094 | 15.5917 | -0.065897 | 0.462084 | 0 | 51 | 22 | 100 |
| 2019-02-04 | EWR | 4 | 3 | 6.9667 | 1.0417 | 0.255141 | 1.042915 | 0 | 51 | null | 0 |
| 2019-02-04 | Manhattan | 199857 | 197303 | 12.0623 | 9.9833 | -0.091066 | 0.392558 | 0 | 51 | 59 | 80 |
| 2019-02-04 | Queens | 15952 | 14999 | 31.2181 | 30.3 | -0.095371 | 0.318757 | 0 | 51 | 9 | 132 |
| 2019-02-04 | Staten Island | 7 | 2 | 35.5905 | 17.7833 | 0.076271 | 0.244218 | 0 | 51 | 1 | 17 |
| 2019-02-05 | Bronx | 501 | 69 | 25.5012 | 22.1833 | -0.148669 | 0.666191 | 0 | 54.5 | 4 | 56 |
| 2019-02-05 | Brooklyn | 2706 | 1575 | 18.7979 | 14.8583 | -0.071007 | 0.478511 | 0 | 54.5 | 26 | 116 |