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 |
|---|---|---|---|---|---|---|---|
| 57 | 140 | 5 | 19.033 | 22.72 | 10.356 | 29.26 | 29.51 |
| 24 | 34 | 5 | 29.517 | 33.163 | 11.416 | 36.1 | 21.64 |
| 126 | 241 | 5 | 23.15 | 25.407 | 6.148 | 20.55 | 15.29 |
| 52 | 63 | 5 | 29.233 | 30.707 | 6.886 | 25.5 | 13.79 |
| 148 | 23 | 5 | 38.533 | 37.693 | 18.83 | 52.7 | 30.12 |
| 160 | 45 | 5 | 38.983 | 42.267 | 10.26 | 34.83 | 14.74 |
| 113 | 19 | 5 | 34.35 | 50.753 | 18.24 | 55.1 | 26.39 |
| 147 | 249 | 5 | 36.083 | 37.413 | 11.706 | 37.9 | 19.06 |
| 135 | 42 | 5 | 36.133 | 36.423 | 12.864 | 38.2 | 22.39 |
| 166 | 190 | 5 | 57.017 | 53.84 | 13.2 | 45.6 | 14.97 |
| 151 | 175 | 5 | 44.533 | 45.307 | 16.234 | 46.6 | 22.51 |
| 208 | 162 | 5 | 42.683 | 37.203 | 11.93 | 36.44 | 21.44 |
| 189 | 197 | 5 | 40.267 | 37.973 | 8.58 | 31.4 | 14.45 |
| 163 | 253 | 5 | 45.567 | 52.483 | 14.534 | 47.9 | 18.79 |
| 38 | 68 | 5 | 61.217 | 73.353 | 20.238 | 61.77 | 17.49 |
| 63 | 157 | 5 | 22.983 | 24.24 | 6.58 | 23.3 | 16.72 |
| 211 | 51 | 5 | 39.933 | 43.197 | 18.956 | 54.3 | 27.88 |
| 249 | 154 | 5 | 51.733 | 49.3 | 22.19 | 63.1 | 26.4 |
| 165 | 146 | 5 | 63.717 | 65.857 | 13.96 | 49.9 | 12.91 |
| 228 | 223 | 5 | 31.683 | 30.673 | 13.512 | 38.9 | 28.2 |
| 17 | 93 | 5 | 32.783 | 33.033 | 10.7 | 34.5 | 20.68 |
| 232 | 203 | 5 | 51.083 | 43.033 | 20.652 | 58 | 30.72 |
| 198 | 56 | 5 | 19.467 | 23.873 | 4.48 | 19.1 | 12.78 |
| 71 | 94 | 5 | 50.35 | 53.95 | 22.456 | 59.82 | 25.79 |
| 129 | 174 | 5 | 31.467 | 32.903 | 14.368 | 42 | 27.34 |