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 |
|---|---|---|---|---|---|---|---|
| 249 | 111 | 25 | 23.233 | 24.683 | 7.76 | 25.15 | 19.75 |
| 185 | 259 | 25 | 18.167 | 18.785 | 4.447 | 17.48 | 15.32 |
| 216 | 236 | 25 | 44.55 | 43.685 | 15.934 | 52.74 | 24.84 |
| 28 | 260 | 25 | 19.25 | 20.772 | 8.611 | 28.04 | 26.42 |
| 260 | 41 | 25 | 23.967 | 26.995 | 7.936 | 26.38 | 19.01 |
| 12 | 228 | 25 | 15.35 | 18.1 | 5.657 | 18.92 | 20.16 |
| 228 | 129 | 25 | 39.383 | 38.573 | 12.407 | 39.16 | 20.47 |
| 189 | 125 | 25 | 21.45 | 22.558 | 4.38 | 18.54 | 12.17 |
| 68 | 251 | 25 | 36.75 | 38.584 | 17.158 | 49.64 | 27.36 |
| 165 | 222 | 25 | 29.5 | 29.984 | 7.093 | 25.7 | 14.54 |
| 198 | 177 | 25 | 16.317 | 16.053 | 2.676 | 12.6 | 11.02 |
| 35 | 216 | 25 | 30.333 | 31.271 | 7.054 | 27.06 | 14.06 |
| 121 | 131 | 25 | 9.683 | 9.812 | 2.209 | 9.78 | 13.76 |
| 186 | 115 | 25 | 42.283 | 44.035 | 16.977 | 50.56 | 23.03 |
| 5 | 173 | 25 | 68.217 | 69.224 | 34.19 | 94.02 | 30.98 |
| 218 | 168 | 25 | 35 | 36.191 | 16.156 | 45.35 | 27.9 |
| 258 | 88 | 25 | 39.033 | 38.691 | 14.736 | 43.55 | 23.2 |
| 78 | 135 | 25 | 30.85 | 30.797 | 13.593 | 38.94 | 26.66 |
| 80 | 34 | 25 | 11.35 | 13.893 | 2.509 | 11.51 | 11.94 |
| 49 | 142 | 25 | 35.033 | 38.038 | 9.392 | 32.4 | 15.7 |
| 70 | 79 | 25 | 32.967 | 33.096 | 10.412 | 33.36 | 19.97 |
| 159 | 162 | 25 | 32.2 | 36.067 | 6.122 | 26.11 | 12.16 |
| 174 | 247 | 25 | 23.983 | 28.161 | 4.769 | 21.39 | 11.7 |
| 129 | 243 | 25 | 27.533 | 30.496 | 10.206 | 33.32 | 22.38 |
| 213 | 147 | 25 | 13.2 | 14.235 | 2.673 | 11.88 | 12.16 |