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 |
|---|---|---|---|---|---|---|---|
| 180 | 7 | 5 | 30.683 | 34.647 | 9.69 | 32.1 | 17.37 |
| 195 | 165 | 5 | 27.783 | 38.28 | 6.26 | 28.8 | 11.77 |
| 153 | 69 | 5 | 19.833 | 21.15 | 4.678 | 18.2 | 13.68 |
| 200 | 168 | 5 | 22.833 | 24.78 | 7.466 | 25.3 | 18.97 |
| 210 | 158 | 5 | 48.017 | 47.863 | 18.044 | 52.66 | 22.96 |
| 70 | 71 | 5 | 45.033 | 43.94 | 15.46 | 47.3 | 21.35 |
| 259 | 198 | 5 | 61.533 | 65.03 | 22.556 | 69.47 | 24.41 |
| 95 | 182 | 5 | 24.683 | 37.3 | 12.7 | 40.1 | 25.09 |
| 179 | 254 | 5 | 26.867 | 27.713 | 11.692 | 34.7 | 26.61 |
| 129 | 67 | 5 | 42.833 | 47.28 | 15.914 | 48.1 | 24.25 |
| 180 | 42 | 5 | 42.6 | 44.403 | 18.712 | 55.03 | 25.75 |
| 223 | 26 | 5 | 35.65 | 37.433 | 15.758 | 49.3 | 26.28 |
| 13 | 101 | 5 | 41.817 | 41.873 | 23.162 | 62.85 | 34.06 |
| 200 | 151 | 5 | 23.733 | 24.077 | 9.9 | 30.25 | 25.37 |
| 78 | 39 | 5 | 48.083 | 60.307 | 23.968 | 71.5 | 27.08 |
| 130 | 207 | 5 | 21.1 | 33.083 | 9.294 | 33.4 | 24.33 |
| 31 | 74 | 5 | 25.4 | 30.417 | 8.976 | 29.44 | 18.38 |
| 227 | 148 | 5 | 31.333 | 31.213 | 8.344 | 29.1 | 17.64 |
| 185 | 152 | 5 | 27.1 | 27.66 | 8.598 | 28.22 | 19.68 |
| 36 | 83 | 5 | 14.583 | 15.097 | 4.026 | 14.8 | 16.52 |
| 220 | 126 | 5 | 34.233 | 32.667 | 8.874 | 29.76 | 17 |
| 81 | 7 | 5 | 28.183 | 34.103 | 15.39 | 44.5 | 28.36 |
| 145 | 26 | 5 | 30.117 | 33.447 | 12.978 | 38.4 | 24.31 |
| 24 | 71 | 5 | 51.583 | 52.46 | 16.866 | 52.7 | 19.67 |
| 82 | 71 | 5 | 55.967 | 56.04 | 11.96 | 41.57 | 13 |