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 |
|---|---|---|---|---|---|---|---|
| 63 | 33 | 27 | 41.717 | 44.399 | 7.519 | 30.01 | 10.49 |
| 39 | 170 | 27 | 49.817 | 54.135 | 17.35 | 50.63 | 20.01 |
| 223 | 160 | 27 | 19.283 | 19.762 | 5.925 | 20.15 | 18.88 |
| 225 | 129 | 27 | 27.867 | 31.791 | 8.081 | 28.26 | 16.08 |
| 262 | 76 | 27 | 44.733 | 47.649 | 16.871 | 51.27 | 22.74 |
| 188 | 42 | 27 | 52.517 | 54.807 | 17.293 | 54.08 | 19.57 |
| 134 | 218 | 27 | 21.317 | 23.198 | 5.956 | 21.17 | 16.8 |
| 42 | 215 | 27 | 38.783 | 41.386 | 15.22 | 45.5 | 24.62 |
| 243 | 233 | 27 | 30.783 | 34.892 | 9.073 | 31.5 | 17.53 |
| 188 | 90 | 27 | 41.217 | 43.165 | 8.671 | 32.31 | 13.24 |
| 225 | 63 | 27 | 16.717 | 19.227 | 3.874 | 15.57 | 13.03 |
| 261 | 124 | 27 | 51.867 | 56.925 | 17.936 | 54.31 | 21.44 |
| 77 | 89 | 27 | 28.3 | 27.731 | 4.63 | 19.95 | 10.24 |
| 227 | 231 | 27 | 30.4 | 31.186 | 6.438 | 22.33 | 12.81 |
| 223 | 97 | 27 | 25.933 | 27.443 | 8.928 | 29.61 | 22.31 |
| 88 | 201 | 27 | 39.133 | 41.324 | 22.937 | 62.11 | 34.35 |
| 14 | 13 | 27 | 19.45 | 20.202 | 7.727 | 44.38 | 24.73 |
| 225 | 230 | 27 | 44.833 | 43.014 | 9.19 | 34 | 14.12 |
| 97 | 160 | 27 | 28.067 | 29.17 | 8.482 | 28.11 | 18.44 |
| 166 | 36 | 27 | 43.15 | 47.527 | 12.769 | 42.93 | 17.08 |
| 224 | 159 | 27 | 20.217 | 23.328 | 8.039 | 25.87 | 22.74 |
| 158 | 169 | 27 | 28.417 | 34.94 | 11.454 | 36.22 | 22.35 |
| 224 | 157 | 27 | 20.25 | 21.817 | 6.661 | 22.31 | 19.4 |
| 90 | 124 | 27 | 51.867 | 58.428 | 15.46 | 50.69 | 17.68 |
| 151 | 196 | 27 | 44.267 | 41.957 | 11.493 | 37.62 | 17.74 |