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 |
|---|---|---|---|---|---|---|---|
| 49 | 150 | 5 | 48.183 | 48.597 | 12.88 | 42.9 | 16.4 |
| 77 | 230 | 5 | 55.933 | 52.683 | 15.444 | 50.3 | 18.2 |
| 12 | 11 | 5 | 18.15 | 22.817 | 10.092 | 29.9 | 29.15 |
| 165 | 243 | 5 | 78.033 | 73.08 | 20.224 | 63.24 | 17.13 |
| 157 | 97 | 5 | 25.383 | 31.223 | 5.086 | 20.13 | 12.62 |
| 54 | 90 | 5 | 27.2 | 27.327 | 5.448 | 22 | 12.4 |
| 135 | 122 | 5 | 17 | 17.637 | 4.818 | 15.9 | 16.49 |
| 5 | 237 | 5 | 75.417 | 76.1 | 30.302 | 87.7 | 24.73 |
| 145 | 29 | 5 | 42.733 | 40.337 | 19.898 | 55.47 | 31.29 |
| 65 | 23 | 5 | 31.167 | 32.603 | 15.826 | 45.5 | 31.55 |
| 85 | 233 | 5 | 52.283 | 50.41 | 11.272 | 41.9 | 14.81 |
| 136 | 3 | 5 | 25.017 | 24.413 | 4.052 | 18.5 | 10.3 |
| 153 | 236 | 5 | 45.367 | 43.03 | 9.954 | 35.61 | 14.2 |
| 10 | 83 | 5 | 25.85 | 26.297 | 9.272 | 28.43 | 22.37 |
| 108 | 76 | 5 | 23.517 | 26.097 | 10.96 | 32.38 | 28.76 |
| 81 | 76 | 5 | 41.45 | 45.847 | 20.996 | 56.56 | 29.9 |
| 54 | 4 | 5 | 17.1 | 17.97 | 5.094 | 17.5 | 18.12 |
| 168 | 122 | 5 | 41.883 | 43.347 | 15.948 | 47.7 | 22.35 |
| 31 | 45 | 5 | 44.183 | 43.243 | 16.302 | 45.37 | 23.44 |
| 116 | 130 | 5 | 37.067 | 38.517 | 15.674 | 46.2 | 25.93 |
| 8 | 226 | 5 | 20.683 | 27.18 | 4.714 | 21.8 | 9.92 |
| 196 | 181 | 5 | 25.85 | 29.483 | 12.122 | 36.1 | 25.39 |
| 127 | 31 | 5 | 21.517 | 22.403 | 5.05 | 20.1 | 14.84 |
| 29 | 33 | 5 | 26.15 | 25.927 | 11.034 | 33.6 | 27.16 |
| 180 | 45 | 5 | 41.867 | 47.093 | 10.6 | 36.69 | 14.1 |