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 |
|---|---|---|---|---|---|---|---|
| 61 | 258 | 12 | 24.125 | 25.158 | 5.734 | 21.67 | 14.43 |
| 233 | 251 | 12 | 42.717 | 42.597 | 19.046 | 54.33 | 27.97 |
| 116 | 171 | 12 | 28.567 | 31.381 | 12.77 | 37.88 | 25.34 |
| 137 | 58 | 12 | 32.892 | 35.631 | 13.016 | 38.75 | 24.45 |
| 257 | 79 | 12 | 28.833 | 28.543 | 8.299 | 27.12 | 17.95 |
| 45 | 222 | 12 | 53.892 | 57.787 | 15.203 | 49.43 | 16.2 |
| 218 | 230 | 12 | 62.442 | 62.839 | 19.94 | 60.06 | 19.6 |
| 13 | 169 | 12 | 37.533 | 41.108 | 13.462 | 42 | 20.96 |
| 259 | 208 | 12 | 19.583 | 20.907 | 6.955 | 23.95 | 21.92 |
| 244 | 40 | 12 | 38.408 | 44.146 | 18.037 | 52.71 | 24.92 |
| 249 | 176 | 12 | 47.158 | 45.756 | 18.693 | 54.33 | 24.9 |
| 205 | 97 | 12 | 56.417 | 58.381 | 14.772 | 47.59 | 15.5 |
| 37 | 151 | 12 | 36.633 | 38.026 | 10.557 | 35.46 | 17.36 |
| 82 | 194 | 12 | 19.9 | 20.694 | 7.952 | 26.88 | 23.85 |
| 260 | 126 | 12 | 20.208 | 23.207 | 8.078 | 26.08 | 23.13 |
| 220 | 137 | 12 | 32.725 | 40.272 | 12.812 | 38.6 | 23.31 |
| 152 | 256 | 12 | 44.175 | 44.014 | 11.316 | 39.45 | 16.4 |
| 61 | 180 | 12 | 27.308 | 28.331 | 5.65 | 21.83 | 12.18 |
| 14 | 143 | 12 | 39.55 | 41.907 | 12.94 | 41.72 | 18.72 |
| 145 | 169 | 12 | 39.2 | 35.917 | 11.572 | 38.38 | 21.15 |
| 38 | 92 | 12 | 29.2 | 32.796 | 12.635 | 37.91 | 25.71 |
| 78 | 243 | 12 | 22.775 | 22.16 | 3.75 | 18.09 | 11.7 |
| 14 | 117 | 12 | 49.017 | 54.068 | 16.872 | 52.71 | 19.78 |
| 52 | 55 | 12 | 27.075 | 28.29 | 11.888 | 35.58 | 27.67 |
| 33 | 160 | 12 | 26.192 | 29.178 | 8.702 | 28.42 | 19.48 |