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 |
|---|---|---|---|---|---|---|---|
| 68 | 117 | 34 | 62.467 | 69.181 | 25.509 | 75.12 | 23.88 |
| 114 | 93 | 34 | 38.9 | 41.617 | 12.953 | 41.13 | 20.09 |
| 255 | 173 | 34 | 23.125 | 23.797 | 7.196 | 24.34 | 18.96 |
| 87 | 222 | 34 | 56.875 | 59.85 | 15.305 | 52.65 | 16.21 |
| 246 | 16 | 34 | 38.533 | 42.579 | 17.837 | 52.9 | 27.34 |
| 45 | 19 | 34 | 34.133 | 34.195 | 17.399 | 48.71 | 31.14 |
| 203 | 188 | 34 | 52.275 | 49.474 | 13.87 | 43.03 | 18.54 |
| 45 | 159 | 34 | 30.592 | 35.847 | 10.731 | 34.11 | 20.74 |
| 37 | 91 | 34 | 26.375 | 27.208 | 5.378 | 21.27 | 12.32 |
| 47 | 242 | 34 | 25.95 | 25.018 | 5.035 | 19.88 | 12.61 |
| 232 | 196 | 34 | 21.808 | 22.089 | 8.09 | 25.51 | 24.42 |
| 259 | 87 | 34 | 36.25 | 40.073 | 19.956 | 55.65 | 31.4 |
| 168 | 161 | 34 | 24.025 | 27.76 | 6.04 | 22.54 | 15.37 |
| 26 | 17 | 34 | 44.55 | 41.358 | 7.992 | 31.4 | 12.86 |
| 203 | 87 | 34 | 67.192 | 62.812 | 24.029 | 73.82 | 24.35 |
| 95 | 10 | 34 | 20.992 | 21.222 | 4.934 | 18.07 | 16.13 |
| 166 | 52 | 34 | 37.358 | 40.003 | 12.001 | 38.44 | 18.73 |
| 263 | 76 | 34 | 49.042 | 53.995 | 17.303 | 52.9 | 21.27 |
| 189 | 230 | 34 | 34.65 | 36.226 | 7.991 | 29.72 | 16.42 |
| 235 | 68 | 34 | 31.417 | 34.461 | 10.789 | 34.62 | 20 |
| 39 | 123 | 34 | 24.267 | 26.095 | 7.169 | 25.48 | 18 |
| 219 | 76 | 34 | 19.167 | 22.033 | 6.726 | 22.68 | 21.55 |
| 61 | 142 | 34 | 40.017 | 46.287 | 10.511 | 36.7 | 14.87 |
| 152 | 20 | 34 | 21.292 | 22.809 | 6.782 | 22.66 | 18.95 |
| 165 | 87 | 34 | 26.25 | 28.6 | 8.945 | 29.13 | 20.03 |