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 |
|---|---|---|---|---|---|---|---|
| 52 | 76 | 19 | 38.5 | 39.626 | 9.637 | 34.37 | 15.07 |
| 60 | 182 | 19 | 8.9 | 8.978 | 1.626 | 8.37 | 11.97 |
| 216 | 222 | 19 | 16.317 | 16.116 | 4.92 | 18.91 | 19.98 |
| 95 | 143 | 19 | 51 | 54.568 | 12.306 | 45.46 | 14.02 |
| 112 | 143 | 19 | 27.917 | 28.235 | 6.249 | 23.55 | 13.75 |
| 263 | 73 | 19 | 32.1 | 41.556 | 12.818 | 39.66 | 21.24 |
| 255 | 152 | 19 | 36.7 | 36.111 | 11.491 | 36.5 | 19.96 |
| 22 | 177 | 19 | 55.75 | 57.084 | 10.102 | 41.26 | 11.03 |
| 225 | 116 | 19 | 54.1 | 53.883 | 17.417 | 53.8 | 20.85 |
| 60 | 126 | 19 | 10.8 | 12.782 | 1.891 | 10.71 | 11.49 |
| 168 | 177 | 19 | 57.75 | 54.099 | 15.181 | 49.48 | 18.92 |
| 248 | 167 | 19 | 13.867 | 15.808 | 2.562 | 12.53 | 10.16 |
| 159 | 241 | 19 | 22.9 | 22.568 | 5.436 | 20.41 | 16.52 |
| 55 | 186 | 19 | 45.95 | 49.207 | 17.114 | 52.79 | 21.71 |
| 173 | 53 | 19 | 13.233 | 15.103 | 3.794 | 14.63 | 15.99 |
| 89 | 232 | 19 | 26.767 | 28.183 | 7.948 | 26.96 | 17.91 |
| 164 | 218 | 19 | 50.9 | 54.628 | 16.821 | 50 | 20.31 |
| 7 | 54 | 19 | 23.717 | 26.353 | 9.599 | 29.66 | 23.35 |
| 171 | 226 | 19 | 31.383 | 34.621 | 9.969 | 33.5 | 19.38 |
| 91 | 40 | 19 | 45.283 | 44.167 | 7.668 | 27.88 | 10.85 |
| 11 | 170 | 19 | 78.333 | 68.235 | 26.626 | 77.52 | 23.58 |
| 19 | 130 | 19 | 17.667 | 19.124 | 5.423 | 19.02 | 17.6 |
| 149 | 61 | 19 | 32.317 | 38.813 | 5.843 | 26.38 | 10.25 |
| 205 | 68 | 19 | 62.517 | 66.425 | 16.448 | 53.18 | 15.37 |
| 55 | 39 | 19 | 25.767 | 26.036 | 9.686 | 29.12 | 23.86 |