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 |
|---|---|---|---|---|---|---|---|
| 255 | 202 | 50 | 20.458 | 20.48 | 4.557 | 17.44 | 13.67 |
| 72 | 225 | 50 | 16.517 | 18.051 | 2.944 | 13.79 | 10.21 |
| 65 | 130 | 50 | 34.45 | 38.517 | 13.642 | 40.95 | 23.66 |
| 61 | 55 | 50 | 39.508 | 40.099 | 12.685 | 40.53 | 20.38 |
| 213 | 248 | 50 | 9.083 | 9.06 | 1.894 | 9.26 | 12.86 |
| 138 | 251 | 50 | 49.842 | 56.518 | 24.052 | 68.56 | 28.66 |
| 112 | 41 | 50 | 28.175 | 30.353 | 8.841 | 29.12 | 18.17 |
| 61 | 190 | 50 | 10.325 | 10.875 | 1.816 | 9.37 | 10.76 |
| 79 | 9 | 50 | 31.658 | 33.007 | 14.53 | 42.52 | 27.66 |
| 112 | 238 | 50 | 28.175 | 30.734 | 7.159 | 26.09 | 14.85 |
| 4 | 95 | 50 | 25.083 | 27.256 | 10.43 | 32.41 | 24.11 |
| 244 | 261 | 50 | 35.433 | 38.58 | 11.035 | 35.74 | 17.95 |
| 225 | 90 | 50 | 39.383 | 41.091 | 7.402 | 29.92 | 11.65 |
| 88 | 241 | 50 | 39.967 | 45.019 | 16.066 | 48.98 | 24.84 |
| 130 | 145 | 50 | 23.867 | 26.861 | 11.503 | 46.36 | 29.13 |
| 42 | 125 | 50 | 33.2 | 36.186 | 9.457 | 32.71 | 17 |
| 216 | 163 | 50 | 54.575 | 53.433 | 15.316 | 52.35 | 18.3 |
| 169 | 159 | 50 | 15.808 | 17.991 | 2.818 | 13.96 | 10.68 |
| 90 | 178 | 50 | 35.192 | 36.994 | 10.931 | 35.44 | 19.06 |
| 161 | 215 | 50 | 37.308 | 43.381 | 15.11 | 45.24 | 22.4 |
| 83 | 70 | 50 | 12.333 | 13.553 | 3.445 | 14.09 | 18 |
| 138 | 115 | 50 | 45.008 | 48.624 | 22.36 | 61.91 | 29.29 |
| 157 | 50 | 50 | 27.475 | 29.591 | 7.155 | 48.04 | 16.31 |
| 241 | 254 | 50 | 17.433 | 18.163 | 3.356 | 14.89 | 11.67 |
| 246 | 121 | 50 | 37.733 | 38.744 | 13.2 | 41.16 | 21.61 |