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 |
|---|---|---|---|---|---|---|---|
| 7 | 224 | 43 | 17.633 | 19.815 | 5.492 | 19.05 | 17.72 |
| 159 | 141 | 43 | 27.267 | 27.112 | 5.407 | 21.3 | 13.87 |
| 45 | 85 | 43 | 30.633 | 30.483 | 6.777 | 25.43 | 14.24 |
| 223 | 56 | 43 | 16.683 | 17.871 | 6.109 | 20.31 | 23.61 |
| 223 | 17 | 43 | 24.983 | 28.393 | 8.55 | 28.09 | 20.45 |
| 188 | 222 | 43 | 24.833 | 25.042 | 4.036 | 18.44 | 10.02 |
| 86 | 75 | 43 | 92.15 | 89.271 | 24.335 | 80.59 | 17.88 |
| 113 | 131 | 43 | 46.8 | 48.11 | 16.077 | 49.03 | 21.94 |
| 219 | 148 | 43 | 48.467 | 45.073 | 16.172 | 52.59 | 23.82 |
| 97 | 235 | 43 | 42.05 | 48.441 | 15.477 | 47.71 | 21.67 |
| 3 | 185 | 43 | 11.133 | 12.959 | 2.166 | 11.67 | 10.47 |
| 75 | 240 | 43 | 22.633 | 27.034 | 10.073 | 30.73 | 25.4 |
| 213 | 254 | 43 | 16.367 | 18.387 | 5.921 | 19.53 | 21.24 |
| 151 | 197 | 43 | 50.6 | 50.993 | 15.706 | 50.17 | 21.78 |
| 61 | 232 | 43 | 28.133 | 30.283 | 5.672 | 23.53 | 11.93 |
| 18 | 127 | 43 | 13.333 | 13.952 | 2.233 | 11.33 | 9.76 |
| 230 | 251 | 43 | 47.267 | 49.608 | 19.808 | 59.67 | 24.89 |
| 91 | 137 | 43 | 48.05 | 48.846 | 13.9 | 42.66 | 17.7 |
| 92 | 93 | 43 | 8.467 | 10.52 | 2.502 | 11.44 | 16.18 |
| 39 | 49 | 43 | 31.233 | 32.197 | 5.814 | 23.36 | 11.16 |
| 83 | 92 | 43 | 16.717 | 20.185 | 5.959 | 21.03 | 21.44 |
| 28 | 74 | 43 | 19.317 | 23.287 | 11.983 | 50.81 | 34.88 |
| 129 | 209 | 43 | 43.833 | 43.188 | 10.416 | 36.65 | 15.59 |
| 124 | 209 | 43 | 43.117 | 47.347 | 17.45 | 52.89 | 23.85 |
| 226 | 15 | 43 | 27.55 | 29.695 | 12.813 | 37.81 | 27.02 |