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 |
|---|---|---|---|---|---|---|---|
| 254 | 241 | 47 | 18.183 | 20.118 | 3.748 | 15.67 | 11.71 |
| 49 | 236 | 47 | 34.733 | 34.899 | 10.44 | 33.75 | 18.89 |
| 100 | 120 | 47 | 25.35 | 28.733 | 8.821 | 29.69 | 20.94 |
| 177 | 72 | 47 | 13.717 | 14.054 | 2.099 | 11.07 | 9.45 |
| 209 | 247 | 47 | 29.317 | 34.059 | 11.886 | 36.27 | 24.38 |
| 237 | 63 | 47 | 42.5 | 43.339 | 12.141 | 39.86 | 17.42 |
| 242 | 259 | 47 | 20.55 | 21.484 | 5.128 | 18.97 | 15.44 |
| 155 | 188 | 47 | 23.1 | 22.701 | 4.039 | 17.59 | 11.01 |
| 162 | 120 | 47 | 20.7 | 24.311 | 8.138 | 26.47 | 22.14 |
| 163 | 32 | 47 | 33.067 | 34.145 | 13.191 | 39.61 | 24.69 |
| 239 | 60 | 47 | 23.917 | 27.698 | 9.536 | 29.94 | 23.05 |
| 213 | 166 | 47 | 42.8 | 41.68 | 8.821 | 30.78 | 13.13 |
| 130 | 7 | 47 | 30.467 | 30.189 | 10.613 | 34.7 | 22.84 |
| 125 | 85 | 47 | 31.467 | 32.797 | 7.765 | 28.38 | 14.97 |
| 10 | 92 | 47 | 21.75 | 23.528 | 8.093 | 25.17 | 21.82 |
| 163 | 98 | 47 | 37.533 | 40.052 | 12.632 | 39.91 | 20.15 |
| 261 | 32 | 47 | 39.567 | 44.013 | 17.725 | 51.26 | 25.5 |
| 113 | 194 | 47 | 31.433 | 33.432 | 8.703 | 29.85 | 17.16 |
| 51 | 213 | 47 | 17.383 | 19.772 | 6.493 | 21.41 | 21.06 |
| 223 | 181 | 47 | 37.417 | 37.354 | 11.075 | 36.23 | 19.34 |
| 161 | 23 | 47 | 46.467 | 49.887 | 22.428 | 64.04 | 28.17 |
| 202 | 138 | 47 | 20.333 | 22.154 | 6.501 | 21.87 | 18.43 |
| 7 | 57 | 47 | 15.417 | 18.885 | 5.331 | 18.97 | 18.24 |
| 236 | 27 | 47 | 60.217 | 61.556 | 28.541 | 79.12 | 30.37 |
| 69 | 238 | 47 | 29.183 | 30.093 | 5.625 | 23.01 | 11.86 |