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 |
|---|---|---|---|---|---|---|---|
| 25 | 163 | 111 | 32.033 | 33.003 | 7.789 | 28.68 | 15.19 |
| 162 | 210 | 111 | 48.467 | 52.599 | 19.294 | 57.42 | 23.53 |
| 230 | 63 | 111 | 41.983 | 43.871 | 13.572 | 43.29 | 19.86 |
| 164 | 131 | 111 | 31.583 | 35.081 | 13.808 | 40.87 | 25.83 |
| 7 | 197 | 111 | 24.25 | 27.395 | 10.146 | 31.23 | 24.35 |
| 79 | 72 | 111 | 36.95 | 40.241 | 9.132 | 32.84 | 14.21 |
| 82 | 90 | 111 | 21.2 | 23.523 | 7.724 | 49.84 | 21.43 |
| 158 | 227 | 111 | 27.1 | 29.055 | 8.853 | 28.9 | 19.25 |
| 230 | 9 | 111 | 34.467 | 36.561 | 13.882 | 42.2 | 24.14 |
| 66 | 143 | 111 | 32.95 | 33.411 | 7.346 | 27.82 | 13.75 |
| 164 | 182 | 111 | 30.633 | 34.704 | 12.068 | 37.33 | 22.54 |
| 10 | 88 | 111 | 45.583 | 47.853 | 18.171 | 52.31 | 24.88 |
| 113 | 200 | 111 | 36.517 | 38.739 | 14.207 | 43.3 | 23.13 |
| 40 | 227 | 111 | 15.467 | 16.114 | 3.816 | 14.83 | 14.72 |
| 161 | 248 | 111 | 26.8 | 30.244 | 10.093 | 31.8 | 21.7 |
| 112 | 48 | 111 | 25.55 | 27.25 | 5.879 | 22.58 | 13.7 |
| 144 | 67 | 111 | 24.9 | 26.498 | 9.387 | 29.71 | 22.93 |
| 25 | 39 | 111 | 40.617 | 42.535 | 8.891 | 33.4 | 13.19 |
| 125 | 146 | 111 | 29.917 | 31.21 | 6.7 | 25.11 | 14.04 |
| 151 | 65 | 111 | 35.45 | 35.19 | 10.379 | 33.98 | 18.84 |
| 7 | 8 | 111 | 7.983 | 8.667 | 1.534 | 8.03 | 11.2 |
| 61 | 231 | 111 | 28.483 | 29.692 | 5.45 | 25.68 | 11.86 |
| 162 | 174 | 111 | 34.967 | 38.215 | 13.429 | 41.6 | 23.11 |
| 162 | 136 | 111 | 26.5 | 29.977 | 10.352 | 32.67 | 22.7 |
| 193 | 79 | 111 | 22.667 | 25.207 | 5.374 | 20.95 | 14.5 |