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 |
|---|---|---|---|---|---|---|---|
| 146 | 61 | 52 | 33.883 | 37.229 | 7.392 | 28.44 | 12.83 |
| 157 | 113 | 52 | 19.258 | 20.061 | 6.628 | 49.08 | 21.41 |
| 69 | 147 | 52 | 10.583 | 12.458 | 1.997 | 10.17 | 10.06 |
| 197 | 75 | 52 | 35.85 | 37.321 | 14.271 | 43.99 | 25.39 |
| 142 | 171 | 52 | 42.792 | 44.676 | 13.679 | 44.38 | 19.63 |
| 114 | 55 | 52 | 34.542 | 36.137 | 15.664 | 45.47 | 27 |
| 213 | 174 | 52 | 17.1 | 19.732 | 5.579 | 19.91 | 18.77 |
| 234 | 78 | 52 | 35.383 | 37.498 | 12.06 | 38.56 | 21.95 |
| 143 | 254 | 52 | 31.942 | 36.395 | 13.773 | 43.79 | 25.31 |
| 140 | 222 | 52 | 62.833 | 65.768 | 20.315 | 62.65 | 20.19 |
| 91 | 62 | 52 | 21.475 | 21.468 | 3.93 | 16.5 | 11.44 |
| 233 | 31 | 52 | 28.75 | 31.832 | 11.478 | 34.93 | 23.38 |
| 62 | 88 | 52 | 41.8 | 42.65 | 6.059 | 29.02 | 8.76 |
| 141 | 29 | 52 | 41.75 | 43.26 | 19.969 | 56.61 | 29.65 |
| 188 | 48 | 52 | 43.042 | 44.808 | 10.509 | 36.59 | 14.89 |
| 141 | 240 | 52 | 22.4 | 24.069 | 11.391 | 33.04 | 29.82 |
| 66 | 151 | 52 | 28.633 | 31.154 | 10.139 | 32.34 | 21.81 |
| 43 | 1 | 52 | 45.958 | 47.433 | 19.135 | 86.38 | 26.85 |
| 168 | 151 | 52 | 18.792 | 19.806 | 3.524 | 15.92 | 11.38 |
| 261 | 135 | 52 | 39.892 | 42.423 | 14.743 | 45.01 | 21.93 |
| 35 | 137 | 52 | 44.175 | 45.702 | 10.858 | 37.17 | 15.59 |
| 232 | 190 | 52 | 24.133 | 25.495 | 5.801 | 22.05 | 14.41 |
| 144 | 191 | 52 | 42.667 | 46.341 | 18.361 | 52.5 | 24.84 |
| 223 | 113 | 52 | 31.492 | 32.234 | 8.841 | 29.91 | 17.52 |
| 216 | 180 | 52 | 8.775 | 11.287 | 2.11 | 11.25 | 13.38 |