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 |
|---|---|---|---|---|---|---|---|
| 101 | 131 | 19 | 12.333 | 14.845 | 4.988 | 16.66 | 21.5 |
| 63 | 65 | 19 | 39.883 | 41.435 | 6.946 | 28.65 | 10.59 |
| 216 | 179 | 19 | 29.583 | 32.125 | 12.18 | 36.39 | 24.56 |
| 42 | 62 | 19 | 47.417 | 49.99 | 15.681 | 47.98 | 20.6 |
| 215 | 25 | 18 | 54.258 | 56.362 | 15.771 | 50.54 | 19.13 |
| 247 | 31 | 18 | 20.292 | 21.212 | 7.135 | 23.11 | 21.12 |
| 256 | 258 | 18 | 26.867 | 32.485 | 8.829 | 29.72 | 18.01 |
| 77 | 91 | 18 | 19.525 | 21.419 | 3.904 | 17.08 | 11.3 |
| 50 | 109 | 18 | 54.417 | 57.874 | 23.461 | 71.53 | 24.96 |
| 24 | 185 | 18 | 32.683 | 32.367 | 10.424 | 33.33 | 21.05 |
| 114 | 98 | 18 | 31.717 | 32.597 | 14.132 | 41.17 | 26.35 |
| 243 | 208 | 18 | 25.975 | 27.158 | 8.924 | 29.99 | 21.25 |
| 197 | 131 | 18 | 17.592 | 18.298 | 3.849 | 15.77 | 12.66 |
| 223 | 189 | 18 | 29.875 | 33.988 | 9.439 | 32.06 | 18.99 |
| 17 | 227 | 18 | 24.675 | 25.545 | 7.828 | 26.1 | 20.33 |
| 36 | 217 | 18 | 13.242 | 14.306 | 2.307 | 11.44 | 10.47 |
| 18 | 220 | 18 | 13.183 | 13.243 | 2.494 | 11.54 | 11.07 |
| 98 | 82 | 18 | 16.3 | 19.68 | 6.391 | 20.99 | 21.01 |
| 241 | 74 | 18 | 29.475 | 29.378 | 7.153 | 26.06 | 15.63 |
| 39 | 205 | 18 | 30.175 | 35.696 | 11.1 | 36.06 | 20.9 |
| 89 | 191 | 18 | 48.092 | 50.41 | 19.302 | 56.1 | 23.54 |
| 196 | 88 | 18 | 28.525 | 31.101 | 11.937 | 47.52 | 25.27 |
| 161 | 139 | 18 | 46.867 | 55.027 | 18.282 | 54.58 | 22.22 |
| 126 | 35 | 18 | 45.408 | 48.868 | 19.477 | 55.95 | 24.7 |
| 239 | 219 | 18 | 59.675 | 58.689 | 19.698 | 55.17 | 22.02 |