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 |
|---|---|---|---|---|---|---|---|
| 189 | 85 | 50 | 13.358 | 15.082 | 2.885 | 12.67 | 12.1 |
| 112 | 246 | 50 | 26.9 | 27.781 | 6.3 | 23.58 | 14.07 |
| 223 | 157 | 50 | 13.45 | 15.856 | 4.36 | 15.94 | 18.24 |
| 17 | 107 | 49 | 26.8 | 30.539 | 5.836 | 22.74 | 12.64 |
| 78 | 47 | 49 | 8.733 | 9.37 | 1.491 | 8.21 | 57.36 |
| 142 | 71 | 49 | 54.767 | 58.784 | 13.404 | 47.56 | 14.68 |
| 157 | 145 | 49 | 9.067 | 12.405 | 4.921 | 38.46 | 36.86 |
| 143 | 190 | 49 | 36.75 | 38.682 | 10.275 | 34.9 | 16.46 |
| 177 | 132 | 49 | 25 | 26.781 | 9.029 | 35.4 | 20.89 |
| 45 | 160 | 49 | 28.783 | 29.024 | 9.097 | 29.41 | 19.97 |
| 7 | 144 | 49 | 27.233 | 29.09 | 7.566 | 26.12 | 16.68 |
| 146 | 174 | 49 | 41.45 | 41.931 | 14.179 | 45.74 | 20.99 |
| 186 | 19 | 49 | 44.033 | 48.197 | 17.616 | 53.51 | 24.68 |
| 141 | 72 | 49 | 47.767 | 52.053 | 13.033 | 44.59 | 15.8 |
| 35 | 88 | 49 | 54.483 | 54.236 | 8.258 | 36.87 | 9.52 |
| 123 | 21 | 49 | 8.683 | 9.355 | 1.435 | 8.61 | 9.98 |
| 49 | 195 | 49 | 17.167 | 18.866 | 4.367 | 16.6 | 15.32 |
| 97 | 149 | 49 | 29.75 | 34.381 | 7.741 | 28.42 | 14.45 |
| 89 | 75 | 49 | 49.633 | 49.816 | 15.226 | 48.22 | 19.59 |
| 189 | 195 | 49 | 17.267 | 18.405 | 3.337 | 14.66 | 11.24 |
| 145 | 25 | 49 | 21.717 | 25.311 | 6.901 | 23.89 | 18.34 |
| 80 | 208 | 49 | 21.933 | 22.978 | 14.463 | 39.4 | 38.79 |
| 247 | 65 | 49 | 42.517 | 43.645 | 12.67 | 40.22 | 18.78 |
| 237 | 192 | 49 | 31.933 | 34.522 | 11.006 | 35.42 | 20.56 |
| 61 | 42 | 49 | 44.25 | 46.999 | 15.413 | 47.46 | 20.99 |