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 |
|---|---|---|---|---|---|---|---|
| 114 | 202 | 188 | 26.9 | 28.429 | 6.719 | 23.96 | 15.02 |
| 255 | 13 | 188 | 23.825 | 25.011 | 6.191 | 22.67 | 15.83 |
| 233 | 157 | 188 | 18.7 | 21.427 | 6.246 | 23.88 | 19.56 |
| 148 | 35 | 188 | 28.517 | 30.657 | 7.502 | 26.66 | 15.41 |
| 246 | 227 | 188 | 29.308 | 31.421 | 10.022 | 32.05 | 20.05 |
| 243 | 41 | 188 | 17.867 | 18.415 | 4.504 | 17.07 | 15.58 |
| 125 | 127 | 187 | 30.3 | 32.668 | 11.974 | 36.81 | 23.29 |
| 41 | 144 | 187 | 31.65 | 32.369 | 8.679 | 29.93 | 16.73 |
| 116 | 137 | 187 | 29.767 | 31.548 | 8.276 | 28.45 | 17.37 |
| 41 | 136 | 187 | 22.3 | 24.06 | 6.036 | 21.96 | 16.44 |
| 48 | 91 | 187 | 54.85 | 56.812 | 14.222 | 48.01 | 15.91 |
| 146 | 238 | 187 | 20.55 | 22.291 | 4.723 | 18.81 | 13.9 |
| 195 | 25 | 187 | 12.05 | 13.674 | 2.209 | 10.95 | 10.55 |
| 125 | 95 | 187 | 37.933 | 40.351 | 10.765 | 36.29 | 17.38 |
| 113 | 69 | 187 | 28.517 | 31.656 | 9.78 | 31.7 | 20.43 |
| 129 | 145 | 187 | 17.917 | 18.736 | 4.318 | 17.05 | 14.71 |
| 114 | 83 | 187 | 21.883 | 24.074 | 7.794 | 25.96 | 21.04 |
| 236 | 167 | 187 | 22.817 | 24.748 | 5.197 | 20.19 | 13.83 |
| 234 | 35 | 187 | 54.517 | 55.422 | 10.091 | 38.23 | 11.64 |
| 132 | 31 | 187 | 41.467 | 43.2 | 21.058 | 58.63 | 31.87 |
| 68 | 76 | 187 | 48.5 | 51.836 | 13.915 | 46.32 | 17.1 |
| 179 | 164 | 187 | 25.417 | 26.589 | 5.112 | 20.98 | 12.43 |
| 186 | 185 | 187 | 38.617 | 41.812 | 14.899 | 45.48 | 22.91 |
| 231 | 69 | 187 | 34.55 | 38.937 | 12.285 | 38.95 | 21.46 |
| 80 | 90 | 187 | 22.383 | 24.295 | 5.416 | 20.74 | 14.37 |