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 |
|---|---|---|---|---|---|---|---|
| 246 | 189 | 867 | 33.95 | 34.987 | 7.107 | 27.54 | 12.71 |
| 48 | 52 | 866 | 30.642 | 32.045 | 7.582 | 27.09 | 14.91 |
| 13 | 14 | 866 | 18.383 | 20.185 | 8.17 | 25.02 | 25.53 |
| 33 | 113 | 866 | 17.758 | 18.935 | 4.522 | 15.87 | 15.05 |
| 4 | 262 | 863 | 15.6 | 16.677 | 4.551 | 16.45 | 17.56 |
| 186 | 200 | 863 | 29.567 | 32.733 | 12.557 | 38.42 | 24.49 |
| 142 | 40 | 863 | 33.333 | 35.131 | 8.956 | 30.9 | 16.49 |
| 50 | 145 | 863 | 21.467 | 22.726 | 4.372 | 18.44 | 12.37 |
| 65 | 40 | 862 | 10.142 | 10.669 | 1.832 | 9.14 | 10.87 |
| 88 | 189 | 862 | 21.617 | 22.409 | 4.853 | 18.64 | 13.6 |
| 223 | 129 | 862 | 9.733 | 10.643 | 2.369 | 11.23 | 16.59 |
| 132 | 32 | 862 | 40.017 | 42.278 | 20.567 | 57.18 | 31.27 |
| 12 | 186 | 861 | 23.533 | 25.085 | 4.478 | 19.51 | 11.29 |
| 230 | 195 | 861 | 38.183 | 40.017 | 9.569 | 33.98 | 15.13 |
| 170 | 89 | 860 | 34.417 | 36.988 | 11.603 | 37.13 | 20.74 |
| 13 | 145 | 860 | 23.583 | 25.661 | 8.467 | 27.35 | 20.96 |
| 138 | 35 | 860 | 34.75 | 37.632 | 12.825 | 39.97 | 22.12 |
| 138 | 63 | 860 | 27.083 | 29.993 | 11.106 | 33.81 | 24.32 |
| 146 | 233 | 860 | 13.358 | 14.837 | 2.54 | 12.2 | 12.46 |
| 100 | 188 | 859 | 38.333 | 41.075 | 9.563 | 34.1 | 14.81 |
| 209 | 256 | 859 | 16.633 | 17.818 | 3.941 | 15.94 | 14.09 |
| 145 | 163 | 859 | 19.983 | 22.053 | 3.485 | 37.72 | 10.6 |
| 65 | 232 | 858 | 9.383 | 10.386 | 2.863 | 11.28 | 17.97 |
| 137 | 61 | 858 | 32.433 | 33.996 | 8.223 | 29.18 | 15.7 |
| 4 | 255 | 858 | 16.433 | 17.408 | 3.602 | 15.1 | 13.01 |