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 |
|---|---|---|---|---|---|---|---|
| 230 | 124 | 180 | 47.033 | 47.658 | 15.09 | 47.53 | 19.88 |
| 19 | 19 | 180 | 3.342 | 5.961 | 1.529 | 9.85 | 52.63 |
| 79 | 102 | 180 | 30.792 | 32.431 | 9.33 | 30.8 | 18.2 |
| 52 | 211 | 180 | 19.175 | 20.137 | 3.75 | 16.33 | 11.8 |
| 26 | 133 | 180 | 10.933 | 12.065 | 1.2 | 9.19 | 6.71 |
| 97 | 54 | 180 | 12.225 | 12.738 | 2.284 | 10.86 | 11.25 |
| 142 | 134 | 180 | 42.825 | 44.958 | 13.226 | 43.12 | 18.67 |
| 36 | 61 | 180 | 15.867 | 16.705 | 3.277 | 13.68 | 12.32 |
| 161 | 31 | 180 | 34.392 | 35.245 | 12.34 | 38.4 | 22 |
| 132 | 84 | 180 | 59.817 | 62.356 | 34.765 | 93.11 | 37.48 |
| 42 | 90 | 180 | 28.725 | 31.583 | 7.67 | 27.71 | 15.81 |
| 260 | 112 | 180 | 15.033 | 15.718 | 3.664 | 14.8 | 15.32 |
| 234 | 55 | 180 | 42.067 | 43.342 | 17.066 | 50.26 | 24.51 |
| 179 | 263 | 180 | 16.767 | 20.008 | 4.787 | 17.74 | 16.28 |
| 226 | 144 | 180 | 24.1 | 25.101 | 5.865 | 39.39 | 16.17 |
| 188 | 189 | 180 | 8.392 | 9.444 | 1.675 | 8.66 | 11.59 |
| 161 | 102 | 180 | 33.058 | 35.699 | 8.978 | 31.38 | 16.24 |
| 40 | 89 | 180 | 17.6 | 19.07 | 4.145 | 16.52 | 13.65 |
| 100 | 91 | 179 | 55.45 | 57.141 | 13.981 | 48.01 | 15.64 |
| 43 | 61 | 179 | 41.933 | 44.789 | 11.217 | 38.79 | 15.66 |
| 87 | 152 | 179 | 31.483 | 34.658 | 10.325 | 33.9 | 19.24 |
| 209 | 51 | 179 | 64.933 | 69.426 | 20.036 | 62.57 | 19.13 |
| 189 | 231 | 179 | 21.833 | 26.338 | 4.058 | 19.65 | 10.68 |
| 50 | 119 | 179 | 20.35 | 23.937 | 8.776 | 27.49 | 25.39 |
| 140 | 134 | 179 | 38.733 | 41.364 | 12.458 | 40.72 | 20.38 |