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 |
|---|---|---|---|---|---|---|---|
| 222 | 95 | 7 | 30.083 | 31.15 | 9.04 | 28.58 | 17.98 |
| 167 | 53 | 7 | 35.967 | 37.105 | 10.197 | 35 | 17.08 |
| 149 | 168 | 7 | 57.817 | 58.307 | 22.714 | 65.91 | 24.23 |
| 83 | 61 | 7 | 26.483 | 27.46 | 8.067 | 26.71 | 18.79 |
| 145 | 18 | 7 | 28.133 | 29.069 | 13.504 | 39.5 | 29.36 |
| 94 | 259 | 7 | 18.933 | 19.848 | 5.206 | 19.36 | 16.1 |
| 175 | 196 | 7 | 28.167 | 25.921 | 7.469 | 25.21 | 19.07 |
| 149 | 140 | 7 | 48.183 | 46.702 | 18.014 | 51.83 | 23.8 |
| 139 | 35 | 7 | 34.267 | 34.231 | 9.994 | 32.35 | 18.61 |
| 218 | 115 | 7 | 34.2 | 33.045 | 23.487 | 64.64 | 47.12 |
| 81 | 61 | 7 | 55.067 | 52.233 | 20.53 | 60.1 | 23.62 |
| 210 | 225 | 7 | 43.35 | 44.421 | 8.383 | 33.43 | 11.56 |
| 114 | 59 | 7 | 43.767 | 41.883 | 13.179 | 41.36 | 19.13 |
| 261 | 222 | 7 | 47.5 | 53.426 | 16.791 | 52.6 | 21.43 |
| 152 | 173 | 7 | 32.817 | 36.976 | 10.673 | 35.21 | 18.01 |
| 169 | 153 | 7 | 16.333 | 17.574 | 3.349 | 14.86 | 11.58 |
| 225 | 163 | 7 | 50 | 49.552 | 8.94 | 35.1 | 11.52 |
| 227 | 130 | 7 | 62.8 | 61.098 | 22.059 | 64.36 | 22.19 |
| 70 | 189 | 7 | 47.3 | 44.698 | 11.69 | 38.93 | 17.39 |
| 239 | 86 | 7 | 68.55 | 68.819 | 25.619 | 75.79 | 23.93 |
| 73 | 130 | 7 | 21.85 | 22.019 | 4.731 | 17.21 | 13.3 |
| 50 | 101 | 7 | 43.517 | 45.076 | 19.491 | 56.5 | 26.44 |
| 33 | 208 | 7 | 42.883 | 46.398 | 18.774 | 53.71 | 26.35 |
| 92 | 243 | 7 | 18.817 | 24.007 | 11.301 | 52 | 32.69 |
| 65 | 126 | 7 | 30.033 | 31.743 | 15.267 | 43 | 29.72 |