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 |
|---|---|---|---|---|---|---|---|
| 163 | 3 | 48 | 35.267 | 40.157 | 13.823 | 43.01 | 22.38 |
| 141 | 3 | 48 | 32.433 | 37.523 | 12.35 | 38.14 | 22.38 |
| 247 | 237 | 48 | 28.375 | 27.979 | 5.593 | 21.9 | 12.84 |
| 45 | 35 | 48 | 38.775 | 40.397 | 7.735 | 30.31 | 12.07 |
| 147 | 168 | 48 | 9.075 | 9.948 | 1.555 | 8.61 | 9.65 |
| 247 | 68 | 48 | 38.275 | 38.367 | 8.974 | 32.75 | 15.07 |
| 261 | 72 | 48 | 43.567 | 43.012 | 9.024 | 34.26 | 12.88 |
| 42 | 144 | 48 | 31.775 | 31.609 | 9.479 | 31.14 | 19.05 |
| 170 | 191 | 48 | 34.558 | 42.259 | 16.02 | 47.59 | 26.06 |
| 260 | 134 | 48 | 19.9 | 21.932 | 7.088 | 23.65 | 21.42 |
| 262 | 227 | 48 | 34.908 | 36.29 | 14.193 | 41.61 | 24.25 |
| 24 | 169 | 48 | 23.542 | 25.148 | 6.339 | 22.54 | 16.69 |
| 246 | 185 | 48 | 35.55 | 36.339 | 14.546 | 42.68 | 25.13 |
| 228 | 225 | 48 | 33.75 | 33.093 | 6.398 | 25.32 | 12.17 |
| 224 | 257 | 48 | 25.042 | 27.266 | 8.961 | 28.36 | 21.83 |
| 47 | 74 | 48 | 23.583 | 25.086 | 5.285 | 20.92 | 13.72 |
| 249 | 63 | 48 | 38.008 | 40.224 | 11.788 | 38.52 | 18.31 |
| 75 | 3 | 48 | 27.2 | 30.852 | 10.468 | 32.81 | 22.74 |
| 106 | 132 | 48 | 44.925 | 47.131 | 19.556 | 57.48 | 27.24 |
| 47 | 42 | 48 | 20.583 | 21.438 | 3.853 | 16.8 | 11.58 |
| 159 | 237 | 48 | 28.708 | 28.384 | 5.254 | 21.25 | 12.48 |
| 229 | 175 | 48 | 31.775 | 35.638 | 14.671 | 42.59 | 26.6 |
| 22 | 89 | 48 | 19.875 | 21.728 | 3.458 | 16.4 | 10.08 |
| 261 | 119 | 48 | 35.917 | 36.75 | 12.501 | 38.44 | 22.52 |
| 107 | 16 | 48 | 37.717 | 41.605 | 16.06 | 47.53 | 25.98 |