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 |
|---|---|---|---|---|---|---|---|
| 14 | 188 | 39 | 31.667 | 31.638 | 8.063 | 28.47 | 16.4 |
| 127 | 119 | 39 | 15.633 | 18.303 | 3.401 | 15.09 | 12.24 |
| 133 | 97 | 39 | 20.65 | 22.028 | 4.404 | 17.95 | 12.65 |
| 229 | 78 | 39 | 28.133 | 29.908 | 9.94 | 31.22 | 21.55 |
| 134 | 140 | 39 | 30.167 | 34.827 | 13.585 | 48.98 | 28.45 |
| 143 | 26 | 39 | 50.583 | 51.354 | 12.961 | 43.38 | 15.78 |
| 97 | 260 | 39 | 19.283 | 21.611 | 7.389 | 23.76 | 23.37 |
| 125 | 200 | 39 | 32.233 | 34.502 | 14.079 | 42.1 | 25.31 |
| 89 | 106 | 39 | 14.6 | 16.022 | 3.493 | 14.53 | 14.21 |
| 87 | 136 | 39 | 30.767 | 35.355 | 14.561 | 42.65 | 28.31 |
| 213 | 152 | 39 | 34.317 | 36.469 | 7.152 | 26.47 | 12.58 |
| 263 | 81 | 39 | 29.367 | 31.756 | 12.547 | 37.49 | 26 |
| 158 | 72 | 39 | 40.267 | 42.818 | 9.539 | 34.55 | 13.98 |
| 212 | 74 | 39 | 17.933 | 20.224 | 5.443 | 19.42 | 18.29 |
| 79 | 98 | 39 | 30.533 | 34.376 | 13.328 | 39.12 | 25.64 |
| 48 | 118 | 39 | 47.717 | 51.067 | 21.159 | 63.2 | 25.66 |
| 14 | 149 | 39 | 24.533 | 27.035 | 7.467 | 24.86 | 17.85 |
| 49 | 141 | 39 | 27.1 | 30.732 | 8.827 | 29.33 | 18.45 |
| 92 | 135 | 39 | 14.367 | 14.835 | 3.335 | 13.83 | 14.53 |
| 241 | 200 | 39 | 15.917 | 15.637 | 3.416 | 14.14 | 14.43 |
| 88 | 214 | 39 | 28.133 | 32.503 | 13.828 | 40.95 | 27.23 |
| 22 | 149 | 39 | 19.25 | 19.497 | 2.954 | 14.59 | 9.48 |
| 215 | 131 | 39 | 14.367 | 15.174 | 2.528 | 12.26 | 10.65 |
| 134 | 236 | 39 | 29.783 | 33.371 | 13.491 | 50.47 | 26.83 |
| 18 | 247 | 39 | 17.083 | 19.497 | 3.713 | 15.92 | 12.46 |