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 |
|---|---|---|---|---|---|---|---|
| 147 | 41 | 23 | 21.15 | 22.463 | 3.927 | 17.26 | 10.85 |
| 150 | 14 | 23 | 20.767 | 24.764 | 8.285 | 27.93 | 21.33 |
| 136 | 159 | 23 | 19.967 | 20.598 | 4.78 | 18.15 | 15.63 |
| 246 | 9 | 23 | 37.083 | 38.403 | 14.871 | 44.83 | 24.43 |
| 39 | 228 | 23 | 37.6 | 38.943 | 13.929 | 41.8 | 22.96 |
| 125 | 159 | 23 | 34.9 | 36.597 | 10.546 | 35.13 | 18.01 |
| 181 | 27 | 23 | 36.3 | 37.245 | 17.203 | 49.43 | 28.86 |
| 148 | 191 | 23 | 31.133 | 36.59 | 16.629 | 47.72 | 30.71 |
| 236 | 192 | 23 | 36.3 | 37.415 | 11.796 | 37.24 | 21.07 |
| 10 | 117 | 23 | 32.417 | 32.84 | 9.867 | 31.87 | 18.55 |
| 87 | 169 | 23 | 36.95 | 36.059 | 13.902 | 41.29 | 24.93 |
| 90 | 219 | 23 | 54.983 | 63.862 | 18.604 | 58.98 | 18.98 |
| 88 | 245 | 23 | 31.65 | 32.49 | 15.052 | 43.04 | 28.45 |
| 34 | 68 | 23 | 25.683 | 25.924 | 5.54 | 21.54 | 13.36 |
| 13 | 35 | 23 | 38.483 | 38.968 | 9.147 | 32.02 | 14.58 |
| 218 | 19 | 23 | 19.9 | 21.536 | 9.15 | 26.47 | 26.83 |
| 228 | 80 | 22 | 32.458 | 32.206 | 7.776 | 25.62 | 16.86 |
| 25 | 157 | 22 | 24.767 | 25.989 | 7.381 | 25.29 | 18.72 |
| 122 | 122 | 22 | 4.333 | 4.396 | 0.624 | 4.98 | 8.25 |
| 226 | 14 | 22 | 29.45 | 33.098 | 13.735 | 40 | 27.07 |
| 195 | 241 | 22 | 65.375 | 70.654 | 19.829 | 63.75 | 18.8 |
| 32 | 236 | 22 | 45.542 | 46.864 | 9.621 | 33.01 | 13.17 |
| 40 | 41 | 22 | 37.158 | 39.767 | 12.868 | 40.45 | 20.28 |
| 82 | 10 | 22 | 35.292 | 34.885 | 8.416 | 30.23 | 15.78 |
| 74 | 198 | 22 | 38.683 | 36.245 | 10.424 | 33.73 | 18.01 |