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 | 223 | 351 | 31 | 32.497 | 11.798 | 36.19 | 23.43 |
| 33 | 225 | 351 | 22.567 | 23.647 | 4.101 | 17.88 | 10.93 |
| 74 | 129 | 351 | 17.367 | 19.077 | 6.385 | 21.2 | 22.26 |
| 52 | 49 | 350 | 13.642 | 14.733 | 2.314 | 11.69 | 9.92 |
| 229 | 157 | 350 | 19.417 | 20.719 | 5.558 | 19.75 | 17.35 |
| 140 | 37 | 350 | 34.692 | 35.433 | 8.468 | 30.47 | 15.23 |
| 263 | 126 | 350 | 18.858 | 19.921 | 5.419 | 19.13 | 17.46 |
| 100 | 182 | 350 | 32.342 | 35.519 | 12.508 | 38.57 | 23.26 |
| 74 | 226 | 350 | 21.15 | 22.638 | 6.276 | 21.76 | 18.49 |
| 224 | 74 | 350 | 17.833 | 19.678 | 5.789 | 19.54 | 19.43 |
| 194 | 194 | 350 | 2.758 | 7.538 | 2.329 | 14.37 | 54.13 |
| 45 | 74 | 350 | 25.925 | 28.382 | 8.51 | 27.99 | 20.3 |
| 234 | 247 | 350 | 26.508 | 30.154 | 9.198 | 30.02 | 20.54 |
| 25 | 234 | 349 | 22.35 | 23.236 | 4.996 | 19.65 | 13.56 |
| 80 | 226 | 349 | 11.65 | 12.156 | 2.966 | 12.31 | 15.86 |
| 7 | 79 | 349 | 22.05 | 23.665 | 6.092 | 21.45 | 16.65 |
| 41 | 113 | 349 | 29.95 | 30.661 | 6.707 | 25.14 | 14.22 |
| 170 | 134 | 349 | 28.217 | 32.043 | 11.385 | 37.33 | 23.5 |
| 66 | 246 | 349 | 23.083 | 24.482 | 5.174 | 20.67 | 13.33 |
| 164 | 173 | 349 | 33.3 | 33.92 | 8.877 | 30.8 | 16.81 |
| 13 | 54 | 348 | 13.383 | 15.216 | 4.062 | 15.14 | 17.53 |
| 163 | 195 | 348 | 38.667 | 40.48 | 10.128 | 35.33 | 15.76 |
| 40 | 138 | 348 | 27.342 | 29.632 | 12.173 | 35.94 | 26.9 |
| 7 | 100 | 348 | 23.183 | 26.06 | 4.908 | 20.33 | 12.69 |
| 66 | 17 | 347 | 15.05 | 15.586 | 3.024 | 13.19 | 12.24 |