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 |
|---|---|---|---|---|---|---|---|
| 112 | 9 | 3 | 26.75 | 30.006 | 10.813 | 32.83 | 23.01 |
| 93 | 195 | 3 | 33.433 | 32.706 | 14.387 | 40.67 | 27.43 |
| 198 | 195 | 3 | 36.433 | 34.45 | 9.373 | 30.33 | 17.66 |
| 41 | 124 | 3 | 41.117 | 41.494 | 18.43 | 52 | 29.07 |
| 178 | 262 | 3 | 56.9 | 60 | 15.117 | 48.38 | 15.29 |
| 143 | 253 | 3 | 28.483 | 34.633 | 14.507 | 41.83 | 25.52 |
| 127 | 135 | 3 | 34.733 | 38.494 | 16.267 | 46.67 | 26.36 |
| 122 | 45 | 3 | 45.65 | 47.356 | 18.057 | 52.67 | 22.96 |
| 77 | 98 | 3 | 20.4 | 21.011 | 9.29 | 26.98 | 26.52 |
| 155 | 125 | 3 | 42.833 | 42.989 | 19.987 | 52 | 28.7 |
| 183 | 159 | 3 | 23.9 | 21.433 | 6.423 | 21.63 | 19.19 |
| 130 | 66 | 3 | 64.15 | 58.139 | 15.573 | 45.31 | 17.83 |
| 254 | 184 | 3 | 31.25 | 28.511 | 10.557 | 27.48 | 22.32 |
| 165 | 125 | 3 | 33.467 | 33.683 | 8.84 | 30.5 | 16.47 |
| 193 | 52 | 3 | 23.133 | 25.056 | 8.493 | 26.67 | 20.69 |
| 188 | 224 | 3 | 27.417 | 31.544 | 8.01 | 25.01 | 16.27 |
| 154 | 71 | 3 | 24.667 | 22.228 | 5.367 | 20.33 | 14.53 |
| 40 | 160 | 3 | 22.767 | 21.978 | 10.14 | 29.33 | 28.02 |
| 213 | 37 | 3 | 26.017 | 33.117 | 17.11 | 47.83 | 33.61 |
| 50 | 5 | 3 | 47.917 | 44.944 | 27.39 | 74.17 | 37.87 |
| 37 | 18 | 3 | 36.683 | 34.95 | 16.927 | 49 | 29.97 |
| 89 | 127 | 3 | 43.533 | 44.633 | 21.087 | 58.67 | 28.41 |
| 152 | 175 | 3 | 44.517 | 42.939 | 17.52 | 50.5 | 24.7 |
| 19 | 63 | 3 | 27.267 | 24.839 | 13.037 | 35.78 | 32.71 |
| 14 | 176 | 3 | 33.05 | 33.789 | 10.06 | 33 | 18.37 |