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 |
|---|---|---|---|---|---|---|---|
| 197 | 234 | 26 | 44.067 | 44.767 | 13.619 | 44.68 | 18.68 |
| 56 | 83 | 26 | 14.517 | 14.883 | 2.449 | 11.94 | 10.42 |
| 159 | 234 | 26 | 50.342 | 49.785 | 8.943 | 33.7 | 11.83 |
| 36 | 231 | 26 | 25.025 | 27.2 | 6.266 | 23.42 | 14.74 |
| 237 | 150 | 26 | 48.767 | 52.027 | 21.42 | 61.73 | 26.39 |
| 49 | 41 | 26 | 35.55 | 40.474 | 12.919 | 40.23 | 20.71 |
| 242 | 159 | 26 | 26.95 | 28.413 | 5.885 | 22.82 | 12.88 |
| 71 | 169 | 26 | 59.6 | 60.949 | 22.198 | 64.29 | 22.35 |
| 234 | 201 | 26 | 45.983 | 48.969 | 25.104 | 69.27 | 32.01 |
| 236 | 15 | 26 | 40.992 | 43.287 | 15.68 | 47.08 | 23.86 |
| 200 | 127 | 26 | 13.517 | 14.684 | 3.381 | 13.6 | 14.52 |
| 66 | 74 | 26 | 28.1 | 29.477 | 9.897 | 30.53 | 21.47 |
| 179 | 232 | 26 | 24.883 | 24.744 | 7.612 | 25.29 | 20.65 |
| 188 | 87 | 26 | 39.867 | 40.851 | 6.548 | 28.72 | 10.6 |
| 241 | 247 | 26 | 17.05 | 19.958 | 3.998 | 16.43 | 13.52 |
| 179 | 197 | 26 | 26.983 | 28.641 | 10.545 | 32.73 | 24.48 |
| 136 | 94 | 26 | 7.208 | 7.737 | 1 | 6.73 | 8.1 |
| 152 | 209 | 26 | 32.917 | 33.703 | 10.171 | 33.18 | 18.77 |
| 92 | 116 | 26 | 34.375 | 35.954 | 12.548 | 37.63 | 22.45 |
| 26 | 257 | 26 | 14.942 | 15.59 | 2.066 | 11.87 | 8.65 |
| 153 | 18 | 26 | 12.267 | 13.445 | 2.154 | 10.88 | 9.47 |
| 244 | 173 | 26 | 30.367 | 31.188 | 11.386 | 35.07 | 23.15 |
| 241 | 168 | 26 | 25.4 | 27.501 | 6.738 | 24.3 | 15.62 |
| 213 | 25 | 26 | 33.067 | 38.169 | 15.848 | 44.16 | 27.75 |
| 22 | 91 | 26 | 23.917 | 28.244 | 4.967 | 20.67 | 10.78 |