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 |
|---|---|---|---|---|---|---|---|
| 250 | 55 | 1 | 42.283 | 42.283 | 27.02 | 64.06 | 38.34 |
| 32 | 225 | 1 | 35.35 | 35.35 | 17.24 | 46.12 | 29.26 |
| 228 | 185 | 1 | 48.55 | 48.55 | 22.22 | 61.05 | 27.46 |
| 55 | 38 | 1 | 38.717 | 38.717 | 19.29 | 52 | 29.89 |
| 183 | 77 | 1 | 26.867 | 26.867 | 16.5 | 44.2 | 36.85 |
| 46 | 197 | 1 | 25.667 | 25.667 | 15.36 | 42.5 | 35.91 |
| 245 | 258 | 1 | 39.267 | 39.267 | 23.68 | 64 | 36.18 |
| 257 | 206 | 1 | 31.383 | 31.383 | 11.5 | 35 | 21.99 |
| 76 | 34 | 1 | 31.183 | 31.183 | 6.32 | 24 | 12.16 |
| 218 | 189 | 1 | 55.483 | 55.483 | 11.96 | 44 | 12.93 |
| 21 | 159 | 1 | 55 | 55 | 30.68 | 83.5 | 33.47 |
| 207 | 95 | 1 | 14.25 | 14.25 | 6.34 | 20 | 26.69 |
| 217 | 219 | 1 | 21.917 | 21.917 | 13.4 | 52 | 36.68 |
| 30 | 180 | 1 | 16.317 | 16.317 | 5.13 | 18 | 18.86 |
| 191 | 98 | 1 | 13.95 | 13.95 | 3.22 | 15 | 13.85 |
| 12 | 73 | 1 | 33.95 | 33.95 | 15.52 | 44.5 | 27.43 |
| 70 | 6 | 1 | 60.067 | 60.067 | 28.54 | 78.5 | 28.51 |
| 181 | 248 | 1 | 33.65 | 33.65 | 22.03 | 60 | 39.28 |
| 70 | 31 | 1 | 14.35 | 14.35 | 9.03 | 26 | 37.76 |
| 195 | 47 | 1 | 69.883 | 69.883 | 20.58 | 64 | 17.67 |
| 14 | 32 | 1 | 97.917 | 97.917 | 24.3 | 76.5 | 14.89 |
| 27 | 49 | 1 | 31.55 | 31.55 | 8.29 | 28 | 15.77 |
| 82 | 31 | 1 | 28.95 | 28.95 | 11.79 | 37 | 24.44 |
| 197 | 247 | 1 | 31.9 | 31.9 | 14.44 | 40.5 | 27.16 |
| 215 | 57 | 1 | 20.867 | 20.867 | 6.79 | 22 | 19.52 |