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 |
|---|---|---|---|---|---|---|---|
| 65 | 1 | 10 | 43.158 | 46.83 | 19.054 | 73.2 | 25.91 |
| 130 | 250 | 10 | 31.083 | 34.968 | 12.956 | 42.15 | 24.52 |
| 260 | 167 | 10 | 25.592 | 31.187 | 9.842 | 35.05 | 22.88 |
| 20 | 127 | 10 | 19.183 | 18.953 | 2.725 | 14.25 | 9.6 |
| 112 | 22 | 10 | 24.75 | 27.665 | 13.009 | 37.82 | 29.59 |
| 242 | 230 | 10 | 40.092 | 43.81 | 12.766 | 41.92 | 19.47 |
| 250 | 20 | 10 | 17.025 | 18.438 | 4.007 | 16.4 | 13.11 |
| 75 | 8 | 10 | 18.142 | 15.487 | 5.001 | 21.05 | 21.81 |
| 241 | 140 | 10 | 40.067 | 40.152 | 10.657 | 35.69 | 17.28 |
| 195 | 166 | 10 | 45.542 | 45.845 | 13.893 | 44.68 | 18.79 |
| 11 | 95 | 10 | 42.15 | 43.798 | 19.265 | 55.09 | 26.68 |
| 234 | 27 | 10 | 59.958 | 61.887 | 24.558 | 72.35 | 24.95 |
| 136 | 231 | 10 | 39.692 | 52.793 | 14.698 | 48.25 | 19.75 |
| 57 | 92 | 10 | 6.55 | 6.985 | 1.574 | 7.55 | 15.01 |
| 160 | 146 | 10 | 20.225 | 21.37 | 4.789 | 16.91 | 13.74 |
| 95 | 26 | 10 | 58.992 | 62.522 | 18.085 | 59.25 | 18.72 |
| 125 | 11 | 10 | 30.892 | 31.81 | 12.748 | 38.2 | 24.4 |
| 185 | 239 | 10 | 41.758 | 45.635 | 13.865 | 50.05 | 19.7 |
| 61 | 125 | 10 | 33.492 | 31.918 | 5.305 | 28.54 | 9.98 |
| 119 | 182 | 10 | 17.3 | 18.31 | 6.055 | 19.84 | 23.16 |
| 195 | 86 | 10 | 76.608 | 71.092 | 25.157 | 75.4 | 21.96 |
| 94 | 113 | 10 | 47.042 | 51.125 | 13.107 | 43.14 | 15.92 |
| 219 | 14 | 10 | 32.05 | 31.375 | 19.625 | 52.74 | 39.29 |
| 200 | 262 | 10 | 32.967 | 35.42 | 10.256 | 33.65 | 18.06 |
| 193 | 117 | 10 | 58.658 | 57.788 | 21.86 | 62.81 | 23.25 |