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 |
|---|---|---|---|---|---|---|---|
| 230 | 59 | 22 | 29.508 | 31.222 | 10.522 | 33.11 | 22.08 |
| 158 | 121 | 22 | 33.6 | 38.307 | 14.301 | 43.86 | 24.09 |
| 17 | 88 | 22 | 28.725 | 29.31 | 5.25 | 23.57 | 11.81 |
| 225 | 52 | 22 | 20.208 | 22.419 | 4.55 | 18.11 | 13.35 |
| 181 | 83 | 22 | 25.658 | 26.821 | 8.686 | 28.45 | 20.6 |
| 200 | 48 | 22 | 34.992 | 37.739 | 12.019 | 36.83 | 20.68 |
| 147 | 226 | 22 | 33.792 | 35.519 | 6.7 | 26.67 | 11.94 |
| 164 | 57 | 22 | 35.15 | 38.201 | 10.844 | 36.27 | 18.89 |
| 144 | 108 | 22 | 32.283 | 33.26 | 14.375 | 41.93 | 27.24 |
| 125 | 210 | 22 | 37.767 | 40.677 | 16.579 | 48.37 | 25.87 |
| 173 | 223 | 22 | 15.217 | 20.256 | 4.875 | 18.07 | 15.36 |
| 257 | 138 | 22 | 35.575 | 35.498 | 13.865 | 40.61 | 24.42 |
| 22 | 29 | 22 | 11.833 | 14.014 | 3.828 | 14.41 | 18.89 |
| 91 | 37 | 22 | 29.083 | 28.305 | 5.26 | 21.69 | 11.41 |
| 170 | 27 | 22 | 50.125 | 55.764 | 26.177 | 75.42 | 29.96 |
| 174 | 20 | 22 | 13.892 | 13.622 | 2.189 | 11.18 | 10.05 |
| 254 | 235 | 22 | 21.783 | 26.518 | 5.492 | 22.41 | 14.64 |
| 179 | 258 | 22 | 31.008 | 33.403 | 11.862 | 36.8 | 23.35 |
| 145 | 14 | 22 | 29.017 | 32.761 | 14.305 | 41.07 | 27.86 |
| 166 | 150 | 22 | 62.392 | 64.905 | 23.494 | 69.03 | 22.28 |
| 248 | 78 | 22 | 12.742 | 12.173 | 2.628 | 11.43 | 13.13 |
| 24 | 72 | 22 | 78.367 | 78.917 | 15.865 | 59.94 | 12.68 |
| 218 | 150 | 22 | 34.767 | 38.539 | 14.977 | 41.92 | 25 |
| 212 | 167 | 22 | 11.858 | 12.241 | 2.288 | 10.64 | 11.9 |
| 256 | 243 | 22 | 33.283 | 37.722 | 13.785 | 41.84 | 24.31 |