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 |
|---|---|---|---|---|---|---|---|
| 243 | 69 | 65 | 13.55 | 14.762 | 2.779 | 12.61 | 11.9 |
| 195 | 164 | 65 | 33.7 | 36.935 | 8.639 | 32.46 | 14.79 |
| 148 | 94 | 65 | 28.1 | 31.098 | 13.025 | 38.46 | 26.96 |
| 249 | 147 | 65 | 28.817 | 30.865 | 10.516 | 33.18 | 21.7 |
| 106 | 79 | 65 | 21.9 | 21.997 | 5.52 | 20.28 | 15.85 |
| 50 | 177 | 65 | 46.1 | 49.263 | 11.77 | 41.51 | 15.22 |
| 76 | 45 | 65 | 44.417 | 48.7 | 13.913 | 48.1 | 18.43 |
| 237 | 60 | 65 | 26.417 | 30.858 | 8.177 | 28.15 | 17.96 |
| 80 | 142 | 65 | 29.967 | 30.994 | 8.191 | 28.24 | 16.39 |
| 225 | 256 | 65 | 13.35 | 15.734 | 2.335 | 12.05 | 9.81 |
| 90 | 149 | 65 | 40.45 | 42.902 | 13.1 | 41.44 | 19.23 |
| 12 | 61 | 65 | 27.35 | 28.271 | 6.182 | 23.02 | 13.44 |
| 167 | 75 | 65 | 26.033 | 26.553 | 4.246 | 19.62 | 10.47 |
| 155 | 61 | 65 | 26.883 | 28.26 | 5.273 | 21.19 | 11.77 |
| 135 | 134 | 65 | 11.017 | 11.828 | 2.203 | 11.06 | 12.1 |
| 262 | 92 | 65 | 25 | 30.568 | 11.152 | 34.52 | 25.21 |
| 167 | 247 | 65 | 9.783 | 11.891 | 1.527 | 9.27 | 8.97 |
| 194 | 143 | 65 | 28.583 | 29.455 | 6.526 | 48.54 | 14.6 |
| 113 | 63 | 65 | 39.783 | 42.775 | 12.05 | 39.98 | 18.07 |
| 231 | 121 | 65 | 41.617 | 42.834 | 15.051 | 45.49 | 23.07 |
| 146 | 197 | 65 | 38.25 | 37.404 | 10.063 | 34.27 | 18.48 |
| 118 | 118 | 64 | 7.375 | 13.605 | 3.289 | 12.59 | 18.96 |
| 244 | 242 | 64 | 26.583 | 26.66 | 7.239 | 24.8 | 17.9 |
| 152 | 13 | 64 | 28.425 | 28.62 | 8.497 | 28.3 | 18.68 |
| 244 | 88 | 64 | 36.408 | 37.723 | 11.634 | 37.43 | 20.04 |