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 |
|---|---|---|---|---|---|---|---|
| 211 | 10 | 17 | 49.233 | 50.92 | 15.861 | 49.73 | 20.47 |
| 37 | 163 | 17 | 39.35 | 41.416 | 8.493 | 30.68 | 13.03 |
| 73 | 16 | 17 | 8.933 | 10.055 | 2.204 | 9.53 | 13.51 |
| 97 | 86 | 17 | 54.983 | 54.376 | 22.385 | 68.18 | 29.52 |
| 223 | 119 | 17 | 17.083 | 21.172 | 7.058 | 22.79 | 22.95 |
| 243 | 60 | 17 | 17.733 | 17.84 | 4.064 | 15.85 | 14.68 |
| 217 | 89 | 17 | 22.25 | 26.72 | 6.858 | 24.38 | 17.14 |
| 147 | 244 | 17 | 27.617 | 28.379 | 4.06 | 20.34 | 9.19 |
| 92 | 229 | 17 | 29.65 | 31.734 | 10.973 | 34.57 | 22.09 |
| 162 | 115 | 17 | 37.867 | 42.336 | 18.158 | 51.94 | 27.08 |
| 54 | 79 | 17 | 18.95 | 20.268 | 5.337 | 19.21 | 16.57 |
| 196 | 193 | 17 | 26.05 | 26.193 | 7.025 | 26.48 | 16.38 |
| 225 | 55 | 17 | 48.267 | 48.675 | 14.049 | 46.1 | 18.16 |
| 181 | 168 | 17 | 30.683 | 32.686 | 13.326 | 39.56 | 25.5 |
| 195 | 209 | 17 | 14.783 | 16.644 | 4.018 | 29.35 | 15.75 |
| 20 | 47 | 17 | 6.667 | 6.924 | 1.108 | 6.65 | 9.06 |
| 144 | 77 | 17 | 38.667 | 37.984 | 9.231 | 32.32 | 15.08 |
| 165 | 161 | 17 | 65.767 | 64.931 | 13.885 | 50.88 | 14.63 |
| 112 | 202 | 17 | 12 | 12.674 | 3.164 | 12.24 | 15.18 |
| 228 | 112 | 17 | 25.3 | 27.23 | 8.246 | 26.79 | 19.98 |
| 95 | 148 | 17 | 29.417 | 34.622 | 10.295 | 34.09 | 19.02 |
| 232 | 60 | 17 | 30.417 | 32.653 | 11.757 | 35.38 | 23.81 |
| 19 | 218 | 17 | 17.167 | 17.342 | 8.105 | 23.8 | 28.97 |
| 88 | 51 | 17 | 54.75 | 51.972 | 19.845 | 57.65 | 25.91 |
| 188 | 249 | 17 | 33.883 | 35.648 | 6.904 | 27.17 | 12.2 |