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 |
|---|---|---|---|---|---|---|---|
| 157 | 224 | 17 | 16.767 | 17.586 | 6.061 | 52 | 22.67 |
| 63 | 165 | 17 | 29.083 | 32.912 | 9.372 | 30.78 | 17.44 |
| 26 | 71 | 17 | 28.917 | 28.537 | 3.698 | 19.41 | 8.36 |
| 71 | 100 | 17 | 46.967 | 52.681 | 12.596 | 43.05 | 15.38 |
| 36 | 74 | 17 | 32.25 | 32.245 | 10.881 | 33.91 | 21.46 |
| 195 | 4 | 17 | 17.3 | 18.603 | 5.752 | 19.09 | 19.69 |
| 216 | 55 | 17 | 34.583 | 36.59 | 14.922 | 43.01 | 26.88 |
| 107 | 214 | 17 | 35.633 | 34.874 | 16.055 | 45.91 | 27.56 |
| 154 | 261 | 17 | 28.317 | 34.534 | 16.289 | 52 | 33.29 |
| 69 | 87 | 17 | 39 | 43.505 | 13.29 | 42.34 | 20.29 |
| 36 | 42 | 17 | 30.217 | 36.033 | 12.329 | 38.91 | 22.6 |
| 191 | 89 | 17 | 52.15 | 52.222 | 18.785 | 55.61 | 22.36 |
| 38 | 170 | 17 | 46.967 | 49.165 | 18.838 | 54.29 | 24.52 |
| 161 | 253 | 17 | 37.8 | 40.196 | 12.525 | 39.09 | 19.6 |
| 148 | 81 | 17 | 41.383 | 42.914 | 18.313 | 52.2 | 27.41 |
| 213 | 33 | 17 | 37.333 | 37.744 | 15.596 | 42.75 | 26.19 |
| 135 | 19 | 17 | 27.983 | 27.129 | 7.885 | 26.83 | 18.88 |
| 56 | 138 | 17 | 12.717 | 14.86 | 4.862 | 16.34 | 20.67 |
| 36 | 77 | 17 | 19.617 | 21.564 | 3.749 | 16.68 | 11.72 |
| 50 | 178 | 17 | 36.4 | 42.844 | 12.769 | 42.12 | 19.5 |
| 77 | 69 | 17 | 53.75 | 53.98 | 20.482 | 60.21 | 25.25 |
| 139 | 13 | 17 | 43 | 44.273 | 24.438 | 63.04 | 33.51 |
| 200 | 247 | 17 | 27.383 | 28.86 | 7.361 | 26.07 | 18.25 |
| 37 | 127 | 17 | 47.25 | 46.085 | 19.414 | 53.71 | 25.83 |
| 205 | 248 | 17 | 39.6 | 37.996 | 15.263 | 44.25 | 24.41 |