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 |
|---|---|---|---|---|---|---|---|
| 43 | 177 | 27 | 45.2 | 51.149 | 12.917 | 44.65 | 16.45 |
| 219 | 246 | 27 | 51.933 | 53.731 | 16.175 | 52.02 | 19.32 |
| 77 | 97 | 27 | 32.8 | 34.378 | 5.776 | 24.43 | 10.72 |
| 87 | 6 | 27 | 26.117 | 27.572 | 11.796 | 34.8 | 27.1 |
| 133 | 33 | 27 | 14.717 | 17.452 | 4.654 | 16.91 | 19.28 |
| 249 | 73 | 27 | 34.1 | 35.817 | 13.771 | 41.65 | 23.89 |
| 131 | 19 | 27 | 11.1 | 11.632 | 4.66 | 15.35 | 25.63 |
| 209 | 222 | 27 | 53.033 | 53.983 | 16.512 | 53.04 | 19.41 |
| 236 | 35 | 27 | 54.517 | 58.264 | 16.112 | 52.31 | 17.38 |
| 87 | 31 | 27 | 33.6 | 42.312 | 16.179 | 47.69 | 26.45 |
| 4 | 213 | 27 | 28.333 | 33.264 | 11.684 | 35.47 | 24.08 |
| 260 | 17 | 27 | 27.067 | 28.046 | 6.925 | 24.74 | 16.62 |
| 250 | 78 | 27 | 14.35 | 15.673 | 3.028 | 13.19 | 12.43 |
| 217 | 160 | 27 | 29.483 | 30.868 | 6.726 | 25.11 | 15.34 |
| 72 | 75 | 27 | 60.1 | 57.269 | 17.105 | 53.88 | 18.57 |
| 129 | 125 | 27 | 42.8 | 45.886 | 9.972 | 35.67 | 14.1 |
| 223 | 89 | 27 | 44.7 | 45.993 | 15.12 | 47.28 | 23.27 |
| 37 | 82 | 27 | 20.967 | 22.424 | 5.856 | 20.98 | 16.38 |
| 166 | 227 | 27 | 47.65 | 50.011 | 15.246 | 48.33 | 19.07 |
| 235 | 60 | 27 | 17.35 | 18.163 | 3.511 | 15.31 | 12.24 |
| 69 | 243 | 27 | 17.483 | 18.44 | 3.019 | 14.48 | 10.41 |
| 43 | 34 | 27 | 35.033 | 37.045 | 9.636 | 33.57 | 16.75 |
| 91 | 230 | 27 | 56.283 | 58.464 | 14.438 | 49.31 | 15.87 |
| 194 | 127 | 27 | 14.633 | 18.867 | 7.186 | 48.35 | 26.67 |
| 244 | 260 | 27 | 25.8 | 26.119 | 9.278 | 29.2 | 22.55 |