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 |
|---|---|---|---|---|---|---|---|
| 12 | 72 | 10 | 46.05 | 45.227 | 9.068 | 34.6 | 12.06 |
| 192 | 157 | 9 | 16.817 | 18.783 | 5.197 | 18.67 | 17.85 |
| 34 | 246 | 9 | 22.55 | 23.522 | 5.043 | 20.28 | 12.85 |
| 233 | 221 | 9 | 32.867 | 38.263 | 16.886 | 48.22 | 28.88 |
| 12 | 24 | 9 | 28.717 | 30.922 | 8.478 | 29.22 | 17.13 |
| 87 | 154 | 9 | 45.15 | 46.222 | 21.906 | 53.2 | 29.64 |
| 17 | 142 | 9 | 33.15 | 39.404 | 9.366 | 33.78 | 15.87 |
| 217 | 179 | 9 | 18.367 | 23.589 | 7.752 | 25.94 | 22.8 |
| 129 | 219 | 9 | 19.4 | 22.981 | 11.004 | 31.83 | 32.17 |
| 217 | 77 | 9 | 26.967 | 28.27 | 5.569 | 21.41 | 12.57 |
| 51 | 88 | 9 | 41.617 | 47.198 | 19.011 | 52.76 | 27.1 |
| 107 | 109 | 9 | 53.817 | 56.767 | 22.43 | 64.65 | 24.21 |
| 66 | 92 | 9 | 27.017 | 32.761 | 12.564 | 38 | 24.8 |
| 128 | 239 | 9 | 22.15 | 24.298 | 8.229 | 27.17 | 21.7 |
| 78 | 170 | 9 | 40.65 | 39.115 | 10.539 | 33.96 | 17.42 |
| 193 | 218 | 9 | 41.033 | 40.359 | 17.467 | 49.81 | 26.58 |
| 155 | 233 | 9 | 49.067 | 54.207 | 18.434 | 54.34 | 22.36 |
| 21 | 132 | 9 | 31.467 | 35.811 | 17.532 | 49.44 | 32.33 |
| 263 | 38 | 9 | 61.3 | 61.124 | 19.609 | 59.3 | 20.65 |
| 193 | 126 | 9 | 28.783 | 31.906 | 8.773 | 29.94 | 18.82 |
| 81 | 20 | 9 | 23.183 | 24.53 | 3.797 | 17.89 | 10.5 |
| 240 | 254 | 9 | 6.917 | 12.061 | 1.232 | 9.22 | 8.95 |
| 38 | 165 | 9 | 43.567 | 43.437 | 17.091 | 49.67 | 24.16 |
| 81 | 170 | 9 | 67.6 | 66.496 | 16.141 | 52.77 | 14.73 |
| 157 | 91 | 9 | 38.767 | 40.126 | 16.64 | 48.49 | 25.58 |