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 |
|---|---|---|---|---|---|---|---|
| 125 | 214 | 12 | 28.75 | 31.508 | 13.674 | 41.38 | 27.03 |
| 114 | 219 | 12 | 43.2 | 43.64 | 16.986 | 51.17 | 25.41 |
| 241 | 167 | 12 | 22.333 | 23.824 | 4.828 | 19.83 | 12.88 |
| 223 | 76 | 12 | 29.083 | 31.537 | 13.103 | 38.84 | 27.89 |
| 55 | 137 | 12 | 49.733 | 48.275 | 18.148 | 53.42 | 23.09 |
| 200 | 137 | 12 | 40.408 | 41.956 | 13.436 | 40.05 | 19.86 |
| 136 | 185 | 12 | 23.05 | 23.967 | 4.163 | 18.3 | 11.38 |
| 190 | 54 | 12 | 15.933 | 16.657 | 3.653 | 14.71 | 13.46 |
| 261 | 215 | 12 | 41.45 | 45.264 | 18.397 | 52.75 | 25.82 |
| 222 | 42 | 12 | 42.292 | 48.044 | 21.517 | 59.7 | 28.04 |
| 129 | 167 | 12 | 21.608 | 21.676 | 8.424 | 26.33 | 23.85 |
| 32 | 137 | 12 | 44.458 | 47.95 | 13.465 | 42.66 | 17.92 |
| 71 | 10 | 12 | 39.833 | 38.46 | 11.066 | 35.25 | 17.7 |
| 145 | 15 | 12 | 25.4 | 26.944 | 13.237 | 39.71 | 31.05 |
| 244 | 218 | 12 | 51.108 | 51.2 | 23.015 | 67.22 | 27.58 |
| 231 | 122 | 12 | 57.45 | 56.91 | 17.221 | 54.21 | 21.56 |
| 13 | 111 | 12 | 16.5 | 18.11 | 5.75 | 20.5 | 21.19 |
| 254 | 126 | 12 | 17.942 | 18.778 | 6.944 | 22.49 | 22.99 |
| 162 | 184 | 12 | 38.858 | 38.181 | 13.846 | 41.58 | 22.54 |
| 51 | 159 | 12 | 24.567 | 29.01 | 8.946 | 29.12 | 20.24 |
| 82 | 69 | 12 | 31.283 | 28.335 | 9.477 | 30.21 | 21.33 |
| 167 | 230 | 12 | 40.508 | 41.682 | 9.058 | 32.1 | 14.29 |
| 219 | 7 | 12 | 36.658 | 37.942 | 14.502 | 45.18 | 25.34 |
| 191 | 121 | 12 | 17.275 | 16.156 | 4.113 | 15.83 | 17.21 |
| 164 | 109 | 12 | 53.108 | 55.364 | 22.64 | 65.46 | 25.08 |