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 |
|---|---|---|---|---|---|---|---|
| 41 | 80 | 63 | 32.567 | 34.055 | 10.401 | 33.35 | 19.9 |
| 135 | 93 | 63 | 3.817 | 7.072 | 1.935 | 8.33 | 18.12 |
| 256 | 195 | 63 | 15.1 | 17.492 | 5.525 | 18.41 | 21.54 |
| 97 | 22 | 63 | 26.5 | 29.014 | 8.3 | 27.82 | 18.37 |
| 129 | 143 | 63 | 30.317 | 33.607 | 7.831 | 28.7 | 15.17 |
| 129 | 263 | 63 | 19.7 | 23.08 | 6.685 | 22.6 | 19.35 |
| 260 | 88 | 63 | 25.233 | 27.168 | 9.111 | 37.33 | 21.59 |
| 68 | 77 | 63 | 48.333 | 51.813 | 13.489 | 44.67 | 16.67 |
| 239 | 212 | 63 | 24.133 | 25.99 | 9.837 | 30.27 | 25.01 |
| 181 | 42 | 63 | 31.65 | 34.908 | 13.254 | 39.87 | 24.65 |
| 133 | 165 | 63 | 14.35 | 14.613 | 2.245 | 11.6 | 9.82 |
| 71 | 62 | 63 | 13.533 | 15.643 | 2.447 | 12.58 | 9.8 |
| 13 | 210 | 63 | 31.433 | 32.953 | 14.63 | 42.11 | 28.3 |
| 85 | 256 | 63 | 28.55 | 30.887 | 5.734 | 23.15 | 12.42 |
| 97 | 165 | 63 | 28.1 | 28.956 | 6.123 | 23.34 | 13.63 |
| 217 | 79 | 63 | 12.983 | 14.36 | 3.11 | 13.13 | 13.91 |
| 14 | 108 | 63 | 16.633 | 17.051 | 5.239 | 17.94 | 20.72 |
| 166 | 188 | 63 | 49.883 | 52.559 | 13.829 | 46.71 | 16.47 |
| 116 | 78 | 63 | 21.817 | 22.862 | 5.703 | 20.36 | 15.81 |
| 75 | 157 | 63 | 30.7 | 33.272 | 8.762 | 29.99 | 17.02 |
| 107 | 1 | 63 | 44.1 | 45.883 | 16.683 | 75.02 | 23.61 |
| 37 | 72 | 63 | 21.317 | 22.578 | 3.494 | 16.61 | 9.86 |
| 196 | 229 | 63 | 19.867 | 23.082 | 7.633 | 42.38 | 22.29 |
| 189 | 186 | 63 | 29 | 30.965 | 6.384 | 24.99 | 13.22 |
| 158 | 83 | 63 | 31.517 | 33.733 | 8.894 | 30.81 | 16.79 |