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 |
|---|---|---|---|---|---|---|---|
| 218 | 16 | 29 | 25.483 | 27.117 | 10.797 | 32.74 | 25.52 |
| 223 | 16 | 29 | 19.633 | 23.286 | 11.194 | 32.81 | 30.45 |
| 162 | 245 | 29 | 44.983 | 45.753 | 19.915 | 56.74 | 26.64 |
| 69 | 97 | 29 | 43.167 | 46.03 | 13.907 | 48.43 | 20.22 |
| 220 | 148 | 29 | 40.1 | 39.808 | 15.278 | 46.24 | 23.55 |
| 189 | 7 | 29 | 31.583 | 31.302 | 9.377 | 31.12 | 19.02 |
| 123 | 76 | 29 | 32.867 | 35.786 | 8.165 | 29.25 | 14.62 |
| 188 | 234 | 29 | 45.8 | 47.964 | 8.557 | 34.34 | 11.32 |
| 125 | 93 | 29 | 40.033 | 45.059 | 13.23 | 43.43 | 19.94 |
| 68 | 44 | 29 | 52.8 | 55.598 | 28.645 | 78.52 | 32.12 |
| 163 | 35 | 29 | 48.317 | 52.828 | 14.135 | 47.47 | 17.35 |
| 230 | 46 | 29 | 36.783 | 40.287 | 18.128 | 51.53 | 27.83 |
| 83 | 134 | 29 | 20.85 | 23.899 | 6.24 | 23.21 | 17.19 |
| 71 | 77 | 29 | 18.917 | 20.76 | 3.369 | 15.84 | 10.07 |
| 22 | 181 | 29 | 28.333 | 29.348 | 5.1 | 21.87 | 10.97 |
| 161 | 77 | 29 | 47.2 | 48.522 | 14.11 | 45.88 | 18.79 |
| 145 | 106 | 29 | 25.517 | 29.881 | 8.651 | 28.74 | 19.19 |
| 89 | 40 | 29 | 16.867 | 18.157 | 4.196 | 17.27 | 15.65 |
| 186 | 118 | 29 | 43.317 | 45.035 | 16.923 | 50.74 | 22.23 |
| 24 | 250 | 29 | 28.917 | 28.449 | 9.074 | 29.52 | 21.33 |
| 165 | 21 | 29 | 12.683 | 13.882 | 2.049 | 11.14 | 9.38 |
| 77 | 222 | 29 | 10.983 | 10.768 | 1.668 | 9.14 | 9.81 |
| 43 | 182 | 29 | 30.633 | 31.814 | 9.56 | 30.72 | 19.64 |
| 45 | 130 | 29 | 49.8 | 56.406 | 15.548 | 50.67 | 18.12 |
| 7 | 63 | 29 | 27.15 | 28.903 | 12.106 | 35.84 | 26.6 |