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 |
|---|---|---|---|---|---|---|---|
| 10 | 23 | 24 | 57.217 | 55.181 | 30.649 | 86.46 | 33.84 |
| 50 | 23 | 24 | 40.683 | 44.038 | 20.248 | 58.75 | 28.75 |
| 49 | 229 | 24 | 26.833 | 30.777 | 8.121 | 27.94 | 17.26 |
| 256 | 72 | 24 | 28.6 | 28.782 | 5.574 | 21.98 | 12.11 |
| 52 | 67 | 24 | 18.25 | 18.494 | 6.3 | 20.67 | 21.59 |
| 198 | 179 | 24 | 33.983 | 35.119 | 9.197 | 31.75 | 16.15 |
| 97 | 117 | 24 | 59.4 | 59.039 | 20.36 | 61.34 | 21.68 |
| 189 | 229 | 24 | 28.092 | 29.336 | 7.837 | 27.35 | 16.86 |
| 158 | 150 | 24 | 36.325 | 38.644 | 16.87 | 48.63 | 27.17 |
| 225 | 217 | 24 | 10.167 | 12.119 | 1.812 | 9.62 | 10.37 |
| 106 | 35 | 24 | 23.292 | 25.708 | 5.103 | 20.46 | 12.61 |
| 223 | 9 | 24 | 21.033 | 22.557 | 8.928 | 27.52 | 25.72 |
| 92 | 197 | 24 | 19.167 | 25.203 | 5.952 | 22.5 | 16.74 |
| 144 | 171 | 24 | 37.875 | 44.051 | 14.269 | 45.06 | 21.97 |
| 24 | 94 | 24 | 25.375 | 26.076 | 7.275 | 24.96 | 17.92 |
| 145 | 78 | 24 | 45.933 | 51.155 | 12.158 | 42.6 | 15.16 |
| 195 | 137 | 24 | 27.258 | 28.412 | 7.562 | 25.2 | 16.78 |
| 10 | 135 | 24 | 18.425 | 18.79 | 4.582 | 18.62 | 16.04 |
| 42 | 72 | 24 | 60.433 | 60.465 | 18.497 | 57.49 | 19.81 |
| 17 | 4 | 24 | 22.25 | 23.917 | 4.743 | 19.01 | 12.76 |
| 246 | 3 | 24 | 30.933 | 35.813 | 15.868 | 45.83 | 28.58 |
| 165 | 150 | 24 | 19.783 | 21.459 | 4.274 | 17.79 | 12.06 |
| 263 | 192 | 24 | 30.258 | 32.508 | 11.775 | 35.62 | 23.54 |
| 209 | 126 | 24 | 41.217 | 43.797 | 12.507 | 40.43 | 19.58 |
| 89 | 237 | 24 | 47.417 | 45.362 | 13.345 | 41.57 | 18.55 |