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 |
|---|---|---|---|---|---|---|---|
| 260 | 145 | 512 | 12.383 | 13.542 | 2.795 | 14.21 | 14.18 |
| 161 | 106 | 512 | 33.875 | 35.252 | 9.016 | 31.18 | 16.2 |
| 138 | 67 | 512 | 41.717 | 46.277 | 16.968 | 49.98 | 24.87 |
| 65 | 163 | 512 | 26.883 | 27.936 | 6.889 | 24.88 | 16.3 |
| 129 | 179 | 511 | 12.1 | 13.088 | 2.992 | 12.25 | 15.01 |
| 52 | 189 | 511 | 11.883 | 12.749 | 1.881 | 10.17 | 9.42 |
| 229 | 152 | 511 | 20.55 | 22.861 | 5.739 | 20.64 | 15.96 |
| 48 | 119 | 511 | 23.467 | 26.354 | 8.968 | 28.7 | 22.84 |
| 100 | 70 | 511 | 33.35 | 35.885 | 9.738 | 33.59 | 18.1 |
| 211 | 36 | 511 | 26.083 | 27.392 | 5.771 | 22.6 | 13.27 |
| 82 | 170 | 511 | 14.567 | 17.025 | 6.413 | 43.42 | 26.74 |
| 232 | 61 | 510 | 24.608 | 25.601 | 5.421 | 20.95 | 13.47 |
| 162 | 198 | 510 | 26.658 | 28.518 | 7.165 | 25.19 | 15.93 |
| 41 | 231 | 510 | 31.058 | 32.669 | 8.68 | 30.05 | 16.83 |
| 209 | 40 | 510 | 14.775 | 15.305 | 3.298 | 13.06 | 13.68 |
| 236 | 159 | 510 | 17.8 | 19.943 | 4.389 | 17.18 | 14.47 |
| 237 | 189 | 510 | 36.983 | 38.373 | 9.474 | 33.25 | 15.58 |
| 116 | 132 | 510 | 41.717 | 45.529 | 19.513 | 52.23 | 28.12 |
| 233 | 17 | 509 | 28.867 | 29.676 | 7.018 | 25.9 | 15.01 |
| 97 | 107 | 509 | 17.3 | 18.487 | 4.218 | 16.59 | 14.49 |
| 224 | 239 | 509 | 23.267 | 24.834 | 4.938 | 19.75 | 12.77 |
| 239 | 66 | 509 | 35.167 | 36.186 | 9.08 | 31.65 | 15.87 |
| 161 | 157 | 509 | 24.95 | 26.967 | 6.584 | 24.77 | 15.67 |
| 52 | 132 | 509 | 42.533 | 44.144 | 19.043 | 54.78 | 28.59 |
| 142 | 247 | 508 | 26.225 | 28.401 | 7.136 | 25.55 | 16.67 |