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 |
|---|---|---|---|---|---|---|---|
| 218 | 191 | 23 | 17.633 | 18.972 | 6.16 | 20.48 | 20.24 |
| 166 | 71 | 23 | 64.917 | 67.386 | 17.079 | 59.24 | 19.85 |
| 233 | 8 | 23 | 23.167 | 23.193 | 6.24 | 21.91 | 16.13 |
| 145 | 175 | 23 | 32.633 | 32.701 | 12.686 | 37.48 | 24.57 |
| 28 | 224 | 23 | 29.183 | 30.233 | 12.323 | 51.07 | 26.43 |
| 119 | 238 | 23 | 24.6 | 26.172 | 6.056 | 22.96 | 15.22 |
| 249 | 9 | 23 | 39.367 | 41.275 | 15.787 | 47.54 | 24.16 |
| 4 | 169 | 23 | 27.283 | 31.032 | 11.869 | 35.33 | 26.22 |
| 136 | 166 | 23 | 26.7 | 28.599 | 5.973 | 21.54 | 13.25 |
| 106 | 162 | 23 | 25.95 | 30.067 | 8.624 | 28.93 | 18.82 |
| 49 | 197 | 23 | 33.617 | 34.709 | 10.408 | 33.64 | 19.02 |
| 70 | 137 | 23 | 29.983 | 29.799 | 9.883 | 31.43 | 20.91 |
| 263 | 177 | 23 | 43.717 | 44.866 | 13.991 | 44.26 | 19.85 |
| 97 | 191 | 23 | 51.783 | 51.785 | 17.081 | 51.02 | 21.88 |
| 71 | 36 | 23 | 28.933 | 29.951 | 4.907 | 21.32 | 9.94 |
| 165 | 163 | 23 | 54.617 | 55.583 | 15.262 | 48.63 | 16.75 |
| 143 | 120 | 23 | 19 | 21.091 | 6.403 | 21.7 | 20.8 |
| 35 | 80 | 23 | 29.233 | 30.848 | 4.73 | 21.23 | 9.43 |
| 151 | 133 | 23 | 39.933 | 45.723 | 14.709 | 46.57 | 20.89 |
| 241 | 51 | 23 | 26.333 | 25.391 | 5.565 | 21.26 | 13.54 |
| 155 | 130 | 23 | 37.95 | 38.557 | 12.891 | 40.47 | 20.83 |
| 71 | 132 | 23 | 31.683 | 36.106 | 12.373 | 39.33 | 22.52 |
| 93 | 135 | 23 | 8.233 | 11.437 | 3.403 | 14.76 | 43.97 |
| 47 | 119 | 23 | 13.1 | 14.844 | 2.336 | 11.67 | 9.62 |
| 226 | 38 | 23 | 45.25 | 44.867 | 16.595 | 48.86 | 24.86 |