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 |
|---|---|---|---|---|---|---|---|
| 82 | 191 | 24 | 26.733 | 29.721 | 11.076 | 33.56 | 24.84 |
| 89 | 45 | 24 | 36.75 | 34.724 | 7.531 | 27.66 | 14.33 |
| 250 | 168 | 24 | 16.167 | 17.442 | 4.86 | 17.2 | 18.04 |
| 165 | 227 | 24 | 26.092 | 27.507 | 4.698 | 19.99 | 11.1 |
| 83 | 148 | 24 | 18.392 | 22.143 | 6.726 | 23 | 21.62 |
| 14 | 40 | 24 | 19.4 | 20.842 | 5.568 | 21.27 | 17.99 |
| 123 | 14 | 24 | 17.7 | 21.296 | 6.072 | 20.88 | 20.67 |
| 13 | 124 | 24 | 60.408 | 60.388 | 21.382 | 58.29 | 24.41 |
| 221 | 221 | 24 | 5.892 | 11.429 | 3.14 | 14.71 | 44.5 |
| 10 | 80 | 24 | 29.383 | 33.912 | 12.813 | 46.88 | 27.23 |
| 45 | 18 | 24 | 53.1 | 54.392 | 15.771 | 50.29 | 19.17 |
| 107 | 15 | 24 | 36.058 | 37.954 | 16.758 | 48.1 | 27.65 |
| 10 | 76 | 24 | 18.808 | 21.149 | 6.051 | 20.74 | 18.09 |
| 151 | 173 | 24 | 35.392 | 39.89 | 10.502 | 36.31 | 17.9 |
| 186 | 172 | 24 | 51.733 | 53.262 | 18.803 | 56.75 | 22.33 |
| 231 | 117 | 24 | 59.042 | 62.586 | 25.341 | 71.95 | 25.63 |
| 188 | 216 | 24 | 36.558 | 37.418 | 9.726 | 33.17 | 16.03 |
| 198 | 97 | 24 | 27.033 | 29.04 | 4.91 | 20.85 | 10.6 |
| 13 | 108 | 24 | 28.8 | 33.184 | 13.649 | 38.44 | 25.89 |
| 202 | 163 | 24 | 13.042 | 15.042 | 2.454 | 20.73 | 10.08 |
| 119 | 151 | 24 | 18.817 | 20.137 | 5.74 | 20.06 | 18.62 |
| 39 | 145 | 24 | 62.7 | 64.52 | 18.933 | 58.83 | 17.9 |
| 232 | 77 | 24 | 35.558 | 38.867 | 8.742 | 31.65 | 14.43 |
| 22 | 228 | 24 | 19.158 | 20.912 | 4.212 | 17.74 | 13.01 |
| 17 | 161 | 24 | 32.783 | 36.398 | 9.033 | 31.07 | 16.45 |