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 |
|---|---|---|---|---|---|---|---|
| 260 | 198 | 128 | 16.4 | 17.166 | 3.734 | 14.91 | 13.54 |
| 231 | 92 | 128 | 40.45 | 41.304 | 14.762 | 44.82 | 22.67 |
| 13 | 76 | 128 | 39.367 | 40.921 | 10.09 | 34.35 | 14.91 |
| 236 | 190 | 128 | 41.658 | 42.517 | 11.428 | 38.21 | 17.03 |
| 80 | 234 | 128 | 22.167 | 23.798 | 5.134 | 20.83 | 13.83 |
| 136 | 136 | 128 | 5.292 | 7.722 | 1.439 | 7.99 | 59.62 |
| 166 | 18 | 128 | 24.008 | 26.998 | 8.428 | 28.15 | 20.58 |
| 144 | 177 | 128 | 29.892 | 31.35 | 6.416 | 25.01 | 12.98 |
| 92 | 171 | 128 | 8.408 | 10.138 | 1.359 | 8.93 | 9.04 |
| 93 | 114 | 128 | 30.858 | 31.085 | 11.181 | 51.09 | 23.22 |
| 130 | 10 | 128 | 14.033 | 14.661 | 2.72 | 12.7 | 12.03 |
| 223 | 168 | 128 | 8.675 | 11.044 | 4.088 | 17.36 | 26.4 |
| 198 | 36 | 128 | 7.258 | 8.385 | 1.274 | 7.36 | 9.83 |
| 162 | 94 | 128 | 31.292 | 33.178 | 10.314 | 33.09 | 19.93 |
| 127 | 136 | 128 | 8.6 | 9.046 | 1.331 | 7.83 | 9.48 |
| 151 | 255 | 128 | 38.208 | 39.215 | 9.562 | 33.83 | 15.24 |
| 185 | 185 | 128 | 4.842 | 6.438 | 1.12 | 7.76 | 12.51 |
| 163 | 121 | 128 | 37.233 | 41.137 | 12.505 | 39.81 | 19.82 |
| 33 | 238 | 128 | 33.917 | 36.378 | 9.87 | 33.49 | 17.45 |
| 142 | 215 | 128 | 48.658 | 51.652 | 15.733 | 49.63 | 19.25 |
| 164 | 258 | 128 | 32.817 | 36.145 | 11.371 | 36.2 | 19.92 |
| 36 | 97 | 128 | 16.358 | 18.147 | 3.53 | 14.8 | 12.35 |
| 196 | 260 | 128 | 14.333 | 15.026 | 2.934 | 12.99 | 12.32 |
| 161 | 11 | 128 | 38.983 | 39.977 | 15.903 | 47.01 | 25.1 |
| 252 | 135 | 127 | 19.3 | 22.673 | 7.36 | 25.33 | 21.66 |