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 |
|---|---|---|---|---|---|---|---|
| 28 | 230 | 413 | 35.983 | 37.878 | 12.579 | 52.05 | 22 |
| 151 | 4 | 413 | 24.933 | 26.407 | 6.934 | 24.43 | 16.67 |
| 107 | 62 | 413 | 32.917 | 34.241 | 7.049 | 27.07 | 12.91 |
| 48 | 56 | 413 | 32.517 | 34.063 | 9.37 | 31.94 | 17.83 |
| 52 | 229 | 413 | 22.633 | 24.265 | 7.592 | 24.51 | 19.82 |
| 138 | 34 | 413 | 30.417 | 31.496 | 8.588 | 28.84 | 18.64 |
| 224 | 65 | 413 | 13.417 | 15.267 | 4.795 | 16.74 | 20.85 |
| 75 | 169 | 412 | 20.85 | 22.643 | 5.924 | 21.07 | 17.91 |
| 148 | 227 | 412 | 22.333 | 24.663 | 8.384 | 26.78 | 22.09 |
| 52 | 144 | 412 | 17.183 | 18.306 | 3.46 | 15.23 | 12.29 |
| 138 | 86 | 412 | 41.417 | 45.674 | 17.283 | 52.31 | 24.48 |
| 25 | 37 | 412 | 21.617 | 22.517 | 4.233 | 17.89 | 11.96 |
| 144 | 243 | 411 | 31.833 | 33.655 | 11.808 | 37.07 | 22.19 |
| 12 | 43 | 411 | 30.083 | 32.014 | 7.11 | 26.86 | 14.23 |
| 246 | 188 | 411 | 36.1 | 37.624 | 8.987 | 31.9 | 14.92 |
| 61 | 177 | 410 | 9.658 | 10.831 | 1.755 | 9.3 | 10.5 |
| 88 | 223 | 410 | 29.633 | 30.845 | 11.523 | 34.88 | 23.9 |
| 93 | 107 | 410 | 21.008 | 23.339 | 9.9 | 50.7 | 27.99 |
| 261 | 129 | 410 | 30.517 | 32.917 | 11.01 | 34.94 | 21.56 |
| 170 | 92 | 410 | 28.242 | 30.717 | 11.04 | 34.12 | 23.92 |
| 82 | 95 | 410 | 11.108 | 11.944 | 2.439 | 10.87 | 12.92 |
| 164 | 193 | 410 | 20.875 | 22.723 | 4.311 | 17.93 | 12.45 |
| 193 | 223 | 410 | 12.133 | 13.387 | 2.793 | 12 | 12.98 |
| 166 | 69 | 409 | 19.767 | 20.651 | 3.918 | 16.63 | 11.91 |
| 41 | 167 | 409 | 19.25 | 20.719 | 3.889 | 16.46 | 11.9 |