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 |
|---|---|---|---|---|---|---|---|
| 16 | 175 | 41 | 9.9 | 11.825 | 2.697 | 11.52 | 14.92 |
| 183 | 242 | 41 | 10.383 | 11.062 | 1.765 | 9.43 | 10.23 |
| 54 | 65 | 41 | 8.983 | 9.304 | 1.406 | 8.07 | 9.53 |
| 87 | 3 | 41 | 57.15 | 57.432 | 18.266 | 55.99 | 21.81 |
| 226 | 213 | 41 | 29 | 32.331 | 8.743 | 29.41 | 17.25 |
| 152 | 45 | 41 | 32.15 | 33.243 | 9.707 | 32.27 | 18.27 |
| 212 | 248 | 41 | 5.8 | 7.421 | 1.246 | 7.1 | 10.61 |
| 165 | 55 | 41 | 21.817 | 22.726 | 4.7 | 18.39 | 12.82 |
| 188 | 170 | 41 | 41.267 | 45.783 | 9.844 | 35.21 | 14.26 |
| 161 | 111 | 41 | 30.667 | 32.189 | 10.956 | 34.29 | 21.01 |
| 237 | 124 | 41 | 46.233 | 49.25 | 13.674 | 45.43 | 17.11 |
| 143 | 39 | 41 | 68.167 | 70.983 | 20.042 | 64.98 | 17.91 |
| 65 | 243 | 41 | 38.817 | 43.148 | 14.595 | 44.88 | 23.03 |
| 100 | 240 | 41 | 29.017 | 31.03 | 13.861 | 40.37 | 28.42 |
| 72 | 155 | 41 | 16.067 | 17.215 | 3.008 | 14 | 10.77 |
| 106 | 148 | 41 | 17.383 | 19.535 | 4.01 | 16.84 | 13.39 |
| 160 | 164 | 41 | 22.467 | 23.549 | 7.568 | 25.7 | 20.3 |
| 97 | 146 | 41 | 23.883 | 25.387 | 7.2 | 24.68 | 18.15 |
| 197 | 225 | 41 | 30.95 | 31.482 | 7.505 | 27.17 | 14.73 |
| 100 | 117 | 41 | 59.55 | 63.203 | 23.774 | 69.33 | 23.66 |
| 147 | 167 | 41 | 7.6 | 8.67 | 0.918 | 7 | 7.58 |
| 28 | 92 | 41 | 18.467 | 18.606 | 5.108 | 18.35 | 17.94 |
| 131 | 215 | 41 | 14.583 | 15.689 | 2.777 | 12.87 | 11.28 |
| 255 | 196 | 41 | 18.95 | 19.339 | 6.118 | 20.63 | 19.59 |
| 25 | 123 | 41 | 30.15 | 31.805 | 9.158 | 31 | 18.23 |