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 |
|---|---|---|---|---|---|---|---|
| 196 | 69 | 5 | 32.417 | 31.943 | 11.884 | 36.3 | 22.66 |
| 86 | 25 | 5 | 63.85 | 66.993 | 23.698 | 71.8 | 21.53 |
| 136 | 81 | 5 | 18.65 | 23.18 | 5.222 | 19.79 | 14.96 |
| 151 | 77 | 5 | 100.767 | 78.64 | 17.684 | 64.3 | 17.57 |
| 135 | 175 | 5 | 22.617 | 20.99 | 4.424 | 16.22 | 12.93 |
| 205 | 78 | 5 | 33.45 | 42.52 | 17.708 | 52.37 | 27.53 |
| 73 | 137 | 5 | 33.133 | 34.283 | 11.204 | 33.61 | 20.47 |
| 22 | 35 | 5 | 38.883 | 37.677 | 9.682 | 33.82 | 15.99 |
| 228 | 50 | 5 | 26.45 | 27.55 | 8.974 | 28.7 | 19.79 |
| 42 | 64 | 5 | 38.95 | 40.367 | 18.134 | 49.57 | 29.28 |
| 91 | 95 | 5 | 42.967 | 41.497 | 10.592 | 35.49 | 15.6 |
| 28 | 136 | 5 | 53.517 | 48.753 | 18.152 | 54.3 | 23.36 |
| 254 | 177 | 5 | 36.95 | 40.873 | 20.624 | 57.8 | 31.35 |
| 13 | 58 | 5 | 35.933 | 41.303 | 18.462 | 51.4 | 28.75 |
| 41 | 102 | 5 | 36.017 | 37.367 | 12.688 | 40.1 | 22.66 |
| 71 | 145 | 5 | 35.95 | 38.99 | 9.256 | 33.7 | 15.19 |
| 182 | 97 | 5 | 77.067 | 72.897 | 18.78 | 59.19 | 18.31 |
| 15 | 209 | 5 | 39.45 | 48.71 | 19.298 | 56.21 | 26.29 |
| 17 | 179 | 5 | 28.767 | 36.117 | 11.074 | 35.1 | 20.56 |
| 45 | 156 | 5 | 38.283 | 40.723 | 18.274 | 51.6 | 27.59 |
| 212 | 183 | 5 | 11.017 | 11.44 | 2.9 | 11.3 | 17.35 |
| 76 | 217 | 5 | 42.133 | 39.163 | 7.184 | 26.99 | 11.27 |
| 4 | 81 | 5 | 37.017 | 41.847 | 16.666 | 49.1 | 27.69 |
| 255 | 159 | 5 | 29.5 | 30.67 | 10.88 | 35.16 | 21.62 |
| 220 | 132 | 5 | 54.05 | 47.927 | 23.662 | 63.6 | 31.29 |