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 |
|---|---|---|---|---|---|---|---|
| 225 | 190 | 11 | 20.45 | 21.809 | 3.837 | 16.59 | 11.29 |
| 180 | 231 | 11 | 44.583 | 49.627 | 13.821 | 51.15 | 18.57 |
| 133 | 140 | 11 | 39.35 | 47.852 | 12.36 | 41.17 | 17.62 |
| 146 | 212 | 11 | 26.533 | 28.72 | 9.055 | 29.68 | 20.83 |
| 92 | 72 | 11 | 41.933 | 45.467 | 12.042 | 42.73 | 17.44 |
| 83 | 50 | 11 | 31.433 | 37.224 | 7.732 | 29.73 | 13.55 |
| 78 | 48 | 11 | 43.017 | 49.383 | 12.032 | 40.54 | 16.76 |
| 117 | 33 | 11 | 62.15 | 69.111 | 23.039 | 70.79 | 22.12 |
| 192 | 9 | 11 | 10.467 | 11.867 | 2.758 | 11.64 | 14.71 |
| 165 | 45 | 11 | 50.117 | 49.47 | 10.34 | 37.84 | 13.29 |
| 248 | 18 | 11 | 12.5 | 14.714 | 3.928 | 14.59 | 18.25 |
| 97 | 252 | 11 | 33.333 | 39.979 | 14.952 | 44.39 | 26.6 |
| 259 | 247 | 11 | 28.833 | 32.898 | 8.451 | 29.22 | 17.16 |
| 14 | 37 | 11 | 57 | 53.594 | 10.772 | 41.55 | 13.62 |
| 171 | 53 | 11 | 21.233 | 21.274 | 3.875 | 15.5 | 11.13 |
| 26 | 41 | 11 | 53.367 | 52.314 | 16.549 | 51.04 | 18.76 |
| 185 | 140 | 11 | 41.067 | 44.682 | 10.165 | 35.15 | 14.79 |
| 116 | 55 | 11 | 58.867 | 62.741 | 22.815 | 65.99 | 22.65 |
| 93 | 193 | 11 | 25.033 | 22.741 | 7.896 | 40.22 | 22.22 |
| 227 | 132 | 11 | 36.25 | 37.927 | 22.92 | 61.88 | 37.55 |
| 117 | 205 | 11 | 40.65 | 42.63 | 12.213 | 38.1 | 17.95 |
| 54 | 107 | 11 | 23.933 | 23.017 | 5.147 | 19.55 | 13.38 |
| 50 | 222 | 11 | 60.017 | 61.802 | 17.908 | 58.83 | 17.97 |
| 250 | 259 | 11 | 18.467 | 20.37 | 6.634 | 21.53 | 21.03 |
| 25 | 150 | 11 | 35.917 | 35.27 | 13.936 | 41.82 | 26.01 |