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 |
|---|---|---|---|---|---|---|---|
| 102 | 170 | 9 | 35.383 | 35.346 | 10.107 | 35.11 | 18.76 |
| 128 | 169 | 9 | 13.4 | 15.52 | 2.791 | 12.78 | 11.67 |
| 182 | 43 | 9 | 30.883 | 35.135 | 8.67 | 29.4 | 15.29 |
| 247 | 181 | 9 | 47.733 | 54.641 | 15.506 | 48.8 | 18.09 |
| 69 | 233 | 9 | 22.45 | 26.493 | 7.928 | 25.97 | 20.2 |
| 53 | 261 | 9 | 54.55 | 53.139 | 16.189 | 51.67 | 19.13 |
| 144 | 86 | 9 | 64.667 | 74.143 | 25.107 | 76.44 | 23.88 |
| 173 | 216 | 9 | 24.467 | 24.176 | 7.691 | 27.41 | 23.6 |
| 188 | 125 | 9 | 36.933 | 34.487 | 6.971 | 25.45 | 12.98 |
| 134 | 42 | 9 | 25.767 | 28.97 | 13.497 | 49 | 30.52 |
| 80 | 213 | 9 | 32.9 | 43.524 | 14.127 | 41.96 | 22.27 |
| 226 | 220 | 9 | 28.167 | 31.487 | 12.306 | 36.94 | 25.47 |
| 236 | 187 | 9 | 48.633 | 48.787 | 21.202 | 60.83 | 25.18 |
| 68 | 207 | 9 | 41.35 | 44.557 | 10.411 | 40.06 | 14.72 |
| 95 | 169 | 9 | 49.233 | 52.087 | 14.903 | 48.17 | 17.76 |
| 4 | 39 | 9 | 54.217 | 56.787 | 14.991 | 49.94 | 17.13 |
| 15 | 98 | 9 | 21.5 | 22.569 | 6.744 | 22.67 | 19.05 |
| 155 | 117 | 9 | 24.5 | 24.954 | 8.869 | 28.06 | 21.51 |
| 233 | 86 | 9 | 50.233 | 58.62 | 21.902 | 65.21 | 25.28 |
| 20 | 168 | 9 | 19.783 | 23.08 | 5.819 | 21.06 | 17.36 |
| 119 | 148 | 9 | 32.1 | 37.861 | 11.34 | 36.86 | 20.16 |
| 35 | 227 | 9 | 36.75 | 35.007 | 9.922 | 35.72 | 21.3 |
| 7 | 190 | 9 | 30.5 | 32.926 | 9.93 | 32.33 | 19.67 |
| 14 | 6 | 9 | 3.5 | 10.1 | 5.657 | 17.39 | 40.29 |
| 259 | 20 | 9 | 15.517 | 14.585 | 4.528 | 16.39 | 20.41 |