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 |
|---|---|---|---|---|---|---|---|
| 25 | 29 | 20 | 31.042 | 32.664 | 10.972 | 34.7 | 21.77 |
| 49 | 63 | 20 | 26.142 | 26.778 | 5.45 | 21.12 | 12.69 |
| 102 | 79 | 20 | 28.9 | 32.11 | 8.567 | 25.54 | 16.79 |
| 39 | 239 | 20 | 45.125 | 46.996 | 15.296 | 44.6 | 19.74 |
| 220 | 230 | 20 | 33.133 | 35.501 | 11.085 | 36.35 | 20.76 |
| 208 | 185 | 20 | 15.042 | 16.557 | 4.133 | 15.65 | 15.12 |
| 87 | 78 | 20 | 32.892 | 38.562 | 15.07 | 44.5 | 26.53 |
| 90 | 218 | 20 | 58.15 | 62.475 | 17.577 | 56.77 | 19.52 |
| 121 | 76 | 20 | 30.208 | 31.07 | 7.918 | 27.74 | 15.83 |
| 63 | 87 | 20 | 48.842 | 49.243 | 9.067 | 52 | 11.33 |
| 152 | 194 | 20 | 17.25 | 21.023 | 5.178 | 26.6 | 14.82 |
| 119 | 20 | 20 | 14.133 | 15.921 | 4.178 | 15.43 | 17.93 |
| 143 | 157 | 20 | 33.575 | 36.772 | 8.25 | 29.43 | 13.86 |
| 213 | 18 | 20 | 21.925 | 22.878 | 5.784 | 21.53 | 16.77 |
| 170 | 221 | 20 | 39.308 | 36.223 | 15.315 | 44.64 | 24.11 |
| 40 | 91 | 20 | 28.558 | 30.755 | 7.01 | 26.05 | 14.45 |
| 195 | 152 | 20 | 42.358 | 43.657 | 15.255 | 45.55 | 21.43 |
| 239 | 91 | 20 | 58.767 | 61.693 | 16.552 | 54.7 | 16.77 |
| 164 | 172 | 20 | 42.467 | 42.68 | 18.5 | 52.9 | 25.87 |
| 97 | 216 | 20 | 39.05 | 41.892 | 13.361 | 41.83 | 20.42 |
| 166 | 62 | 20 | 51.817 | 53.403 | 14.439 | 47.67 | 16.64 |
| 188 | 163 | 20 | 37.55 | 41.95 | 10.877 | 37.48 | 16.48 |
| 226 | 152 | 20 | 28.642 | 32.112 | 8.752 | 30 | 17.74 |
| 11 | 123 | 20 | 17.425 | 18.418 | 3.202 | 14.78 | 11.08 |
| 68 | 222 | 20 | 54.775 | 54.443 | 22.282 | 63.58 | 26.27 |