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 |
|---|---|---|---|---|---|---|---|
| 113 | 31 | 20 | 36.383 | 42.162 | 14.556 | 45.02 | 22.97 |
| 256 | 67 | 20 | 24.8 | 26.751 | 10.08 | 31.29 | 26 |
| 81 | 18 | 20 | 20.925 | 20.693 | 4.349 | 17.07 | 14.17 |
| 195 | 45 | 20 | 16.475 | 20.067 | 4.386 | 18.88 | 14.65 |
| 3 | 74 | 20 | 27.95 | 30.676 | 9.394 | 31.29 | 20.14 |
| 53 | 225 | 20 | 37.208 | 39.582 | 12.895 | 40.33 | 20.26 |
| 191 | 234 | 20 | 45.517 | 46.588 | 18.858 | 54.76 | 25.09 |
| 227 | 45 | 20 | 31.042 | 34.867 | 6.789 | 23.12 | 12.77 |
| 39 | 124 | 20 | 14.808 | 19.132 | 6.256 | 22.42 | 21.9 |
| 75 | 9 | 20 | 35.908 | 38.762 | 13.639 | 41.3 | 22.85 |
| 69 | 151 | 20 | 25.858 | 25.307 | 4.807 | 19.24 | 11.96 |
| 220 | 100 | 20 | 41.575 | 41.07 | 11.431 | 39.6 | 17.57 |
| 61 | 11 | 20 | 33.775 | 36.43 | 9.14 | 31.29 | 15.72 |
| 26 | 234 | 20 | 39.108 | 42.39 | 9.989 | 33.26 | 14.93 |
| 93 | 185 | 20 | 24.833 | 25.52 | 11.671 | 34.27 | 28.39 |
| 216 | 233 | 20 | 39.492 | 40.218 | 13.444 | 49.38 | 21.77 |
| 189 | 88 | 20 | 20.458 | 20.179 | 4.046 | 17 | 12.86 |
| 87 | 180 | 20 | 42.042 | 48.033 | 17.752 | 52.7 | 23.99 |
| 74 | 196 | 20 | 26.583 | 28.242 | 10.577 | 32.4 | 25.27 |
| 65 | 173 | 20 | 25.9 | 27.21 | 10.303 | 31.38 | 24.68 |
| 76 | 151 | 20 | 46.208 | 51.828 | 19.937 | 59.27 | 24.11 |
| 80 | 152 | 20 | 42.758 | 44.015 | 12.087 | 40.01 | 17.52 |
| 113 | 98 | 20 | 43.575 | 45.288 | 13.5 | 43.15 | 19.41 |
| 158 | 171 | 20 | 43.575 | 43.735 | 16.023 | 48.49 | 22.7 |
| 36 | 133 | 20 | 32.2 | 33.733 | 9.589 | 31.08 | 18.94 |