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 |
|---|---|---|---|---|---|---|---|
| 85 | 75 | 20 | 44.533 | 46.802 | 15.094 | 46.28 | 20.08 |
| 236 | 117 | 20 | 76.908 | 75.906 | 25.161 | 77.41 | 21.29 |
| 113 | 124 | 20 | 49.925 | 49.442 | 15.825 | 50.12 | 21.13 |
| 94 | 168 | 20 | 18.7 | 18.711 | 4.829 | 17.54 | 16.05 |
| 210 | 22 | 20 | 17.125 | 19.52 | 5.036 | 18.85 | 17.7 |
| 102 | 235 | 20 | 53.558 | 54.826 | 17.147 | 53.2 | 20.27 |
| 188 | 123 | 20 | 27.183 | 27.491 | 4.857 | 20.17 | 10.95 |
| 51 | 197 | 20 | 32.258 | 32.76 | 15.15 | 41.6 | 28.4 |
| 261 | 31 | 20 | 38.225 | 44.692 | 16.571 | 49.85 | 24.5 |
| 16 | 252 | 20 | 12.05 | 12.238 | 3.734 | 13.65 | 20.1 |
| 242 | 147 | 20 | 23.175 | 23.758 | 4.693 | 18.94 | 12.74 |
| 97 | 127 | 20 | 33.333 | 34.143 | 15.927 | 45.7 | 29.84 |
| 231 | 221 | 20 | 30.883 | 29.397 | 13.321 | 38.44 | 28.87 |
| 209 | 29 | 20 | 39.35 | 39.978 | 14.197 | 43.44 | 22.48 |
| 121 | 129 | 20 | 21.825 | 22.562 | 6.095 | 19.76 | 16.81 |
| 209 | 213 | 20 | 40.833 | 41.611 | 14.732 | 43.63 | 24.27 |
| 159 | 185 | 20 | 31.3 | 30.158 | 6.076 | 23.51 | 13.12 |
| 85 | 33 | 20 | 31.358 | 32.946 | 5.369 | 23.95 | 10.53 |
| 175 | 191 | 20 | 9.642 | 12.345 | 3.768 | 13.98 | 17.28 |
| 4 | 18 | 20 | 27.092 | 30.061 | 12.834 | 37.77 | 27.49 |
| 215 | 97 | 20 | 41.342 | 42.442 | 14.727 | 44.48 | 22.1 |
| 262 | 252 | 20 | 18.325 | 21.314 | 12.605 | 35.02 | 37.65 |
| 238 | 28 | 20 | 39.083 | 41.133 | 15.23 | 46.05 | 23.27 |
| 227 | 40 | 20 | 17.333 | 19.52 | 3.856 | 15.14 | 13.02 |
| 12 | 225 | 20 | 28.833 | 30.032 | 6.463 | 24.18 | 13.21 |