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 |
|---|---|---|---|---|---|---|---|
| 59 | 59 | 7 | 7.667 | 6.95 | 0.774 | 6 | 5.76 |
| 35 | 13 | 7 | 54.183 | 55.75 | 9.321 | 38.87 | 11.1 |
| 12 | 227 | 7 | 20.183 | 20.512 | 7.303 | 23.07 | 22.62 |
| 98 | 72 | 7 | 33.7 | 34.812 | 11.936 | 36.77 | 21.23 |
| 241 | 138 | 7 | 28.167 | 34.288 | 17.8 | 48.74 | 30.4 |
| 97 | 136 | 7 | 33.417 | 37.836 | 16.753 | 46.79 | 28.65 |
| 21 | 106 | 7 | 25.167 | 26.54 | 6.596 | 23.86 | 15.17 |
| 69 | 3 | 7 | 29.683 | 35.976 | 9.466 | 33.55 | 17.73 |
| 114 | 58 | 7 | 34.467 | 39.976 | 16.359 | 48.21 | 25.84 |
| 153 | 164 | 7 | 51.067 | 50.502 | 11.13 | 36.43 | 13.81 |
| 9 | 230 | 7 | 53.65 | 56.326 | 13.403 | 46.5 | 15.16 |
| 238 | 77 | 7 | 59 | 62.505 | 17.21 | 56.14 | 17.6 |
| 202 | 80 | 7 | 17.7 | 18.917 | 4.616 | 16.93 | 15 |
| 47 | 195 | 7 | 36.367 | 37.474 | 19.749 | 52.1 | 31.83 |
| 158 | 51 | 7 | 37.033 | 38.679 | 18.399 | 52.57 | 29.32 |
| 168 | 120 | 7 | 10.65 | 18.881 | 4.86 | 17.79 | 18.8 |
| 193 | 194 | 7 | 22.6 | 22.71 | 5.557 | 19.5 | 16.45 |
| 41 | 101 | 7 | 46 | 47.967 | 19.296 | 55.93 | 25.22 |
| 35 | 164 | 7 | 57.9 | 61.145 | 12.331 | 43.72 | 13.24 |
| 33 | 173 | 7 | 30.317 | 32.479 | 10.217 | 33.93 | 19.86 |
| 169 | 141 | 7 | 40.517 | 38.493 | 7.681 | 26.79 | 14.06 |
| 248 | 140 | 7 | 35.55 | 33.243 | 8.503 | 28.86 | 15.88 |
| 167 | 146 | 7 | 23.65 | 26.974 | 6.707 | 23.71 | 16.06 |
| 158 | 191 | 7 | 39.65 | 44.069 | 19.123 | 55.21 | 26.86 |
| 62 | 239 | 7 | 40.7 | 43.586 | 10.573 | 37.57 | 15.49 |