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 |
|---|---|---|---|---|---|---|---|
| 17 | 188 | 240 | 14.025 | 14.715 | 2.758 | 12.49 | 12.12 |
| 263 | 235 | 240 | 21.292 | 24.784 | 6.967 | 24.06 | 19.42 |
| 45 | 244 | 240 | 34.208 | 38.101 | 11.438 | 37.35 | 20.17 |
| 65 | 54 | 240 | 9.975 | 10.4 | 1.936 | 9.37 | 11.97 |
| 229 | 101 | 240 | 39.967 | 41.426 | 20.048 | 56.18 | 30.03 |
| 43 | 194 | 240 | 22.058 | 23.32 | 5.528 | 23.41 | 14.79 |
| 97 | 125 | 240 | 14.625 | 15.787 | 3.327 | 15.33 | 14.3 |
| 233 | 93 | 239 | 26.667 | 30.409 | 11.507 | 36.92 | 25.65 |
| 202 | 7 | 239 | 10.267 | 10.89 | 1.995 | 9.4 | 11.96 |
| 211 | 195 | 239 | 22.367 | 23.052 | 5.128 | 19.47 | 13.95 |
| 91 | 155 | 239 | 8.617 | 9.637 | 1.484 | 8.43 | 12.24 |
| 42 | 100 | 239 | 28.167 | 29.388 | 6.543 | 24.78 | 14.42 |
| 45 | 7 | 239 | 26.3 | 28.936 | 9.112 | 29.6 | 20.97 |
| 79 | 258 | 239 | 29.75 | 33.462 | 11.672 | 36.49 | 22.9 |
| 244 | 200 | 239 | 13.1 | 14.261 | 5.241 | 17.63 | 23.4 |
| 194 | 132 | 238 | 28.242 | 32.387 | 16.15 | 51.92 | 34.59 |
| 48 | 254 | 238 | 34.2 | 36.994 | 15.209 | 45 | 26.59 |
| 61 | 65 | 238 | 19.683 | 21.273 | 3.459 | 15.74 | 10.35 |
| 114 | 173 | 238 | 30.375 | 32.219 | 10.35 | 33.69 | 20.34 |
| 196 | 170 | 238 | 16.867 | 19.977 | 7.358 | 40.53 | 26.13 |
| 37 | 112 | 238 | 12.15 | 13.137 | 2.353 | 10.99 | 11.12 |
| 52 | 45 | 238 | 12.633 | 13.507 | 2.997 | 12.46 | 14.33 |
| 232 | 145 | 238 | 18.875 | 20.113 | 5.486 | 19.67 | 17.84 |
| 25 | 88 | 238 | 12.992 | 13.898 | 3.209 | 13.62 | 15.6 |
| 88 | 133 | 238 | 17.85 | 19.29 | 6.716 | 21.54 | 22.24 |