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 |
|---|---|---|---|---|---|---|---|
| 244 | 237 | 668 | 28.442 | 29.221 | 6.759 | 25.35 | 14.99 |
| 10 | 10 | 667 | 2.767 | 7.166 | 1.727 | 15.97 | 86.55 |
| 52 | 97 | 667 | 11.1 | 11.781 | 1.6 | 9.34 | 8.57 |
| 233 | 80 | 666 | 20.717 | 22.288 | 5.785 | 20.78 | 16.75 |
| 164 | 228 | 666 | 29.967 | 31.787 | 9.961 | 32.15 | 19.84 |
| 226 | 186 | 666 | 23.1 | 25.479 | 4.635 | 30.12 | 12.33 |
| 162 | 228 | 666 | 32.208 | 34.196 | 10.765 | 34.46 | 20.11 |
| 50 | 112 | 666 | 25.725 | 26.901 | 5.563 | 21.9 | 13.01 |
| 261 | 145 | 665 | 24.333 | 26.268 | 7.812 | 26.11 | 19.12 |
| 145 | 255 | 665 | 12.35 | 12.97 | 2.692 | 11.49 | 13.02 |
| 263 | 256 | 664 | 26.367 | 27.312 | 7.82 | 26.67 | 18.36 |
| 66 | 45 | 664 | 7 | 8.7 | 1.859 | 9.28 | 15.7 |
| 142 | 82 | 664 | 30.175 | 31.277 | 6.87 | 25.94 | 13.92 |
| 33 | 189 | 664 | 14.258 | 14.855 | 2.282 | 11.61 | 9.71 |
| 231 | 227 | 664 | 22.458 | 23.383 | 6.927 | 23.19 | 19.71 |
| 83 | 260 | 664 | 4.9 | 5.857 | 1.051 | 6.58 | 11.69 |
| 95 | 196 | 663 | 6.683 | 7.793 | 1.214 | 7.3 | 9.98 |
| 225 | 61 | 663 | 10.433 | 11.419 | 1.824 | 9.6 | 10.32 |
| 189 | 49 | 663 | 7.483 | 8.048 | 1.264 | 7.29 | 9.72 |
| 74 | 235 | 662 | 15.558 | 17.963 | 5.102 | 18.17 | 19.7 |
| 255 | 107 | 662 | 19.783 | 20.658 | 4.099 | 16.91 | 12.7 |
| 41 | 107 | 662 | 28.542 | 29.235 | 6.459 | 24.12 | 14.43 |
| 88 | 17 | 662 | 24.408 | 24.935 | 5.446 | 20.69 | 13.78 |
| 52 | 162 | 661 | 26.683 | 27.491 | 7.672 | 25.94 | 17.83 |
| 43 | 181 | 661 | 39.033 | 41.121 | 10.749 | 36.5 | 16.49 |