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 |
|---|---|---|---|---|---|---|---|
| 191 | 230 | 27 | 61.4 | 62.072 | 16.964 | 52.21 | 19.87 |
| 51 | 78 | 27 | 26.883 | 29.841 | 6.826 | 24.73 | 15.71 |
| 121 | 82 | 27 | 25.35 | 24.696 | 6.093 | 22.48 | 15.43 |
| 205 | 117 | 27 | 36.533 | 38.682 | 11.381 | 39.87 | 18.36 |
| 249 | 171 | 27 | 38.05 | 42.773 | 15.186 | 46.5 | 23.29 |
| 149 | 14 | 27 | 25.633 | 27.927 | 8.523 | 27.26 | 19.81 |
| 82 | 239 | 27 | 28.867 | 32.917 | 8.789 | 45.89 | 17.52 |
| 54 | 138 | 27 | 31.167 | 33.244 | 12.902 | 38 | 25.86 |
| 37 | 244 | 27 | 42.1 | 44.678 | 14.746 | 46.45 | 21.8 |
| 18 | 242 | 27 | 17.633 | 19.86 | 4.117 | 16.81 | 13.29 |
| 42 | 33 | 27 | 36.55 | 35.844 | 12.446 | 38.38 | 80.39 |
| 195 | 158 | 27 | 18.55 | 20.573 | 5.572 | 21.04 | 18.35 |
| 255 | 119 | 27 | 35.267 | 34.908 | 11.908 | 36.85 | 21.29 |
| 125 | 147 | 27 | 41.8 | 41.901 | 12.789 | 40.96 | 18.87 |
| 209 | 16 | 27 | 57.267 | 58.065 | 19.347 | 57.57 | 22.43 |
| 74 | 121 | 27 | 25.017 | 26.382 | 11.883 | 34.72 | 29.48 |
| 146 | 243 | 27 | 26.3 | 28.046 | 9.724 | 30.57 | 22.2 |
| 137 | 180 | 27 | 37.917 | 42.557 | 12.365 | 39.67 | 19.38 |
| 198 | 107 | 27 | 34.4 | 33.14 | 7.283 | 26.57 | 14.32 |
| 60 | 47 | 27 | 10.017 | 10.711 | 1.527 | 8.96 | 9.3 |
| 89 | 151 | 27 | 36.733 | 39.209 | 14.964 | 41.23 | 23.45 |
| 50 | 131 | 27 | 39.167 | 43.945 | 16.763 | 50.46 | 24.39 |
| 140 | 58 | 27 | 28.85 | 30.389 | 11.047 | 33.59 | 23.96 |
| 13 | 197 | 27 | 46.817 | 49.964 | 15.777 | 48.43 | 20.63 |
| 168 | 164 | 27 | 31.417 | 35.43 | 6.996 | 27.39 | 15.15 |