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 |
|---|---|---|---|---|---|---|---|
| 237 | 190 | 140 | 41.75 | 42.479 | 10.831 | 37.56 | 17.07 |
| 143 | 61 | 140 | 46.108 | 47.94 | 10.668 | 38.38 | 14.1 |
| 88 | 67 | 140 | 22.5 | 25.66 | 8.604 | 27.38 | 22.29 |
| 45 | 146 | 140 | 29.208 | 31.856 | 7.762 | 27.68 | 16.03 |
| 247 | 167 | 140 | 10.433 | 10.989 | 1.68 | 9.11 | 9.8 |
| 130 | 28 | 140 | 6.725 | 8.35 | 1.557 | 9.51 | 12.72 |
| 238 | 82 | 140 | 33.417 | 34.436 | 8.83 | 30.72 | 16.61 |
| 231 | 123 | 140 | 31.75 | 34.17 | 10.73 | 34.43 | 20.28 |
| 69 | 47 | 140 | 8.133 | 9.343 | 1.434 | 8.29 | 9.54 |
| 195 | 40 | 140 | 6.683 | 8.02 | 1.562 | 7.74 | 11.44 |
| 107 | 212 | 140 | 27.908 | 30.475 | 10.798 | 33.39 | 23.01 |
| 249 | 149 | 140 | 35.408 | 38.262 | 12.258 | 38.53 | 19.79 |
| 45 | 226 | 140 | 24.042 | 26.126 | 7.374 | 25.15 | 18.78 |
| 113 | 165 | 140 | 39.008 | 40.3 | 10.832 | 36.41 | 17.18 |
| 181 | 198 | 140 | 26.233 | 28.6 | 6.781 | 24.49 | 14.96 |
| 66 | 14 | 140 | 17.708 | 20.557 | 7.461 | 23.59 | 24.74 |
| 40 | 48 | 140 | 29.017 | 30.345 | 7.431 | 27.12 | 15.61 |
| 65 | 133 | 140 | 17.317 | 19.831 | 5.735 | 20.2 | 19.26 |
| 62 | 17 | 140 | 11.2 | 12.578 | 2.057 | 10.47 | 10.69 |
| 87 | 98 | 140 | 57.767 | 58.793 | 16.664 | 53.59 | 19.01 |
| 255 | 34 | 140 | 11.8 | 12.561 | 2.13 | 10.31 | 11.16 |
| 232 | 14 | 140 | 25.408 | 27.647 | 10.383 | 31.76 | 24.11 |
| 228 | 25 | 140 | 14.208 | 16.53 | 2.868 | 13.74 | 11.37 |
| 244 | 213 | 140 | 20.367 | 22.678 | 7.108 | 23.38 | 20.51 |
| 256 | 239 | 139 | 30.367 | 32.847 | 8.168 | 28.61 | 15.83 |