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 |
|---|---|---|---|---|---|---|---|
| 262 | 112 | 441 | 21.85 | 23.627 | 5.705 | 20.92 | 15.01 |
| 48 | 136 | 441 | 24.6 | 26.539 | 10.386 | 31.7 | 25.3 |
| 230 | 159 | 441 | 25.7 | 27.726 | 7.616 | 26.08 | 17.28 |
| 224 | 43 | 440 | 20.383 | 21.925 | 4.222 | 17.66 | 12.54 |
| 146 | 82 | 440 | 19.158 | 19.944 | 4.071 | 16.62 | 12.72 |
| 90 | 198 | 440 | 32.383 | 34.704 | 8.36 | 29.68 | 15.43 |
| 88 | 226 | 440 | 26.008 | 27.718 | 8.843 | 28.67 | 20.83 |
| 163 | 1 | 439 | 41.6 | 45.95 | 19.304 | 92.74 | 27.76 |
| 152 | 237 | 439 | 22.417 | 22.946 | 4.448 | 18.44 | 12.29 |
| 255 | 234 | 439 | 23.617 | 24.935 | 4.696 | 19.45 | 12.12 |
| 142 | 37 | 439 | 36.783 | 38.128 | 8.492 | 31.11 | 13.84 |
| 45 | 37 | 439 | 23.767 | 25.11 | 5.111 | 20.47 | 13.07 |
| 88 | 257 | 438 | 17.075 | 18.965 | 5.861 | 19.72 | 20.01 |
| 152 | 263 | 438 | 19.908 | 20.57 | 3.81 | 16.34 | 11.7 |
| 125 | 37 | 438 | 26.2 | 27.299 | 5.414 | 22.07 | 12.58 |
| 68 | 62 | 438 | 35.917 | 37.162 | 7.909 | 29.66 | 13.41 |
| 236 | 80 | 438 | 29.975 | 30.955 | 7.501 | 27.07 | 15.22 |
| 45 | 143 | 438 | 28.633 | 30.475 | 5.592 | 23.42 | 11.97 |
| 141 | 61 | 437 | 34.95 | 37.408 | 10.667 | 35.17 | 18.32 |
| 244 | 168 | 437 | 15.75 | 16.685 | 3.492 | 14.75 | 13.35 |
| 25 | 140 | 437 | 20.383 | 22.292 | 7.733 | 24.65 | 22.42 |
| 80 | 61 | 437 | 15.8 | 16.785 | 3.436 | 14.13 | 12.92 |
| 170 | 195 | 437 | 28.65 | 30.821 | 8.741 | 29.19 | 18.06 |
| 93 | 239 | 437 | 30.017 | 32.559 | 12.522 | 51.31 | 24.69 |
| 100 | 235 | 436 | 27.842 | 30.98 | 10.148 | 32.51 | 21.72 |