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 |
|---|---|---|---|---|---|---|---|
| 52 | 87 | 684 | 15.308 | 15.827 | 3.272 | 13.8 | 13.07 |
| 125 | 75 | 684 | 27.158 | 28.876 | 7.082 | 25.56 | 15.69 |
| 87 | 166 | 684 | 31.292 | 33.419 | 9.374 | 31.76 | 17.86 |
| 138 | 174 | 683 | 28.967 | 32.159 | 12.926 | 38.52 | 26.32 |
| 65 | 211 | 683 | 11.683 | 12.669 | 2.577 | 12.36 | 13.25 |
| 74 | 7 | 683 | 14.1 | 15.826 | 4.682 | 16.6 | 19.45 |
| 263 | 194 | 683 | 12.067 | 13.351 | 3.926 | 15.05 | 19.12 |
| 238 | 4 | 683 | 25.967 | 27.194 | 6.6 | 23.93 | 15.48 |
| 193 | 140 | 682 | 12.992 | 14.136 | 2.576 | 12.31 | 12.95 |
| 7 | 173 | 681 | 16.15 | 17.177 | 4.143 | 15.92 | 15.48 |
| 144 | 226 | 681 | 23.767 | 24.84 | 6.567 | 23.4 | 17.03 |
| 263 | 80 | 681 | 24.65 | 26.063 | 7.388 | 25.08 | 17.79 |
| 13 | 112 | 681 | 26.25 | 27.042 | 7.645 | 26.03 | 17.86 |
| 93 | 162 | 681 | 23.767 | 25.765 | 9.728 | 51.37 | 25.48 |
| 237 | 52 | 681 | 30.25 | 31.629 | 8.617 | 29.04 | 17.35 |
| 113 | 228 | 680 | 26.6 | 27.96 | 7.606 | 26.05 | 17.41 |
| 138 | 167 | 680 | 22.75 | 24.946 | 8.16 | 26.68 | 21.1 |
| 137 | 24 | 679 | 24.733 | 26.211 | 5.581 | 21.37 | 13.85 |
| 162 | 70 | 679 | 26.65 | 30.211 | 9.233 | 30.45 | 20.93 |
| 163 | 61 | 678 | 40.25 | 42.167 | 10.049 | 35.28 | 15.04 |
| 145 | 107 | 678 | 11.458 | 13.233 | 3.062 | 40.45 | 15.92 |
| 261 | 189 | 678 | 23.05 | 23.993 | 4.647 | 18.89 | 12.15 |
| 12 | 209 | 678 | 8.617 | 9.433 | 1.137 | 7.7 | 7.87 |
| 232 | 236 | 677 | 21.65 | 23.252 | 6.022 | 21.35 | 16.82 |
| 144 | 129 | 677 | 23.55 | 25.655 | 8.132 | 27.23 | 20.92 |