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 |
|---|---|---|---|---|---|---|---|
| 171 | 50 | 5 | 64.817 | 65.44 | 18.408 | 61.7 | 17.13 |
| 49 | 124 | 5 | 36.083 | 38.353 | 9.02 | 32.7 | 13.77 |
| 18 | 116 | 5 | 20.7 | 20.777 | 5.704 | 19.83 | 17.64 |
| 118 | 7 | 5 | 81.417 | 80.433 | 33.192 | 94.1 | 24.95 |
| 35 | 119 | 5 | 48.5 | 50.507 | 20.904 | 54.9 | 26.15 |
| 121 | 222 | 5 | 29.9 | 30.877 | 11.026 | 33.63 | 23.28 |
| 252 | 78 | 5 | 31.317 | 33.007 | 9.184 | 31.7 | 18.49 |
| 217 | 229 | 5 | 38.083 | 36.34 | 7.148 | 28.8 | 13.67 |
| 108 | 181 | 5 | 28.167 | 27.833 | 6.508 | 21.02 | 14.22 |
| 179 | 39 | 5 | 68.25 | 64.647 | 13.498 | 50.3 | 15.56 |
| 26 | 88 | 5 | 30.283 | 35.203 | 8.936 | 30.16 | 16.04 |
| 217 | 130 | 5 | 34.05 | 35.443 | 12.028 | 37.4 | 21.27 |
| 124 | 102 | 5 | 20.6 | 20.757 | 4.754 | 18.5 | 14.39 |
| 256 | 124 | 5 | 57.95 | 56.07 | 16.326 | 56.2 | 19.04 |
| 78 | 184 | 5 | 15.217 | 17.21 | 8.124 | 24.5 | 32.2 |
| 159 | 194 | 5 | 12.25 | 12.52 | 3.412 | 12.9 | 16.59 |
| 207 | 40 | 5 | 22.617 | 22.41 | 10.926 | 43.8 | 30.99 |
| 33 | 86 | 5 | 58.183 | 60.777 | 26.624 | 75.2 | 26.46 |
| 139 | 17 | 5 | 39.55 | 37.207 | 13.054 | 37.94 | 21.77 |
| 15 | 234 | 5 | 46.967 | 48.803 | 15.818 | 47.26 | 20.94 |
| 213 | 153 | 5 | 29.967 | 31.277 | 8.276 | 27.42 | 16.24 |
| 208 | 261 | 5 | 68.6 | 65.07 | 17.792 | 57.2 | 17.04 |
| 21 | 13 | 5 | 22.05 | 21.563 | 11.59 | 48.1 | 32.48 |
| 216 | 47 | 5 | 46.083 | 46.803 | 18.564 | 53.73 | 24.04 |
| 114 | 204 | 5 | 44.45 | 45.973 | 26.08 | 71.2 | 34.46 |