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 |
|---|---|---|---|---|---|---|---|
| 107 | 55 | 101 | 41.933 | 42.964 | 17.22 | 50.53 | 25.19 |
| 262 | 126 | 101 | 18.65 | 20.751 | 5.466 | 19.34 | 17.3 |
| 258 | 197 | 101 | 11.333 | 11.727 | 2.021 | 10.06 | 11.06 |
| 196 | 48 | 101 | 30.367 | 31.448 | 8.484 | 50.83 | 18.05 |
| 170 | 241 | 101 | 32.2 | 35.784 | 12.474 | 38.29 | 22.95 |
| 42 | 7 | 101 | 19.783 | 20.764 | 5.688 | 20.17 | 17.58 |
| 90 | 210 | 101 | 50.417 | 51.19 | 18.274 | 54.9 | 22.6 |
| 83 | 95 | 101 | 12.7 | 13.672 | 3.119 | 12.77 | 14.21 |
| 170 | 63 | 101 | 41.467 | 43.301 | 11.846 | 38.77 | 17.79 |
| 151 | 136 | 101 | 24.783 | 25.505 | 7.672 | 25.63 | 19.49 |
| 42 | 87 | 101 | 31.733 | 34.887 | 10.808 | 34.62 | 20.81 |
| 229 | 22 | 101 | 36.967 | 39.025 | 14.603 | 43.75 | 23.91 |
| 42 | 249 | 101 | 30.067 | 32.479 | 8.421 | 29.47 | 16.85 |
| 194 | 42 | 101 | 11.25 | 13.654 | 3.367 | 40.47 | 16.8 |
| 151 | 256 | 101 | 37 | 37.82 | 9.872 | 34.21 | 16.38 |
| 42 | 158 | 101 | 27.1 | 28.734 | 8.396 | 28.36 | 18.24 |
| 217 | 61 | 101 | 14.167 | 16.238 | 3.041 | 13.22 | 12.11 |
| 163 | 235 | 101 | 26.133 | 29.15 | 9.202 | 29.98 | 20.88 |
| 213 | 41 | 101 | 26.833 | 29.281 | 6.384 | 23.25 | 14.27 |
| 136 | 127 | 100 | 6.733 | 7.848 | 1.088 | 7.53 | 9.84 |
| 82 | 80 | 100 | 15.9 | 16.811 | 5.127 | 19.2 | 20.84 |
| 255 | 260 | 100 | 16.217 | 17.506 | 4.857 | 17.57 | 17.6 |
| 51 | 87 | 100 | 51.633 | 55.83 | 18.825 | 57.67 | 21.91 |
| 223 | 112 | 100 | 17.425 | 19.108 | 5.578 | 19.23 | 19.22 |
| 75 | 130 | 100 | 32.9 | 37.841 | 14.304 | 42.83 | 24.79 |