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 |
|---|---|---|---|---|---|---|---|
| 196 | 125 | 27 | 37.7 | 36.991 | 9.904 | 46.17 | 17.61 |
| 112 | 224 | 27 | 19.2 | 20.757 | 4.669 | 18.28 | 15.37 |
| 166 | 173 | 27 | 31.433 | 38.815 | 9.783 | 34.78 | 17.25 |
| 122 | 131 | 27 | 10.067 | 11.023 | 1.74 | 9.52 | 9.9 |
| 260 | 168 | 27 | 20.417 | 22.836 | 7.748 | 24.94 | 23.09 |
| 129 | 98 | 27 | 16.017 | 19.925 | 7.897 | 24.52 | 26.2 |
| 216 | 158 | 27 | 51.517 | 55.551 | 19.83 | 50.52 | 22.76 |
| 112 | 13 | 27 | 24.983 | 24.943 | 7.262 | 24.63 | 18.46 |
| 188 | 141 | 27 | 47.717 | 50.317 | 11.932 | 42.04 | 15.23 |
| 43 | 227 | 27 | 45.25 | 45.82 | 13.585 | 43.21 | 18.54 |
| 216 | 142 | 27 | 50.517 | 51.899 | 16.341 | 51.74 | 20.26 |
| 47 | 94 | 27 | 10.733 | 13.602 | 1.676 | 10.44 | 8.41 |
| 49 | 263 | 27 | 26.817 | 28.135 | 9.891 | 30.52 | 21.86 |
| 87 | 174 | 27 | 45.417 | 48.329 | 18.251 | 53.23 | 25.24 |
| 116 | 92 | 27 | 25.9 | 29.967 | 12.336 | 36.3 | 26.04 |
| 48 | 221 | 27 | 39.05 | 40.257 | 16.74 | 48.83 | 25.36 |
| 19 | 64 | 27 | 9.483 | 11.511 | 2.984 | 11.93 | 20.84 |
| 188 | 79 | 27 | 29.3 | 30.16 | 6.804 | 25.61 | 14.63 |
| 161 | 245 | 27 | 50.95 | 51.025 | 19.049 | 56.31 | 22.88 |
| 86 | 151 | 27 | 115.267 | 110.249 | 27.382 | 92.3 | 15.65 |
| 34 | 231 | 27 | 12.617 | 12.795 | 2.61 | 13.17 | 13.17 |
| 164 | 240 | 27 | 34.317 | 39.817 | 14.401 | 44.44 | 23.88 |
| 146 | 53 | 27 | 24.467 | 27.569 | 8.696 | 28.31 | 20.02 |
| 209 | 182 | 27 | 31.267 | 35.912 | 15.232 | 44.33 | 28.15 |
| 37 | 114 | 27 | 23.533 | 25.869 | 4.686 | 20.09 | 12.02 |