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 |
|---|---|---|---|---|---|---|---|
| 136 | 168 | 46 | 24 | 24.061 | 5.997 | 21.93 | 17.1 |
| 26 | 228 | 46 | 13.233 | 17.205 | 2.731 | 13.39 | 9.53 |
| 126 | 42 | 46 | 18.95 | 19.921 | 4.085 | 16.77 | 13.3 |
| 60 | 167 | 46 | 7.583 | 9.091 | 1.271 | 7.85 | 9.54 |
| 76 | 48 | 46 | 55.592 | 58.632 | 16.993 | 52.46 | 18.61 |
| 196 | 93 | 46 | 7.208 | 11.693 | 3.718 | 13.26 | 23.18 |
| 26 | 170 | 46 | 46.617 | 49.368 | 12.225 | 42.72 | 16.26 |
| 130 | 92 | 46 | 22.658 | 23.242 | 6.442 | 22.7 | 18.91 |
| 159 | 263 | 46 | 14.525 | 19.17 | 3.814 | 15.98 | 14.15 |
| 34 | 181 | 46 | 15.875 | 17.146 | 2.475 | 12.84 | 9.07 |
| 203 | 205 | 46 | 15.142 | 15.625 | 3.477 | 13.89 | 13.71 |
| 225 | 130 | 46 | 34.55 | 35.69 | 9.857 | 33.35 | 17.09 |
| 9 | 16 | 46 | 8.592 | 8.582 | 1.828 | 8.54 | 13.4 |
| 166 | 191 | 46 | 40.492 | 42.449 | 20.712 | 58.29 | 30.26 |
| 216 | 121 | 46 | 22.65 | 22.474 | 5.492 | 20.02 | 15.59 |
| 157 | 237 | 46 | 20.392 | 23.884 | 5.84 | 47.41 | 17.18 |
| 130 | 38 | 46 | 21.917 | 21.169 | 4.806 | 18.54 | 14.82 |
| 79 | 10 | 46 | 43.992 | 47.369 | 15.667 | 49.24 | 21.83 |
| 144 | 39 | 46 | 46.033 | 48.625 | 11.334 | 40.09 | 14.97 |
| 17 | 71 | 46 | 18.392 | 20.471 | 3.461 | 15.63 | 11.42 |
| 249 | 47 | 46 | 33.742 | 36.943 | 12.323 | 38.85 | 21.67 |
| 171 | 98 | 46 | 17.992 | 18.267 | 4.781 | 16.76 | 15.86 |
| 113 | 182 | 46 | 36.742 | 41.318 | 12.986 | 40.89 | 20.78 |
| 39 | 261 | 46 | 42.225 | 46.879 | 14.868 | 44.68 | 21.91 |
| 26 | 188 | 46 | 27.333 | 28.244 | 3.991 | 19.39 | 9.26 |