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 |
|---|---|---|---|---|---|---|---|
| 166 | 165 | 9 | 47.75 | 50.161 | 16.178 | 50.22 | 19.74 |
| 62 | 79 | 9 | 38.65 | 35.457 | 6.853 | 27.27 | 12.47 |
| 106 | 260 | 9 | 28.167 | 27.25 | 10.359 | 31.22 | 23.53 |
| 230 | 207 | 9 | 36.683 | 38.585 | 9.378 | 34.11 | 15.24 |
| 18 | 62 | 9 | 53.933 | 55.117 | 20.216 | 61.24 | 22.22 |
| 14 | 173 | 9 | 48.15 | 51.756 | 20.699 | 59.89 | 24.45 |
| 88 | 176 | 9 | 34.65 | 43.576 | 17.393 | 51.06 | 27.2 |
| 154 | 216 | 9 | 9.35 | 10.576 | 7.589 | 21.44 | 45.63 |
| 229 | 214 | 9 | 40 | 46.159 | 17.988 | 52.83 | 26.34 |
| 113 | 101 | 9 | 46.8 | 53.881 | 19.038 | 57.11 | 22.86 |
| 39 | 258 | 9 | 28.883 | 32.472 | 7.734 | 29.1 | 14.95 |
| 92 | 107 | 9 | 27.783 | 29.443 | 11.042 | 33.41 | 24.47 |
| 163 | 30 | 9 | 52.533 | 52.9 | 17.206 | 54.44 | 19.58 |
| 63 | 234 | 9 | 46.267 | 46.843 | 14.124 | 45.22 | 20.11 |
| 211 | 9 | 9 | 31.683 | 36.744 | 14.208 | 42.61 | 25.35 |
| 202 | 113 | 9 | 36.9 | 35.585 | 5.622 | 24.83 | 9.4 |
| 88 | 128 | 9 | 34 | 35.478 | 14.381 | 42.22 | 25.74 |
| 213 | 43 | 9 | 33.967 | 35.389 | 8.371 | 28.71 | 14.72 |
| 7 | 195 | 9 | 31 | 30.007 | 10.17 | 31.72 | 22.29 |
| 244 | 227 | 9 | 50.083 | 50.654 | 17.73 | 53.89 | 21.88 |
| 129 | 203 | 9 | 30.083 | 33.952 | 15.051 | 43.53 | 30.97 |
| 166 | 59 | 9 | 24.417 | 26.789 | 6.347 | 23.17 | 16.65 |
| 224 | 134 | 9 | 30.883 | 37.619 | 11.182 | 38.67 | 19.98 |
| 134 | 122 | 9 | 16.433 | 16.394 | 4.158 | 15.39 | 17 |
| 19 | 203 | 9 | 19.75 | 18.383 | 6.544 | 21.89 | 23.09 |