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 |
|---|---|---|---|---|---|---|---|
| 133 | 52 | 15 | 13.183 | 13.397 | 3.913 | 14.33 | 18.29 |
| 135 | 229 | 15 | 26.3 | 30.552 | 11.94 | 43.83 | 26.64 |
| 107 | 6 | 15 | 33.65 | 34.883 | 15.952 | 46.1 | 29.6 |
| 196 | 256 | 15 | 14.367 | 17.311 | 6.795 | 26.8 | 29.49 |
| 257 | 234 | 15 | 30.9 | 33.216 | 8.646 | 28.28 | 16.6 |
| 143 | 149 | 15 | 47.033 | 50.513 | 16.206 | 49.98 | 19.49 |
| 91 | 86 | 15 | 39.45 | 39.248 | 12.75 | 39.76 | 19.8 |
| 255 | 22 | 15 | 26.417 | 28.761 | 11.399 | 34.3 | 25.62 |
| 90 | 46 | 15 | 49.533 | 48.884 | 18.34 | 54.3 | 23.53 |
| 170 | 207 | 15 | 17.4 | 18.401 | 8.236 | 28.78 | 28.42 |
| 7 | 188 | 15 | 46.25 | 45.937 | 11.736 | 39.67 | 16.58 |
| 209 | 242 | 15 | 34.8 | 40.334 | 15.812 | 46.44 | 25.92 |
| 34 | 45 | 15 | 9.15 | 11.417 | 2.71 | 11.37 | 15.33 |
| 4 | 196 | 15 | 27.483 | 27.938 | 9.405 | 29.9 | 21.71 |
| 62 | 237 | 15 | 51.033 | 50.876 | 11.193 | 40.03 | 13.82 |
| 27 | 27 | 15 | 9.083 | 11.568 | 1.601 | 9.4 | 8.83 |
| 226 | 133 | 15 | 26.033 | 28.196 | 11.573 | 34.17 | 26.59 |
| 203 | 163 | 15 | 42.483 | 42.95 | 20.585 | 54.47 | 29.92 |
| 3 | 259 | 15 | 14.833 | 19.227 | 3.367 | 15.87 | 11.82 |
| 24 | 134 | 15 | 39.517 | 43.902 | 14.401 | 45.13 | 21.37 |
| 168 | 91 | 15 | 47.183 | 49.979 | 24.239 | 67.33 | 30.15 |
| 248 | 208 | 15 | 11.417 | 14.192 | 3.969 | 15.33 | 22.69 |
| 50 | 139 | 15 | 44 | 48.816 | 22.355 | 63.8 | 29.4 |
| 159 | 197 | 15 | 35.567 | 36.011 | 14.386 | 41.92 | 24.5 |
| 195 | 205 | 15 | 50.283 | 50.692 | 21.891 | 61.1 | 27.55 |