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 |
|---|---|---|---|---|---|---|---|
| 253 | 161 | 3 | 33.267 | 36.85 | 13.87 | 40.03 | 23.16 |
| 92 | 160 | 3 | 18.383 | 17.272 | 5.267 | 18.17 | 18.27 |
| 53 | 160 | 3 | 29.117 | 29.639 | 8.43 | 28 | 17 |
| 97 | 192 | 3 | 37.633 | 41.222 | 11.097 | 36.5 | 22.99 |
| 85 | 246 | 3 | 37.55 | 37.289 | 9.823 | 33.84 | 15.89 |
| 17 | 192 | 3 | 23.183 | 23.006 | 10.84 | 31.5 | 28.25 |
| 32 | 179 | 3 | 39.1 | 37.522 | 11.457 | 34.55 | 18.91 |
| 14 | 44 | 3 | 32.1 | 42.661 | 18.943 | 55.67 | 29.53 |
| 74 | 221 | 3 | 43.733 | 44.444 | 22.47 | 61.83 | 30.4 |
| 126 | 234 | 3 | 24.883 | 25.6 | 9.747 | 37.17 | 23.12 |
| 20 | 234 | 3 | 48.983 | 48.622 | 13.187 | 40.81 | 16.91 |
| 130 | 40 | 3 | 49.283 | 42.778 | 14.577 | 43.83 | 22.21 |
| 46 | 167 | 3 | 23.817 | 24.289 | 9.23 | 27.83 | 23.57 |
| 225 | 12 | 3 | 36.867 | 38.144 | 6.797 | 27.5 | 10.69 |
| 228 | 263 | 3 | 42.6 | 43.156 | 12.06 | 39 | 17.04 |
| 195 | 247 | 3 | 34.817 | 40.344 | 15.76 | 46.5 | 24.67 |
| 229 | 44 | 3 | 51.55 | 51.528 | 32.163 | 84.67 | 37.7 |
| 61 | 185 | 3 | 39.733 | 40.578 | 20.69 | 58.5 | 30.82 |
| 166 | 221 | 3 | 62.233 | 57.972 | 26.12 | 74.17 | 27.56 |
| 134 | 119 | 3 | 58.567 | 46.961 | 15.36 | 48.17 | 23.93 |
| 167 | 238 | 3 | 18.95 | 18.794 | 4.73 | 17.5 | 15.12 |
| 254 | 129 | 3 | 28.267 | 31.411 | 16.53 | 37.15 | 30.69 |
| 121 | 83 | 3 | 19.45 | 20.428 | 5.627 | 21.33 | 18.24 |
| 182 | 122 | 3 | 38.1 | 41.544 | 12.423 | 39.13 | 18.27 |
| 223 | 12 | 3 | 31.4 | 46.7 | 13.05 | 42.67 | 21.12 |