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 |
|---|---|---|---|---|---|---|---|
| 146 | 157 | 107 | 17.333 | 18.262 | 4.231 | 16.38 | 14.37 |
| 48 | 210 | 107 | 46.05 | 49.016 | 19.358 | 57.02 | 24.6 |
| 62 | 25 | 107 | 17.783 | 19.172 | 2.718 | 14.21 | 8.99 |
| 89 | 33 | 107 | 28.1 | 28.968 | 5.28 | 21.7 | 12.42 |
| 50 | 167 | 107 | 26.6 | 28.783 | 9.778 | 30.76 | 22.12 |
| 190 | 89 | 107 | 9.45 | 10.921 | 2.095 | 10.06 | 12.82 |
| 146 | 256 | 107 | 20.083 | 20.813 | 4.241 | 17.16 | 12.61 |
| 237 | 31 | 107 | 32.217 | 35.039 | 10.665 | 34.77 | 19.63 |
| 263 | 89 | 107 | 34.933 | 37.522 | 14.197 | 42.5 | 25.94 |
| 254 | 174 | 107 | 10.317 | 10.885 | 1.618 | 9.13 | 9.88 |
| 263 | 135 | 107 | 32.067 | 34.649 | 13.024 | 38.66 | 24.73 |
| 107 | 213 | 107 | 28.283 | 31.242 | 11.172 | 33.97 | 23.36 |
| 129 | 198 | 107 | 20.083 | 21.383 | 5.256 | 19.36 | 15.53 |
| 263 | 92 | 107 | 28.883 | 31.168 | 11.312 | 34.86 | 24.17 |
| 193 | 166 | 107 | 21.367 | 24.768 | 6.353 | 22.25 | 16.8 |
| 235 | 243 | 107 | 9.25 | 10.341 | 1.662 | 9.61 | 11.05 |
| 7 | 13 | 107 | 24.967 | 27.263 | 9.892 | 31.01 | 23.6 |
| 66 | 263 | 107 | 25.433 | 26.423 | 8.458 | 26.96 | 20.33 |
| 116 | 18 | 107 | 21.3 | 22.572 | 6.03 | 21.51 | 17.29 |
| 237 | 78 | 107 | 29.85 | 33.357 | 8.525 | 29.45 | 16.89 |
| 100 | 171 | 107 | 36.8 | 39.587 | 13.384 | 41.72 | 21.79 |
| 213 | 250 | 107 | 10.117 | 10.234 | 1.852 | 9.26 | 11.36 |
| 142 | 155 | 107 | 45.583 | 47.941 | 15.454 | 48.17 | 20.77 |
| 79 | 203 | 107 | 30.6 | 32.191 | 19.883 | 54.33 | 37.79 |
| 114 | 200 | 107 | 35.4 | 38.3 | 14.557 | 43.95 | 23.98 |