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 |
|---|---|---|---|---|---|---|---|
| 130 | 76 | 63 | 30.567 | 31.334 | 8.336 | 28.5 | 16.83 |
| 91 | 123 | 63 | 18.383 | 18.398 | 2.87 | 14.15 | 9.45 |
| 50 | 39 | 63 | 55.183 | 56.615 | 17.667 | 56.22 | 19.69 |
| 3 | 42 | 63 | 38.683 | 39.429 | 8.057 | 31.15 | 13.44 |
| 61 | 48 | 63 | 44.15 | 44.61 | 9.724 | 35.18 | 13.67 |
| 262 | 18 | 63 | 27.617 | 29.407 | 8.334 | 27.92 | 18.29 |
| 230 | 19 | 63 | 38.85 | 41.743 | 18.209 | 53.21 | 27.76 |
| 218 | 196 | 63 | 27.45 | 29.878 | 8.176 | 27.25 | 17.75 |
| 233 | 91 | 63 | 42.633 | 47.158 | 14.133 | 44.67 | 19.26 |
| 233 | 242 | 63 | 30.717 | 33.885 | 11.399 | 35.45 | 21.78 |
| 152 | 125 | 63 | 24.75 | 26.111 | 7.938 | 26.64 | 18.93 |
| 80 | 261 | 63 | 19.383 | 22.232 | 6.486 | 31.83 | 19.93 |
| 165 | 178 | 63 | 7.717 | 8.227 | 1.153 | 7.32 | 9.62 |
| 182 | 87 | 63 | 38.767 | 43.442 | 15.118 | 44.26 | 22.36 |
| 163 | 101 | 63 | 60.633 | 63.711 | 18.527 | 58.32 | 19.13 |
| 89 | 37 | 63 | 34.9 | 34.53 | 6.015 | 24.95 | 11.14 |
| 229 | 227 | 63 | 32 | 35.159 | 12.179 | 37.62 | 22.27 |
| 88 | 92 | 63 | 42.167 | 45.443 | 15.454 | 47.19 | 22.2 |
| 119 | 159 | 63 | 14.033 | 14.254 | 2.216 | 11.28 | 9.74 |
| 197 | 42 | 63 | 47.5 | 46.972 | 14.04 | 44.67 | 18.79 |
| 86 | 86 | 63 | 6.033 | 7.431 | 1.274 | 7.44 | 37.16 |
| 195 | 97 | 63 | 17.683 | 18.682 | 3.281 | 14.5 | 11.25 |
| 60 | 78 | 62 | 7.9 | 12.628 | 2.704 | 14.46 | 9.9 |
| 256 | 76 | 62 | 30.567 | 33.692 | 7.711 | 28.1 | 14.05 |
| 229 | 250 | 62 | 25.25 | 28.324 | 10.296 | 31.71 | 23.7 |