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 |
|---|---|---|---|---|---|---|---|
| 25 | 223 | 51 | 24.7 | 28.8 | 10.305 | 31.82 | 23.98 |
| 49 | 162 | 51 | 30.233 | 31.445 | 8.02 | 27.96 | 16.38 |
| 45 | 26 | 51 | 22.917 | 26.089 | 8.399 | 27.54 | 21.8 |
| 80 | 88 | 51 | 19.917 | 24.505 | 6.621 | 28.16 | 18.96 |
| 247 | 127 | 51 | 16.333 | 17.796 | 4.096 | 16.36 | 15.15 |
| 142 | 149 | 51 | 55.067 | 54.563 | 16.676 | 52.15 | 18.96 |
| 166 | 31 | 51 | 26.567 | 28.258 | 9.703 | 30.43 | 21.79 |
| 159 | 60 | 51 | 15.45 | 15.621 | 2.375 | 12.21 | 9.83 |
| 263 | 165 | 51 | 44.6 | 47.703 | 15.434 | 47.83 | 20.86 |
| 43 | 62 | 51 | 45.017 | 48.675 | 11.557 | 40.47 | 15.04 |
| 198 | 157 | 51 | 7.8 | 9.947 | 1.834 | 8.91 | 12.32 |
| 222 | 25 | 51 | 45.017 | 43.047 | 10.248 | 36.23 | 15.11 |
| 45 | 242 | 51 | 53.4 | 55.353 | 15.759 | 50.22 | 19.25 |
| 223 | 248 | 51 | 22.9 | 22.587 | 7.455 | 24.15 | 20.82 |
| 107 | 10 | 51 | 35.333 | 39.789 | 15.404 | 47.54 | 25.2 |
| 247 | 43 | 51 | 22.483 | 24.177 | 4.505 | 19.14 | 11.69 |
| 231 | 250 | 51 | 35.8 | 40.534 | 15.647 | 46.4 | 25.47 |
| 90 | 259 | 51 | 40.967 | 42.78 | 16.612 | 49.65 | 24.74 |
| 66 | 62 | 51 | 21.4 | 23.006 | 3.932 | 17.39 | 10.7 |
| 155 | 71 | 51 | 16.6 | 17.251 | 2.854 | 13.57 | 10.49 |
| 229 | 91 | 51 | 51.65 | 53.04 | 14.863 | 48.3 | 17.89 |
| 198 | 225 | 51 | 12.667 | 13.991 | 2.144 | 10.83 | 9.47 |
| 189 | 227 | 51 | 18.833 | 19.877 | 4.182 | 16.85 | 13.08 |
| 17 | 45 | 51 | 21.583 | 22.722 | 4.337 | 19.61 | 12.28 |
| 136 | 247 | 51 | 16.183 | 16.066 | 3.389 | 14.13 | 13.68 |