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 |
|---|---|---|---|---|---|---|---|
| 181 | 107 | 347 | 23.5 | 24.945 | 5.428 | 21.14 | 13.73 |
| 186 | 241 | 347 | 33.467 | 35.649 | 12.796 | 39.51 | 22.75 |
| 223 | 142 | 347 | 28 | 29.631 | 7.62 | 39.59 | 17.03 |
| 141 | 189 | 347 | 33.417 | 34.634 | 9.447 | 31.81 | 17.29 |
| 100 | 169 | 347 | 28.633 | 31.504 | 10.402 | 33.2 | 21.65 |
| 143 | 223 | 347 | 29.567 | 30.381 | 6.996 | 25.78 | 14.37 |
| 164 | 220 | 346 | 29.658 | 32.532 | 12.023 | 37.09 | 23.67 |
| 236 | 169 | 346 | 24.792 | 26.863 | 6.525 | 23.35 | 16.01 |
| 239 | 82 | 346 | 34.492 | 35.962 | 8.033 | 29.66 | 13.97 |
| 163 | 198 | 346 | 29.225 | 30.913 | 7.629 | 26.9 | 15.44 |
| 45 | 189 | 346 | 17.217 | 18.211 | 3.643 | 15.16 | 12.82 |
| 256 | 25 | 346 | 16.417 | 17.842 | 3.948 | 15.83 | 14.48 |
| 4 | 41 | 345 | 24.55 | 26.212 | 7.451 | 25.21 | 18.11 |
| 93 | 186 | 345 | 26.817 | 29.575 | 9.852 | 51.28 | 21.98 |
| 170 | 56 | 345 | 26.183 | 28.23 | 8.517 | 28.27 | 20.34 |
| 100 | 165 | 345 | 43.283 | 46.333 | 12.9 | 42.4 | 17.8 |
| 144 | 152 | 345 | 28.283 | 30.325 | 8.849 | 29.77 | 18.41 |
| 66 | 48 | 345 | 29.3 | 30.612 | 6.714 | 25.61 | 13.85 |
| 7 | 262 | 345 | 18.433 | 20.215 | 4.46 | 17.26 | 14.6 |
| 260 | 163 | 345 | 21.217 | 23.893 | 4.972 | 29.86 | 13.72 |
| 170 | 26 | 345 | 40.283 | 42.32 | 12.164 | 39.89 | 18.41 |
| 65 | 145 | 344 | 17.683 | 19.146 | 5.702 | 19.65 | 19.19 |
| 82 | 196 | 344 | 9.642 | 10.508 | 1.722 | 9.06 | 10.59 |
| 231 | 83 | 344 | 24.008 | 26.94 | 8.945 | 28.55 | 21.93 |
| 50 | 228 | 344 | 31.175 | 33.021 | 9.258 | 31 | 17.62 |