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 |
|---|---|---|---|---|---|---|---|
| 88 | 93 | 43 | 45.017 | 48.105 | 15.647 | 48.92 | 22.42 |
| 49 | 14 | 43 | 25.9 | 27.694 | 8.84 | 28.79 | 21.02 |
| 32 | 81 | 43 | 12.133 | 12.444 | 2.304 | 10.85 | 11.38 |
| 17 | 68 | 43 | 34.85 | 42.112 | 7.357 | 29.31 | 11.83 |
| 95 | 215 | 43 | 21.5 | 21.999 | 4.629 | 18 | 13.36 |
| 65 | 82 | 43 | 19.933 | 21.881 | 8.056 | 25.35 | 23.54 |
| 80 | 74 | 43 | 26.133 | 27.298 | 9.726 | 30.2 | 22.95 |
| 113 | 155 | 43 | 45.267 | 47.014 | 14.035 | 44.78 | 18.64 |
| 185 | 32 | 43 | 8.817 | 11.495 | 1.566 | 9.26 | 9.31 |
| 174 | 213 | 43 | 19.133 | 20.048 | 5.686 | 20.18 | 18.6 |
| 37 | 164 | 43 | 28.833 | 34.118 | 6.71 | 26.37 | 13.14 |
| 243 | 137 | 43 | 32.283 | 34.578 | 9.814 | 32.73 | 19.49 |
| 138 | 172 | 43 | 54.717 | 60.766 | 24.263 | 69.2 | 26.2 |
| 209 | 85 | 43 | 30.617 | 34.041 | 7.746 | 28.42 | 14.77 |
| 223 | 196 | 43 | 17.617 | 19.786 | 6.574 | 21.81 | 21.76 |
| 202 | 236 | 43 | 12.75 | 14.343 | 2.645 | 11.78 | 12.11 |
| 141 | 34 | 43 | 29.4 | 29.746 | 8.453 | 28.76 | 17.87 |
| 181 | 178 | 43 | 15.55 | 19.651 | 4.644 | 17.72 | 15.44 |
| 112 | 83 | 43 | 16.15 | 17.254 | 4.947 | 17.62 | 17.97 |
| 181 | 151 | 43 | 37.167 | 38.319 | 11.169 | 36.95 | 18.28 |
| 119 | 166 | 43 | 20.05 | 21.058 | 4.092 | 17.21 | 12.4 |
| 164 | 64 | 43 | 32.15 | 34.55 | 16.598 | 48.56 | 30.01 |
| 186 | 222 | 43 | 52.2 | 53.242 | 17.508 | 54.12 | 20.73 |
| 259 | 51 | 43 | 14.133 | 15.691 | 2.879 | 12.98 | 11.69 |
| 186 | 122 | 43 | 45.583 | 50.113 | 15.861 | 49.85 | 20.95 |