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 |
|---|---|---|---|---|---|---|---|
| 43 | 260 | 337 | 24.1 | 25.43 | 5.4 | 21.16 | 13.3 |
| 142 | 119 | 337 | 23.883 | 26.062 | 7.842 | 26.11 | 19.96 |
| 82 | 48 | 337 | 27.133 | 29.633 | 7.713 | 47.18 | 17.7 |
| 226 | 160 | 337 | 15.75 | 17.088 | 3.968 | 15.47 | 15.72 |
| 132 | 1 | 337 | 64.317 | 68.785 | 36.725 | 129.34 | 42.07 |
| 152 | 247 | 337 | 13.733 | 15.163 | 2.553 | 12.34 | 10.98 |
| 125 | 225 | 337 | 29.25 | 30.813 | 5.811 | 23.83 | 12.12 |
| 209 | 116 | 336 | 28.942 | 31.47 | 10.889 | 33.91 | 22.51 |
| 100 | 26 | 336 | 42.767 | 45.032 | 11.746 | 39.72 | 16.74 |
| 75 | 146 | 336 | 18.175 | 19.651 | 4.835 | 17.74 | 16.09 |
| 256 | 211 | 336 | 16.133 | 17.114 | 2.923 | 17.41 | 11.4 |
| 25 | 4 | 336 | 15.208 | 15.789 | 4.609 | 16.33 | 18.37 |
| 239 | 80 | 336 | 32.492 | 34.109 | 8.113 | 29.24 | 14.8 |
| 89 | 181 | 335 | 13.817 | 15.023 | 2.974 | 13.09 | 12.87 |
| 151 | 7 | 335 | 26.6 | 28.412 | 6.637 | 24.42 | 14.8 |
| 74 | 179 | 335 | 12.2 | 13.278 | 4.006 | 14.61 | 20.32 |
| 48 | 92 | 335 | 36.283 | 38.893 | 12.614 | 40.24 | 20.81 |
| 48 | 1 | 335 | 31.95 | 36.943 | 17.276 | 81.84 | 31.37 |
| 152 | 140 | 335 | 25.85 | 26.192 | 5.187 | 20.97 | 12.92 |
| 123 | 123 | 335 | 6.167 | 6.957 | 0.984 | 6.93 | 18.01 |
| 25 | 80 | 334 | 14.883 | 16.548 | 4.183 | 15.88 | 16.52 |
| 146 | 43 | 334 | 14.008 | 15.765 | 3.029 | 15.28 | 12.8 |
| 36 | 80 | 334 | 7.2 | 7.81 | 1.507 | 7.58 | 12.14 |
| 173 | 173 | 334 | 4.275 | 5.706 | 1.199 | 6.14 | 39.31 |
| 170 | 22 | 334 | 37.217 | 39.006 | 14.499 | 43.63 | 23.61 |