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 |
|---|---|---|---|---|---|---|---|
| 149 | 100 | 26 | 44.567 | 46.336 | 13.236 | 41.41 | 17.77 |
| 233 | 180 | 26 | 36.775 | 39.751 | 11.362 | 37.85 | 19.57 |
| 223 | 207 | 26 | 5.667 | 9.549 | 1.845 | 11.38 | 16.81 |
| 202 | 100 | 26 | 24.517 | 24.299 | 4.095 | 18.23 | 10.8 |
| 232 | 29 | 26 | 40.1 | 41.188 | 15.774 | 47.05 | 25.43 |
| 76 | 198 | 26 | 18.725 | 21.921 | 3.969 | 17.27 | 11.61 |
| 55 | 76 | 26 | 37.692 | 39.392 | 12.244 | 39.06 | 20.09 |
| 43 | 252 | 26 | 40.075 | 43.158 | 13.527 | 43.23 | 20.5 |
| 189 | 238 | 26 | 34.583 | 37.892 | 10.857 | 36.31 | 17.98 |
| 10 | 168 | 26 | 30.242 | 32.462 | 15.157 | 44.11 | 29.5 |
| 145 | 121 | 26 | 20.425 | 22.254 | 9.317 | 27.9 | 27.78 |
| 75 | 102 | 26 | 40.2 | 42.264 | 13.495 | 42.73 | 21.1 |
| 92 | 137 | 26 | 43.417 | 42.372 | 11.443 | 36.94 | 17.52 |
| 229 | 240 | 26 | 23.55 | 25.163 | 12.499 | 35.67 | 31.72 |
| 143 | 35 | 26 | 62.617 | 66.36 | 15.184 | 53.98 | 14.59 |
| 158 | 128 | 26 | 26.617 | 30.511 | 11.662 | 35.69 | 24.53 |
| 50 | 98 | 26 | 37.017 | 38.251 | 14.846 | 44.73 | 23.97 |
| 196 | 148 | 26 | 23.208 | 23.898 | 8.73 | 49.96 | 23.44 |
| 36 | 114 | 26 | 24.367 | 27.67 | 5.75 | 21.75 | 13.1 |
| 70 | 229 | 26 | 29.833 | 29.445 | 8.696 | 30.62 | 18.8 |
| 188 | 66 | 26 | 24.658 | 24.484 | 4.035 | 18.12 | 10.78 |
| 24 | 61 | 26 | 48.917 | 51.012 | 13.683 | 45.56 | 17.05 |
| 174 | 47 | 26 | 16.908 | 19.662 | 3.69 | 15.99 | 12.08 |
| 144 | 174 | 26 | 44.408 | 45.187 | 16.989 | 51 | 24.03 |
| 196 | 211 | 26 | 28.442 | 29.437 | 9.633 | 52 | 21.21 |