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 |
|---|---|---|---|---|---|---|---|
| 66 | 4 | 193 | 13.1 | 14.138 | 4.119 | 14.74 | 18.75 |
| 113 | 227 | 192 | 28.517 | 30.021 | 8.844 | 29.11 | 18.66 |
| 68 | 259 | 192 | 32.842 | 35.97 | 15.628 | 45.75 | 27.39 |
| 82 | 68 | 192 | 23.733 | 26.386 | 7.873 | 49.27 | 19.93 |
| 163 | 56 | 192 | 28.592 | 30.264 | 8.538 | 29.02 | 18.25 |
| 161 | 212 | 192 | 27.15 | 29.146 | 9.652 | 30.66 | 21.2 |
| 48 | 165 | 192 | 44.192 | 46.419 | 12.903 | 42.42 | 17.72 |
| 132 | 120 | 192 | 39.742 | 42.781 | 20.678 | 52.39 | 32.2 |
| 230 | 210 | 192 | 51.892 | 55.766 | 19.983 | 60.21 | 22.99 |
| 12 | 181 | 192 | 20.9 | 21.654 | 4.896 | 18.53 | 14.44 |
| 17 | 80 | 192 | 10.642 | 10.965 | 1.937 | 9.57 | 11.25 |
| 141 | 147 | 192 | 18.367 | 20.169 | 5.802 | 19.89 | 18.34 |
| 238 | 52 | 192 | 34.192 | 35.709 | 10.1 | 33.38 | 17.62 |
| 140 | 250 | 192 | 20 | 22.283 | 8.39 | 25.98 | 24.51 |
| 79 | 185 | 192 | 25.408 | 28.466 | 13.503 | 38.58 | 30.01 |
| 72 | 35 | 192 | 7.875 | 9.037 | 1.212 | 7.76 | 8.91 |
| 231 | 197 | 192 | 40.508 | 44.035 | 14.877 | 45.75 | 22.04 |
| 165 | 89 | 192 | 8.7 | 10.221 | 1.519 | 8.78 | 10.82 |
| 50 | 69 | 192 | 24.8 | 27.596 | 8.946 | 29.05 | 21.34 |
| 25 | 48 | 191 | 28.717 | 31.448 | 7.041 | 26.52 | 14.38 |
| 95 | 56 | 191 | 10.85 | 11.407 | 2.047 | 10.31 | 10.68 |
| 97 | 261 | 191 | 13.95 | 14.969 | 3.361 | 14.84 | 14.41 |
| 239 | 202 | 191 | 25.9 | 27.661 | 5.778 | 22.25 | 13.07 |
| 61 | 39 | 191 | 22.267 | 23.354 | 4.333 | 18.14 | 11.65 |
| 129 | 234 | 191 | 22.4 | 25.789 | 7.184 | 24.1 | 18.01 |