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 |
|---|---|---|---|---|---|---|---|
| 119 | 3 | 5 | 22.65 | 23.353 | 7.514 | 24.6 | 24.19 |
| 120 | 18 | 5 | 16.7 | 17.383 | 3.356 | 14.3 | 12.12 |
| 211 | 32 | 5 | 46.717 | 52.09 | 15.92 | 51.4 | 19.2 |
| 222 | 26 | 5 | 42.583 | 41.6 | 15.538 | 45.8 | 22.85 |
| 189 | 150 | 5 | 30.6 | 29.693 | 9.69 | 32.91 | 19.6 |
| 62 | 238 | 5 | 50.917 | 58.193 | 12.284 | 41.78 | 13.23 |
| 248 | 243 | 5 | 19.7 | 20.097 | 4.78 | 17.4 | 15.33 |
| 125 | 64 | 5 | 47.867 | 50.817 | 18.83 | 56.2 | 23.31 |
| 256 | 150 | 5 | 27.567 | 28.943 | 16.116 | 45.81 | 34.28 |
| 151 | 183 | 5 | 32.4 | 40 | 11.796 | 39.1 | 19.78 |
| 122 | 56 | 5 | 19.233 | 20.257 | 7.144 | 22.76 | 21.25 |
| 213 | 177 | 5 | 36.067 | 43.66 | 18.23 | 52.27 | 26.87 |
| 51 | 205 | 5 | 34.067 | 34.637 | 16.858 | 45.96 | 29.54 |
| 62 | 166 | 5 | 68.517 | 63.883 | 13.408 | 48.83 | 13.5 |
| 181 | 254 | 5 | 56.183 | 66.94 | 21.564 | 66.62 | 23.38 |
| 163 | 187 | 5 | 39.283 | 35.51 | 17.584 | 49.5 | 27.64 |
| 61 | 151 | 5 | 36.35 | 36.45 | 12.644 | 39.6 | 21.24 |
| 255 | 60 | 5 | 29.4 | 28.57 | 13.588 | 38.8 | 28.6 |
| 241 | 126 | 5 | 20.9 | 23.09 | 6.998 | 23.71 | 18.79 |
| 242 | 163 | 5 | 53.017 | 52.627 | 13.446 | 39.67 | 15.82 |
| 19 | 260 | 5 | 27.15 | 26.35 | 13.848 | 39.2 | 31.87 |
| 140 | 115 | 5 | 42.033 | 50.05 | 19.376 | 55.5 | 26.01 |
| 211 | 98 | 5 | 32.767 | 35.54 | 14.194 | 41.7 | 25.02 |
| 3 | 186 | 5 | 48.5 | 55.717 | 15.756 | 49.21 | 18.58 |
| 248 | 94 | 5 | 10.917 | 14.103 | 3.52 | 13.7 | 18.39 |