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 |
|---|---|---|---|---|---|---|---|
| 149 | 155 | 119 | 10.35 | 11.36 | 2.117 | 10.11 | 11.63 |
| 256 | 262 | 119 | 20.967 | 23.511 | 6.994 | 23.44 | 19.29 |
| 168 | 78 | 119 | 17.6 | 19.331 | 4.391 | 17.43 | 15.36 |
| 151 | 97 | 119 | 45.133 | 44.732 | 10.906 | 37.65 | 15.49 |
| 148 | 159 | 119 | 24.883 | 27.372 | 9.713 | 30.26 | 23.2 |
| 144 | 202 | 119 | 29.217 | 30.484 | 7.414 | 26.2 | 15.14 |
| 140 | 35 | 119 | 51.467 | 55.004 | 13.896 | 46.84 | 16.01 |
| 42 | 60 | 119 | 18.15 | 19.928 | 4.971 | 18.65 | 16.76 |
| 170 | 108 | 118 | 43.967 | 47.037 | 17.399 | 51.61 | 24.11 |
| 40 | 112 | 118 | 18.85 | 20.348 | 6.118 | 20.65 | 19.44 |
| 226 | 158 | 118 | 25.883 | 28.056 | 6.152 | 38.31 | 14.2 |
| 129 | 112 | 118 | 16.7 | 17.885 | 4.974 | 17.64 | 18.35 |
| 48 | 194 | 118 | 28.517 | 31.704 | 8.029 | 29.71 | 16.39 |
| 190 | 97 | 118 | 11.225 | 11.684 | 1.91 | 9.82 | 10.22 |
| 28 | 236 | 118 | 27.075 | 28.854 | 13.572 | 50.98 | 29.99 |
| 140 | 177 | 118 | 46.633 | 48.425 | 12.443 | 42.34 | 16.47 |
| 249 | 76 | 118 | 41.033 | 43.61 | 12.042 | 39.93 | 17.14 |
| 236 | 20 | 118 | 29.783 | 33.007 | 9.208 | 30.91 | 18.22 |
| 238 | 185 | 118 | 25.908 | 27.547 | 11.173 | 33.28 | 26.49 |
| 49 | 138 | 118 | 24.592 | 26.795 | 9.801 | 30.67 | 24.3 |
| 88 | 213 | 118 | 49.55 | 49.865 | 14.854 | 45.61 | 19.74 |
| 157 | 107 | 118 | 14.892 | 17.779 | 5.874 | 47.18 | 23.38 |
| 146 | 92 | 118 | 23.383 | 25.014 | 7.908 | 26.09 | 20.14 |
| 148 | 210 | 118 | 36.508 | 37.625 | 16.986 | 48.88 | 28.11 |
| 157 | 7 | 118 | 29.117 | 26.155 | 4.209 | 19.74 | 10.75 |