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 |
|---|---|---|---|---|---|---|---|
| 209 | 93 | 28 | 38.475 | 44.505 | 14.655 | 44.95 | 22.67 |
| 52 | 34 | 28 | 14.392 | 15.407 | 2.602 | 12.55 | 11.13 |
| 14 | 17 | 28 | 41.467 | 41.305 | 9.565 | 33.62 | 15.09 |
| 218 | 121 | 28 | 24.083 | 26.149 | 5.143 | 20.7 | 11.96 |
| 195 | 249 | 28 | 20.125 | 20.556 | 5.301 | 20.27 | 15.72 |
| 233 | 205 | 28 | 44.825 | 46.802 | 15.839 | 48.3 | 21.68 |
| 135 | 82 | 28 | 15.858 | 17.744 | 4.286 | 16.66 | 16.35 |
| 164 | 150 | 28 | 44.817 | 46.408 | 19.861 | 56.88 | 26.96 |
| 113 | 78 | 28 | 37.383 | 39.887 | 12.593 | 40.04 | 20.45 |
| 122 | 216 | 28 | 29.608 | 29.006 | 5.959 | 23.05 | 12.65 |
| 216 | 1 | 28 | 51.042 | 57.808 | 34.179 | 159.29 | 38.13 |
| 114 | 191 | 28 | 39.158 | 42.575 | 18.046 | 52.77 | 27.03 |
| 114 | 171 | 28 | 33.942 | 37.334 | 14.575 | 43.54 | 24.41 |
| 222 | 71 | 28 | 21.333 | 22.071 | 4.048 | 17.46 | 11.45 |
| 12 | 257 | 28 | 14.067 | 16.738 | 5.311 | 17.98 | 20.59 |
| 216 | 17 | 28 | 37.25 | 37.785 | 9.502 | 32.89 | 15.85 |
| 80 | 133 | 28 | 17.383 | 20.325 | 8.786 | 26.3 | 28.33 |
| 45 | 167 | 28 | 37.958 | 42.596 | 11.906 | 39.39 | 19.44 |
| 32 | 231 | 28 | 50.45 | 55.393 | 17.207 | 50.57 | 20.15 |
| 205 | 9 | 28 | 15.842 | 18.077 | 5.687 | 19.44 | 20.13 |
| 83 | 197 | 28 | 20.483 | 24.118 | 6.61 | 25.21 | 17.33 |
| 125 | 78 | 28 | 41.233 | 45.977 | 13.929 | 44.75 | 19.57 |
| 91 | 42 | 28 | 52.792 | 59.743 | 20.667 | 61.81 | 23.04 |
| 196 | 70 | 28 | 15.383 | 16.902 | 3.929 | 15.16 | 16.05 |
| 43 | 32 | 28 | 32.642 | 34.985 | 11.383 | 36.3 | 21.62 |