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 |
|---|---|---|---|---|---|---|---|
| 150 | 210 | 104 | 6.858 | 8.174 | 1.585 | 8.01 | 12.05 |
| 130 | 82 | 104 | 20.95 | 24.063 | 6.385 | 22.92 | 17.39 |
| 244 | 232 | 103 | 32.35 | 34.006 | 11.721 | 36.48 | 22.83 |
| 162 | 172 | 103 | 49.15 | 50.342 | 20.676 | 59 | 24.99 |
| 88 | 248 | 103 | 31.883 | 35.039 | 14.624 | 42.31 | 26.95 |
| 223 | 194 | 103 | 9.083 | 10.071 | 3.815 | 22.92 | 28.93 |
| 166 | 194 | 103 | 20.067 | 20.894 | 4.224 | 19.31 | 12.52 |
| 137 | 32 | 103 | 29.267 | 36.834 | 12.692 | 39.02 | 24.44 |
| 107 | 174 | 103 | 34.983 | 37.269 | 15.024 | 44.43 | 27.52 |
| 4 | 52 | 103 | 16.917 | 18.117 | 5.081 | 17.77 | 17.79 |
| 52 | 14 | 103 | 16.183 | 18.065 | 6.116 | 20.24 | 21.88 |
| 7 | 252 | 103 | 19.983 | 22.972 | 8.656 | 27.1 | 25.03 |
| 246 | 29 | 103 | 37.117 | 40.345 | 17.99 | 52.11 | 27.88 |
| 236 | 183 | 103 | 25.233 | 28.718 | 10.164 | 31.66 | 23.16 |
| 82 | 179 | 103 | 17.4 | 18.05 | 4.399 | 16.71 | 15.66 |
| 148 | 169 | 103 | 28.2 | 29.501 | 12.576 | 37.03 | 27.08 |
| 225 | 181 | 103 | 24.05 | 24.341 | 3.976 | 17.67 | 10.19 |
| 48 | 98 | 103 | 37.55 | 40.801 | 12.972 | 41.21 | 20.37 |
| 75 | 32 | 103 | 25.417 | 28.021 | 8.856 | 28.63 | 21.41 |
| 132 | 5 | 103 | 52.867 | 56.803 | 34.351 | 90.65 | 38.09 |
| 4 | 179 | 103 | 23.3 | 24.801 | 7.34 | 24.63 | 18.84 |
| 33 | 198 | 103 | 27.083 | 28.868 | 6.351 | 23.85 | 14.06 |
| 175 | 175 | 103 | 4.917 | 6.858 | 1.452 | 8.81 | 31.33 |
| 74 | 173 | 103 | 24.133 | 26.711 | 8.462 | 27.63 | 21.41 |
| 161 | 155 | 103 | 58.067 | 62.253 | 20.589 | 63.58 | 21.1 |