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 |
|---|---|---|---|---|---|---|---|
| 252 | 9 | 25 | 19.05 | 20.278 | 5.376 | 19.78 | 16.96 |
| 134 | 151 | 25 | 28.933 | 31.257 | 14.216 | 50.7 | 29.5 |
| 89 | 52 | 25 | 20.6 | 22.096 | 4.912 | 19.08 | 14.38 |
| 190 | 79 | 25 | 26.233 | 27.881 | 5.681 | 22.9 | 12.82 |
| 193 | 25 | 25 | 29.817 | 31.107 | 7.923 | 27.82 | 16.33 |
| 169 | 249 | 25 | 45.033 | 45.693 | 12.829 | 42.48 | 17.54 |
| 244 | 82 | 25 | 28.8 | 31.976 | 10.782 | 34.55 | 21.55 |
| 14 | 91 | 25 | 30.233 | 32.138 | 10.457 | 33.6 | 20.41 |
| 239 | 35 | 25 | 53.717 | 58.211 | 14.728 | 50.47 | 15.66 |
| 127 | 163 | 25 | 28.5 | 27.917 | 9.135 | 30.18 | 22.27 |
| 88 | 98 | 25 | 38.1 | 41.913 | 16.681 | 48.32 | 25.34 |
| 78 | 18 | 25 | 13.767 | 15.543 | 2.574 | 12.36 | 9.97 |
| 188 | 114 | 25 | 43.6 | 41.467 | 6.633 | 28.36 | 10.34 |
| 192 | 44 | 25 | 70.633 | 70.962 | 41.442 | 111.58 | 35.89 |
| 215 | 138 | 25 | 20.067 | 22.23 | 8.591 | 28.48 | 24.89 |
| 116 | 3 | 25 | 24.85 | 28.122 | 10.133 | 31.61 | 24.49 |
| 72 | 140 | 25 | 50.467 | 53.365 | 13.99 | 46.74 | 17.08 |
| 152 | 64 | 25 | 46.967 | 48.777 | 17.855 | 51.67 | 22.6 |
| 231 | 53 | 25 | 38.7 | 43.879 | 15.991 | 47.9 | 23.43 |
| 189 | 261 | 25 | 19.867 | 21.855 | 3.951 | 17.44 | 11.47 |
| 157 | 92 | 25 | 17.3 | 18.251 | 6.341 | 21.53 | 23.51 |
| 233 | 58 | 25 | 24.983 | 30.275 | 12.04 | 35.92 | 26.63 |
| 152 | 71 | 25 | 63.333 | 63.403 | 16.997 | 55.97 | 63.35 |
| 233 | 81 | 25 | 36.65 | 39.673 | 14.598 | 43.25 | 23.82 |
| 166 | 196 | 25 | 48.317 | 47.444 | 12.132 | 41.41 | 16.68 |