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 |
|---|---|---|---|---|---|---|---|
| 82 | 234 | 159 | 20.6 | 22.614 | 7.448 | 46 | 21.77 |
| 36 | 256 | 159 | 12.067 | 12.783 | 2.506 | 11.05 | 11.98 |
| 233 | 26 | 159 | 34.267 | 36.034 | 12.141 | 37.82 | 21.83 |
| 87 | 55 | 159 | 32.133 | 34.688 | 14.427 | 42.31 | 26.6 |
| 88 | 22 | 158 | 29.7 | 30.802 | 10 | 31.71 | 20.56 |
| 67 | 14 | 158 | 9.925 | 10.939 | 1.646 | 9.28 | 9.93 |
| 78 | 78 | 158 | 5.275 | 7.984 | 1.541 | 9.36 | 17.62 |
| 231 | 155 | 158 | 51.05 | 51.278 | 13.706 | 45.26 | 17.03 |
| 143 | 260 | 158 | 28.367 | 29.701 | 6.024 | 24.16 | 12.78 |
| 168 | 147 | 158 | 10.15 | 10.55 | 1.718 | 9.06 | 10.27 |
| 144 | 69 | 158 | 27.358 | 29.438 | 10.986 | 33.86 | 23.28 |
| 239 | 228 | 158 | 38.2 | 41.324 | 11.951 | 39.07 | 18.53 |
| 79 | 259 | 158 | 32.433 | 36.347 | 15.862 | 45.65 | 28.59 |
| 170 | 55 | 158 | 42.192 | 45.345 | 18.41 | 53.79 | 26.2 |
| 43 | 189 | 158 | 38.525 | 40.453 | 10.127 | 35.08 | 15.76 |
| 140 | 123 | 158 | 45.55 | 47.921 | 16.097 | 49.1 | 21.43 |
| 189 | 79 | 158 | 20.317 | 21.668 | 4.4 | 17.98 | 12.81 |
| 237 | 165 | 158 | 46.408 | 48.756 | 15.062 | 47.71 | 19.69 |
| 256 | 100 | 158 | 27.533 | 29.145 | 5.431 | 22.65 | 12.29 |
| 164 | 130 | 158 | 36.267 | 41.034 | 13.384 | 41.82 | 22.25 |
| 48 | 11 | 158 | 36.617 | 38.802 | 15.303 | 45.6 | 24.55 |
| 143 | 128 | 158 | 18.358 | 18.934 | 8.33 | 25.28 | 27.34 |
| 68 | 21 | 157 | 37.683 | 39.796 | 13.895 | 42.57 | 21.81 |
| 143 | 256 | 157 | 34.833 | 36.496 | 8.059 | 30.29 | 13.88 |
| 141 | 102 | 157 | 28.033 | 31.254 | 7.957 | 27.96 | 16.3 |