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 |
|---|---|---|---|---|---|---|---|
| 193 | 101 | 3 | 38.583 | 46.222 | 16.927 | 50 | 23.59 |
| 53 | 182 | 3 | 20.867 | 20.544 | 7.197 | 22.83 | 21.04 |
| 42 | 73 | 3 | 30.75 | 31.956 | 11.2 | 33.33 | 21.99 |
| 198 | 252 | 3 | 26.033 | 27.956 | 12 | 34.67 | 26.64 |
| 159 | 215 | 3 | 28.633 | 30.639 | 15.623 | 41.06 | 30.85 |
| 21 | 87 | 3 | 37.2 | 33.311 | 10.183 | 38.03 | 19.36 |
| 191 | 7 | 3 | 36.767 | 37.894 | 13.693 | 40.67 | 21.67 |
| 85 | 81 | 3 | 57.533 | 60.233 | 26.9 | 76.83 | 28.49 |
| 80 | 101 | 3 | 48.733 | 47.094 | 16.063 | 48.17 | 20.94 |
| 171 | 239 | 3 | 44.017 | 43.183 | 14.557 | 45.45 | 20.77 |
| 179 | 62 | 3 | 38.817 | 42.7 | 14.427 | 44.83 | 20.28 |
| 253 | 237 | 3 | 23.833 | 22.839 | 11.277 | 52 | 29.9 |
| 119 | 66 | 3 | 51.767 | 59.761 | 18.02 | 55.5 | 17.63 |
| 127 | 61 | 3 | 62.567 | 65.867 | 17.917 | 59.67 | 16.46 |
| 61 | 1 | 3 | 46.583 | 38.222 | 11.897 | 39.17 | 15.86 |
| 241 | 205 | 3 | 55.467 | 54.611 | 20.873 | 60.33 | 22.98 |
| 200 | 233 | 3 | 42.417 | 48.989 | 14.247 | 45.83 | 22.1 |
| 131 | 195 | 3 | 36.55 | 36.406 | 19.5 | 52.98 | 32.18 |
| 258 | 112 | 3 | 20.283 | 21.617 | 7.843 | 24.83 | 22.24 |
| 88 | 240 | 3 | 37.367 | 48.2 | 18.763 | 55.14 | 30.74 |
| 54 | 26 | 3 | 22.917 | 26.6 | 5.117 | 22.17 | 13.66 |
| 174 | 76 | 3 | 51.45 | 50.344 | 22.033 | 63.33 | 29.07 |
| 248 | 238 | 3 | 27.4 | 28.717 | 9.153 | 28.83 | 19.27 |
| 59 | 213 | 3 | 23.983 | 20.75 | 3.057 | 15.67 | 9.63 |
| 243 | 222 | 3 | 46.667 | 50.217 | 22.883 | 61.65 | 28.33 |