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 |
|---|---|---|---|---|---|---|---|
| 248 | 132 | 6 | 34.742 | 33.719 | 19.73 | 53.08 | 36.78 |
| 65 | 180 | 6 | 34.55 | 37.519 | 13.093 | 39.67 | 22.14 |
| 212 | 186 | 6 | 38.925 | 38.622 | 10.472 | 32.99 | 17.24 |
| 33 | 1 | 6 | 38.517 | 37.678 | 18.598 | 67.33 | 29.88 |
| 32 | 87 | 6 | 61.658 | 65.078 | 16.995 | 56.92 | 15.92 |
| 51 | 82 | 6 | 34.567 | 37.669 | 13.945 | 41.42 | 22.78 |
| 171 | 131 | 6 | 24.433 | 29.939 | 7.228 | 26.75 | 14.6 |
| 65 | 167 | 6 | 30.542 | 31.164 | 13.585 | 39.4 | 27.25 |
| 74 | 192 | 6 | 19.092 | 25.858 | 10.532 | 31.25 | 28.75 |
| 153 | 195 | 6 | 44.858 | 36.533 | 16.78 | 53.67 | 46.44 |
| 65 | 32 | 6 | 53.083 | 57.653 | 20.128 | 60.08 | 24.16 |
| 36 | 10 | 6 | 38.408 | 36.017 | 10.148 | 31.58 | 18.54 |
| 195 | 136 | 6 | 79.417 | 76.594 | 18.985 | 66.67 | 17.02 |
| 166 | 102 | 6 | 38.225 | 37.356 | 15.175 | 45.5 | 25.41 |
| 108 | 258 | 6 | 27.708 | 31.486 | 13.95 | 40.76 | 28.41 |
| 86 | 163 | 6 | 63.058 | 61.233 | 21.575 | 65.97 | 20.83 |
| 152 | 3 | 6 | 27.783 | 29.9 | 10.612 | 32.92 | 22.96 |
| 198 | 180 | 6 | 20.775 | 20.544 | 4.188 | 16.58 | 12.44 |
| 57 | 82 | 6 | 9.525 | 11.05 | 1.948 | 9.33 | 10.82 |
| 72 | 108 | 6 | 27.933 | 28.186 | 8.078 | 28.1 | 17.62 |
| 237 | 57 | 6 | 41.917 | 40.936 | 9.318 | 34.5 | 15.14 |
| 160 | 138 | 6 | 15.558 | 18.447 | 5.873 | 20.08 | 20.17 |
| 151 | 1 | 6 | 41.783 | 44.675 | 19.912 | 62.08 | 28.12 |
| 121 | 188 | 6 | 31.375 | 35.458 | 10.117 | 33.68 | 17.7 |
| 257 | 113 | 6 | 37.642 | 38.222 | 7.827 | 29.83 | 12.32 |