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 |
|---|---|---|---|---|---|---|---|
| 257 | 90 | 45 | 24.117 | 25.744 | 8.788 | 26.54 | 21.19 |
| 238 | 135 | 45 | 36.333 | 39.148 | 14.63 | 44.45 | 23.95 |
| 133 | 162 | 45 | 32.05 | 32.437 | 11.527 | 35.26 | 22.55 |
| 148 | 78 | 45 | 27.85 | 30.335 | 12.951 | 37.95 | 27.2 |
| 164 | 117 | 45 | 79.133 | 79.135 | 24.365 | 75.3 | 20.19 |
| 93 | 127 | 45 | 23.667 | 27.722 | 13.497 | 51.41 | 32.27 |
| 226 | 219 | 45 | 31.233 | 36.367 | 14.379 | 43.64 | 26.67 |
| 14 | 61 | 45 | 39.35 | 39.337 | 9.318 | 33.4 | 14.9 |
| 188 | 205 | 45 | 45.5 | 46.886 | 12.345 | 41.39 | 16.23 |
| 50 | 34 | 45 | 30.217 | 31.051 | 7.532 | 27.14 | 15.23 |
| 237 | 219 | 45 | 42.767 | 44.96 | 17.202 | 51.39 | 24.88 |
| 49 | 261 | 45 | 18.983 | 19.824 | 4.174 | 24.29 | 13.22 |
| 13 | 168 | 45 | 29.85 | 33.412 | 11.628 | 35.62 | 23.22 |
| 151 | 185 | 45 | 27.25 | 29.42 | 11.063 | 33.77 | 26.02 |
| 131 | 191 | 45 | 10.2 | 10.486 | 2.336 | 10.22 | 14.58 |
| 249 | 39 | 45 | 45.667 | 48.724 | 13.167 | 43.53 | 16.56 |
| 148 | 108 | 45 | 32.733 | 34.004 | 14.76 | 42.87 | 27.53 |
| 41 | 81 | 45 | 27.5 | 30.91 | 11.787 | 35.61 | 24.76 |
| 152 | 213 | 45 | 24 | 26.483 | 8.087 | 26.19 | 20 |
| 250 | 212 | 45 | 8.367 | 9.124 | 1.577 | 8.42 | 12.03 |
| 112 | 158 | 45 | 26 | 29.946 | 5.963 | 23.99 | 13.01 |
| 246 | 91 | 45 | 45.017 | 48.034 | 13.495 | 44.54 | 18.05 |
| 165 | 35 | 45 | 23.55 | 26.516 | 4.671 | 20.05 | 10.9 |
| 225 | 146 | 45 | 34.683 | 34.486 | 6.16 | 25.39 | 10.97 |
| 175 | 16 | 45 | 10.5 | 11.536 | 2.632 | 11.4 | 13.25 |