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 |
|---|---|---|---|---|---|---|---|
| 232 | 251 | 3 | 28.55 | 39.006 | 18.417 | 50.5 | 31.06 |
| 86 | 213 | 3 | 52.117 | 51.639 | 22.287 | 63.5 | 25.89 |
| 195 | 213 | 3 | 55.533 | 55.328 | 18.737 | 55.17 | 22.35 |
| 12 | 206 | 3 | 30 | 31.178 | 13.933 | 40.33 | 27.02 |
| 165 | 36 | 3 | 52.65 | 51.222 | 7.85 | 32.93 | 9.23 |
| 168 | 117 | 3 | 54.233 | 69.122 | 23.003 | 70.67 | 22.47 |
| 133 | 129 | 3 | 23.367 | 32.206 | 13.307 | 39.67 | 30.34 |
| 57 | 43 | 3 | 56.05 | 57.294 | 11.463 | 41.17 | 12.21 |
| 43 | 122 | 3 | 36.8 | 35.428 | 15.963 | 45.33 | 27.49 |
| 135 | 13 | 3 | 52.133 | 50.639 | 24.8 | 68.5 | 29.02 |
| 195 | 146 | 3 | 29.783 | 28.661 | 9.11 | 29 | 19.16 |
| 248 | 225 | 3 | 36 | 38.117 | 17.757 | 52.03 | 28.91 |
| 227 | 229 | 3 | 35.667 | 36.572 | 11.76 | 36.22 | 19.51 |
| 252 | 13 | 3 | 69.783 | 64 | 19.513 | 61 | 19.71 |
| 55 | 235 | 3 | 83.683 | 92.006 | 26.343 | 80.31 | 17.67 |
| 248 | 97 | 3 | 62.5 | 63.517 | 16.707 | 58 | 16.58 |
| 121 | 233 | 3 | 41.4 | 47.106 | 12.12 | 40.67 | 16.02 |
| 54 | 22 | 3 | 19.517 | 18.872 | 6.877 | 21.17 | 22.99 |
| 222 | 186 | 3 | 48 | 46.356 | 20.303 | 54.25 | 27.44 |
| 188 | 20 | 3 | 45.533 | 52.067 | 22.593 | 63.42 | 26.96 |
| 183 | 184 | 3 | 6.583 | 9.506 | 1.133 | 8 | 9.22 |
| 205 | 15 | 3 | 26.783 | 27.522 | 8 | 27.17 | 17.53 |
| 31 | 200 | 3 | 18.75 | 18.967 | 5.28 | 18.83 | 16.78 |
| 128 | 143 | 3 | 19.35 | 21.75 | 8.383 | 26.83 | 23.64 |
| 129 | 32 | 3 | 19.433 | 30.772 | 11.907 | 36.5 | 29.3 |