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 |
|---|---|---|---|---|---|---|---|
| 146 | 255 | 247 | 17.417 | 18.165 | 3.575 | 15.06 | 12.15 |
| 247 | 75 | 247 | 15.233 | 16.678 | 3.31 | 14 | 13.24 |
| 230 | 135 | 247 | 34.183 | 37.122 | 12.106 | 38.31 | 21.27 |
| 234 | 157 | 247 | 23.583 | 25.955 | 7.153 | 24.87 | 17.62 |
| 145 | 75 | 247 | 18.15 | 20.055 | 4.802 | 17.84 | 16.17 |
| 138 | 117 | 247 | 48.4 | 50.435 | 18.904 | 56.05 | 32.46 |
| 209 | 244 | 247 | 31.567 | 35.501 | 12.26 | 38.03 | 23.34 |
| 137 | 106 | 247 | 24.6 | 26.132 | 7.516 | 25.14 | 18.32 |
| 238 | 65 | 246 | 33.45 | 34.772 | 9.832 | 32.82 | 18.13 |
| 224 | 112 | 246 | 19.717 | 20.961 | 5.05 | 19.01 | 15.3 |
| 166 | 4 | 246 | 30.275 | 31.445 | 8.012 | 28.16 | 16.15 |
| 230 | 76 | 246 | 50.842 | 55.786 | 15.899 | 51.3 | 18.73 |
| 181 | 162 | 246 | 26.242 | 28.696 | 7.931 | 27.26 | 18.12 |
| 140 | 165 | 246 | 46.875 | 49.048 | 14.663 | 46.89 | 19.07 |
| 25 | 90 | 246 | 21.35 | 22.898 | 4.714 | 18.97 | 13.24 |
| 230 | 3 | 246 | 32.933 | 35.541 | 14.102 | 41.52 | 24.98 |
| 12 | 132 | 246 | 52.708 | 56.968 | 22.463 | 52.8 | 28.68 |
| 40 | 132 | 246 | 40.842 | 43.345 | 21.746 | 59.99 | 32.35 |
| 135 | 95 | 246 | 8.142 | 9.157 | 1.763 | 8.76 | 13.42 |
| 145 | 231 | 246 | 25.325 | 27.227 | 6.887 | 41.27 | 16.2 |
| 65 | 142 | 245 | 30.233 | 31.73 | 7.789 | 27.92 | 15.91 |
| 232 | 166 | 245 | 31.7 | 32.121 | 8.876 | 29.94 | 17.65 |
| 236 | 188 | 245 | 45.983 | 47.613 | 12.406 | 41.79 | 16.6 |
| 166 | 232 | 245 | 31.45 | 32.743 | 8.878 | 30.33 | 17.26 |
| 74 | 82 | 245 | 19.6 | 21.885 | 7.375 | 23.93 | 22.08 |