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 |
|---|---|---|---|---|---|---|---|
| 230 | 23 | 52 | 47.333 | 49.011 | 21.724 | 64 | 27.31 |
| 100 | 15 | 52 | 39.758 | 42.658 | 16.554 | 49.61 | 24.59 |
| 181 | 111 | 52 | 7.625 | 8.424 | 1.76 | 8.4 | 13.06 |
| 168 | 246 | 52 | 28.467 | 29.914 | 8.243 | 28.81 | 17.31 |
| 35 | 226 | 52 | 28.183 | 37.208 | 12.877 | 39.41 | 23.95 |
| 263 | 128 | 52 | 20.208 | 23.557 | 7.639 | 25.24 | 21.06 |
| 148 | 252 | 52 | 29.175 | 31.977 | 15.244 | 44.4 | 30.84 |
| 49 | 85 | 52 | 16.867 | 18.95 | 3.404 | 14.84 | 11.67 |
| 165 | 72 | 52 | 20.733 | 21.467 | 3.831 | 16.72 | 11.13 |
| 93 | 134 | 51 | 6.367 | 10.321 | 3.575 | 19.4 | 26.16 |
| 246 | 55 | 51 | 41.817 | 43.497 | 16.851 | 49.97 | 24.75 |
| 231 | 201 | 51 | 45.1 | 49.482 | 22.501 | 63.09 | 29.23 |
| 219 | 254 | 51 | 48.683 | 48.747 | 21.858 | 61.28 | 28 |
| 24 | 260 | 51 | 26.7 | 30.086 | 7.821 | 26.96 | 16.43 |
| 196 | 28 | 51 | 16.15 | 16.625 | 4.164 | 16.27 | 16.35 |
| 258 | 82 | 51 | 16.233 | 17.972 | 4.24 | 16.59 | 15.81 |
| 239 | 259 | 51 | 30.4 | 31.824 | 12.831 | 37.9 | 25.83 |
| 195 | 87 | 51 | 15.083 | 16.053 | 3.849 | 24.51 | 15.75 |
| 91 | 149 | 51 | 12.967 | 13.15 | 2.22 | 11.06 | 10.43 |
| 225 | 137 | 51 | 36.65 | 38.504 | 7.06 | 27.29 | 11.74 |
| 141 | 252 | 51 | 29.767 | 33.487 | 12.826 | 38.98 | 24.71 |
| 238 | 3 | 51 | 30.667 | 31.96 | 13.104 | 38.87 | 26.57 |
| 224 | 189 | 51 | 25.633 | 25.957 | 6.62 | 23.39 | 15.86 |
| 233 | 51 | 51 | 29.433 | 33.197 | 14.437 | 41.47 | 28.18 |
| 90 | 1 | 51 | 32.717 | 39.935 | 15.186 | 69.83 | 26.29 |