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 |
|---|---|---|---|---|---|---|---|
| 146 | 35 | 12 | 39.892 | 42.082 | 14.458 | 45.42 | 21.51 |
| 8 | 244 | 12 | 14.642 | 17.803 | 6.421 | 48.25 | 24.48 |
| 260 | 26 | 12 | 48.35 | 47.444 | 14.291 | 44.29 | 20.74 |
| 195 | 91 | 12 | 34.55 | 33.489 | 8.357 | 29.71 | 15.45 |
| 223 | 73 | 12 | 17.808 | 19.463 | 9.065 | 26.83 | 28.55 |
| 82 | 65 | 12 | 30.475 | 29.247 | 7.959 | 26.17 | 20.06 |
| 180 | 212 | 12 | 34.1 | 36.218 | 18.064 | 50.59 | 31.52 |
| 146 | 19 | 12 | 30.158 | 35.114 | 15.627 | 44.66 | 29.22 |
| 219 | 116 | 12 | 38.983 | 45.078 | 17.91 | 55.62 | 26.48 |
| 189 | 166 | 12 | 37.158 | 37.538 | 13.112 | 40.71 | 21.04 |
| 52 | 24 | 12 | 46.5 | 46.124 | 11.881 | 40.29 | 15.7 |
| 152 | 112 | 12 | 40.467 | 40.96 | 10.274 | 35.88 | 15.91 |
| 238 | 64 | 12 | 40.417 | 44.415 | 20.458 | 58.46 | 29.89 |
| 228 | 86 | 12 | 55.375 | 57.042 | 23.749 | 67.57 | 25.67 |
| 97 | 248 | 12 | 30.267 | 37.132 | 16.433 | 47.38 | 29.45 |
| 189 | 63 | 12 | 31.758 | 30.721 | 5.498 | 21.91 | 11.79 |
| 80 | 168 | 12 | 21.475 | 23.549 | 10.429 | 31 | 27.8 |
| 188 | 243 | 12 | 84.608 | 78.256 | 19.966 | 67.92 | 15.98 |
| 47 | 215 | 12 | 39.833 | 47.11 | 19.402 | 56.42 | 26.05 |
| 69 | 83 | 12 | 45.067 | 45.682 | 10.913 | 38.04 | 14.46 |
| 116 | 62 | 12 | 62.508 | 60.561 | 15.359 | 51.98 | 15.96 |
| 224 | 177 | 12 | 30.1 | 31.419 | 7.891 | 27.75 | 15.71 |
| 70 | 64 | 12 | 22.567 | 24.189 | 10.769 | 36.67 | 31.51 |
| 238 | 38 | 12 | 47.342 | 53.208 | 22.727 | 64.83 | 27.24 |
| 90 | 245 | 12 | 42.675 | 45.607 | 17.203 | 51.62 | 23.59 |