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 |
|---|---|---|---|---|---|---|---|
| 216 | 68 | 38 | 56.05 | 52.889 | 14.785 | 50.99 | 18.72 |
| 246 | 94 | 38 | 31.225 | 32.561 | 11.203 | 35.24 | 22.44 |
| 239 | 85 | 38 | 48.325 | 51.684 | 14.402 | 46.8 | 17.3 |
| 143 | 94 | 38 | 28.333 | 29.269 | 9.063 | 29.8 | 19.8 |
| 225 | 85 | 38 | 21.342 | 22.145 | 4.137 | 17.36 | 11.74 |
| 190 | 231 | 38 | 25.908 | 28.118 | 4.878 | 21.37 | 11.13 |
| 61 | 26 | 38 | 28.442 | 28.908 | 5.274 | 21.4 | 11.87 |
| 224 | 194 | 38 | 16.667 | 18.596 | 7.223 | 22.16 | 25.81 |
| 159 | 254 | 38 | 25.192 | 26.716 | 8.964 | 29.39 | 21.49 |
| 148 | 124 | 38 | 38.875 | 42.546 | 16.645 | 50.63 | 24.83 |
| 121 | 192 | 38 | 8.967 | 10.286 | 1.599 | 8.99 | 9.5 |
| 261 | 167 | 38 | 36.117 | 36.695 | 13.346 | 40.68 | 22.87 |
| 168 | 43 | 38 | 12.892 | 14.622 | 2.899 | 12.34 | 13.38 |
| 247 | 186 | 38 | 35.442 | 37.39 | 8.957 | 31.71 | 15.69 |
| 193 | 62 | 38 | 35.617 | 36.746 | 7.354 | 27.62 | 12.22 |
| 75 | 165 | 38 | 53.825 | 59.63 | 16.993 | 54.26 | 18.3 |
| 164 | 201 | 38 | 50.933 | 53.369 | 25.452 | 71.39 | 29.68 |
| 107 | 120 | 38 | 26.833 | 28.274 | 9.736 | 30.74 | 22.57 |
| 89 | 170 | 38 | 37.125 | 40.496 | 11.482 | 37.29 | 18.49 |
| 80 | 14 | 38 | 24.225 | 25.192 | 10.877 | 32.19 | 28.02 |
| 7 | 194 | 38 | 17.417 | 20.045 | 5.229 | 18.91 | 17.36 |
| 134 | 205 | 38 | 18.183 | 19.889 | 5.238 | 18.83 | 17.2 |
| 129 | 76 | 38 | 32.617 | 40.535 | 12.532 | 40.27 | 21.42 |
| 142 | 9 | 38 | 31.25 | 34.964 | 13.692 | 41.38 | 24.77 |
| 4 | 82 | 38 | 25.342 | 29.147 | 8.904 | 29.33 | 19.69 |