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 |
|---|---|---|---|---|---|---|---|
| 162 | 152 | 1007 | 23.317 | 24.715 | 5.777 | 21.41 | 14.85 |
| 224 | 209 | 1006 | 10.325 | 10.98 | 3.327 | 12.61 | 19.55 |
| 116 | 68 | 1005 | 21 | 22.554 | 6.696 | 22.97 | 19.06 |
| 33 | 54 | 1004 | 5.5 | 5.977 | 1.036 | 6.15 | 10.93 |
| 236 | 255 | 1003 | 31.167 | 32.314 | 7.455 | 27.41 | 14.42 |
| 90 | 40 | 1002 | 25.417 | 26.574 | 5.931 | 21.87 | 14.17 |
| 170 | 168 | 998 | 18.133 | 20.504 | 6.374 | 21.32 | 20.83 |
| 229 | 66 | 998 | 24.625 | 25.708 | 6.746 | 23.47 | 17.2 |
| 114 | 89 | 996 | 27.408 | 29.215 | 8.323 | 28.05 | 18.18 |
| 79 | 127 | 996 | 26.15 | 28.488 | 11.807 | 35.24 | 26.68 |
| 229 | 65 | 995 | 23.083 | 23.985 | 6.864 | 23.36 | 18.44 |
| 244 | 247 | 995 | 11.867 | 12.927 | 2.029 | 10.65 | 10.14 |
| 186 | 106 | 995 | 33 | 34.277 | 7.421 | 27.78 | 13.68 |
| 33 | 138 | 994 | 23.408 | 26.475 | 10.779 | 32.23 | 27.05 |
| 100 | 225 | 993 | 38.083 | 40.605 | 8.417 | 31.92 | 13.3 |
| 158 | 145 | 992 | 26.617 | 27.76 | 5.903 | 22.78 | 13.37 |
| 10 | 170 | 992 | 36.042 | 37.708 | 13.773 | 52.03 | 24.53 |
| 41 | 69 | 991 | 16.767 | 17.856 | 3.18 | 14.25 | 11.35 |
| 107 | 146 | 991 | 18.367 | 19.581 | 4.346 | 16.91 | 14.57 |
| 234 | 152 | 991 | 25.817 | 28.174 | 7.248 | 25.76 | 16.6 |
| 137 | 49 | 991 | 25.3 | 26.809 | 6.494 | 23.51 | 15.43 |
| 68 | 179 | 989 | 28.667 | 29.904 | 6.621 | 24.75 | 14.16 |
| 148 | 14 | 989 | 24.317 | 26.396 | 10.459 | 31.77 | 25.33 |
| 66 | 162 | 989 | 20.583 | 21.664 | 6.486 | 21.88 | 19.1 |
| 113 | 36 | 989 | 30.217 | 31.474 | 6.37 | 25.13 | 12.79 |