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 |
|---|---|---|---|---|---|---|---|
| 149 | 11 | 6 | 27.4 | 26.267 | 4.233 | 19.25 | 10.17 |
| 72 | 236 | 6 | 57.567 | 58.494 | 14.232 | 48.21 | 15.3 |
| 72 | 86 | 6 | 46.558 | 44.997 | 14.15 | 44.73 | 19.31 |
| 153 | 75 | 6 | 32.842 | 31.206 | 7.13 | 26.83 | 14.85 |
| 125 | 205 | 6 | 58.175 | 58.511 | 20.105 | 63.91 | 20.76 |
| 23 | 14 | 6 | 18.792 | 26.442 | 10.425 | 40.66 | 26.67 |
| 39 | 139 | 6 | 25.358 | 27.689 | 10.992 | 32.98 | 25.84 |
| 160 | 237 | 6 | 29.108 | 29.328 | 5.9 | 23.67 | 12.53 |
| 229 | 203 | 6 | 45.233 | 46.078 | 21.912 | 60.67 | 28.96 |
| 10 | 47 | 6 | 40.825 | 37.533 | 16.917 | 47.22 | 29.02 |
| 233 | 57 | 6 | 30.3 | 31.739 | 9.793 | 31.5 | 21.14 |
| 146 | 248 | 6 | 26.825 | 35.614 | 10.912 | 36 | 21.64 |
| 198 | 89 | 6 | 28.658 | 36.831 | 7.603 | 28.58 | 13.98 |
| 70 | 202 | 6 | 16.658 | 19.517 | 5.617 | 19.58 | 18.3 |
| 145 | 254 | 6 | 33.892 | 35.858 | 13.995 | 41.83 | 26.48 |
| 119 | 181 | 6 | 51.025 | 53.581 | 17.845 | 54.69 | 23.58 |
| 183 | 18 | 6 | 17.083 | 18.075 | 5.938 | 19.84 | 20.95 |
| 127 | 125 | 6 | 49.225 | 47.922 | 12.015 | 40.42 | 15.9 |
| 76 | 119 | 6 | 43.442 | 47.575 | 20.93 | 59.33 | 27.88 |
| 173 | 237 | 6 | 40.183 | 42.453 | 8.427 | 29.71 | 12.5 |
| 203 | 192 | 6 | 35.608 | 39.378 | 12.337 | 39.34 | 20.73 |
| 145 | 250 | 6 | 30.342 | 31.022 | 13.767 | 40.25 | 26.71 |
| 186 | 154 | 6 | 49.7 | 59.531 | 20.622 | 60.74 | 21.3 |
| 177 | 261 | 6 | 41.333 | 43.644 | 7.095 | 46.75 | 9.87 |
| 191 | 162 | 6 | 57.742 | 51.922 | 16.633 | 49.15 | 20.83 |