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 |
|---|---|---|---|---|---|---|---|
| 45 | 36 | 214 | 24.217 | 25.468 | 5.749 | 21.65 | 14.42 |
| 56 | 162 | 214 | 19.967 | 21.634 | 7.911 | 50.92 | 24.53 |
| 12 | 125 | 214 | 12.175 | 12.851 | 2.013 | 10.54 | 10.39 |
| 72 | 61 | 214 | 13.092 | 14.85 | 2.376 | 11.86 | 10.19 |
| 69 | 168 | 214 | 11.017 | 11.711 | 1.704 | 9.58 | 9.38 |
| 164 | 119 | 214 | 25.175 | 28.038 | 8.862 | 28.75 | 20.81 |
| 68 | 157 | 214 | 27.783 | 30.183 | 7.56 | 27.24 | 16.21 |
| 132 | 30 | 214 | 22.917 | 23.848 | 10.112 | 30.09 | 26.38 |
| 25 | 217 | 214 | 18.692 | 18.907 | 2.932 | 14.74 | 9.98 |
| 162 | 185 | 214 | 28.342 | 30.176 | 11.786 | 35.33 | 25.36 |
| 186 | 126 | 213 | 33.683 | 36.172 | 10.298 | 34.27 | 18.48 |
| 80 | 129 | 213 | 14.617 | 15.556 | 5.219 | 17.97 | 21.66 |
| 37 | 49 | 213 | 12.567 | 14.038 | 2.492 | 11.41 | 11.36 |
| 75 | 195 | 213 | 34.183 | 35.445 | 12.858 | 39.19 | 23.64 |
| 189 | 40 | 213 | 12.267 | 13.066 | 2.102 | 10.6 | 10.09 |
| 263 | 70 | 213 | 18.633 | 22.598 | 8.202 | 25.95 | 25.03 |
| 230 | 130 | 213 | 40.867 | 43.427 | 14.013 | 44.13 | 21.11 |
| 236 | 157 | 213 | 29.5 | 30.849 | 7.334 | 26.81 | 15.12 |
| 13 | 146 | 213 | 26.517 | 28.057 | 9.221 | 29.54 | 21.01 |
| 146 | 95 | 213 | 23.65 | 25.236 | 7.584 | 25.51 | 19.55 |
| 107 | 216 | 213 | 43.283 | 45.52 | 14.717 | 48.78 | 22.82 |
| 48 | 177 | 212 | 43.058 | 46.957 | 11.247 | 39.22 | 15.42 |
| 48 | 60 | 212 | 27.358 | 30.01 | 11.68 | 35.24 | 25.85 |
| 144 | 34 | 212 | 15.408 | 16.436 | 3.169 | 13.89 | 12.43 |
| 186 | 20 | 212 | 38.292 | 41.466 | 13.307 | 42.45 | 20.88 |