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 |
|---|---|---|---|---|---|---|---|
| 135 | 198 | 3 | 15.317 | 15.061 | 5.733 | 18.5 | 23.28 |
| 62 | 126 | 3 | 43 | 54.922 | 17.657 | 54.83 | 20.81 |
| 72 | 18 | 3 | 53.133 | 53.706 | 25.783 | 70.98 | 28.58 |
| 160 | 53 | 3 | 19.2 | 21.883 | 7.367 | 24.33 | 21.53 |
| 210 | 93 | 3 | 38.283 | 35.517 | 18.51 | 51.86 | 32.55 |
| 253 | 173 | 3 | 5.933 | 6.506 | 1.973 | 8.17 | 17.39 |
| 217 | 166 | 3 | 35.033 | 37.8 | 10.323 | 34.17 | 17.77 |
| 122 | 3 | 3 | 31.183 | 33.728 | 14.573 | 44 | 26.51 |
| 229 | 204 | 3 | 48.667 | 61 | 29.05 | 82.83 | 30.84 |
| 173 | 33 | 3 | 50.4 | 51.028 | 11.047 | 39.78 | 13.05 |
| 135 | 203 | 3 | 27.683 | 29.033 | 14.82 | 42.33 | 30.3 |
| 260 | 213 | 3 | 23.933 | 21.739 | 8.023 | 25.17 | 22.74 |
| 61 | 136 | 3 | 47.917 | 55.85 | 17.513 | 57.69 | 23.53 |
| 180 | 108 | 3 | 23.517 | 24.783 | 12.65 | 36.67 | 33.2 |
| 56 | 127 | 3 | 48.567 | 41.628 | 15.897 | 48.5 | 24.47 |
| 141 | 176 | 3 | 47.283 | 48.706 | 22.08 | 63.17 | 27.77 |
| 4 | 111 | 3 | 28.333 | 27.9 | 8.02 | 27.67 | 19.57 |
| 18 | 231 | 3 | 60.433 | 53.872 | 16.677 | 51.05 | 22.03 |
| 23 | 28 | 3 | 49.6 | 57.283 | 30.557 | 82.17 | 34.13 |
| 131 | 181 | 3 | 45.8 | 44.1 | 13.317 | 42.33 | 18.24 |
| 141 | 154 | 3 | 60.317 | 56.356 | 26.78 | 73.17 | 28.93 |
| 12 | 254 | 3 | 41.7 | 41.439 | 19 | 53.17 | 28.16 |
| 157 | 218 | 3 | 35.9 | 33.694 | 10.79 | 39.09 | 24.63 |
| 117 | 155 | 3 | 29.8 | 27.378 | 10.013 | 29.64 | 22.38 |
| 6 | 251 | 3 | 7.017 | 8.711 | 3.523 | 11.83 | 26.94 |