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 |
|---|---|---|---|---|---|---|---|
| 92 | 228 | 2 | 69.825 | 69.825 | 17.725 | 58.5 | 17.26 |
| 122 | 91 | 2 | 60.367 | 60.367 | 13.95 | 44.64 | 13.97 |
| 189 | 205 | 2 | 35.592 | 35.592 | 12.925 | 39.25 | 21.79 |
| 195 | 220 | 2 | 63.475 | 63.475 | 20.2 | 64.75 | 19.25 |
| 33 | 242 | 2 | 38.533 | 38.533 | 19.6 | 54.75 | 30.79 |
| 150 | 1 | 2 | 36.742 | 36.742 | 22.495 | 162.5 | 37.46 |
| 235 | 10 | 2 | 32.2 | 32.2 | 17.92 | 49.25 | 33.63 |
| 247 | 53 | 2 | 22.408 | 22.408 | 11.27 | 32.25 | 31.68 |
| 133 | 47 | 2 | 58.758 | 58.758 | 21.245 | 63.25 | 22.78 |
| 139 | 79 | 2 | 45.433 | 45.433 | 19.325 | 53.36 | 25.52 |
| 84 | 214 | 2 | 23.15 | 23.15 | 6.21 | 21.25 | 16.09 |
| 86 | 26 | 2 | 45.192 | 45.192 | 22.585 | 63.75 | 29.95 |
| 201 | 123 | 2 | 25.683 | 25.683 | 9.665 | 29.25 | 22.59 |
| 32 | 56 | 2 | 30.1 | 30.1 | 13.185 | 33.34 | 27.42 |
| 120 | 134 | 2 | 36.975 | 36.975 | 15.9 | 49.25 | 26.9 |
| 39 | 214 | 2 | 28.15 | 28.15 | 20.22 | 54 | 43.45 |
| 29 | 62 | 2 | 45.467 | 45.467 | 7.235 | 28.55 | 9.53 |
| 197 | 94 | 2 | 33.792 | 33.792 | 18.015 | 50.25 | 32.33 |
| 18 | 120 | 2 | 12.525 | 12.525 | 3.23 | 13 | 14.91 |
| 174 | 90 | 2 | 43.467 | 43.467 | 16.485 | 50 | 23.55 |
| 31 | 220 | 2 | 23.358 | 23.358 | 7.24 | 24.5 | 21.16 |
| 33 | 81 | 2 | 76.525 | 76.525 | 21.23 | 65.44 | 17.8 |
| 143 | 111 | 2 | 48.125 | 48.125 | 10.835 | 38.25 | 13.57 |
| 184 | 159 | 2 | 15.417 | 15.417 | 5.65 | 19 | 23.09 |
| 70 | 133 | 2 | 62.983 | 62.983 | 17.375 | 55.5 | 16.55 |