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 |
|---|---|---|---|---|---|---|---|
| 4 | 40 | 201 | 19.083 | 19.966 | 5.567 | 19.18 | 17.85 |
| 160 | 132 | 201 | 29.483 | 30.565 | 10.56 | 50.85 | 23.97 |
| 43 | 52 | 201 | 32.45 | 34.681 | 9.322 | 31.37 | 17.14 |
| 88 | 116 | 201 | 31.283 | 33.839 | 11.356 | 35.6 | 21.88 |
| 45 | 227 | 201 | 28.667 | 28.674 | 7.356 | 25.59 | 17.25 |
| 152 | 69 | 200 | 18.208 | 19.943 | 3.462 | 15.37 | 11.45 |
| 75 | 200 | 200 | 23.142 | 26.254 | 10.035 | 30.6 | 24.84 |
| 33 | 263 | 200 | 26.325 | 27.803 | 8.877 | 28.42 | 20.49 |
| 65 | 43 | 200 | 25.733 | 27.412 | 7.576 | 25.78 | 17.39 |
| 65 | 129 | 200 | 20.85 | 22.378 | 8.145 | 25.41 | 24.73 |
| 186 | 258 | 200 | 40.383 | 42.392 | 11.54 | 38.96 | 17.44 |
| 66 | 232 | 200 | 11.542 | 12.254 | 3.294 | 13.1 | 17.48 |
| 164 | 102 | 200 | 29.208 | 32.106 | 8.661 | 29.49 | 17.1 |
| 162 | 192 | 200 | 23.475 | 25.426 | 10.006 | 30.23 | 25.65 |
| 12 | 25 | 199 | 17.433 | 18.686 | 3.816 | 15.58 | 13.03 |
| 161 | 121 | 199 | 32.95 | 35.844 | 12.305 | 38.37 | 22.23 |
| 231 | 157 | 199 | 27.317 | 28.502 | 8.286 | 27.88 | 19.11 |
| 262 | 202 | 199 | 20.3 | 20.971 | 4.979 | 18.31 | 14.63 |
| 12 | 141 | 199 | 22.2 | 24.119 | 6.78 | 23.31 | 18.45 |
| 49 | 148 | 199 | 14.283 | 15.525 | 3.382 | 14.22 | 14.08 |
| 236 | 147 | 199 | 17.783 | 19.031 | 5.124 | 18.21 | 17.07 |
| 235 | 42 | 199 | 15.2 | 16.033 | 3.442 | 14.39 | 14.03 |
| 229 | 194 | 199 | 16.45 | 17.477 | 5.893 | 20.33 | 21.73 |
| 186 | 212 | 199 | 32.75 | 35.216 | 11.683 | 36.81 | 21.37 |
| 236 | 228 | 199 | 34.767 | 36.52 | 12.717 | 39.01 | 22.15 |