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 |
|---|---|---|---|---|---|---|---|
| 45 | 11 | 29 | 29.417 | 30.47 | 10.967 | 34.09 | 23.5 |
| 83 | 107 | 29 | 21.533 | 26.514 | 6.66 | 24.83 | 16.91 |
| 66 | 82 | 29 | 18.533 | 20.793 | 8.199 | 25.34 | 25.44 |
| 71 | 41 | 29 | 64.467 | 66.09 | 17.542 | 58.55 | 16.56 |
| 71 | 137 | 29 | 48.45 | 52.805 | 12.084 | 43.18 | 14.51 |
| 139 | 62 | 29 | 49.3 | 47.105 | 13.659 | 42.69 | 47.2 |
| 152 | 25 | 29 | 42.5 | 46.447 | 12.534 | 41.83 | 16.91 |
| 87 | 242 | 29 | 43.217 | 43.413 | 16.104 | 47.52 | 24.1 |
| 226 | 85 | 29 | 50.3 | 54.037 | 11.587 | 42.6 | 15.26 |
| 252 | 16 | 29 | 12.6 | 13.613 | 3.649 | 14.14 | 18.72 |
| 90 | 252 | 29 | 37.583 | 41.708 | 14.933 | 46.02 | 23.99 |
| 42 | 66 | 29 | 39.417 | 39.534 | 12.092 | 38.84 | 19.5 |
| 212 | 174 | 29 | 21.45 | 22.409 | 4.891 | 19.15 | 15.17 |
| 32 | 18 | 29 | 13.683 | 14.278 | 2.118 | 11.28 | 10.03 |
| 74 | 62 | 29 | 48.567 | 50.977 | 15.554 | 49.57 | 19.46 |
| 148 | 122 | 29 | 35.867 | 38.053 | 15.802 | 46.06 | 27.33 |
| 247 | 130 | 29 | 41.733 | 45.555 | 15.074 | 47.83 | 23.02 |
| 205 | 170 | 29 | 47.117 | 49.385 | 15.447 | 47.2 | 19.98 |
| 24 | 89 | 29 | 45.783 | 51.718 | 14.579 | 47.77 | 17.95 |
| 96 | 96 | 29 | 4.833 | 7.359 | 1.564 | 7.83 | 20.08 |
| 188 | 144 | 29 | 27.067 | 30.949 | 5.626 | 23.09 | 11.75 |
| 43 | 123 | 29 | 52.517 | 53.184 | 16.338 | 51.36 | 19.97 |
| 10 | 181 | 29 | 49.233 | 48.46 | 15.758 | 49.44 | 20.34 |
| 76 | 242 | 29 | 34.533 | 38.125 | 18.734 | 51.47 | 31.43 |
| 168 | 208 | 29 | 19.167 | 19.183 | 6.653 | 21.92 | 22.91 |