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 |
|---|---|---|---|---|---|---|---|
| 231 | 60 | 30 | 45.067 | 47.173 | 14.372 | 45.67 | 21.46 |
| 153 | 157 | 30 | 30.742 | 32.774 | 15.694 | 42.56 | 30.1 |
| 158 | 76 | 30 | 44.275 | 46.789 | 12.62 | 42.08 | 16.7 |
| 36 | 102 | 30 | 13.158 | 13.423 | 2.609 | 11.38 | 11.73 |
| 138 | 154 | 30 | 48.392 | 50.115 | 21.218 | 60.8 | 27.98 |
| 71 | 17 | 30 | 21.925 | 22.525 | 3.947 | 16.88 | 11.03 |
| 211 | 35 | 30 | 37.158 | 39.229 | 7.751 | 30.22 | 12.86 |
| 193 | 244 | 30 | 25.525 | 27.765 | 9.43 | 30.52 | 22.61 |
| 49 | 13 | 30 | 22.125 | 22.357 | 4.865 | 26.23 | 13.75 |
| 13 | 135 | 30 | 35.708 | 37.95 | 15.793 | 45.97 | 26.76 |
| 191 | 197 | 30 | 26.95 | 26.732 | 8.156 | 27.31 | 19.27 |
| 263 | 39 | 30 | 50.542 | 55.786 | 20.298 | 61.02 | 23.45 |
| 54 | 87 | 30 | 12.85 | 13.929 | 3.145 | 14.05 | 14.37 |
| 133 | 231 | 30 | 20.833 | 22.695 | 6.847 | 22.74 | 18.78 |
| 193 | 49 | 30 | 24.35 | 24.703 | 6.289 | 22.03 | 15.9 |
| 158 | 56 | 30 | 31.75 | 33.468 | 11.112 | 35.3 | 20.77 |
| 125 | 92 | 30 | 40.617 | 43.602 | 14.326 | 44.95 | 20.69 |
| 89 | 113 | 30 | 36.017 | 35.893 | 8.98 | 30.83 | 15.57 |
| 215 | 93 | 30 | 32.258 | 33.233 | 10.194 | 36.79 | 22.25 |
| 157 | 43 | 30 | 25.825 | 29.501 | 6.465 | 48.92 | 14.74 |
| 83 | 75 | 30 | 27.683 | 28.853 | 7.476 | 25.93 | 17.26 |
| 171 | 15 | 30 | 11.85 | 13.167 | 2.778 | 12.17 | 12.99 |
| 127 | 186 | 30 | 27.125 | 30.563 | 10.35 | 33.28 | 21.75 |
| 155 | 222 | 30 | 19.358 | 20.479 | 4.876 | 18.03 | 14.9 |
| 32 | 75 | 30 | 43.583 | 43.738 | 9.921 | 36.25 | 14.63 |