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 |
|---|---|---|---|---|---|---|---|
| 79 | 117 | 27 | 57.783 | 60.465 | 26.15 | 74.75 | 27.05 |
| 231 | 206 | 27 | 32.95 | 38.67 | 16.098 | 46.83 | 26.75 |
| 196 | 13 | 27 | 25.367 | 30.064 | 12.341 | 51.89 | 27.58 |
| 129 | 261 | 27 | 39.233 | 41.896 | 13.021 | 40.99 | 20.85 |
| 225 | 223 | 27 | 29.783 | 30.422 | 8.613 | 29.28 | 17.09 |
| 71 | 113 | 27 | 42.467 | 44.384 | 8.633 | 29.2 | 12 |
| 191 | 131 | 27 | 9.383 | 11.41 | 2.854 | 11.52 | 16.43 |
| 151 | 106 | 27 | 40.9 | 40.984 | 11.869 | 38.76 | 18.18 |
| 177 | 80 | 27 | 31.05 | 30.654 | 4.078 | 19.53 | 8.38 |
| 226 | 73 | 27 | 25.4 | 25.814 | 8.894 | 28.31 | 22.04 |
| 238 | 15 | 27 | 31.617 | 33.099 | 16.689 | 47.24 | 31 |
| 254 | 168 | 27 | 22.55 | 24.242 | 8.514 | 27.04 | 22.59 |
| 49 | 74 | 27 | 30.767 | 32.758 | 11.763 | 34.77 | 23.5 |
| 152 | 181 | 27 | 41.867 | 42.204 | 13.02 | 42.02 | 19.04 |
| 94 | 42 | 27 | 22.633 | 22.095 | 4.792 | 18.93 | 13.93 |
| 66 | 41 | 27 | 31.617 | 36.002 | 11.21 | 36.04 | 20.58 |
| 260 | 159 | 27 | 23.85 | 25.243 | 8.422 | 27.4 | 21.04 |
| 189 | 39 | 27 | 25.983 | 28.335 | 6.155 | 23.15 | 13.78 |
| 155 | 17 | 27 | 35.6 | 35.378 | 5.85 | 25.25 | 10.22 |
| 87 | 109 | 27 | 42.4 | 44.768 | 18.853 | 54.19 | 25.72 |
| 190 | 148 | 27 | 18.167 | 19.615 | 4.397 | 17.41 | 13.7 |
| 124 | 155 | 27 | 21.4 | 21.634 | 8.721 | 26.46 | 25.35 |
| 129 | 10 | 27 | 20.133 | 25.012 | 10.179 | 31.17 | 28.71 |
| 185 | 3 | 27 | 8.833 | 10.927 | 2.19 | 11.81 | 11.33 |
| 233 | 73 | 27 | 29.233 | 28.819 | 11.611 | 34.3 | 25.33 |