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-22 | Staten Island | 11 | 2 | 52.3727 | 56.55 | -0.073323 | 0.103695 | 0 | 40 | 3 | 11 |
| 2019-02-23 | Bronx | 471 | 84 | 19.1801 | 16.0167 | -0.052788 | 0.614076 | 0.01 | 37 | 13 | 39 |
| 2019-02-23 | Brooklyn | 3329 | 1932 | 16.2259 | 13.9167 | -0.026914 | 0.495792 | 0.01 | 37 | 44 | 93 |
| 2019-02-23 | Manhattan | 224143 | 220994 | 12.127 | 10.1333 | -0.070907 | 0.421361 | 0.01 | 37 | 84 | 57 |
| 2019-02-23 | Queens | 11407 | 10373 | 26.3339 | 25.9667 | -0.17027 | 0.376293 | 0.01 | 37 | 22 | 98 |
| 2019-02-23 | Staten Island | 3 | 0 | 80.8111 | 91.5833 | null | null | 0.01 | 37 | 6 | 5 |
| 2019-02-24 | Bronx | 433 | 60 | 19.3765 | 15.9333 | -0.202198 | 0.710378 | 0.58 | 41.5 | 6 | 26 |
| 2019-02-24 | Brooklyn | 2979 | 1637 | 15.2001 | 12.7833 | -0.099107 | 0.491069 | 0.58 | 41.5 | 44 | 83 |
| 2019-02-24 | EWR | 1 | 1 | 4.3667 | 4.3667 | 2.650574 | null | 0.58 | 41.5 | null | 0 |
| 2019-02-24 | Manhattan | 178273 | 175421 | 10.9067 | 9.05 | -0.186139 | 0.410599 | 0.58 | 41.5 | 83 | 49 |
| 2019-02-24 | Queens | 15491 | 14454 | 26.666 | 26.4 | -0.187774 | 0.368864 | 0.58 | 41.5 | 26 | 73 |
| 2019-02-24 | Staten Island | 13 | 2 | 38.4859 | 29.5167 | 0.118576 | 0.213954 | 0.58 | 41.5 | 8 | 10 |
| 2019-02-25 | Bronx | 517 | 75 | 27.8569 | 22.8167 | -0.001691 | 0.525829 | 0 | 35.5 | 7 | 75 |
| 2019-02-25 | Brooklyn | 2603 | 1495 | 19.4653 | 15.8667 | -0.068332 | 0.511162 | 0 | 35.5 | 27 | 164 |
| 2019-02-25 | EWR | 1 | 1 | 0.05 | 0.05 | -2.159484 | null | 0 | 35.5 | null | 0 |
| 2019-02-25 | Manhattan | 201209 | 198808 | 12.0552 | 9.95 | -0.076733 | 0.404837 | 0 | 35.5 | 66 | 84 |
| 2019-02-25 | Queens | 16154 | 15257 | 30.9876 | 29.7333 | -0.096787 | 0.327656 | 0 | 35.5 | 12 | 130 |
| 2019-02-25 | Staten Island | 10 | 2 | 52.1583 | 55.7833 | -0.07057 | 0.099801 | 0 | 35.5 | 2 | 14 |
| 2019-02-26 | Bronx | 523 | 87 | 26.5965 | 21.3667 | -0.069834 | 0.671023 | 0 | 30.5 | 7 | 58 |
| 2019-02-26 | Brooklyn | 2753 | 1522 | 20.2376 | 16.1167 | -0.014868 | 0.470497 | 0 | 30.5 | 25 | 143 |
| 2019-02-26 | EWR | 1 | 1 | 0.05 | 0.05 | -1.791759 | null | 0 | 30.5 | null | 0 |
| 2019-02-26 | Manhattan | 228456 | 225823 | 12.8469 | 10.6333 | -0.01382 | 0.395941 | 0 | 30.5 | 70 | 76 |
| 2019-02-26 | Queens | 16191 | 15212 | 31.4092 | 29.7667 | -0.054543 | 0.333294 | 0 | 30.5 | 13 | 115 |
| 2019-02-26 | Staten Island | 8 | 2 | 30.8479 | 27.35 | 0.003733 | 0.231633 | 0 | 30.5 | 2 | 20 |
| 2019-02-27 | Bronx | 572 | 83 | 26.1347 | 21.9583 | 0.115639 | 0.437934 | 0 | 27 | 6 | 65 |