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 |
|---|---|---|---|---|---|---|---|
| 92 | 14 | 3 | 49.8 | 53.511 | 21.897 | 62.17 | 25.07 |
| 61 | 83 | 3 | 28.85 | 35.678 | 8.61 | 33.57 | 16.06 |
| 108 | 257 | 3 | 22.867 | 22.872 | 5.267 | 21.03 | 13.81 |
| 182 | 209 | 3 | 37 | 40.483 | 15.253 | 45.5 | 25.06 |
| 121 | 155 | 3 | 42.117 | 43.044 | 16.11 | 48.56 | 24.49 |
| 112 | 167 | 3 | 47.783 | 44.306 | 13.4 | 44.83 | 18.95 |
| 119 | 25 | 3 | 60.983 | 60.55 | 14.63 | 49 | 14.5 |
| 76 | 114 | 3 | 45.567 | 67.989 | 14.323 | 50.66 | 14.69 |
| 166 | 73 | 3 | 40 | 48.067 | 12.91 | 43.33 | 18.72 |
| 149 | 234 | 3 | 41.133 | 45.911 | 12.597 | 35.92 | 17.35 |
| 18 | 142 | 3 | 31.217 | 33.972 | 11.503 | 36.33 | 22 |
| 40 | 127 | 3 | 48.25 | 48.844 | 17.713 | 52.33 | 21.8 |
| 18 | 79 | 3 | 36.75 | 39.161 | 13.953 | 42.17 | 21.88 |
| 229 | 27 | 3 | 49.5 | 52.033 | 25.587 | 70.17 | 29.91 |
| 124 | 263 | 3 | 66.133 | 47.589 | 9.733 | 36.83 | 10.65 |
| 85 | 40 | 3 | 21.083 | 20.961 | 4.313 | 17.83 | 12.41 |
| 3 | 193 | 3 | 44.367 | 43.217 | 14.47 | 44.5 | 20.49 |
| 217 | 263 | 3 | 43.1 | 34.122 | 6.847 | 26.17 | 13.86 |
| 63 | 91 | 3 | 29.267 | 25.883 | 7.13 | 25.17 | 18.62 |
| 12 | 177 | 3 | 34.6 | 37.022 | 8.807 | 31.33 | 14.59 |
| 123 | 263 | 3 | 51.8 | 48.917 | 15.967 | 49.33 | 19.79 |
| 119 | 52 | 3 | 40.817 | 41.456 | 15.98 | 46.33 | 23.38 |
| 81 | 249 | 3 | 47.033 | 51.75 | 18.017 | 51.46 | 21.44 |
| 47 | 228 | 3 | 42.55 | 48.161 | 20.467 | 58.67 | 26.4 |
| 193 | 208 | 3 | 26.617 | 25.961 | 13.18 | 37.5 | 30.59 |