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 |
|---|---|---|---|---|---|---|---|
| 217 | 108 | 3 | 37.283 | 55.406 | 14.81 | 47.33 | 19.82 |
| 165 | 213 | 3 | 67.467 | 65.222 | 22.8 | 69.08 | 21.25 |
| 126 | 259 | 3 | 19.417 | 21.094 | 7.667 | 23.66 | 22.23 |
| 109 | 214 | 3 | 17.567 | 17.711 | 4.57 | 16.33 | 15.49 |
| 105 | 138 | 3 | 39.167 | 39.233 | 15.177 | 43.67 | 23.23 |
| 241 | 208 | 3 | 28.7 | 26.639 | 7.547 | 25.83 | 17.14 |
| 77 | 18 | 3 | 41.85 | 46.556 | 21.617 | 61.17 | 28.93 |
| 60 | 45 | 3 | 28.983 | 26.956 | 15.28 | 41.5 | 34.51 |
| 94 | 212 | 3 | 12.917 | 12.744 | 4.02 | 14.17 | 20.32 |
| 151 | 180 | 3 | 54.133 | 53.906 | 15.787 | 50.5 | 18.82 |
| 151 | 98 | 3 | 33.15 | 36.628 | 16.603 | 47.67 | 28.06 |
| 28 | 203 | 3 | 24.25 | 23.106 | 8.2 | 25.91 | 22.73 |
| 160 | 192 | 3 | 17.833 | 24 | 6.043 | 23.17 | 18.93 |
| 150 | 67 | 3 | 18.15 | 18.922 | 6.58 | 21.12 | 21.94 |
| 63 | 86 | 3 | 42.1 | 46.178 | 13.473 | 45.33 | 18.71 |
| 22 | 113 | 3 | 26.5 | 26.272 | 11.013 | 32.5 | 25.01 |
| 171 | 218 | 3 | 35.433 | 35.361 | 13.09 | 40.51 | 22.97 |
| 229 | 222 | 3 | 50.417 | 59.95 | 14.277 | 47.46 | 15.9 |
| 18 | 92 | 3 | 32.133 | 35.044 | 12.087 | 38.5 | 21.51 |
| 166 | 30 | 3 | 50.183 | 53.533 | 25.293 | 70.67 | 28.6 |
| 33 | 98 | 3 | 40.917 | 37.6 | 13.333 | 39.5 | 21.7 |
| 245 | 251 | 3 | 11.617 | 14.5 | 3.01 | 13 | 12.55 |
| 160 | 89 | 3 | 42.233 | 44.517 | 9.027 | 35 | 12.29 |
| 227 | 238 | 3 | 45 | 56.978 | 13.163 | 46.67 | 17.03 |
| 151 | 205 | 3 | 46.1 | 46.517 | 19.72 | 57.5 | 27.18 |