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 |
|---|---|---|---|---|---|---|---|
| 126 | 170 | 3 | 38.367 | 40.472 | 8.707 | 32.33 | 13.2 |
| 154 | 10 | 3 | 31.683 | 31.272 | 12.913 | 38.33 | 25.45 |
| 78 | 132 | 3 | 37.25 | 33.817 | 20.273 | 50.33 | 36.98 |
| 169 | 37 | 3 | 37.117 | 40.272 | 15.5 | 46.83 | 23.38 |
| 196 | 208 | 3 | 20.25 | 21.061 | 9.54 | 29.39 | 27.32 |
| 61 | 93 | 3 | 30.167 | 31.733 | 12.87 | 37.83 | 23.86 |
| 157 | 40 | 3 | 19.3 | 19.478 | 8.323 | 25.17 | 25.71 |
| 72 | 82 | 3 | 47.067 | 44.956 | 11.103 | 38.76 | 14.84 |
| 218 | 169 | 3 | 41.367 | 52.706 | 20.913 | 61.6 | 26.39 |
| 188 | 28 | 3 | 44.833 | 44.789 | 12.2 | 39.45 | 16.35 |
| 253 | 164 | 3 | 29.1 | 34.8 | 11.063 | 44.5 | 19.55 |
| 26 | 52 | 3 | 19.467 | 30.167 | 5.303 | 22.33 | 12.48 |
| 25 | 241 | 3 | 76.15 | 84.772 | 17.663 | 65.5 | 12.86 |
| 129 | 156 | 3 | 43.267 | 54.383 | 24.547 | 69.33 | 29.52 |
| 251 | 187 | 3 | 7.017 | 5.817 | 1.78 | 7.5 | 17.72 |
| 200 | 114 | 3 | 47.05 | 47.122 | 13.84 | 43.7 | 18.1 |
| 82 | 52 | 3 | 33.533 | 36.039 | 10.327 | 33.17 | 17.15 |
| 122 | 218 | 3 | 17.483 | 17.228 | 3.663 | 27 | 13.07 |
| 101 | 237 | 3 | 46.55 | 46.172 | 19.713 | 55.09 | 25.88 |
| 167 | 239 | 3 | 34.333 | 33.6 | 8.213 | 29.83 | 14.92 |
| 8 | 231 | 3 | 21.5 | 23.128 | 11.14 | 36.67 | 28.87 |
| 67 | 129 | 3 | 26.4 | 40.083 | 14.22 | 43.33 | 25.16 |
| 214 | 41 | 3 | 65.183 | 63.306 | 21.943 | 66.5 | 20.83 |
| 7 | 165 | 3 | 57.183 | 58.9 | 18.64 | 57.83 | 18.95 |
| 153 | 130 | 3 | 52.85 | 79.539 | 29.057 | 87.52 | 23.66 |