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 |
|---|---|---|---|---|---|---|---|
| 229 | 46 | 14 | 33.342 | 37.392 | 15.344 | 44.61 | 25.78 |
| 51 | 94 | 14 | 30.7 | 29.615 | 5.347 | 22.54 | 11.25 |
| 114 | 73 | 14 | 36.583 | 41.114 | 13.688 | 43.21 | 20.99 |
| 113 | 201 | 14 | 52.933 | 52.914 | 23.699 | 67.36 | 28.51 |
| 50 | 251 | 14 | 38.158 | 41.607 | 19.305 | 63.04 | 28.77 |
| 48 | 27 | 14 | 53.167 | 59.052 | 25.854 | 72.86 | 27.28 |
| 72 | 144 | 14 | 58.775 | 58.001 | 7.672 | 37.71 | 8.28 |
| 150 | 39 | 14 | 24.2 | 24.071 | 7.584 | 24.2 | 21.36 |
| 45 | 28 | 14 | 42.475 | 43.779 | 13.375 | 42.54 | 19.77 |
| 63 | 75 | 14 | 68.5 | 64.533 | 18.331 | 58.16 | 17.96 |
| 170 | 176 | 14 | 48.967 | 52.642 | 21.511 | 61.57 | 25.62 |
| 130 | 102 | 14 | 18.675 | 25.569 | 5.763 | 22.37 | 16.01 |
| 152 | 135 | 14 | 50.317 | 51.486 | 12.781 | 43.04 | 16.1 |
| 17 | 130 | 14 | 39.308 | 39.539 | 11.532 | 38.45 | 19.46 |
| 51 | 231 | 14 | 80.683 | 81.386 | 20.267 | 62.09 | 15.6 |
| 43 | 60 | 14 | 25.283 | 28.113 | 8.133 | 27.5 | 18.76 |
| 133 | 35 | 14 | 32.375 | 32.967 | 5.203 | 23.28 | 9.6 |
| 197 | 20 | 14 | 48.075 | 50.873 | 16.536 | 52.11 | 20.53 |
| 14 | 52 | 14 | 24.717 | 24.069 | 5.732 | 20.79 | 15.06 |
| 18 | 138 | 14 | 25.458 | 26.639 | 12.631 | 36.75 | 29.4 |
| 248 | 254 | 14 | 14.133 | 16.745 | 5.099 | 20.22 | 20.75 |
| 49 | 216 | 14 | 33.1 | 36.914 | 11.968 | 37.71 | 20.98 |
| 25 | 134 | 14 | 39.225 | 40.408 | 12.123 | 39.13 | 19.19 |
| 142 | 58 | 14 | 32.483 | 31.632 | 13.202 | 38.68 | 25.61 |
| 169 | 25 | 14 | 58.575 | 60.533 | 16.875 | 53.66 | 17.58 |