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 |
|---|---|---|---|---|---|---|---|
| 231 | 16 | 49 | 39.717 | 43.535 | 18.553 | 53.26 | 27.33 |
| 41 | 208 | 49 | 23.167 | 25.395 | 8.922 | 28.11 | 22.98 |
| 177 | 39 | 49 | 18.283 | 19.432 | 3.607 | 15.42 | 11.4 |
| 137 | 60 | 49 | 31.1 | 34.974 | 9.872 | 32.72 | 19.07 |
| 88 | 206 | 49 | 31.833 | 35.691 | 15.153 | 43.66 | 27.19 |
| 112 | 14 | 49 | 21.517 | 24.936 | 11.453 | 33.5 | 29.64 |
| 229 | 242 | 49 | 29.333 | 32.975 | 11.255 | 35.03 | 22.3 |
| 87 | 119 | 49 | 25.717 | 28.906 | 12.548 | 36.59 | 28.56 |
| 112 | 62 | 49 | 25.367 | 27.397 | 5.521 | 21.68 | 13.02 |
| 18 | 169 | 49 | 9.9 | 10.856 | 1.538 | 8.88 | 9.17 |
| 225 | 75 | 49 | 48.233 | 48.552 | 12.29 | 38.14 | 15.99 |
| 28 | 197 | 49 | 9.333 | 9.754 | 1.861 | 9.03 | 12.59 |
| 130 | 135 | 49 | 12.383 | 14.471 | 2.597 | 13.11 | 12.1 |
| 51 | 32 | 49 | 16.217 | 17.922 | 3.361 | 14.68 | 11.76 |
| 129 | 43 | 49 | 26.333 | 26.241 | 6.458 | 23.42 | 14.91 |
| 193 | 148 | 49 | 24.583 | 25.517 | 6.337 | 23.2 | 16.05 |
| 193 | 83 | 49 | 17.283 | 17.867 | 3.844 | 15.58 | 13.35 |
| 232 | 235 | 49 | 26.983 | 29.367 | 12.376 | 36.26 | 27.84 |
| 38 | 191 | 49 | 11.3 | 12.018 | 2.351 | 11.33 | 11.87 |
| 260 | 256 | 49 | 15.117 | 16.438 | 4.622 | 17.42 | 21.51 |
| 147 | 74 | 49 | 13.067 | 16.271 | 3.555 | 14.8 | 14.6 |
| 28 | 216 | 49 | 16.083 | 17.505 | 3.87 | 16.97 | 14.51 |
| 116 | 125 | 49 | 26.717 | 29.754 | 8.482 | 28.79 | 18.29 |
| 261 | 197 | 49 | 41.867 | 48.137 | 16.194 | 49.17 | 21.84 |
| 144 | 212 | 49 | 28.733 | 30.035 | 12.561 | 37.46 | 26.75 |