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 |
|---|---|---|---|---|---|---|---|
| 142 | 157 | 197 | 27.05 | 29.61 | 6.944 | 25.68 | 14.83 |
| 100 | 149 | 197 | 46.917 | 48.535 | 14.159 | 45.55 | 18.24 |
| 141 | 126 | 197 | 18.9 | 21.174 | 6.391 | 21.44 | 19.28 |
| 100 | 177 | 197 | 47.617 | 49.636 | 11.438 | 41.05 | 16 |
| 65 | 62 | 197 | 18.283 | 19.499 | 3.3 | 15.16 | 10.86 |
| 151 | 223 | 197 | 27.617 | 28.963 | 7.841 | 26.93 | 16.82 |
| 87 | 26 | 197 | 25.65 | 27.267 | 8.028 | 26.73 | 18.95 |
| 90 | 67 | 197 | 29.433 | 31.485 | 11.026 | 34.21 | 21.93 |
| 82 | 107 | 197 | 18.017 | 20.461 | 7.092 | 44.33 | 23.76 |
| 140 | 92 | 197 | 36.167 | 37.715 | 11.956 | 38 | 20.74 |
| 233 | 62 | 197 | 29.6 | 32.856 | 8.717 | 29.99 | 16.84 |
| 17 | 76 | 197 | 27.533 | 29.172 | 5.496 | 22.02 | 11.81 |
| 142 | 198 | 197 | 36.1 | 36.546 | 8.2 | 30.02 | 14.85 |
| 97 | 190 | 197 | 12.8 | 13.291 | 2.239 | 10.98 | 10.72 |
| 230 | 16 | 197 | 36.9 | 39.637 | 16.005 | 47.39 | 25.91 |
| 42 | 47 | 197 | 18.933 | 20.059 | 3.824 | 16.25 | 12.35 |
| 70 | 223 | 197 | 10.2 | 10.984 | 2.791 | 11.17 | 16.26 |
| 79 | 134 | 196 | 30.025 | 33.602 | 12.875 | 39.3 | 25.48 |
| 53 | 25 | 196 | 32.158 | 33.513 | 15.218 | 44.41 | 27.65 |
| 236 | 257 | 196 | 35.867 | 36.463 | 13.08 | 39.52 | 22.88 |
| 88 | 165 | 196 | 32.208 | 33.212 | 8.801 | 29.89 | 17.06 |
| 40 | 255 | 196 | 17.667 | 19.084 | 5.305 | 18.81 | 17.94 |
| 215 | 68 | 196 | 40.017 | 41.651 | 14.074 | 52.06 | 21.95 |
| 239 | 70 | 196 | 30.983 | 33.186 | 10.078 | 32.99 | 19.99 |
| 52 | 90 | 196 | 26.742 | 27.372 | 5.311 | 21.58 | 12.31 |