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 |
|---|---|---|---|---|---|---|---|
| 75 | 125 | 267 | 27.9 | 27.761 | 7.044 | 24.96 | 16.75 |
| 45 | 52 | 267 | 13.95 | 14.853 | 2.966 | 12.53 | 12.75 |
| 230 | 102 | 267 | 32.217 | 34.994 | 9.643 | 32.5 | 17.81 |
| 237 | 197 | 267 | 47.883 | 49.104 | 13.495 | 44.06 | 17.9 |
| 236 | 136 | 267 | 28.467 | 29.509 | 8.103 | 27.71 | 17.77 |
| 137 | 220 | 267 | 31.383 | 35.439 | 12.331 | 37.75 | 23.19 |
| 107 | 160 | 266 | 22.467 | 25.724 | 7.632 | 25.82 | 19.64 |
| 256 | 161 | 266 | 27.775 | 30.098 | 5.927 | 23.94 | 12.79 |
| 66 | 125 | 266 | 15.592 | 16.128 | 2.807 | 13.39 | 11.1 |
| 13 | 223 | 266 | 34.375 | 35.616 | 12.615 | 38.6 | 22.77 |
| 162 | 62 | 266 | 36.225 | 38.572 | 9.456 | 33.12 | 15.6 |
| 163 | 188 | 266 | 42.742 | 44.647 | 10.948 | 37.9 | 16.11 |
| 48 | 32 | 266 | 30.475 | 32.859 | 14.095 | 41.13 | 27.54 |
| 4 | 66 | 266 | 16.575 | 17.565 | 4.091 | 15.83 | 15.48 |
| 48 | 26 | 266 | 37.633 | 40.054 | 11.866 | 38.5 | 18.9 |
| 50 | 52 | 266 | 30.642 | 31.682 | 7.621 | 27.11 | 15.19 |
| 159 | 69 | 266 | 8.058 | 8.531 | 1.237 | 7.84 | 9.41 |
| 260 | 56 | 266 | 14.95 | 16.364 | 3.631 | 14.62 | 14.47 |
| 50 | 189 | 266 | 36.633 | 38.467 | 8.412 | 31.24 | 13.64 |
| 177 | 61 | 265 | 11.183 | 12.141 | 2.018 | 10.17 | 10.45 |
| 141 | 228 | 265 | 29.4 | 31.607 | 11.942 | 36.32 | 24.07 |
| 83 | 7 | 265 | 11.367 | 11.998 | 2.569 | 11.14 | 13.68 |
| 52 | 209 | 265 | 13.283 | 14.676 | 3.071 | 12.98 | 13.61 |
| 87 | 67 | 264 | 25.117 | 26.765 | 8.767 | 27.86 | 20.92 |
| 116 | 249 | 264 | 25.383 | 26.486 | 7.835 | 26.38 | 19.08 |