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 |
|---|---|---|---|---|---|---|---|
| 42 | 4 | 126 | 24.233 | 27.475 | 8.384 | 27.11 | 20.64 |
| 107 | 91 | 126 | 48.267 | 50.864 | 13.001 | 44.01 | 16.13 |
| 107 | 136 | 126 | 30.058 | 34.194 | 11.683 | 35.98 | 23.65 |
| 235 | 244 | 126 | 12.383 | 13.765 | 2.167 | 11.21 | 10.64 |
| 119 | 247 | 126 | 6.55 | 7.307 | 1.141 | 6.93 | 10.5 |
| 140 | 185 | 126 | 32.592 | 34.695 | 10.558 | 34.01 | 19.8 |
| 28 | 263 | 126 | 24.8 | 25.786 | 13.494 | 51.51 | 33.11 |
| 262 | 119 | 126 | 13.517 | 17.779 | 4.943 | 17.69 | 20.37 |
| 263 | 60 | 126 | 21.2 | 24.119 | 6.616 | 23 | 18.18 |
| 144 | 56 | 125 | 24.767 | 27.518 | 9.974 | 31.43 | 23.97 |
| 262 | 49 | 125 | 30.567 | 31.459 | 9.824 | 31.34 | 19.41 |
| 93 | 232 | 125 | 24.367 | 25.81 | 10.852 | 49.89 | 27.94 |
| 209 | 133 | 125 | 19.167 | 21.898 | 7.067 | 23.51 | 22.08 |
| 143 | 159 | 125 | 23.217 | 25.32 | 6.975 | 23.93 | 17.41 |
| 7 | 168 | 125 | 14.517 | 16.767 | 5.041 | 17.6 | 19.87 |
| 39 | 71 | 125 | 16.3 | 17.175 | 3.074 | 13.92 | 11.29 |
| 66 | 43 | 125 | 29.233 | 29.49 | 8.341 | 28.25 | 17.99 |
| 129 | 107 | 125 | 23.05 | 26.879 | 7.332 | 25.17 | 18.44 |
| 68 | 55 | 125 | 38.55 | 40.989 | 17.107 | 49.97 | 26.23 |
| 79 | 241 | 125 | 28.95 | 31.129 | 13.703 | 39.81 | 28.24 |
| 47 | 47 | 125 | 3.5 | 6.941 | 1.162 | 7.31 | 48.14 |
| 76 | 37 | 125 | 23.567 | 24.822 | 4.114 | 18.08 | 10.34 |
| 136 | 42 | 125 | 18.117 | 19.156 | 4.734 | 17.99 | 15.85 |
| 223 | 79 | 125 | 26.383 | 27.675 | 8.441 | 28.78 | 20.04 |
| 130 | 140 | 125 | 31.683 | 34.099 | 14.609 | 51.67 | 28.31 |