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 |
|---|---|---|---|---|---|---|---|
| 87 | 197 | 122 | 38.208 | 42.249 | 15.145 | 45.54 | 24.25 |
| 97 | 74 | 122 | 25.592 | 30.237 | 10.832 | 33.3 | 23.77 |
| 65 | 143 | 122 | 27.2 | 29.342 | 7.209 | 26.02 | 15.32 |
| 238 | 18 | 122 | 28.775 | 30.919 | 10.098 | 32.54 | 21.38 |
| 26 | 165 | 122 | 19.492 | 20.153 | 2.773 | 14.53 | 8.73 |
| 97 | 145 | 122 | 20.233 | 20.827 | 6.257 | 21.36 | 18.9 |
| 145 | 74 | 122 | 19.5 | 22.094 | 5.898 | 20.63 | 17.4 |
| 71 | 39 | 122 | 16.9 | 17.591 | 2.949 | 13.92 | 10.59 |
| 161 | 185 | 122 | 35.208 | 37.305 | 12.474 | 38.8 | 21.37 |
| 87 | 200 | 122 | 37.167 | 39.246 | 16.37 | 47.77 | 26.69 |
| 68 | 258 | 122 | 40.992 | 42.988 | 12.174 | 40.24 | 17.84 |
| 107 | 28 | 122 | 34.983 | 38.646 | 12.298 | 38.75 | 21.36 |
| 237 | 123 | 122 | 50.8 | 53.524 | 16.495 | 52.04 | 19.39 |
| 107 | 76 | 122 | 49.375 | 52.246 | 12.417 | 43.48 | 15.55 |
| 151 | 25 | 122 | 35.067 | 37.271 | 11.031 | 36 | 19.39 |
| 124 | 132 | 122 | 6.967 | 9.427 | 4.664 | 40.71 | 38.9 |
| 100 | 180 | 122 | 39.1 | 42.421 | 12.228 | 40.4 | 18.31 |
| 262 | 82 | 122 | 29.425 | 29.058 | 7.752 | 26.98 | 17.79 |
| 7 | 232 | 122 | 23.608 | 25.564 | 7.659 | 25.75 | 19.76 |
| 249 | 21 | 122 | 31.342 | 33.893 | 12.545 | 37.93 | 23.24 |
| 83 | 132 | 122 | 35.867 | 37.134 | 11.788 | 49.06 | 21.17 |
| 166 | 97 | 122 | 43.292 | 45.352 | 11.82 | 40.2 | 16.57 |
| 238 | 198 | 122 | 34.183 | 36.758 | 9.255 | 31.85 | 15.46 |
| 125 | 157 | 122 | 23.025 | 25.456 | 7.626 | 25.98 | 19.48 |
| 244 | 78 | 121 | 19.067 | 21.099 | 4.479 | 17.72 | 13.71 |