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 | 159 | 22 | 36.1 | 40.174 | 12.795 | 39.99 | 21.33 |
| 209 | 56 | 22 | 34.408 | 35.711 | 11.18 | 35.54 | 20.65 |
| 155 | 137 | 22 | 51.033 | 54.933 | 18.716 | 55.62 | 21.63 |
| 237 | 11 | 22 | 43.283 | 42.701 | 17.153 | 49.91 | 25.63 |
| 35 | 87 | 22 | 49.758 | 50.978 | 8.601 | 36.99 | 10.08 |
| 70 | 80 | 22 | 32.575 | 31.417 | 7.768 | 27.02 | 16.35 |
| 113 | 47 | 22 | 30.033 | 40.063 | 11.996 | 39.02 | 21.28 |
| 206 | 206 | 22 | 7.333 | 9.286 | 1.74 | 13.59 | 22.03 |
| 22 | 155 | 22 | 27.458 | 28.985 | 7.206 | 24.32 | 15.17 |
| 151 | 210 | 22 | 59.492 | 63.095 | 22.113 | 67.55 | 22.59 |
| 55 | 33 | 22 | 41.475 | 41.065 | 11.325 | 36.81 | 17.65 |
| 189 | 239 | 22 | 38.525 | 40.788 | 9.762 | 35.55 | 15.28 |
| 215 | 7 | 22 | 33.742 | 35.199 | 12.074 | 38.64 | 21.89 |
| 133 | 87 | 22 | 20.508 | 22.741 | 6.813 | 22.97 | 19.57 |
| 36 | 228 | 22 | 26.933 | 28.808 | 9.21 | 29.73 | 20.55 |
| 8 | 142 | 22 | 27.2 | 27.449 | 7.004 | 52 | 16.82 |
| 108 | 228 | 22 | 20.708 | 21.315 | 7.736 | 23.86 | 23.85 |
| 100 | 96 | 22 | 37.317 | 41.227 | 11.82 | 40.16 | 19 |
| 157 | 88 | 22 | 23.75 | 25.28 | 9.395 | 52 | 24.22 |
| 79 | 81 | 22 | 35.4 | 35.352 | 16.59 | 46.94 | 28.98 |
| 49 | 239 | 22 | 35.942 | 37.966 | 9.799 | 32.86 | 16.08 |
| 14 | 238 | 22 | 51.575 | 52.658 | 14.461 | 47.93 | 16.87 |
| 49 | 260 | 22 | 20.125 | 20.208 | 7.125 | 33.69 | 22.15 |
| 40 | 7 | 22 | 28.442 | 27.903 | 10.443 | 31.8 | 23.44 |
| 150 | 181 | 22 | 32.108 | 32.567 | 9.836 | 31 | 19.19 |