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 |
|---|---|---|---|---|---|---|---|
| 149 | 26 | 44 | 22.508 | 24.264 | 3.928 | 18.15 | 10.53 |
| 237 | 64 | 44 | 38.7 | 40.533 | 17.955 | 51.23 | 27.78 |
| 85 | 65 | 44 | 25.575 | 27.37 | 4.717 | 20.47 | 11.65 |
| 45 | 205 | 44 | 61.417 | 66.743 | 19.301 | 59.9 | 19.6 |
| 71 | 170 | 44 | 33.925 | 40.604 | 10.758 | 36.91 | 17.07 |
| 181 | 179 | 44 | 28.392 | 30.626 | 10.561 | 33.43 | 22.43 |
| 123 | 22 | 44 | 12.992 | 13.497 | 2.268 | 11.17 | 10.44 |
| 232 | 86 | 44 | 78.55 | 79.046 | 28.384 | 83.46 | 22.38 |
| 244 | 25 | 44 | 42.925 | 43.606 | 14.008 | 42.75 | 19.54 |
| 224 | 127 | 44 | 23.942 | 25.77 | 10.981 | 32.73 | 27.55 |
| 163 | 183 | 44 | 35.125 | 37.591 | 13.414 | 40.93 | 23.12 |
| 215 | 145 | 44 | 22.675 | 26.588 | 12.411 | 52.45 | 31.43 |
| 152 | 120 | 44 | 11.308 | 11.857 | 2.594 | 11.03 | 13.59 |
| 50 | 135 | 44 | 36.6 | 38.57 | 14.077 | 43.07 | 23.27 |
| 140 | 34 | 44 | 25.283 | 26.15 | 8.5 | 27.61 | 20.59 |
| 114 | 208 | 44 | 37.95 | 39.166 | 16.033 | 47 | 25.63 |
| 256 | 35 | 44 | 26.4 | 28.714 | 5.343 | 21.41 | 12.29 |
| 49 | 209 | 44 | 16.625 | 17.523 | 3.532 | 20.91 | 13.12 |
| 87 | 194 | 44 | 25.325 | 27.44 | 11.498 | 33.24 | 27.04 |
| 63 | 197 | 44 | 16.225 | 18.209 | 3.242 | 14.64 | 11.1 |
| 97 | 157 | 44 | 15.058 | 17.066 | 6.628 | 22.09 | 25.94 |
| 129 | 144 | 44 | 19.508 | 25.594 | 7.855 | 26.07 | 21.23 |
| 189 | 211 | 44 | 19.225 | 19.845 | 3.982 | 16.66 | 12.77 |
| 79 | 64 | 44 | 34.475 | 38.255 | 18.287 | 52.2 | 29.97 |
| 69 | 166 | 44 | 23.258 | 23.339 | 4.069 | 17.62 | 11.22 |