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 |
|---|---|---|---|---|---|---|---|
| 52 | 1 | 7 | 32.567 | 47.645 | 22.786 | 74.07 | 32.91 |
| 42 | 77 | 7 | 39.85 | 44.229 | 17.821 | 54.41 | 27.94 |
| 55 | 42 | 7 | 54.233 | 62.445 | 23.891 | 71.82 | 24.13 |
| 198 | 231 | 7 | 51.017 | 54.705 | 7.977 | 36.71 | 9.22 |
| 34 | 48 | 7 | 32.317 | 32.207 | 6.474 | 25.07 | 13.27 |
| 124 | 236 | 7 | 52.817 | 53.395 | 18.093 | 52.67 | 21.1 |
| 86 | 140 | 7 | 82.333 | 78.929 | 25.574 | 82.32 | 20.24 |
| 20 | 220 | 7 | 16.05 | 17.552 | 2.937 | 13.86 | 10.61 |
| 241 | 230 | 7 | 49.017 | 45.764 | 13.503 | 44.21 | 19.24 |
| 78 | 151 | 7 | 24.933 | 27.636 | 9.03 | 27.57 | 20.29 |
| 229 | 207 | 7 | 22.65 | 23.357 | 8.059 | 25.43 | 22.27 |
| 106 | 74 | 7 | 33.967 | 37.188 | 11.664 | 37.36 | 19.92 |
| 260 | 64 | 7 | 26.217 | 39.955 | 15.673 | 46.45 | 31.85 |
| 3 | 127 | 7 | 43.55 | 41.648 | 7.786 | 32.21 | 11.09 |
| 51 | 76 | 7 | 49.983 | 55.067 | 22.91 | 65.5 | 26.33 |
| 47 | 31 | 7 | 14.633 | 16.602 | 4.163 | 16.45 | 15.1 |
| 100 | 84 | 7 | 55.3 | 59.45 | 28.041 | 78 | 30.17 |
| 39 | 67 | 7 | 36.317 | 35.717 | 12.199 | 38.57 | 22.02 |
| 77 | 123 | 7 | 32.067 | 36.383 | 9.826 | 33.43 | 16.97 |
| 96 | 102 | 7 | 6.433 | 5.943 | 0.774 | 5.86 | 9.84 |
| 225 | 160 | 7 | 23.6 | 32.44 | 6.101 | 24.43 | 13.01 |
| 244 | 135 | 7 | 34.65 | 41.469 | 15.396 | 47.07 | 23.53 |
| 198 | 136 | 7 | 48.283 | 50.788 | 15.471 | 50 | 19.02 |
| 207 | 61 | 7 | 20.133 | 26.81 | 9.404 | 41.5 | 23.85 |
| 224 | 16 | 7 | 33.167 | 35.731 | 16.2 | 46.79 | 28.12 |