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 |
|---|---|---|---|---|---|---|---|
| 50 | 76 | 48 | 61.367 | 61.997 | 17.575 | 58.17 | 18.18 |
| 191 | 130 | 48 | 14.95 | 15.547 | 3.748 | 14.48 | 14.93 |
| 159 | 166 | 48 | 18.883 | 19.882 | 3.297 | 15.03 | 10.4 |
| 146 | 181 | 48 | 33.05 | 34.839 | 9.417 | 31.8 | 17.14 |
| 231 | 98 | 48 | 36.333 | 41.051 | 15.58 | 46.1 | 24.88 |
| 37 | 63 | 48 | 20.517 | 20.366 | 3.642 | 15.56 | 11.22 |
| 73 | 92 | 48 | 8.733 | 9.5 | 1.278 | 7.97 | 8.52 |
| 243 | 162 | 48 | 33.742 | 34.681 | 9.056 | 31.55 | 17.33 |
| 28 | 42 | 48 | 23.825 | 25.96 | 12.915 | 51.44 | 32.34 |
| 246 | 248 | 48 | 27.242 | 30.73 | 12.438 | 38.61 | 27 |
| 101 | 19 | 48 | 8.442 | 9.813 | 2.002 | 10.31 | 13.79 |
| 169 | 78 | 48 | 9.1 | 9.732 | 1.432 | 8.2 | 9.32 |
| 35 | 181 | 48 | 27.458 | 28.026 | 4.813 | 20.67 | 10.56 |
| 137 | 150 | 48 | 38.475 | 43.101 | 19.335 | 54.43 | 29.1 |
| 28 | 121 | 48 | 7.167 | 8.585 | 2 | 8.94 | 14.49 |
| 74 | 89 | 48 | 47.708 | 47.509 | 16.356 | 50.13 | 22.34 |
| 146 | 152 | 48 | 23.542 | 25.286 | 7.283 | 24.4 | 18.13 |
| 261 | 147 | 48 | 43.575 | 46.919 | 12.649 | 41.82 | 18.53 |
| 243 | 263 | 48 | 21.367 | 22.225 | 6.34 | 21.82 | 18.19 |
| 87 | 258 | 48 | 40.342 | 42.13 | 13.791 | 43.16 | 20.84 |
| 226 | 10 | 48 | 35.25 | 37.684 | 11.956 | 39.79 | 22.27 |
| 170 | 172 | 48 | 43.775 | 45.681 | 19.777 | 56.46 | 27.15 |
| 161 | 191 | 48 | 42.867 | 49.3 | 16.434 | 49.94 | 22.42 |
| 151 | 55 | 48 | 60.483 | 62.437 | 21.546 | 63.75 | 21.53 |
| 163 | 124 | 48 | 50.192 | 54.104 | 15.264 | 50.09 | 18.25 |