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 |
|---|---|---|---|---|---|---|---|
| 69 | 51 | 40 | 28.125 | 32.126 | 9.691 | 32.83 | 20.37 |
| 35 | 86 | 40 | 40.717 | 45.692 | 14.392 | 47.29 | 19.78 |
| 112 | 227 | 40 | 22.492 | 24.302 | 9.583 | 28.95 | 25.82 |
| 162 | 19 | 40 | 40.683 | 42.719 | 16.995 | 49.66 | 25.67 |
| 37 | 205 | 40 | 39.542 | 41.738 | 12.618 | 40.19 | 19.5 |
| 249 | 194 | 40 | 32.225 | 32.175 | 9.621 | 31.44 | 18.66 |
| 145 | 89 | 40 | 30.3 | 32.447 | 11.872 | 36.4 | 23.53 |
| 61 | 209 | 40 | 32.617 | 34.967 | 5.829 | 27.76 | 10.83 |
| 77 | 17 | 40 | 27.642 | 27.31 | 4.21 | 19.65 | 9.53 |
| 40 | 75 | 40 | 35.567 | 36.089 | 10.775 | 34.86 | 20.12 |
| 163 | 73 | 40 | 40.833 | 42.325 | 12.207 | 40.69 | 18.81 |
| 37 | 75 | 40 | 39.392 | 42.2 | 11.842 | 39.12 | 18.03 |
| 243 | 100 | 40 | 27.342 | 33.002 | 9.045 | 32.01 | 18.38 |
| 220 | 41 | 40 | 24.517 | 26.483 | 7.074 | 24.59 | 17.54 |
| 125 | 55 | 40 | 34.725 | 36.982 | 15.229 | 44.98 | 26.09 |
| 71 | 65 | 40 | 33.9 | 35.121 | 5.261 | 23.78 | 9.7 |
| 79 | 183 | 40 | 33.192 | 33.642 | 14.819 | 42.8 | 27.36 |
| 127 | 230 | 40 | 22.55 | 25.479 | 9.355 | 29.95 | 24.83 |
| 161 | 19 | 40 | 35.4 | 38.931 | 17.22 | 49.76 | 28.17 |
| 71 | 209 | 40 | 34.108 | 35.24 | 8.244 | 29.43 | 14.76 |
| 75 | 91 | 40 | 65.933 | 65.034 | 18.711 | 59.48 | 17.94 |
| 205 | 132 | 40 | 15.125 | 15.798 | 4.921 | 19.25 | 20.36 |
| 40 | 72 | 40 | 18.867 | 19.74 | 4.714 | 17.46 | 14.82 |
| 45 | 70 | 40 | 38.558 | 41.698 | 12.153 | 40.41 | 20.54 |
| 261 | 153 | 40 | 42.633 | 44.403 | 14.682 | 45.99 | 20.57 |