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 |
|---|---|---|---|---|---|---|---|
| 154 | 132 | 29 | 25.85 | 27.43 | 13.673 | 46.98 | 32.39 |
| 14 | 234 | 29 | 39.367 | 39.867 | 11.021 | 35.38 | 17.35 |
| 134 | 229 | 29 | 29.517 | 31.695 | 11.278 | 48.86 | 23.32 |
| 74 | 72 | 29 | 43.067 | 47.876 | 18.72 | 55.33 | 25.22 |
| 248 | 75 | 29 | 26.083 | 28.698 | 6.72 | 24.31 | 16.78 |
| 75 | 22 | 29 | 45.967 | 49.642 | 19.015 | 55.84 | 24.39 |
| 56 | 28 | 29 | 16.117 | 15.698 | 4.366 | 15.98 | 18.81 |
| 72 | 132 | 29 | 24.65 | 27.061 | 9.442 | 32.94 | 21.59 |
| 159 | 24 | 29 | 23.45 | 24.848 | 3.587 | 17.79 | 9.29 |
| 80 | 54 | 29 | 12.733 | 14.206 | 5.125 | 16.75 | 24.79 |
| 260 | 65 | 29 | 26.633 | 30.37 | 7.464 | 27.71 | 17.01 |
| 78 | 254 | 29 | 22.133 | 23.129 | 4.99 | 20.09 | 13.81 |
| 171 | 48 | 29 | 57.5 | 57.19 | 15.289 | 51.74 | 16.74 |
| 189 | 100 | 29 | 36 | 35.899 | 7.278 | 28.69 | 12.74 |
| 167 | 213 | 29 | 14.533 | 17.404 | 3.263 | 14.67 | 12.45 |
| 203 | 75 | 29 | 52.717 | 51.355 | 21.449 | 57.93 | 25.68 |
| 225 | 195 | 29 | 32.683 | 32.008 | 6.128 | 24.69 | 12.95 |
| 219 | 114 | 29 | 45.667 | 45.668 | 16.53 | 52 | 23.53 |
| 131 | 10 | 29 | 19.933 | 20.683 | 4.473 | 17.29 | 13.22 |
| 70 | 57 | 29 | 7.317 | 8.095 | 2.449 | 11.05 | 22.99 |
| 142 | 122 | 29 | 66.85 | 67.989 | 18.214 | 58.22 | 16.98 |
| 159 | 246 | 29 | 32.45 | 34.777 | 9.503 | 33.06 | 17.47 |
| 177 | 62 | 29 | 13.85 | 14.405 | 2.753 | 12.28 | 11.32 |
| 197 | 124 | 29 | 17.417 | 18.356 | 4.275 | 16.59 | 14.66 |
| 41 | 177 | 29 | 50.4 | 53.757 | 16.947 | 53.5 | 20.61 |