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 |
|---|---|---|---|---|---|---|---|
| 217 | 140 | 12 | 22.725 | 26.331 | 6.658 | 23.68 | 16.49 |
| 250 | 47 | 12 | 22.633 | 23.808 | 4.347 | 18.42 | 11.48 |
| 216 | 7 | 12 | 35.542 | 36.54 | 11.828 | 36.49 | 21.37 |
| 235 | 79 | 12 | 36.125 | 40.796 | 11.534 | 37.92 | 18.03 |
| 197 | 77 | 12 | 22.575 | 23.265 | 5.971 | 21.71 | 15.43 |
| 53 | 173 | 12 | 12.383 | 12.458 | 3.437 | 12.67 | 16.64 |
| 5 | 23 | 12 | 22.767 | 31.322 | 9.773 | 32.46 | 21.42 |
| 76 | 29 | 12 | 24.867 | 26.071 | 10.553 | 31.75 | 24.79 |
| 173 | 118 | 12 | 68.683 | 68.007 | 29.679 | 84.58 | 27.06 |
| 63 | 256 | 12 | 29.975 | 31.353 | 5.27 | 22.83 | 10.43 |
| 195 | 238 | 12 | 36.042 | 34.925 | 11.124 | 35.71 | 20.03 |
| 159 | 4 | 12 | 25.858 | 27.453 | 8.982 | 28.5 | 21.22 |
| 122 | 181 | 12 | 58.783 | 59.428 | 15.519 | 49.71 | 16.02 |
| 218 | 159 | 12 | 47.65 | 47.682 | 18.733 | 54.13 | 24.75 |
| 137 | 96 | 12 | 27.525 | 33.294 | 10.313 | 33.8 | 20.5 |
| 24 | 257 | 12 | 38.983 | 48.035 | 13.746 | 43.31 | 19.18 |
| 25 | 139 | 12 | 58.642 | 59.318 | 17.442 | 55.98 | 18.53 |
| 244 | 66 | 12 | 43.25 | 43.418 | 13.992 | 43.79 | 20.07 |
| 200 | 170 | 12 | 49.683 | 50.543 | 13.305 | 45.47 | 16.85 |
| 147 | 235 | 12 | 20.883 | 21.475 | 4.513 | 18.04 | 12.43 |
| 94 | 242 | 12 | 22.075 | 23.201 | 4.056 | 18.08 | 10.67 |
| 3 | 147 | 12 | 23.042 | 23.236 | 6.611 | 23.08 | 18.59 |
| 222 | 228 | 12 | 35.658 | 35.358 | 15.858 | 46.48 | 28.59 |
| 102 | 260 | 12 | 19.692 | 22.314 | 5.788 | 20.02 | 16.37 |
| 197 | 7 | 12 | 23.383 | 26.506 | 10.427 | 31.97 | 25.24 |