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 |
|---|---|---|---|---|---|---|---|
| 157 | 90 | 65 | 21.317 | 23.244 | 6.617 | 47.59 | 18.41 |
| 114 | 159 | 65 | 28.15 | 32.713 | 9.755 | 31.33 | 20.22 |
| 129 | 244 | 65 | 25.283 | 29.714 | 9.98 | 32 | 22.99 |
| 47 | 235 | 65 | 13.1 | 14.832 | 2.146 | 11.41 | 9.6 |
| 92 | 7 | 65 | 20.4 | 21.658 | 6.397 | 21.64 | 19.13 |
| 92 | 74 | 65 | 28.367 | 29.862 | 10.01 | 31.67 | 21.34 |
| 177 | 188 | 65 | 20.4 | 19.794 | 2.982 | 14.68 | 9.45 |
| 17 | 72 | 65 | 18.7 | 20.596 | 3.62 | 15.77 | 11.39 |
| 114 | 235 | 65 | 33.483 | 35.504 | 12.386 | 38.22 | 22.3 |
| 242 | 208 | 65 | 12.633 | 13.593 | 2.864 | 12.38 | 13.04 |
| 141 | 150 | 65 | 55.133 | 55.046 | 21.51 | 63.05 | 25.25 |
| 143 | 106 | 65 | 37.283 | 37.219 | 9.4 | 32.52 | 15.81 |
| 232 | 12 | 65 | 10.85 | 12.305 | 2.734 | 11.78 | 14.68 |
| 85 | 237 | 65 | 41.883 | 43.669 | 13.98 | 44.15 | 19.98 |
| 83 | 179 | 65 | 14 | 14.826 | 4.056 | 14.97 | 17.52 |
| 146 | 216 | 65 | 35.667 | 38.848 | 12.642 | 39.44 | 21.61 |
| 119 | 168 | 65 | 12.067 | 12.76 | 2.866 | 12.3 | 15.36 |
| 48 | 108 | 65 | 47.05 | 49.011 | 16.88 | 51.69 | 22 |
| 82 | 261 | 65 | 25.483 | 27.697 | 11.116 | 50.62 | 25.88 |
| 212 | 41 | 65 | 33.033 | 32.329 | 6.591 | 24.66 | 13.71 |
| 100 | 53 | 65 | 41.417 | 44.282 | 13.802 | 44.03 | 20.52 |
| 89 | 137 | 65 | 37.817 | 39.673 | 10.857 | 34.93 | 17.65 |
| 61 | 75 | 65 | 54.283 | 54.67 | 13.436 | 46.13 | 15.71 |
| 45 | 39 | 65 | 43.317 | 46.274 | 10.497 | 37.11 | 14.3 |
| 113 | 18 | 65 | 33.233 | 35.863 | 14.042 | 41.96 | 24.54 |