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 | 249 | 5 | 30.3 | 36.38 | 13.684 | 39.21 | 23.67 |
| 7 | 123 | 5 | 37.217 | 46.957 | 21.074 | 60.9 | 29.16 |
| 89 | 43 | 5 | 42.233 | 46.46 | 14.88 | 46.6 | 20.02 |
| 39 | 190 | 5 | 34.517 | 33.13 | 4.972 | 23.3 | 9.29 |
| 75 | 1 | 5 | 40.683 | 48.313 | 22.978 | 92.3 | 31.48 |
| 80 | 159 | 5 | 30.133 | 34.687 | 11.358 | 36.3 | 21.43 |
| 188 | 51 | 5 | 62.333 | 69.537 | 23.276 | 71.46 | 22.17 |
| 198 | 244 | 5 | 46.783 | 49.227 | 14.566 | 47.5 | 18.32 |
| 188 | 247 | 5 | 39.95 | 44.217 | 17.194 | 51.3 | 25.66 |
| 118 | 140 | 5 | 58.533 | 56.083 | 23.778 | 67.9 | 26.42 |
| 40 | 77 | 5 | 32.917 | 34.67 | 6.406 | 26.1 | 12.27 |
| 34 | 188 | 5 | 16 | 17.563 | 3.372 | 14.4 | 12.24 |
| 54 | 50 | 5 | 31.05 | 29.983 | 7.296 | 26.3 | 15.25 |
| 128 | 163 | 5 | 30.217 | 32.013 | 10.46 | 31.4 | 20.06 |
| 180 | 222 | 5 | 14.267 | 14.863 | 3.862 | 14.9 | 16.8 |
| 139 | 101 | 5 | 19.083 | 19.24 | 7.782 | 26.6 | 24.33 |
| 41 | 98 | 5 | 26.367 | 25.677 | 13.308 | 37.4 | 31.19 |
| 144 | 214 | 5 | 36.833 | 34.177 | 13.77 | 40.4 | 24.39 |
| 227 | 142 | 5 | 32.533 | 38.307 | 10.344 | 34.69 | 17.98 |
| 155 | 106 | 5 | 33.733 | 38.853 | 11.564 | 37.9 | 20.97 |
| 227 | 261 | 5 | 23.883 | 25.593 | 5.868 | 21.82 | 14.35 |
| 50 | 30 | 5 | 47.467 | 50.6 | 20.808 | 60.83 | 24.81 |
| 24 | 1 | 5 | 41.333 | 45.437 | 22.534 | 84.6 | 32.82 |
| 58 | 242 | 5 | 12.967 | 13.217 | 2.412 | 11.4 | 10.79 |
| 105 | 13 | 5 | 8.383 | 8.573 | 1.098 | 7.3 | 7.87 |