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 |
|---|---|---|---|---|---|---|---|
| 195 | 127 | 2 | 45.067 | 45.067 | 18.795 | 54.25 | 26.04 |
| 20 | 225 | 2 | 38.183 | 38.183 | 16.8 | 45.62 | 26.62 |
| 28 | 86 | 2 | 37 | 37 | 10.735 | 35.46 | 17.39 |
| 14 | 171 | 2 | 48.692 | 48.692 | 24.01 | 66.75 | 30.83 |
| 130 | 147 | 2 | 43.267 | 43.267 | 15.98 | 41.43 | 22.41 |
| 189 | 200 | 2 | 57.333 | 57.333 | 22.82 | 66.5 | 23.85 |
| 5 | 143 | 2 | 83.333 | 83.333 | 28.345 | 86 | 20.41 |
| 188 | 115 | 2 | 29.208 | 29.208 | 12.355 | 36.5 | 25.9 |
| 183 | 101 | 2 | 26.475 | 26.475 | 11.7 | 36.5 | 28.41 |
| 208 | 48 | 2 | 39.475 | 39.475 | 14.58 | 42.44 | 23.43 |
| 85 | 166 | 2 | 63.717 | 63.717 | 16.61 | 55.5 | 15.68 |
| 157 | 34 | 2 | 21.983 | 21.983 | 4.5 | 18.75 | 12.34 |
| 228 | 213 | 2 | 49.033 | 49.033 | 21.75 | 60.5 | 26.74 |
| 228 | 130 | 2 | 37.208 | 37.208 | 17.12 | 59.02 | 30.26 |
| 106 | 243 | 2 | 35.925 | 35.925 | 15.99 | 46.5 | 26.76 |
| 25 | 206 | 2 | 30.867 | 30.867 | 12.665 | 36.5 | 26.29 |
| 256 | 200 | 2 | 30.025 | 30.025 | 17.725 | 48.5 | 35.53 |
| 188 | 18 | 2 | 54.842 | 54.842 | 21.145 | 58.61 | 23.13 |
| 156 | 97 | 2 | 48.933 | 48.933 | 16.015 | 48.07 | 19.66 |
| 75 | 64 | 2 | 35.533 | 35.533 | 16.01 | 46.25 | 33.75 |
| 23 | 164 | 2 | 59.5 | 59.5 | 16.875 | 54.5 | 12.04 |
| 200 | 159 | 2 | 22.075 | 22.075 | 8.98 | 27 | 27.23 |
| 194 | 82 | 2 | 19.658 | 19.658 | 6.725 | 22.25 | 19.56 |
| 102 | 219 | 2 | 29.892 | 29.892 | 9.3 | 31 | 19.29 |
| 85 | 206 | 2 | 44.617 | 44.617 | 17.08 | 51.75 | 22.92 |