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 |
|---|---|---|---|---|---|---|---|
| 255 | 238 | 156 | 32.517 | 34.817 | 8.881 | 30.67 | 16.05 |
| 75 | 61 | 156 | 46.908 | 49.642 | 13.991 | 46.01 | 18.15 |
| 40 | 113 | 156 | 22.442 | 22.753 | 4.805 | 18.86 | 13.39 |
| 74 | 20 | 156 | 20.367 | 23.821 | 7.166 | 24.03 | 20.07 |
| 68 | 134 | 156 | 35.925 | 40.147 | 12.542 | 41 | 20.41 |
| 107 | 119 | 156 | 21.658 | 27.715 | 9.006 | 28.88 | 22.67 |
| 161 | 250 | 156 | 33.475 | 36.729 | 11.03 | 35.91 | 19.92 |
| 50 | 241 | 156 | 23.442 | 24.781 | 11.479 | 33.7 | 29.51 |
| 146 | 88 | 156 | 23.8 | 24.532 | 8.114 | 26.52 | 22.03 |
| 226 | 134 | 156 | 23.125 | 26.58 | 7.96 | 27.12 | 20.82 |
| 159 | 116 | 156 | 12.267 | 12.713 | 1.906 | 10.39 | 10.04 |
| 223 | 116 | 156 | 16.925 | 19.129 | 6.102 | 38.83 | 21.12 |
| 93 | 50 | 156 | 31.192 | 33.46 | 11.443 | 51.57 | 21.94 |
| 242 | 51 | 156 | 16.083 | 16.82 | 3.796 | 15.24 | 14.26 |
| 226 | 4 | 156 | 23.858 | 24.977 | 5.681 | 30.14 | 15.27 |
| 140 | 56 | 156 | 30.875 | 32.589 | 8.9 | 30.6 | 18.02 |
| 107 | 197 | 156 | 37.867 | 41.788 | 12.264 | 40.71 | 19.66 |
| 163 | 54 | 156 | 30.492 | 33.829 | 8.763 | 29.95 | 17.15 |
| 90 | 70 | 156 | 31.867 | 35.503 | 10.434 | 34.59 | 19.89 |
| 116 | 229 | 156 | 27.108 | 27.917 | 6.586 | 24.12 | 15.79 |
| 41 | 212 | 156 | 19.442 | 21.835 | 6.366 | 21.85 | 18.82 |
| 33 | 36 | 156 | 23.683 | 24.962 | 5.522 | 21.09 | 13.88 |
| 141 | 248 | 156 | 19.983 | 21.643 | 7.709 | 24.21 | 22.85 |
| 225 | 65 | 156 | 22.375 | 24.375 | 3.586 | 17.11 | 9.57 |
| 75 | 49 | 156 | 33.892 | 36.514 | 11.234 | 36.16 | 20.02 |