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 |
|---|---|---|---|---|---|---|---|
| 80 | 51 | 1 | 45.717 | 45.717 | 18.9 | 56.5 | 24.8 |
| 134 | 112 | 1 | 28.817 | 28.817 | 10.04 | 31 | 20.9 |
| 16 | 116 | 1 | 17.017 | 17.017 | 14.84 | 52 | 52.33 |
| 106 | 136 | 1 | 32.783 | 32.783 | 20.16 | 54.5 | 36.9 |
| 157 | 150 | 1 | 52.7 | 52.7 | 16 | 47.5 | 18.22 |
| 2 | 166 | 1 | 52.667 | 52.667 | 18.2 | 52 | 20.73 |
| 20 | 64 | 1 | 49 | 49 | 13.5 | 44 | 16.53 |
| 217 | 224 | 1 | 21.8 | 21.8 | 3.97 | 17 | 10.93 |
| 35 | 60 | 1 | 87.05 | 87.05 | 19.4 | 65 | 13.37 |
| 56 | 250 | 1 | 28.483 | 28.483 | 9.95 | 30.5 | 20.96 |
| 39 | 221 | 1 | 42.083 | 42.083 | 16.01 | 47 | 22.83 |
| 235 | 156 | 1 | 38.017 | 38.017 | 29.96 | 147 | 47.28 |
| 111 | 233 | 1 | 32.083 | 32.083 | 10.28 | 31.5 | 19.22 |
| 57 | 79 | 1 | 35.083 | 35.083 | 10.03 | 32.5 | 17.15 |
| 203 | 79 | 1 | 67.983 | 67.983 | 17.82 | 58 | 15.73 |
| 208 | 31 | 1 | 14.583 | 14.583 | 6.2 | 19 | 25.51 |
| 136 | 24 | 1 | 23.183 | 23.183 | 6.81 | 23.5 | 17.62 |
| 128 | 181 | 1 | 64.617 | 64.617 | 18.19 | 56.5 | 16.89 |
| 159 | 71 | 1 | 89.683 | 89.683 | 16.4 | 59 | 10.97 |
| 174 | 121 | 1 | 41.3 | 41.3 | 16.97 | 46.07 | 24.65 |
| 22 | 36 | 1 | 102.483 | 102.483 | 16.09 | 70 | 9.42 |
| 57 | 142 | 1 | 57.833 | 57.833 | 10.57 | 42 | 10.97 |
| 240 | 123 | 1 | 70.25 | 70.25 | 33.19 | 92.5 | 28.35 |
| 172 | 14 | 1 | 29.717 | 29.717 | 6.28 | 24.5 | 12.68 |
| 21 | 130 | 1 | 48.65 | 48.65 | 18.63 | 51.26 | 22.98 |