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 |
|---|---|---|---|---|---|---|---|
| 125 | 69 | 33 | 32.683 | 37.939 | 11.823 | 38.3 | 20.34 |
| 91 | 170 | 33 | 56.267 | 58.262 | 14.849 | 49.51 | 15.91 |
| 166 | 37 | 33 | 44 | 46.099 | 13.42 | 43.76 | 18.11 |
| 185 | 244 | 33 | 31.067 | 33.373 | 6.355 | 25.44 | 12.2 |
| 220 | 166 | 33 | 20.417 | 21.801 | 7.149 | 23.23 | 21.02 |
| 87 | 251 | 33 | 27.833 | 29.613 | 14.313 | 40.59 | 30.16 |
| 17 | 100 | 33 | 39.183 | 39.744 | 7.937 | 30.8 | 12.41 |
| 227 | 188 | 33 | 28.767 | 29.067 | 5.088 | 22.05 | 10.92 |
| 138 | 109 | 33 | 61.167 | 66.77 | 27.136 | 78.27 | 25.9 |
| 190 | 225 | 33 | 15.967 | 17.089 | 3.309 | 14 | 12.04 |
| 158 | 235 | 33 | 30.9 | 33.035 | 11.885 | 36.73 | 22.91 |
| 137 | 53 | 33 | 38.417 | 39.743 | 13.761 | 42.17 | 22.6 |
| 170 | 240 | 33 | 29.533 | 31.912 | 13.55 | 39.98 | 27.39 |
| 37 | 222 | 33 | 25.783 | 30.137 | 4.978 | 21.07 | 10.43 |
| 25 | 213 | 33 | 51.567 | 52.796 | 15.871 | 48.54 | 20.31 |
| 143 | 173 | 33 | 36.533 | 38.822 | 9.873 | 34.15 | 16.26 |
| 143 | 258 | 33 | 64.45 | 65.276 | 12.517 | 45.72 | 12.42 |
| 146 | 66 | 33 | 31 | 30.655 | 7.656 | 26.79 | 16.56 |
| 146 | 258 | 33 | 31.967 | 34.735 | 10.242 | 33.59 | 18.58 |
| 145 | 62 | 33 | 35.267 | 38.945 | 7.129 | 27.7 | 12.64 |
| 239 | 28 | 33 | 41.65 | 46.809 | 15.896 | 48.5 | 21.99 |
| 20 | 169 | 33 | 11.033 | 12.177 | 1.678 | 9.62 | 9.06 |
| 40 | 262 | 33 | 26.767 | 28.338 | 9.595 | 30.05 | 21.52 |
| 143 | 130 | 33 | 48.233 | 52.683 | 16.673 | 52 | 20.14 |
| 25 | 155 | 33 | 39.65 | 39.227 | 9.363 | 34.31 | 15.39 |