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 |
|---|---|---|---|---|---|---|---|
| 138 | 81 | 629 | 27.717 | 30.434 | 13.321 | 38.86 | 28.22 |
| 148 | 195 | 629 | 18.917 | 19.948 | 5.713 | 19.64 | 18.38 |
| 100 | 36 | 628 | 34.533 | 36.829 | 8.339 | 30.44 | 14.43 |
| 179 | 229 | 627 | 15.117 | 15.961 | 3.524 | 14.16 | 14.18 |
| 79 | 227 | 627 | 25.517 | 27.328 | 9.068 | 29.06 | 21.15 |
| 17 | 49 | 627 | 6.583 | 7.938 | 1.243 | 7.25 | 10.37 |
| 161 | 217 | 626 | 35.875 | 36.797 | 6.366 | 27.6 | 10.98 |
| 79 | 83 | 625 | 21.133 | 22.751 | 7.274 | 24.28 | 21.04 |
| 232 | 33 | 625 | 14.433 | 15.575 | 3.569 | 14.05 | 15.18 |
| 7 | 132 | 625 | 31.333 | 34.13 | 14.617 | 42.93 | 28.61 |
| 87 | 243 | 625 | 28.683 | 31.493 | 13.416 | 39.32 | 27.77 |
| 132 | 126 | 625 | 38.267 | 40.471 | 19.676 | 54.85 | 31.5 |
| 97 | 106 | 624 | 9.667 | 10.548 | 1.627 | 8.98 | 9.79 |
| 50 | 179 | 623 | 23.45 | 24.84 | 5.498 | 21.07 | 14.27 |
| 140 | 49 | 622 | 30.5 | 32.053 | 8.848 | 29.99 | 18.91 |
| 65 | 37 | 622 | 17.883 | 19.481 | 3.872 | 16.11 | 12.84 |
| 246 | 179 | 622 | 25.708 | 27.151 | 6.465 | 23.41 | 15.22 |
| 24 | 107 | 622 | 29.367 | 30.243 | 6.18 | 24.18 | 13.08 |
| 37 | 36 | 622 | 7.083 | 8.05 | 1.379 | 7.39 | 11.06 |
| 13 | 195 | 622 | 12.875 | 15.151 | 4.246 | 15.51 | 18.37 |
| 4 | 238 | 622 | 23.983 | 25.495 | 6.572 | 23.28 | 16.35 |
| 48 | 157 | 621 | 25.333 | 28.021 | 7.144 | 25.62 | 16.34 |
| 146 | 137 | 621 | 13.967 | 15.742 | 3.424 | 13.88 | 14.64 |
| 163 | 168 | 620 | 21.025 | 23.123 | 6.075 | 21.6 | 17.07 |
| 114 | 106 | 620 | 21.792 | 22.438 | 4.867 | 19.06 | 13.48 |