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 |
|---|---|---|---|---|---|---|---|
| 55 | 61 | 22 | 38.85 | 42.436 | 12.944 | 42.03 | 19.37 |
| 231 | 86 | 22 | 78.083 | 82.189 | 26.014 | 80.65 | 20.57 |
| 32 | 213 | 22 | 16.633 | 19.158 | 5.253 | 18.71 | 17.31 |
| 124 | 261 | 22 | 39.467 | 41.187 | 20.609 | 52 | 33.32 |
| 73 | 73 | 22 | 6.075 | 7.318 | 1.201 | 11.8 | 16.65 |
| 260 | 42 | 22 | 23.117 | 25.955 | 7.714 | 27.05 | 20.53 |
| 195 | 233 | 22 | 23.575 | 24.838 | 7.471 | 24.39 | 19.57 |
| 33 | 83 | 22 | 19.675 | 23.72 | 8.958 | 27.36 | 24.01 |
| 62 | 152 | 22 | 47.325 | 49.371 | 15.05 | 47.94 | 18.86 |
| 145 | 8 | 22 | 12.067 | 13.252 | 2.816 | 11.95 | 13.31 |
| 147 | 169 | 22 | 22.017 | 22.092 | 3.407 | 16.11 | 9.77 |
| 95 | 191 | 22 | 21.683 | 22.296 | 7.377 | 24 | 21.52 |
| 83 | 233 | 22 | 25.4 | 25.171 | 5.842 | 23.14 | 14.79 |
| 17 | 165 | 22 | 41.092 | 38.892 | 7.057 | 28.79 | 12.15 |
| 34 | 37 | 22 | 15.242 | 14.75 | 2.851 | 12.57 | 11.61 |
| 192 | 173 | 22 | 15.325 | 15.727 | 3.682 | 14.39 | 15.1 |
| 72 | 100 | 22 | 63.1 | 62.789 | 12.569 | 49.24 | 28.1 |
| 29 | 21 | 22 | 15.217 | 15.408 | 3.037 | 13.18 | 12.23 |
| 74 | 91 | 22 | 53.65 | 58.228 | 20.184 | 60.93 | 22.21 |
| 155 | 170 | 22 | 54.992 | 59.453 | 21.301 | 61.83 | 23.21 |
| 114 | 201 | 22 | 46.725 | 48.232 | 23.67 | 65.68 | 30.38 |
| 123 | 227 | 22 | 21.533 | 22.923 | 4.195 | 17.63 | 11.41 |
| 185 | 147 | 22 | 19.608 | 21.752 | 5.322 | 20.07 | 16.05 |
| 216 | 181 | 22 | 44.008 | 50.751 | 15.67 | 49.25 | 19.68 |
| 189 | 209 | 22 | 17.408 | 17.43 | 3.559 | 15.16 | 12.98 |