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 |
|---|---|---|---|---|---|---|---|
| 140 | 152 | 908 | 23.517 | 24.431 | 5.107 | 20.12 | 13.43 |
| 249 | 257 | 908 | 22.95 | 24.425 | 7.434 | 24.55 | 19.59 |
| 138 | 259 | 908 | 28.733 | 32.076 | 14.276 | 41.43 | 28.66 |
| 80 | 36 | 907 | 10.517 | 11.247 | 2.115 | 9.73 | 11.86 |
| 211 | 17 | 906 | 23.65 | 24.83 | 4.641 | 19.66 | 11.95 |
| 158 | 24 | 905 | 20.117 | 22 | 5.758 | 20.67 | 16.81 |
| 90 | 129 | 905 | 30.633 | 32.32 | 8.225 | 28.85 | 16.32 |
| 42 | 140 | 905 | 21.167 | 21.93 | 4.487 | 17.77 | 14.06 |
| 236 | 127 | 904 | 22.125 | 24.207 | 7.742 | 25.52 | 21.11 |
| 189 | 61 | 903 | 8.25 | 9.242 | 1.63 | 8.38 | 11.06 |
| 209 | 142 | 903 | 26.733 | 28.399 | 6.417 | 24.12 | 14.67 |
| 234 | 260 | 902 | 26.175 | 27.95 | 6.601 | 24.16 | 15.23 |
| 138 | 254 | 901 | 29.517 | 31.847 | 13.402 | 39.35 | 27.01 |
| 42 | 237 | 899 | 19.75 | 20.887 | 3.912 | 16.59 | 12.5 |
| 41 | 233 | 899 | 23.683 | 24.646 | 5.255 | 20.27 | 13.89 |
| 224 | 45 | 897 | 12.35 | 12.707 | 2.76 | 12.08 | 14.47 |
| 42 | 161 | 896 | 22.5 | 24.308 | 4.982 | 19.77 | 14.41 |
| 10 | 161 | 896 | 46.85 | 47.935 | 14.68 | 52.18 | 20.34 |
| 107 | 188 | 895 | 32.55 | 34.105 | 7.442 | 27.85 | 13.83 |
| 97 | 189 | 894 | 8.3 | 9.274 | 1.342 | 7.88 | 9.34 |
| 25 | 54 | 894 | 6.608 | 7.118 | 1.231 | 6.9 | 11.02 |
| 43 | 232 | 893 | 22.783 | 24.28 | 5.849 | 21.59 | 15.57 |
| 162 | 12 | 893 | 20.067 | 22.12 | 5.811 | 21.36 | 17.52 |
| 17 | 61 | 893 | 8.383 | 9.704 | 1.686 | 8.61 | 11.25 |
| 162 | 17 | 892 | 32.392 | 33.355 | 7.731 | 28.38 | 14.68 |