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 |
|---|---|---|---|---|---|---|---|
| 129 | 65 | 39 | 22.767 | 30.963 | 8.782 | 29.19 | 20.93 |
| 164 | 191 | 39 | 37.35 | 39.234 | 16.415 | 47.95 | 27.15 |
| 69 | 161 | 39 | 31.833 | 33.962 | 8.105 | 28.49 | 15.83 |
| 242 | 168 | 39 | 24.25 | 25.457 | 5.896 | 22.11 | 15.65 |
| 246 | 153 | 39 | 27.933 | 29.433 | 11.338 | 34.38 | 24.4 |
| 168 | 127 | 39 | 17.833 | 20.775 | 5.675 | 20.51 | 18.48 |
| 148 | 31 | 39 | 28.317 | 32.581 | 14.352 | 41.71 | 29.05 |
| 65 | 157 | 39 | 18.233 | 19.972 | 6.602 | 21.64 | 21.81 |
| 78 | 247 | 39 | 17.783 | 19.276 | 3.897 | 16.14 | 13.02 |
| 188 | 227 | 39 | 20.383 | 21.212 | 4.144 | 17.33 | 12.36 |
| 61 | 226 | 39 | 25.75 | 27.197 | 7.305 | 25 | 16.67 |
| 42 | 193 | 39 | 24.417 | 27.573 | 7.423 | 25.15 | 17.18 |
| 80 | 116 | 39 | 32.75 | 34.201 | 12.428 | 38.27 | 23.19 |
| 223 | 134 | 39 | 19.05 | 20.597 | 8.412 | 25.81 | 26.61 |
| 32 | 51 | 39 | 18.1 | 21.559 | 3.949 | 17.51 | 11.94 |
| 85 | 17 | 39 | 18.933 | 19.268 | 3.326 | 14.95 | 10.97 |
| 260 | 197 | 39 | 21.617 | 25.529 | 9.079 | 29.73 | 25.23 |
| 69 | 242 | 39 | 27.517 | 29.448 | 6.334 | 23.91 | 13.33 |
| 195 | 148 | 39 | 18.05 | 20.046 | 5.396 | 19.77 | 17.03 |
| 179 | 93 | 39 | 14.65 | 17.632 | 6.306 | 20.76 | 24.87 |
| 157 | 37 | 39 | 11.483 | 11.717 | 2.494 | 10.54 | 13.37 |
| 95 | 231 | 39 | 41.283 | 41.572 | 13.348 | 41.48 | 19.86 |
| 192 | 135 | 39 | 13.067 | 13.354 | 2.294 | 11.44 | 10.99 |
| 249 | 1 | 39 | 30.233 | 34.767 | 14.447 | 72.16 | 28.54 |
| 162 | 218 | 39 | 48.967 | 50.412 | 16.261 | 49.5 | 21.57 |