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 |
|---|---|---|---|---|---|---|---|
| 90 | 16 | 41 | 36.317 | 40.403 | 16.437 | 48.14 | 26.4 |
| 228 | 231 | 41 | 17.133 | 18.721 | 5.26 | 31.59 | 18.8 |
| 223 | 49 | 41 | 22.783 | 23.181 | 8.183 | 25.95 | 24.52 |
| 100 | 139 | 41 | 52.717 | 56.453 | 21.212 | 62.09 | 24.88 |
| 258 | 102 | 41 | 10.767 | 12.525 | 2.509 | 11.23 | 12.53 |
| 247 | 94 | 41 | 14.45 | 15.673 | 3.131 | 13.37 | 12.59 |
| 65 | 117 | 41 | 54.35 | 58.425 | 24.409 | 70.19 | 26.46 |
| 165 | 62 | 41 | 23 | 25.797 | 4.124 | 18.89 | 10.43 |
| 25 | 258 | 41 | 44.1 | 46.279 | 9.471 | 34.37 | 12.97 |
| 113 | 197 | 41 | 39.1 | 41.757 | 13.328 | 42.86 | 20.44 |
| 43 | 133 | 41 | 34.967 | 39.467 | 13.482 | 41.76 | 21.65 |
| 12 | 17 | 41 | 26.95 | 27.904 | 5.756 | 22.41 | 13.12 |
| 61 | 230 | 41 | 41.883 | 44.746 | 9.65 | 35.65 | 14.16 |
| 261 | 28 | 41 | 45.2 | 49.416 | 15.991 | 49.17 | 21.75 |
| 55 | 21 | 41 | 12.95 | 13.715 | 2.61 | 11.84 | 12.09 |
| 28 | 215 | 41 | 10.917 | 14.05 | 2.367 | 11.78 | 12.15 |
| 89 | 141 | 41 | 38.7 | 40.435 | 12.966 | 40.27 | 21.23 |
| 45 | 210 | 41 | 38.467 | 41.429 | 16.086 | 47.74 | 24.9 |
| 130 | 243 | 41 | 32.95 | 36.95 | 16.67 | 52.29 | 30.53 |
| 108 | 22 | 41 | 9.433 | 9.759 | 1.867 | 9.09 | 12.93 |
| 107 | 192 | 41 | 24.65 | 29.073 | 10.77 | 33 | 24.27 |
| 18 | 235 | 41 | 11.683 | 14.148 | 1.871 | 11.25 | 9.23 |
| 246 | 252 | 41 | 36.733 | 39.037 | 15.564 | 46.51 | 25.87 |
| 239 | 22 | 41 | 42.55 | 45.637 | 15.673 | 47.89 | 21.68 |
| 130 | 114 | 41 | 39.533 | 41.046 | 14.21 | 51.26 | 22.64 |