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 |
|---|---|---|---|---|---|---|---|
| 130 | 75 | 118 | 27.142 | 30.813 | 14.092 | 50.05 | 30.79 |
| 93 | 125 | 118 | 33.05 | 34.8 | 12.575 | 51.44 | 23.21 |
| 129 | 53 | 118 | 18.05 | 18.98 | 5.647 | 19.48 | 19.23 |
| 231 | 210 | 118 | 36.375 | 37.916 | 15.64 | 45.95 | 26.2 |
| 80 | 223 | 118 | 14.3 | 15.426 | 6.368 | 20.03 | 26.73 |
| 7 | 231 | 118 | 31.025 | 34.579 | 9.508 | 32.45 | 18.47 |
| 33 | 226 | 118 | 22.117 | 23.79 | 6.995 | 23.7 | 19.2 |
| 107 | 235 | 118 | 30.367 | 33.503 | 10.873 | 34.15 | 22.4 |
| 170 | 235 | 118 | 25.9 | 30.03 | 9.951 | 31.6 | 22.42 |
| 157 | 68 | 118 | 20.858 | 23.349 | 6.344 | 49.79 | 18.22 |
| 7 | 28 | 118 | 19.433 | 22.609 | 9.681 | 29.09 | 28.35 |
| 4 | 129 | 118 | 24.775 | 25.347 | 8.523 | 27.59 | 21.6 |
| 129 | 130 | 118 | 23.05 | 24.824 | 8.427 | 26.91 | 22.35 |
| 69 | 167 | 118 | 8.267 | 9.045 | 1.396 | 8.15 | 9.12 |
| 143 | 189 | 118 | 40.058 | 43.166 | 9.533 | 34.95 | 14 |
| 125 | 190 | 118 | 26.608 | 27.408 | 5.735 | 22.49 | 13.31 |
| 56 | 186 | 118 | 24.8 | 27.371 | 8.387 | 50.12 | 21.07 |
| 238 | 189 | 118 | 44.908 | 46.102 | 11.445 | 39.69 | 15.51 |
| 157 | 163 | 118 | 26.858 | 27.945 | 6.595 | 50.78 | 15.74 |
| 100 | 31 | 118 | 37.592 | 39.14 | 13.296 | 41.53 | 21.88 |
| 82 | 145 | 118 | 14.617 | 15.992 | 5.312 | 29.6 | 25.71 |
| 100 | 81 | 117 | 40.367 | 42.19 | 16.901 | 49.99 | 25.87 |
| 227 | 228 | 117 | 7.817 | 9.655 | 1.612 | 8.87 | 10.1 |
| 163 | 29 | 117 | 49.917 | 52.711 | 20.018 | 59.22 | 24.22 |
| 107 | 51 | 117 | 50.667 | 53.111 | 16.386 | 50.45 | 20.7 |