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 |
|---|---|---|---|---|---|---|---|
| 100 | 227 | 419 | 36.917 | 38.367 | 11.429 | 36.83 | 18.96 |
| 170 | 67 | 419 | 33.067 | 35.215 | 12.871 | 39.04 | 23.07 |
| 148 | 157 | 419 | 17.167 | 18.707 | 6.44 | 21.31 | 22.67 |
| 232 | 138 | 418 | 23.075 | 25.941 | 10.306 | 31.35 | 26.99 |
| 211 | 116 | 418 | 28.775 | 30.929 | 9.355 | 30.94 | 19.04 |
| 181 | 112 | 417 | 20.183 | 21.406 | 5.623 | 20.26 | 16.9 |
| 125 | 89 | 417 | 26.2 | 28.566 | 8.228 | 27.45 | 18.59 |
| 238 | 66 | 416 | 34.992 | 36.2 | 9.89 | 33.41 | 17.21 |
| 209 | 41 | 416 | 33.192 | 35.234 | 9.449 | 31.98 | 17.91 |
| 97 | 50 | 416 | 25.767 | 27.406 | 6.938 | 24.74 | 16 |
| 186 | 235 | 416 | 31.617 | 35.243 | 10.616 | 34.83 | 20.06 |
| 255 | 217 | 416 | 8 | 9.104 | 1.328 | 7.72 | 9.67 |
| 41 | 249 | 416 | 27.3 | 28.376 | 7.037 | 25.15 | 15.81 |
| 88 | 188 | 415 | 28.283 | 29.1 | 6.579 | 24.05 | 14.13 |
| 244 | 141 | 415 | 28.367 | 29.312 | 7.145 | 25.75 | 15.87 |
| 231 | 190 | 415 | 22.733 | 23.569 | 4.978 | 19.66 | 13.63 |
| 24 | 168 | 415 | 17.733 | 18.687 | 3.609 | 15.27 | 12.07 |
| 68 | 247 | 415 | 31.017 | 33.731 | 9.631 | 32.63 | 19 |
| 51 | 51 | 415 | 7.317 | 8.273 | 1.55 | 8.78 | 16.91 |
| 112 | 7 | 415 | 15.35 | 15.671 | 3.734 | 14.57 | 14.74 |
| 13 | 24 | 414 | 25.517 | 27.501 | 7.525 | 26.14 | 17.2 |
| 52 | 107 | 414 | 22.1 | 23.106 | 5.337 | 20.07 | 14.44 |
| 255 | 114 | 414 | 18.467 | 19.398 | 3.553 | 15.63 | 11.8 |
| 236 | 52 | 413 | 30.65 | 32.245 | 9.699 | 31.31 | 19.2 |
| 211 | 228 | 413 | 22.783 | 24.46 | 6.802 | 23.35 | 17.93 |