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 |
|---|---|---|---|---|---|---|---|
| 260 | 235 | 7 | 16.667 | 20.21 | 10.911 | 31.14 | 34.14 |
| 195 | 7 | 7 | 32.967 | 34.579 | 10.189 | 32.71 | 18.58 |
| 9 | 198 | 7 | 36.133 | 33.574 | 8.186 | 30.71 | 15.99 |
| 213 | 82 | 7 | 36.533 | 38.352 | 10.859 | 38.5 | 21.64 |
| 78 | 77 | 7 | 56.833 | 59.043 | 19.833 | 61.21 | 20.86 |
| 123 | 217 | 7 | 35.433 | 34.614 | 9.429 | 31.93 | 18.33 |
| 26 | 160 | 7 | 64.767 | 65.395 | 15.316 | 52.86 | 14.75 |
| 224 | 165 | 7 | 30.117 | 35.088 | 11.96 | 37.29 | 21.32 |
| 183 | 170 | 7 | 31.433 | 39.46 | 14.271 | 42.82 | 24.95 |
| 180 | 165 | 7 | 29.15 | 28.769 | 9.647 | 30.77 | 20.98 |
| 146 | 16 | 7 | 38.1 | 37.419 | 13.809 | 41.29 | 24.13 |
| 147 | 250 | 7 | 18.35 | 19.214 | 4.131 | 17.14 | 13.73 |
| 70 | 125 | 7 | 31.567 | 37.164 | 12.043 | 38.5 | 20.8 |
| 177 | 56 | 7 | 20.5 | 22.383 | 9.626 | 28.5 | 26.43 |
| 127 | 148 | 7 | 38.717 | 36.171 | 11.933 | 37.71 | 19.65 |
| 36 | 165 | 7 | 29.917 | 31.66 | 11.411 | 35.21 | 22.28 |
| 235 | 229 | 7 | 41.817 | 41.836 | 8.919 | 33 | 13.73 |
| 130 | 112 | 7 | 32.117 | 38.562 | 16.154 | 44.73 | 24.81 |
| 123 | 141 | 7 | 61.8 | 61.181 | 16.49 | 51.47 | 16.42 |
| 77 | 117 | 7 | 42.983 | 45.417 | 12.941 | 43.14 | 18.19 |
| 149 | 41 | 7 | 64.25 | 61.217 | 27.157 | 76.71 | 28.29 |
| 51 | 127 | 7 | 32.717 | 38.393 | 10.29 | 35 | 16.21 |
| 74 | 26 | 7 | 55.333 | 59.398 | 16.966 | 55.36 | 18.92 |
| 262 | 139 | 7 | 37.567 | 42.193 | 20.78 | 57.5 | 32.04 |
| 190 | 43 | 7 | 41.3 | 41.052 | 10.891 | 37.43 | 16.58 |