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 |
|---|---|---|---|---|---|---|---|
| 254 | 164 | 6 | 60.992 | 67.317 | 16.245 | 55.81 | 16.76 |
| 190 | 142 | 6 | 45.517 | 44.556 | 10.898 | 38.58 | 15.57 |
| 39 | 78 | 6 | 70.667 | 71.461 | 23.692 | 71.61 | 21.42 |
| 142 | 172 | 6 | 46.167 | 42.75 | 18.492 | 52.92 | 24.28 |
| 22 | 142 | 6 | 53.475 | 59 | 14.587 | 49.75 | 15.95 |
| 102 | 225 | 6 | 16.892 | 16.508 | 4.563 | 16.33 | 16.82 |
| 188 | 69 | 6 | 50.558 | 55.267 | 18.412 | 56.02 | 20.24 |
| 244 | 1 | 6 | 37.133 | 41.133 | 24.768 | 73.08 | 37.76 |
| 70 | 88 | 6 | 39.375 | 38.519 | 14.48 | 42.42 | 23.65 |
| 144 | 81 | 6 | 45.35 | 47.467 | 18.987 | 55.25 | 24.19 |
| 175 | 15 | 6 | 11.9 | 12.472 | 4.95 | 16.17 | 23.58 |
| 67 | 225 | 6 | 33.008 | 34.789 | 9.84 | 31.34 | 17.99 |
| 37 | 10 | 6 | 31.5 | 33.753 | 10.127 | 33.67 | 18.76 |
| 89 | 198 | 6 | 39.467 | 39.372 | 8.307 | 30.75 | 12.68 |
| 72 | 138 | 6 | 51.108 | 47.311 | 14.147 | 45.58 | 19.36 |
| 135 | 244 | 6 | 41.625 | 42.322 | 15.08 | 43.73 | 22.51 |
| 181 | 173 | 6 | 33.517 | 36.283 | 10.74 | 36.25 | 18.63 |
| 181 | 115 | 6 | 26.15 | 25.756 | 11 | 33.5 | 26.83 |
| 129 | 40 | 6 | 27.625 | 28.289 | 11.56 | 37.92 | 26.36 |
| 61 | 94 | 6 | 60.642 | 59.244 | 20.93 | 64.33 | 22.59 |
| 101 | 192 | 6 | 19.167 | 19.164 | 7.46 | 23 | 24.21 |
| 217 | 72 | 6 | 24.425 | 27.6 | 5.153 | 21 | 12.89 |
| 163 | 44 | 6 | 59.517 | 59.436 | 31.997 | 100.67 | 33.14 |
| 129 | 72 | 6 | 38.075 | 36.411 | 13.138 | 40.17 | 22.21 |
| 151 | 190 | 6 | 39.558 | 42.197 | 12.553 | 40.75 | 18.25 |