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 |
|---|---|---|---|---|---|---|---|
| 24 | 37 | 26 | 44.375 | 45.892 | 12.598 | 41.88 | 17.36 |
| 244 | 240 | 26 | 17.283 | 21.138 | 7.02 | 25.16 | 21.71 |
| 65 | 11 | 26 | 22.767 | 25.678 | 9.501 | 29.58 | 23.71 |
| 188 | 261 | 26 | 37.917 | 38.403 | 6.693 | 27.67 | 11.5 |
| 135 | 162 | 26 | 31.2 | 33.06 | 11.198 | 37.27 | 22.34 |
| 7 | 127 | 26 | 20.925 | 25.199 | 9.563 | 29.94 | 25.06 |
| 193 | 188 | 26 | 33.092 | 35.685 | 8.826 | 30.85 | 15.47 |
| 127 | 174 | 26 | 16.85 | 17.167 | 4.01 | 15.98 | 15.46 |
| 186 | 6 | 26 | 37.383 | 39.556 | 15.636 | 46.13 | 24.73 |
| 54 | 161 | 26 | 30.808 | 31.517 | 7.422 | 26.85 | 14.93 |
| 70 | 218 | 26 | 26.1 | 24.871 | 10.817 | 31.88 | 27.51 |
| 229 | 64 | 26 | 37.625 | 41.485 | 16.357 | 48.04 | 25.88 |
| 249 | 183 | 26 | 34.583 | 39.831 | 16.253 | 48 | 26.99 |
| 216 | 63 | 26 | 15.1 | 15.774 | 4.565 | 16.89 | 18.27 |
| 113 | 153 | 26 | 33.417 | 36.69 | 12.938 | 40.14 | 22.93 |
| 49 | 125 | 26 | 20.683 | 21.467 | 4.162 | 21.57 | 12.89 |
| 226 | 39 | 26 | 61.233 | 65.31 | 14.202 | 52.69 | 16.26 |
| 148 | 8 | 26 | 20.883 | 21.801 | 9.472 | 28.65 | 27.4 |
| 17 | 233 | 26 | 34.4 | 35.217 | 8.191 | 29.89 | 15.12 |
| 74 | 134 | 26 | 29.375 | 29.819 | 12.973 | 41.87 | 27.57 |
| 45 | 173 | 26 | 31.333 | 37.434 | 10.719 | 36.37 | 19.41 |
| 246 | 108 | 26 | 36.733 | 37.624 | 16.425 | 47.4 | 26.97 |
| 36 | 179 | 26 | 21.333 | 22.908 | 7.959 | 25.29 | 21.71 |
| 43 | 55 | 26 | 50.792 | 53.266 | 20.846 | 60.63 | 24.48 |
| 80 | 173 | 26 | 20.242 | 21.096 | 7.412 | 24.06 | 21.59 |