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 |
|---|---|---|---|---|---|---|---|
| 260 | 152 | 13 | 30.583 | 29.058 | 8.927 | 28.88 | 19.2 |
| 143 | 175 | 13 | 32.517 | 50.081 | 17.376 | 53.27 | 25.56 |
| 157 | 153 | 13 | 34.117 | 35.009 | 15.865 | 44.5 | 28.3 |
| 14 | 35 | 13 | 48.65 | 50.597 | 12.287 | 42.14 | 15.49 |
| 220 | 51 | 13 | 25.3 | 29.641 | 10.012 | 31.8 | 22.91 |
| 254 | 4 | 13 | 64.183 | 72.41 | 17.06 | 57.23 | 14.67 |
| 134 | 261 | 13 | 37.117 | 38.195 | 16.135 | 52.64 | 26.75 |
| 79 | 46 | 13 | 40.65 | 39.087 | 18.155 | 50.82 | 28.26 |
| 168 | 130 | 13 | 28.267 | 32.246 | 13.798 | 40.23 | 27.53 |
| 217 | 113 | 13 | 21.25 | 24.851 | 3.98 | 18.58 | 10.63 |
| 213 | 237 | 13 | 38.083 | 41.5 | 8.921 | 30.8 | 13.6 |
| 77 | 74 | 13 | 40.983 | 41.181 | 18.01 | 51.41 | 27.23 |
| 129 | 180 | 13 | 26.95 | 28.679 | 9.387 | 30.07 | 21.56 |
| 196 | 43 | 13 | 29.833 | 32.009 | 8.566 | 46.23 | 17.74 |
| 93 | 160 | 13 | 14.7 | 15.929 | 4.777 | 16.58 | 19.14 |
| 21 | 49 | 13 | 38.583 | 40.358 | 6.43 | 28.02 | 9.98 |
| 25 | 251 | 13 | 34.317 | 33.376 | 13.952 | 40.92 | 25.72 |
| 230 | 156 | 13 | 47.65 | 43.34 | 20.735 | 58.92 | 28.35 |
| 95 | 117 | 13 | 45.2 | 45.404 | 13.988 | 43.34 | 19.54 |
| 196 | 175 | 13 | 20.167 | 25.494 | 7.461 | 24.77 | 19.92 |
| 135 | 263 | 13 | 30.8 | 31.24 | 12.702 | 37.67 | 24.76 |
| 61 | 92 | 13 | 30.417 | 30.149 | 11.427 | 34.43 | 23.27 |
| 143 | 73 | 13 | 42.267 | 46.091 | 16.048 | 50.01 | 22.35 |
| 167 | 82 | 13 | 38.617 | 42.635 | 11.434 | 38.81 | 17.31 |
| 116 | 185 | 13 | 24.533 | 26.941 | 8.308 | 27.04 | 19.49 |