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 |
|---|---|---|---|---|---|---|---|
| 45 | 260 | 114 | 21.158 | 24.462 | 8.159 | 26.49 | 22.85 |
| 88 | 70 | 114 | 37.35 | 41.178 | 13.286 | 41.69 | 21.84 |
| 80 | 260 | 114 | 12 | 12.458 | 4.177 | 14.66 | 21.43 |
| 61 | 36 | 114 | 17.092 | 18.424 | 3.254 | 14.34 | 11.05 |
| 50 | 62 | 114 | 40.958 | 44.008 | 9.907 | 35.87 | 14.28 |
| 66 | 190 | 114 | 19.875 | 20.673 | 3.562 | 16.07 | 10.9 |
| 12 | 224 | 114 | 13.85 | 14.755 | 4.284 | 15.5 | 19.01 |
| 246 | 196 | 114 | 28.942 | 30.874 | 8.91 | 30.1 | 18.74 |
| 233 | 3 | 114 | 43.15 | 43.428 | 13.721 | 42.01 | 21.24 |
| 231 | 135 | 114 | 35.158 | 38.131 | 14.318 | 42.78 | 23.96 |
| 223 | 173 | 114 | 15.292 | 17.521 | 4.114 | 16.2 | 15.81 |
| 161 | 76 | 114 | 47.933 | 51.29 | 15.053 | 49.28 | 19.28 |
| 49 | 177 | 114 | 16.733 | 17.546 | 3.227 | 14.11 | 11.55 |
| 232 | 223 | 114 | 23.292 | 24.817 | 9.135 | 28.6 | 24.9 |
| 145 | 92 | 114 | 23.858 | 25.256 | 9.052 | 28.63 | 23.14 |
| 69 | 18 | 114 | 14.508 | 15.879 | 3.364 | 13.53 | 13.56 |
| 81 | 51 | 114 | 10.233 | 11.335 | 2.161 | 10.73 | 12.3 |
| 87 | 83 | 114 | 26.883 | 29.422 | 9.096 | 29.54 | 20.5 |
| 151 | 194 | 114 | 21.533 | 22.189 | 4.739 | 22.46 | 13.32 |
| 229 | 213 | 114 | 26.733 | 28.961 | 9.553 | 30.26 | 22.14 |
| 148 | 200 | 114 | 30.775 | 34.131 | 16.409 | 46.8 | 31.35 |
| 234 | 169 | 114 | 32.042 | 35.657 | 11.105 | 35.66 | 20.89 |
| 52 | 75 | 114 | 29.125 | 30.175 | 10.181 | 31.51 | 21.32 |
| 261 | 21 | 114 | 28.75 | 32.562 | 10.814 | 34.18 | 21.28 |
| 161 | 192 | 114 | 32.325 | 34.236 | 10.849 | 35.04 | 20.37 |