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 |
|---|---|---|---|---|---|---|---|
| 119 | 29 | 2 | 88.858 | 88.858 | 29.8 | 86.25 | 21.29 |
| 197 | 224 | 2 | 40.983 | 40.983 | 13.41 | 52 | 19.69 |
| 70 | 150 | 2 | 38.417 | 38.417 | 20.76 | 56.75 | 37.59 |
| 189 | 60 | 2 | 54.433 | 54.433 | 19.515 | 57.75 | 21.25 |
| 119 | 72 | 2 | 60.942 | 60.942 | 21.815 | 67.75 | 22.86 |
| 139 | 166 | 2 | 20.05 | 20.05 | 19.635 | 56.75 | 103.91 |
| 91 | 12 | 2 | 46.867 | 46.867 | 9.705 | 33.95 | 13.25 |
| 227 | 173 | 2 | 65.083 | 65.083 | 17.51 | 56.5 | 18.81 |
| 156 | 233 | 2 | 4.708 | 4.708 | 0.825 | 5.25 | 13.83 |
| 94 | 262 | 2 | 26.067 | 26.067 | 7.59 | 25.75 | 18.01 |
| 71 | 64 | 2 | 46.642 | 46.642 | 15.775 | 48.75 | 20.95 |
| 258 | 212 | 2 | 37.167 | 37.167 | 17.45 | 49 | 28.82 |
| 23 | 74 | 2 | 46.583 | 46.583 | 24.945 | 68.5 | 32.39 |
| 71 | 40 | 2 | 58.158 | 58.158 | 12.215 | 43.25 | 11.59 |
| 254 | 238 | 2 | 45.067 | 45.067 | 13.695 | 44.75 | 18.26 |
| 146 | 54 | 2 | 18.108 | 18.108 | 7.71 | 23.75 | 25.93 |
| 38 | 43 | 2 | 72.017 | 72.017 | 20.975 | 70.25 | 19.96 |
| 18 | 164 | 2 | 42.25 | 42.25 | 11.77 | 39.5 | 20.68 |
| 93 | 133 | 2 | 32.625 | 32.625 | 17.195 | 47.5 | 32.27 |
| 182 | 127 | 2 | 21.383 | 21.383 | 5.88 | 20.5 | 17.95 |
| 175 | 93 | 2 | 43.45 | 43.45 | 13.555 | 44.62 | 20.46 |
| 53 | 166 | 2 | 24.958 | 24.958 | 8.77 | 27.75 | 22.04 |
| 1 | 90 | 2 | 24.6 | 24.6 | 8.345 | 45.5 | 21.82 |
| 220 | 120 | 2 | 8.058 | 8.058 | 2.65 | 10.25 | 25.65 |
| 203 | 16 | 2 | 28.233 | 28.233 | 11.955 | 36.26 | 26.06 |