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 |
|---|---|---|---|---|---|---|---|
| 220 | 93 | 3 | 43.217 | 42.906 | 17.893 | 52.83 | 25.71 |
| 235 | 115 | 3 | 42.967 | 46.794 | 27.823 | 75.17 | 36.52 |
| 168 | 195 | 3 | 31.017 | 29.939 | 13.917 | 39.17 | 28.26 |
| 177 | 131 | 3 | 27.817 | 31.822 | 9.327 | 30.83 | 20.71 |
| 173 | 117 | 3 | 37.4 | 39.267 | 16.233 | 47.5 | 25.19 |
| 61 | 207 | 3 | 23.85 | 24.817 | 9.303 | 28.17 | 22.64 |
| 71 | 179 | 3 | 64.617 | 66.65 | 14.467 | 51.67 | 13.37 |
| 94 | 250 | 3 | 17.017 | 21.361 | 4.237 | 17.67 | 12.78 |
| 222 | 116 | 3 | 58.6 | 57.606 | 25.207 | 69.77 | 26.34 |
| 22 | 53 | 3 | 38.9 | 41.522 | 24.79 | 65.56 | 36.48 |
| 14 | 10 | 3 | 68.017 | 62.45 | 20.27 | 59.67 | 23.1 |
| 235 | 226 | 3 | 32.35 | 36.222 | 13.677 | 41.67 | 22.63 |
| 203 | 14 | 3 | 39.083 | 42.2 | 21.46 | 59.17 | 31.11 |
| 58 | 170 | 3 | 47.683 | 45.389 | 12.587 | 38.73 | 17.68 |
| 28 | 51 | 3 | 30.717 | 38.678 | 19.643 | 55.17 | 32.1 |
| 256 | 205 | 3 | 39.467 | 40.35 | 15.34 | 45.17 | 22.8 |
| 119 | 4 | 3 | 44.433 | 45.483 | 9.56 | 35.36 | 17.22 |
| 15 | 53 | 3 | 19.95 | 18.794 | 3.85 | 16.17 | 12.77 |
| 5 | 145 | 3 | 89.9 | 97.667 | 30.69 | 94.67 | 19.53 |
| 218 | 77 | 3 | 22.767 | 23.361 | 8.137 | 25.67 | 20.98 |
| 22 | 23 | 3 | 20.167 | 39.056 | 14.56 | 44.83 | 27.47 |
| 83 | 96 | 3 | 15.717 | 18.106 | 6.267 | 20 | 22.19 |
| 22 | 164 | 3 | 56.5 | 58.444 | 13.23 | 46.17 | 13.69 |
| 119 | 95 | 3 | 32.733 | 30.806 | 15.477 | 44.17 | 30.83 |
| 143 | 84 | 3 | 64.733 | 63.761 | 25.43 | 75.32 | 24.01 |