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 |
|---|---|---|---|---|---|---|---|
| 233 | 6 | 18 | 38.442 | 38.946 | 17.868 | 51.06 | 29 |
| 94 | 260 | 18 | 32.667 | 34.378 | 10.134 | 30.66 | 18.51 |
| 212 | 247 | 18 | 23.825 | 25.186 | 4.996 | 20.42 | 14.92 |
| 226 | 91 | 18 | 68.525 | 69.733 | 13.914 | 51.39 | 12.46 |
| 149 | 22 | 18 | 20.633 | 22.3 | 3.835 | 17.43 | 10.81 |
| 213 | 35 | 18 | 40.95 | 45.556 | 17.481 | 52.26 | 24.99 |
| 220 | 236 | 18 | 30.858 | 30.979 | 8.842 | 30.22 | 17.52 |
| 227 | 249 | 18 | 24.825 | 26.869 | 8.321 | 25.7 | 19.46 |
| 135 | 16 | 18 | 24.242 | 25.99 | 5.991 | 21.65 | 15.8 |
| 7 | 250 | 18 | 28.525 | 36.899 | 10.887 | 37.17 | 20.8 |
| 239 | 177 | 18 | 51.35 | 50.591 | 12.529 | 43.43 | 15.51 |
| 25 | 192 | 18 | 27.708 | 31.969 | 12.141 | 36.45 | 24.94 |
| 48 | 46 | 18 | 39.05 | 45.734 | 18.207 | 53.42 | 26.54 |
| 262 | 215 | 18 | 34.217 | 33.48 | 15.066 | 42.98 | 28.03 |
| 155 | 177 | 18 | 23.808 | 27.794 | 4.995 | 21.64 | 11.43 |
| 83 | 28 | 18 | 16.675 | 17.499 | 6 | 19.83 | 21.71 |
| 195 | 113 | 18 | 30.092 | 29.27 | 6.238 | 23.44 | 12.87 |
| 178 | 181 | 18 | 17.825 | 21.703 | 4.758 | 18.31 | 14.79 |
| 212 | 208 | 18 | 11.625 | 12.113 | 2.757 | 12.11 | 17.84 |
| 51 | 107 | 18 | 57.442 | 59.578 | 17.014 | 53.67 | 18.55 |
| 41 | 10 | 18 | 38.125 | 46.042 | 16.487 | 50.94 | 23.92 |
| 170 | 109 | 18 | 52.05 | 54.613 | 23.927 | 68.08 | 26.97 |
| 89 | 168 | 18 | 43.683 | 51.693 | 20.909 | 66.14 | 25.09 |
| 223 | 197 | 18 | 22.367 | 24.181 | 9.374 | 28.64 | 25.12 |
| 130 | 70 | 18 | 23.233 | 21.95 | 6.848 | 29.05 | 20.96 |