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 | 188 | 29 | 31.117 | 30.227 | 7.086 | 25.67 | 14.91 |
| 135 | 131 | 29 | 11.167 | 12.211 | 2.823 | 11.71 | 14.32 |
| 39 | 125 | 29 | 59.55 | 58.273 | 15.14 | 50.3 | 16.23 |
| 234 | 219 | 29 | 42.2 | 48.152 | 17.119 | 52.83 | 24.34 |
| 49 | 130 | 29 | 41.883 | 45.02 | 12.284 | 40.56 | 17.95 |
| 50 | 205 | 29 | 52.9 | 53.726 | 19.407 | 59.58 | 22.99 |
| 213 | 163 | 29 | 47.1 | 47.898 | 10.287 | 36.87 | 14.34 |
| 69 | 248 | 29 | 16.767 | 18.635 | 4.132 | 16.18 | 13.84 |
| 10 | 56 | 29 | 25.233 | 30.602 | 7.994 | 29.42 | 16.55 |
| 232 | 136 | 29 | 28.933 | 32.505 | 13.29 | 39.41 | 27.3 |
| 238 | 76 | 29 | 57.067 | 60.223 | 19.36 | 61.43 | 21.04 |
| 130 | 179 | 29 | 28.4 | 31.072 | 10.593 | 34.28 | 21.25 |
| 54 | 237 | 29 | 25.333 | 26.586 | 8.298 | 26.34 | 19.29 |
| 70 | 48 | 29 | 45.833 | 42.847 | 10.598 | 37.76 | 16.5 |
| 218 | 145 | 29 | 57.517 | 58.837 | 14.061 | 45.82 | 14.73 |
| 42 | 89 | 29 | 45.733 | 48.655 | 18.005 | 53.96 | 23.4 |
| 190 | 132 | 29 | 41.917 | 42.248 | 13.034 | 43.81 | 19.01 |
| 151 | 219 | 29 | 42.133 | 45.966 | 19.657 | 56.18 | 27.45 |
| 72 | 88 | 29 | 27.667 | 32.184 | 8.121 | 28.01 | 16.13 |
| 116 | 32 | 29 | 24.117 | 24.49 | 8.561 | 27.55 | 22.61 |
| 112 | 34 | 29 | 13.983 | 15.07 | 3.095 | 12.83 | 14.21 |
| 167 | 116 | 29 | 18.217 | 20.369 | 3.035 | 15.17 | 9.89 |
| 211 | 130 | 29 | 37.967 | 42.613 | 14.617 | 45.57 | 22.52 |
| 158 | 16 | 29 | 39.933 | 41.94 | 18.125 | 52.41 | 26.87 |
| 124 | 258 | 29 | 12.667 | 13.682 | 2.761 | 12.19 | 12.35 |