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 |
|---|---|---|---|---|---|---|---|
| 244 | 47 | 117 | 17.267 | 17.771 | 3.53 | 14.64 | 13.58 |
| 229 | 119 | 117 | 20.25 | 24.71 | 7.121 | 24.11 | 20.18 |
| 50 | 174 | 117 | 25.817 | 28.977 | 13.296 | 38.93 | 29.64 |
| 146 | 80 | 117 | 17.75 | 19.152 | 3.964 | 16.16 | 12.94 |
| 238 | 228 | 117 | 40.083 | 40.88 | 12.525 | 40.05 | 19.16 |
| 74 | 32 | 117 | 21.033 | 24.166 | 8.088 | 26.08 | 22.56 |
| 25 | 151 | 117 | 36.083 | 37.65 | 10.241 | 34.61 | 17.44 |
| 137 | 169 | 117 | 25.917 | 27.906 | 10.155 | 31.23 | 24.35 |
| 39 | 155 | 117 | 12.867 | 13.41 | 3.102 | 13.3 | 15.23 |
| 209 | 86 | 117 | 82.1 | 83.908 | 28.354 | 84.15 | 20.96 |
| 230 | 120 | 117 | 21.2 | 23.78 | 8.061 | 26.32 | 22.08 |
| 244 | 153 | 117 | 15.383 | 16.828 | 3.856 | 15.44 | 14.64 |
| 162 | 124 | 117 | 42.25 | 45.7 | 13.586 | 44.07 | 19.1 |
| 216 | 10 | 117 | 8.383 | 8.477 | 1.933 | 14.33 | 25.32 |
| 255 | 75 | 117 | 25.067 | 27.588 | 8.291 | 27.33 | 19.02 |
| 234 | 126 | 117 | 30.45 | 34.447 | 10.148 | 33.21 | 19.26 |
| 76 | 65 | 117 | 46.25 | 45.738 | 7.258 | 30.48 | 10.03 |
| 223 | 68 | 117 | 35.6 | 37.796 | 8.964 | 33.95 | 15.79 |
| 163 | 67 | 117 | 39.733 | 41.57 | 13.966 | 43.3 | 21.18 |
| 25 | 26 | 117 | 23.183 | 23.737 | 5.54 | 20.76 | 14.69 |
| 68 | 28 | 117 | 34.2 | 37.525 | 13.141 | 40.83 | 22.77 |
| 162 | 182 | 117 | 28.333 | 31.967 | 10.905 | 33.96 | 22.34 |
| 42 | 113 | 117 | 34.417 | 36.475 | 8.125 | 29.59 | 14.85 |
| 42 | 212 | 117 | 15.467 | 17.705 | 5.623 | 19.09 | 21.02 |
| 145 | 160 | 117 | 16.617 | 18.026 | 5.444 | 19.44 | 20.32 |