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 |
|---|---|---|---|---|---|---|---|
| 126 | 148 | 4 | 51.017 | 47.521 | 11.572 | 39.62 | 15.33 |
| 16 | 22 | 4 | 60.992 | 57.229 | 27.35 | 76.38 | 29.88 |
| 29 | 230 | 4 | 55.45 | 66.121 | 14.332 | 53.12 | 13.54 |
| 254 | 181 | 4 | 74.958 | 80.588 | 22.61 | 68.64 | 19.99 |
| 53 | 167 | 4 | 37.858 | 37.371 | 10.37 | 35.38 | 16.97 |
| 217 | 159 | 4 | 31.125 | 33.025 | 12.31 | 37.25 | 24.37 |
| 197 | 152 | 4 | 40.275 | 40.45 | 15.12 | 48 | 22.82 |
| 188 | 70 | 4 | 29.858 | 28.233 | 12.34 | 35.86 | 26.92 |
| 70 | 228 | 4 | 32.158 | 37.45 | 16.677 | 47.5 | 28.77 |
| 90 | 203 | 4 | 45.033 | 46.587 | 20.373 | 58.75 | 27.32 |
| 12 | 71 | 4 | 34.4 | 34.933 | 7.9 | 29.38 | 13.78 |
| 140 | 27 | 4 | 67.808 | 68.308 | 28.273 | 80.12 | 25 |
| 169 | 85 | 4 | 53.167 | 54.279 | 23.49 | 68.62 | 27.3 |
| 56 | 20 | 4 | 28.533 | 31.696 | 13.875 | 40.34 | 27.12 |
| 167 | 138 | 4 | 23.825 | 26.108 | 9.238 | 28.25 | 21.87 |
| 157 | 16 | 4 | 34.358 | 34.913 | 8.875 | 29.75 | 15.46 |
| 157 | 98 | 4 | 27.45 | 28.433 | 7.562 | 26.88 | 17.1 |
| 78 | 239 | 4 | 29.633 | 31.092 | 9.16 | 30.38 | 18.85 |
| 41 | 149 | 4 | 67.117 | 69.704 | 22.73 | 70 | 19.59 |
| 209 | 128 | 4 | 60.075 | 56.2 | 14.463 | 48.25 | 18.75 |
| 241 | 159 | 4 | 28.933 | 28.125 | 5.255 | 22.12 | 13.32 |
| 218 | 247 | 4 | 43.675 | 43.475 | 20.705 | 57.88 | 31.34 |
| 94 | 79 | 4 | 50.85 | 48.196 | 13.162 | 39.46 | 18.32 |
| 134 | 201 | 4 | 27.258 | 27.896 | 13.45 | 37.62 | 30.13 |
| 147 | 143 | 4 | 40.692 | 39.887 | 7.43 | 27.68 | 11.23 |