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 | 254 | 144 | 34.875 | 38.32 | 15.147 | 45.12 | 25.44 |
| 243 | 220 | 144 | 13.342 | 13.579 | 3.075 | 13.49 | 15.12 |
| 162 | 31 | 144 | 32.117 | 33.634 | 11.654 | 36.22 | 22.32 |
| 146 | 249 | 144 | 22.517 | 25.36 | 5.473 | 20.85 | 13.88 |
| 33 | 133 | 144 | 14.767 | 16.668 | 4.958 | 17.44 | 20.31 |
| 50 | 70 | 144 | 35.067 | 35.948 | 11.475 | 37.05 | 20.74 |
| 130 | 79 | 143 | 31.317 | 33.67 | 13.532 | 51.63 | 26.05 |
| 56 | 173 | 143 | 8.15 | 9.072 | 1.333 | 7.8 | 9.29 |
| 112 | 144 | 143 | 18.1 | 20.17 | 4.362 | 17.67 | 14.83 |
| 140 | 81 | 143 | 37.25 | 39.37 | 13.503 | 41.33 | 22.76 |
| 129 | 216 | 143 | 20.767 | 22.176 | 8.989 | 27.44 | 28.98 |
| 40 | 14 | 143 | 16.933 | 18.789 | 6.007 | 20.26 | 20.38 |
| 142 | 20 | 143 | 32.55 | 34.491 | 11.832 | 37.01 | 22.03 |
| 143 | 69 | 143 | 26.7 | 29.979 | 7.63 | 27.02 | 17.23 |
| 107 | 241 | 143 | 26.633 | 30.291 | 12.586 | 37.01 | 27.15 |
| 25 | 168 | 143 | 27.767 | 32.382 | 11.916 | 35.96 | 24.27 |
| 244 | 7 | 143 | 26.55 | 27.632 | 7.827 | 26.73 | 18.12 |
| 142 | 190 | 143 | 41 | 43.001 | 10.45 | 36.73 | 15.29 |
| 17 | 177 | 143 | 13.75 | 15.381 | 2.722 | 12.57 | 11.34 |
| 65 | 41 | 143 | 34.55 | 36.073 | 11.231 | 35.76 | 20.42 |
| 76 | 63 | 143 | 10.067 | 11.578 | 1.822 | 9.77 | 9.55 |
| 249 | 28 | 143 | 29 | 33.578 | 13.918 | 41.41 | 26.71 |
| 186 | 81 | 143 | 39.267 | 43.57 | 17.109 | 51.01 | 25.32 |
| 97 | 229 | 143 | 21.283 | 23.48 | 7.166 | 23.84 | 19.69 |
| 43 | 14 | 143 | 42.233 | 45.075 | 15.035 | 46.45 | 21.49 |