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 |
|---|---|---|---|---|---|---|---|
| 37 | 146 | 31 | 21.467 | 24.749 | 5.045 | 19.98 | 13.01 |
| 33 | 11 | 31 | 20.15 | 22.02 | 9.749 | 28.66 | 27.17 |
| 218 | 82 | 31 | 35.067 | 35.609 | 10.217 | 31.61 | 17.97 |
| 106 | 13 | 31 | 14.383 | 14.465 | 3.888 | 24.79 | 17.56 |
| 151 | 182 | 31 | 30.65 | 31.66 | 9.953 | 31.34 | 20.94 |
| 68 | 206 | 31 | 41.433 | 44.036 | 18.013 | 52.65 | 24.74 |
| 49 | 4 | 31 | 21.083 | 20.767 | 5.037 | 18.89 | 15.13 |
| 141 | 81 | 31 | 38.417 | 41.081 | 13.642 | 41.75 | 21.38 |
| 4 | 254 | 31 | 39.917 | 42.281 | 16.649 | 48.95 | 24.97 |
| 145 | 53 | 31 | 29.65 | 32.71 | 10.374 | 32.48 | 21.01 |
| 136 | 254 | 31 | 18.883 | 21.182 | 4.487 | 17.92 | 13.96 |
| 129 | 114 | 31 | 27.65 | 32.524 | 8.409 | 29.26 | 17.86 |
| 18 | 47 | 31 | 14.167 | 15.021 | 2.4 | 12.08 | 10.28 |
| 190 | 133 | 31 | 12.417 | 12.676 | 2.364 | 11.05 | 12.26 |
| 147 | 218 | 31 | 49.417 | 50.908 | 20.656 | 57.03 | 24.79 |
| 239 | 21 | 31 | 49.783 | 50.09 | 17.506 | 53.1 | 21.56 |
| 141 | 11 | 31 | 40.817 | 43.013 | 17.944 | 52 | 26.94 |
| 142 | 192 | 31 | 34.383 | 37.715 | 11.995 | 38.68 | 19.9 |
| 51 | 60 | 31 | 21.867 | 23.344 | 7.074 | 23.82 | 19.92 |
| 177 | 140 | 31 | 56.05 | 55.723 | 12.224 | 43.74 | 14.04 |
| 262 | 67 | 31 | 35.75 | 37.146 | 14.934 | 43.13 | 25.82 |
| 47 | 60 | 31 | 8.817 | 9.23 | 1.458 | 8.1 | 10.06 |
| 168 | 55 | 31 | 57.95 | 61.948 | 26.05 | 73.73 | 26.98 |
| 144 | 213 | 31 | 32.317 | 36.97 | 13.142 | 40.29 | 22.77 |
| 121 | 218 | 31 | 23.967 | 24.934 | 5.895 | 21.48 | 14.44 |