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 |
|---|---|---|---|---|---|---|---|
| 42 | 185 | 70 | 25.708 | 28.107 | 8.352 | 27.76 | 20.57 |
| 248 | 242 | 70 | 12.367 | 13.436 | 2.573 | 11.62 | 11.8 |
| 116 | 128 | 70 | 15.367 | 16.383 | 4.918 | 17.48 | 18.96 |
| 211 | 165 | 70 | 29.567 | 33.193 | 9.807 | 31.91 | 18.95 |
| 75 | 40 | 70 | 29.567 | 32.343 | 10.895 | 33.72 | 22.04 |
| 247 | 213 | 70 | 15.425 | 18.584 | 5.901 | 19.84 | 22.16 |
| 141 | 123 | 70 | 44.692 | 47.289 | 16.061 | 49.03 | 21.5 |
| 28 | 226 | 70 | 31.292 | 32.274 | 10.587 | 34.46 | 21.74 |
| 71 | 85 | 70 | 8.067 | 9.345 | 1.174 | 8.56 | 8.35 |
| 76 | 170 | 70 | 48.833 | 49.486 | 14.696 | 45.34 | 18.85 |
| 134 | 164 | 70 | 26.167 | 30.661 | 11.24 | 50.16 | 24.53 |
| 142 | 210 | 70 | 52.2 | 54.863 | 20.15 | 60.4 | 22.89 |
| 129 | 258 | 70 | 25.55 | 26.425 | 7.69 | 25.86 | 18.44 |
| 170 | 19 | 70 | 33.4 | 38.176 | 16.672 | 47.84 | 28.41 |
| 215 | 143 | 70 | 46.85 | 50.222 | 16.548 | 54.06 | 21.19 |
| 97 | 223 | 70 | 21.758 | 24.23 | 9.699 | 29.54 | 26.1 |
| 114 | 258 | 70 | 37.742 | 40.569 | 12.379 | 40.24 | 19.77 |
| 113 | 149 | 70 | 42.1 | 44.42 | 12.952 | 41.8 | 18.53 |
| 243 | 136 | 70 | 14 | 14.759 | 2.538 | 12.14 | 10.95 |
| 164 | 219 | 70 | 49.008 | 52.421 | 16.78 | 52.25 | 21.31 |
| 79 | 121 | 70 | 29.008 | 32.3 | 12.673 | 37.99 | 25.85 |
| 135 | 130 | 70 | 14.075 | 15.371 | 2.692 | 12.84 | 11.33 |
| 152 | 136 | 70 | 19.917 | 20.66 | 5.787 | 20.35 | 18.21 |
| 28 | 249 | 70 | 30.592 | 33.542 | 13.355 | 51.93 | 25.7 |
| 244 | 209 | 70 | 35.667 | 35.679 | 11.858 | 37.24 | 21.58 |