Zone-to-zone routes
Every pickup zone to drop-off zone pair seen in 2019 with trips, median and mean minutes, distance, fare and speed.
45,836 rows · by trips ↓ Download CSV
| pu_idINTEGER | do_idINTEGER | tripsINTEGER | median_minREAL | mean_minREAL | mean_milesREAL | mean_fareREAL | mean_mphREAL |
|---|---|---|---|---|---|---|---|
| 151 | 247 | 476 | 20.558 | 22.112 | 4.703 | 18.74 | 13.81 |
| 33 | 89 | 476 | 18.808 | 21.091 | 5.613 | 20.18 | 17.59 |
| 87 | 95 | 476 | 32.333 | 34.645 | 12.315 | 37.64 | 22.74 |
| 159 | 42 | 476 | 10.075 | 11.364 | 1.701 | 9.46 | 9.92 |
| 33 | 14 | 475 | 17.45 | 19.009 | 7.01 | 22.18 | 23.95 |
| 65 | 188 | 475 | 19.617 | 20.988 | 3.767 | 16.5 | 11.61 |
| 179 | 140 | 475 | 18.333 | 19.683 | 3.927 | 16.32 | 13.18 |
| 66 | 233 | 475 | 16.15 | 17.581 | 5.975 | 19.53 | 21.97 |
| 50 | 97 | 475 | 33 | 34.153 | 7.226 | 27.48 | 13.28 |
| 164 | 133 | 475 | 28.183 | 29.877 | 10.881 | 33.6 | 23.18 |
| 246 | 36 | 474 | 34.825 | 36.566 | 8.475 | 30.4 | 14.44 |
| 238 | 112 | 474 | 31.925 | 32.964 | 7.009 | 26.67 | 13.26 |
| 143 | 145 | 474 | 21.217 | 22.123 | 4.212 | 17.77 | 12.02 |
| 10 | 142 | 474 | 50.292 | 52.453 | 16.802 | 52.39 | 20.96 |
| 211 | 188 | 473 | 25.733 | 27.118 | 5.83 | 22.38 | 13.54 |
| 148 | 127 | 473 | 27.017 | 28.722 | 12.633 | 37.23 | 27.99 |
| 146 | 75 | 473 | 15.083 | 16.984 | 4.349 | 15.85 | 17.12 |
| 140 | 89 | 473 | 39.217 | 42.616 | 13.371 | 42.27 | 20.3 |
| 138 | 147 | 473 | 20.167 | 22.46 | 7.493 | 24.6 | 21.94 |
| 256 | 114 | 472 | 14.492 | 16.041 | 3.061 | 15.57 | 12.76 |
| 114 | 95 | 472 | 30.458 | 32.508 | 10.725 | 34.33 | 21.12 |
| 43 | 127 | 472 | 20.592 | 22.766 | 8.228 | 26.16 | 23.39 |
| 100 | 195 | 472 | 35.192 | 36.711 | 8.747 | 31.12 | 15.1 |
| 246 | 228 | 472 | 27.3 | 29.213 | 8.618 | 28.59 | 18.59 |
| 145 | 137 | 471 | 10.45 | 11.847 | 2.808 | 33.53 | 16.14 |