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 |
|---|---|---|---|---|---|---|---|
| 232 | 89 | 194 | 26.867 | 28.932 | 8.082 | 27.41 | 17.82 |
| 263 | 185 | 194 | 25.408 | 27.111 | 9.823 | 30.47 | 23.42 |
| 230 | 39 | 194 | 57.333 | 61.259 | 17.129 | 55.26 | 17.81 |
| 223 | 164 | 194 | 32.775 | 33.361 | 7.803 | 30.14 | 15.88 |
| 140 | 126 | 194 | 19.975 | 21.885 | 6.263 | 21.43 | 18.45 |
| 90 | 157 | 194 | 26.142 | 29.292 | 7.852 | 26.99 | 17.33 |
| 148 | 136 | 194 | 24.583 | 26.873 | 12.963 | 37.3 | 30.41 |
| 152 | 100 | 194 | 21.75 | 23.363 | 5.976 | 22.18 | 16.93 |
| 231 | 21 | 194 | 31.667 | 33.544 | 10.542 | 33.61 | 20.07 |
| 209 | 217 | 194 | 19.933 | 21.205 | 3.96 | 17.02 | 11.69 |
| 100 | 55 | 194 | 47.008 | 48.981 | 18.543 | 55.14 | 23.84 |
| 159 | 41 | 194 | 15.683 | 16.408 | 2.552 | 12.77 | 9.88 |
| 163 | 134 | 194 | 38.15 | 42.212 | 12.377 | 41.09 | 19.1 |
| 145 | 36 | 194 | 23.108 | 23.765 | 5.222 | 19.62 | 13.71 |
| 230 | 252 | 194 | 35.425 | 37.95 | 14.577 | 43.95 | 24.29 |
| 70 | 161 | 193 | 21.683 | 25.918 | 7.464 | 25.38 | 18.4 |
| 233 | 92 | 193 | 26.883 | 29.235 | 11.146 | 33.89 | 25.1 |
| 145 | 114 | 193 | 20.3 | 22.122 | 4.679 | 37.6 | 13.46 |
| 68 | 22 | 193 | 35.783 | 37.595 | 12.789 | 39.64 | 23.35 |
| 137 | 72 | 193 | 47.55 | 50.741 | 11.305 | 40.48 | 14.23 |
| 12 | 236 | 193 | 27.5 | 29.48 | 8.198 | 27.83 | 18.23 |
| 87 | 51 | 193 | 55.083 | 57.53 | 19.19 | 57.19 | 22.37 |
| 112 | 170 | 193 | 17.75 | 18.963 | 4.251 | 16.79 | 14.62 |
| 196 | 161 | 193 | 23.833 | 26.16 | 7.706 | 39.16 | 19.63 |
| 125 | 195 | 193 | 19.167 | 20.855 | 5.146 | 18.67 | 15.83 |