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 |
|---|---|---|---|---|---|---|---|
| 213 | 169 | 25 | 17.783 | 19.551 | 5.015 | 18.1 | 16.23 |
| 4 | 242 | 25 | 29.85 | 38.291 | 13.355 | 42.06 | 24.5 |
| 18 | 69 | 25 | 20.667 | 22.427 | 3.414 | 16.84 | 10.05 |
| 191 | 140 | 25 | 54.133 | 56.504 | 19.009 | 54.93 | 20.83 |
| 168 | 218 | 25 | 31.683 | 35.24 | 17.08 | 47.99 | 31.47 |
| 80 | 56 | 25 | 16.2 | 17.547 | 6.24 | 20.46 | 22.82 |
| 248 | 60 | 25 | 7.683 | 10.633 | 1.296 | 14.56 | 23.19 |
| 50 | 221 | 25 | 36.783 | 39.752 | 16.15 | 47.4 | 25.31 |
| 170 | 23 | 25 | 43.783 | 48.106 | 21.4 | 60.86 | 28.41 |
| 73 | 121 | 25 | 9.583 | 9.67 | 2.309 | 9.78 | 14.55 |
| 45 | 111 | 25 | 25.633 | 26.107 | 5.401 | 20.58 | 13.09 |
| 28 | 10 | 25 | 14.483 | 15.565 | 3.146 | 13.15 | 13.27 |
| 52 | 223 | 25 | 22.583 | 25.417 | 10.876 | 31.88 | 27.69 |
| 252 | 171 | 25 | 8.783 | 10.475 | 1.864 | 10.87 | 10.76 |
| 186 | 221 | 25 | 38.917 | 40.053 | 15.583 | 46.24 | 23.45 |
| 197 | 205 | 25 | 20.067 | 20.904 | 4.617 | 18.08 | 14.04 |
| 95 | 175 | 25 | 15.067 | 17.327 | 6.53 | 20.44 | 25.46 |
| 28 | 45 | 25 | 36.95 | 37.319 | 14.462 | 51.49 | 26.16 |
| 12 | 62 | 25 | 29.883 | 29.939 | 6.325 | 24.06 | 13.33 |
| 225 | 87 | 25 | 33.367 | 33.53 | 5.959 | 26.75 | 11.29 |
| 144 | 175 | 25 | 33.767 | 34.731 | 15.051 | 43.8 | 28 |
| 168 | 240 | 25 | 22.083 | 24.129 | 8.084 | 25.91 | 25.11 |
| 16 | 64 | 25 | 12.183 | 15.768 | 3.644 | 14.46 | 17.11 |
| 17 | 7 | 25 | 23.6 | 25.367 | 7.622 | 25.5 | 19.28 |
| 225 | 205 | 25 | 38.117 | 40.026 | 12.102 | 40.51 | 18.86 |