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 |
|---|---|---|---|---|---|---|---|
| 241 | 252 | 2 | 26.792 | 26.792 | 10.29 | 30.75 | 23.32 |
| 69 | 108 | 2 | 47.25 | 47.25 | 29.575 | 79.5 | 37.53 |
| 111 | 72 | 2 | 20.283 | 20.283 | 5.145 | 18.5 | 15.24 |
| 147 | 259 | 2 | 22.433 | 22.433 | 8.12 | 24.75 | 22.25 |
| 123 | 196 | 2 | 61.6 | 61.6 | 16.505 | 46.84 | 16.13 |
| 196 | 250 | 2 | 25.358 | 25.358 | 6.31 | 24.41 | 15.54 |
| 130 | 221 | 2 | 56.225 | 56.225 | 24.9 | 70.75 | 26.62 |
| 155 | 50 | 2 | 26.758 | 26.758 | 12.08 | 35.75 | 19.29 |
| 215 | 159 | 2 | 29.417 | 29.417 | 16.825 | 46.25 | 35.95 |
| 82 | 67 | 2 | 42.625 | 42.625 | 15.38 | 47 | 22.93 |
| 130 | 1 | 2 | 62.158 | 62.158 | 26.335 | 96 | 25.43 |
| 241 | 43 | 2 | 48.342 | 48.342 | 12.95 | 44.5 | 17.95 |
| 60 | 65 | 2 | 53.875 | 53.875 | 16.19 | 50 | 18.05 |
| 60 | 97 | 2 | 41.508 | 41.508 | 15.455 | 46.25 | 23.81 |
| 9 | 82 | 2 | 25.108 | 25.108 | 9.63 | 28.75 | 25.44 |
| 237 | 204 | 2 | 64 | 64 | 30.15 | 84.75 | 28.28 |
| 20 | 194 | 2 | 23.992 | 23.992 | 8.645 | 26.25 | 22.02 |
| 183 | 129 | 2 | 25.775 | 25.775 | 10.885 | 33.22 | 26.07 |
| 55 | 244 | 2 | 65.325 | 65.325 | 27.575 | 78.25 | 25.33 |
| 232 | 172 | 2 | 37.517 | 37.517 | 16.715 | 47.75 | 26.7 |
| 222 | 134 | 2 | 28.083 | 28.083 | 9.03 | 29 | 20.22 |
| 52 | 130 | 2 | 68.825 | 68.825 | 16.63 | 57.25 | 15.47 |
| 202 | 56 | 2 | 30.733 | 30.733 | 8.15 | 28 | 15.83 |
| 260 | 183 | 2 | 20.233 | 20.233 | 12.955 | 35.75 | 39.61 |
| 63 | 116 | 2 | 44.592 | 44.592 | 17.015 | 51.75 | 22.9 |