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 |
|---|---|---|---|---|---|---|---|
| 85 | 217 | 7 | 29.95 | 28.119 | 5.441 | 22.07 | 12.96 |
| 63 | 209 | 7 | 47.1 | 48.117 | 8.813 | 52 | 11.42 |
| 216 | 149 | 7 | 31.317 | 29.688 | 12.75 | 38.27 | 27.25 |
| 61 | 167 | 7 | 42.367 | 40.688 | 17.847 | 50.57 | 26.89 |
| 80 | 222 | 7 | 40.917 | 38.94 | 7.46 | 30 | 12.46 |
| 10 | 222 | 7 | 16.567 | 19.429 | 6.184 | 20.79 | 20.13 |
| 31 | 94 | 7 | 17.8 | 16.633 | 2.421 | 12.57 | 9.22 |
| 180 | 19 | 7 | 33.333 | 33.526 | 10.901 | 33.31 | 20.08 |
| 131 | 226 | 7 | 24.967 | 31.7 | 11.447 | 35.19 | 24.96 |
| 168 | 77 | 7 | 43.283 | 46.01 | 17.739 | 51.88 | 24.49 |
| 146 | 91 | 7 | 55.733 | 45.721 | 12.383 | 41.29 | 14.82 |
| 68 | 184 | 7 | 37.1 | 40.49 | 16.34 | 47.71 | 26.28 |
| 89 | 158 | 7 | 26.75 | 28.555 | 8.859 | 29.36 | 19.22 |
| 17 | 218 | 7 | 42.7 | 47.462 | 13.626 | 43.98 | 17.72 |
| 180 | 48 | 7 | 53.917 | 55.495 | 14.704 | 51.38 | 16.28 |
| 223 | 195 | 7 | 37.167 | 35.99 | 11.931 | 36.14 | 22.56 |
| 225 | 206 | 7 | 45.1 | 45.779 | 16.971 | 51.21 | 23.29 |
| 247 | 112 | 7 | 25.1 | 31.743 | 10.194 | 32.71 | 23.9 |
| 40 | 155 | 7 | 32.983 | 33.286 | 8.453 | 29.5 | 15.89 |
| 133 | 108 | 7 | 17.75 | 19.357 | 3.983 | 20.79 | 12.94 |
| 171 | 93 | 7 | 11.517 | 15.06 | 3.884 | 14.86 | 16.39 |
| 213 | 232 | 7 | 44.55 | 42.517 | 12.903 | 39.02 | 19.42 |
| 193 | 228 | 7 | 38.017 | 42.99 | 12.449 | 40.21 | 18.22 |
| 153 | 213 | 7 | 24.3 | 25.736 | 7.874 | 24.64 | 19.78 |
| 31 | 231 | 7 | 40.8 | 41.657 | 15.48 | 45.89 | 23.54 |