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 |
|---|---|---|---|---|---|---|---|
| 174 | 138 | 2 | 28.133 | 28.133 | 13.515 | 37.55 | 30.27 |
| 70 | 78 | 2 | 20.292 | 20.292 | 10.55 | 30.5 | 31.26 |
| 133 | 1 | 2 | 59.017 | 59.017 | 31.4 | 105.25 | 31.25 |
| 190 | 145 | 2 | 38.6 | 38.6 | 7.19 | 29 | 11.18 |
| 94 | 81 | 2 | 21.65 | 21.65 | 4.565 | 17.52 | 12.65 |
| 62 | 18 | 2 | 65.292 | 65.292 | 18.865 | 62 | 17.37 |
| 227 | 236 | 2 | 45.225 | 45.225 | 13.99 | 41.98 | 18.74 |
| 257 | 9 | 2 | 48.008 | 48.008 | 19.05 | 55.25 | 24.01 |
| 108 | 256 | 2 | 35.275 | 35.275 | 14.545 | 40.52 | 27.76 |
| 120 | 230 | 2 | 23.242 | 23.242 | 8.55 | 26.75 | 22.18 |
| 108 | 97 | 2 | 35.158 | 35.158 | 11.1 | 35.75 | 20.23 |
| 174 | 50 | 2 | 34.4 | 34.4 | 13.65 | 44 | 26.3 |
| 235 | 215 | 2 | 45.2 | 45.2 | 18.825 | 53.75 | 27.58 |
| 147 | 24 | 2 | 28.608 | 28.608 | 8.255 | 28.25 | 22.49 |
| 80 | 117 | 2 | 64.175 | 64.175 | 22.525 | 67.25 | 21.14 |
| 254 | 10 | 2 | 27.392 | 27.392 | 17.01 | 46 | 36.35 |
| 38 | 108 | 2 | 64.058 | 64.058 | 22.145 | 70.72 | 21.5 |
| 4 | 19 | 2 | 41.083 | 41.083 | 18.395 | 51.5 | 28.46 |
| 259 | 239 | 2 | 35.9 | 35.9 | 15.51 | 58.75 | 26.1 |
| 213 | 121 | 2 | 30.117 | 30.117 | 12.885 | 36.36 | 25.7 |
| 12 | 102 | 2 | 36.858 | 36.858 | 10.75 | 34.5 | 17.51 |
| 96 | 168 | 2 | 34.458 | 34.458 | 14.35 | 42.25 | 25.25 |
| 228 | 81 | 2 | 78.183 | 78.183 | 24.655 | 76.5 | 19.18 |
| 34 | 111 | 2 | 23.05 | 23.05 | 5.175 | 18.75 | 13.15 |
| 36 | 86 | 2 | 70.367 | 70.367 | 15.56 | 56.75 | 13.45 |