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 |
|---|---|---|---|---|---|---|---|
| 216 | 261 | 97 | 50.333 | 50.265 | 21.426 | 52.67 | 28.18 |
| 249 | 91 | 97 | 36.633 | 38.352 | 11.011 | 36.21 | 17.99 |
| 142 | 26 | 97 | 47.95 | 49.309 | 12.992 | 43.49 | 16.63 |
| 79 | 94 | 97 | 28.5 | 30.628 | 12.376 | 36.81 | 26 |
| 100 | 191 | 97 | 44.167 | 47.156 | 17.152 | 51.93 | 23.49 |
| 211 | 157 | 97 | 24.717 | 26.909 | 7.405 | 25.98 | 17.75 |
| 68 | 155 | 97 | 45.583 | 48.542 | 16.614 | 50.82 | 21.5 |
| 224 | 168 | 97 | 18.117 | 20.36 | 7.01 | 22.47 | 23.73 |
| 249 | 134 | 97 | 34.333 | 38.458 | 13.421 | 41.92 | 23.08 |
| 13 | 260 | 97 | 31.283 | 32.418 | 10.709 | 34.03 | 21.11 |
| 230 | 81 | 97 | 39.217 | 41.063 | 16.505 | 48.87 | 25.53 |
| 151 | 80 | 97 | 38.55 | 40.728 | 10.458 | 35.69 | 16.34 |
| 159 | 147 | 97 | 6.45 | 7.765 | 1.226 | 7.17 | 9.99 |
| 162 | 11 | 97 | 37.967 | 39.427 | 15.572 | 45.94 | 24.84 |
| 179 | 95 | 97 | 17.583 | 19.985 | 7.322 | 23.67 | 24.52 |
| 237 | 67 | 97 | 39.217 | 41.741 | 14.867 | 45.36 | 22.78 |
| 237 | 20 | 97 | 32.967 | 35.467 | 10.316 | 33.79 | 18.91 |
| 112 | 90 | 97 | 23.8 | 24.713 | 5.679 | 21.37 | 14.6 |
| 234 | 135 | 97 | 30.467 | 34.213 | 11.837 | 36.96 | 22.94 |
| 226 | 97 | 97 | 21.833 | 24.934 | 5.879 | 21.71 | 16.26 |
| 230 | 240 | 97 | 24.133 | 26.624 | 13.469 | 38.85 | 32.08 |
| 255 | 257 | 97 | 18.183 | 19.914 | 7.885 | 24.38 | 25.47 |
| 263 | 225 | 96 | 35.35 | 37.137 | 9.895 | 33.41 | 16.87 |
| 39 | 181 | 96 | 34.767 | 35.505 | 7.809 | 28.83 | 13.49 |
| 28 | 231 | 96 | 35.275 | 36.645 | 14.878 | 52.24 | 27.16 |