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 |
|---|---|---|---|---|---|---|---|
| 223 | 101 | 4 | 34.783 | 33.283 | 14.898 | 43.12 | 27.42 |
| 255 | 252 | 4 | 31.767 | 32.371 | 13.298 | 38.75 | 25.48 |
| 171 | 223 | 4 | 19.975 | 19.996 | 7.108 | 23.29 | 22.89 |
| 212 | 226 | 4 | 33.542 | 31.462 | 10.305 | 32.88 | 23.44 |
| 88 | 139 | 4 | 53.042 | 58.104 | 23.333 | 64.38 | 26.92 |
| 116 | 26 | 4 | 45.983 | 46.067 | 17.97 | 53.25 | 23.55 |
| 31 | 186 | 4 | 34.675 | 31.838 | 11.63 | 37 | 19.9 |
| 191 | 3 | 4 | 28.967 | 33.296 | 15.53 | 54.88 | 29.58 |
| 155 | 227 | 4 | 32.775 | 33.521 | 12.628 | 38.62 | 23.13 |
| 22 | 126 | 4 | 53.392 | 54.112 | 25.225 | 68.75 | 28.8 |
| 215 | 228 | 4 | 53.692 | 55.517 | 23.113 | 64.83 | 25.65 |
| 243 | 256 | 4 | 41.083 | 42.125 | 13.37 | 42.25 | 19.79 |
| 31 | 42 | 4 | 23.833 | 27.242 | 8.532 | 28.25 | 19.58 |
| 89 | 115 | 4 | 28.475 | 29.708 | 15.125 | 43.75 | 31.21 |
| 86 | 219 | 4 | 23.867 | 23.292 | 6.068 | 21.09 | 16.44 |
| 63 | 7 | 4 | 31.233 | 31.287 | 12.457 | 37 | 23.93 |
| 255 | 171 | 4 | 29.333 | 34.142 | 13.863 | 41 | 24.8 |
| 34 | 162 | 4 | 19.4 | 19.688 | 6.79 | 22.12 | 21.07 |
| 34 | 198 | 4 | 28.825 | 29.262 | 4.3 | 20.88 | 9.2 |
| 224 | 221 | 4 | 43.392 | 44.85 | 17.6 | 51.38 | 24.44 |
| 33 | 136 | 4 | 56.575 | 74.825 | 16.652 | 59.88 | 18.18 |
| 78 | 68 | 4 | 58.825 | 55.079 | 12.6 | 41.01 | 14.78 |
| 9 | 38 | 4 | 27.4 | 34.933 | 12.258 | 35.72 | 20.73 |
| 219 | 149 | 4 | 38.233 | 43.821 | 13.31 | 40.76 | 19.25 |
| 198 | 238 | 4 | 40.233 | 43.225 | 13.325 | 41 | 19.48 |