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 |
|---|---|---|---|---|---|---|---|
| 261 | 235 | 37 | 30.217 | 36.17 | 13.962 | 41.4 | 26.03 |
| 92 | 260 | 37 | 17.317 | 18.386 | 5.533 | 19.12 | 20.44 |
| 148 | 205 | 37 | 36.467 | 41.734 | 16.966 | 49.27 | 26.92 |
| 215 | 76 | 37 | 25.567 | 26.137 | 7.634 | 25.01 | 18 |
| 168 | 90 | 37 | 41.85 | 41.132 | 8.676 | 32.45 | 13.9 |
| 12 | 80 | 37 | 21.433 | 23.417 | 6.653 | 22.89 | 17.74 |
| 120 | 243 | 37 | 6.517 | 7.327 | 1.518 | 32.32 | 12.26 |
| 239 | 258 | 37 | 41.95 | 42.85 | 13.588 | 42.96 | 19.47 |
| 215 | 45 | 37 | 37.217 | 39.393 | 15.816 | 52.59 | 25.98 |
| 29 | 108 | 37 | 8.533 | 9.295 | 1.711 | 8.7 | 12.52 |
| 179 | 249 | 37 | 31.767 | 34.731 | 7.362 | 28.04 | 13.99 |
| 223 | 256 | 37 | 20.167 | 22.344 | 7.431 | 24.7 | 22.24 |
| 170 | 101 | 37 | 40.1 | 45.252 | 17.863 | 51.93 | 26.33 |
| 237 | 120 | 37 | 25.383 | 26.738 | 7.295 | 25.47 | 18.29 |
| 177 | 217 | 37 | 21.9 | 22.741 | 4.178 | 17.3 | 11.41 |
| 70 | 41 | 37 | 23.667 | 23.805 | 7.599 | 25.89 | 19.94 |
| 21 | 67 | 37 | 14.767 | 14.951 | 2.763 | 12.64 | 11.36 |
| 69 | 126 | 37 | 15.1 | 16.203 | 2.631 | 12.74 | 10.11 |
| 236 | 29 | 37 | 53.083 | 54.836 | 21.684 | 62.82 | 25.72 |
| 180 | 63 | 37 | 3.983 | 6.385 | 1.21 | 6.81 | 12.98 |
| 182 | 41 | 37 | 24.85 | 27.058 | 7.652 | 25.32 | 18.21 |
| 83 | 230 | 37 | 31.583 | 33.024 | 7.225 | 29.66 | 13.9 |
| 48 | 19 | 37 | 44.017 | 48.492 | 18.569 | 55.92 | 25.15 |
| 126 | 209 | 36 | 37.608 | 39.728 | 12.935 | 40.29 | 20.83 |
| 131 | 25 | 36 | 45.975 | 47.569 | 15.254 | 44.57 | 20.7 |