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 |
|---|---|---|---|---|---|---|---|
| 250 | 144 | 1 | 63.817 | 63.817 | 15 | 52 | 14.1 |
| 258 | 115 | 1 | 50.383 | 50.383 | 22 | 62 | 26.2 |
| 208 | 76 | 1 | 34.783 | 34.783 | 17.42 | 48.5 | 30.05 |
| 56 | 254 | 1 | 44.283 | 44.283 | 13.8 | 45.5 | 18.7 |
| 59 | 85 | 1 | 43.467 | 43.467 | 22.38 | 61.5 | 30.89 |
| 224 | 8 | 1 | 19.483 | 19.483 | 4.49 | 16.5 | 13.83 |
| 23 | 75 | 1 | 41.667 | 41.667 | 25.31 | 69.5 | 36.45 |
| 86 | 78 | 1 | 61.517 | 61.517 | 25.94 | 72.5 | 25.3 |
| 235 | 17 | 1 | 72.55 | 72.55 | 16.48 | 43.4 | 13.63 |
| 14 | 156 | 1 | 20.25 | 20.25 | 10.93 | 31 | 32.39 |
| 155 | 203 | 1 | 28.267 | 28.267 | 14.21 | 40.5 | 30.16 |
| 168 | 180 | 1 | 27.167 | 27.167 | 16.29 | 44.5 | 35.98 |
| 202 | 149 | 1 | 58.383 | 58.383 | 22.37 | 65.5 | 22.99 |
| 42 | 214 | 1 | 38.617 | 38.617 | 23.6 | 63.5 | 36.67 |
| 214 | 195 | 1 | 31.817 | 31.817 | 12.35 | 36 | 23.29 |
| 166 | 172 | 1 | 98.65 | 98.65 | 42.76 | 124 | 26.01 |
| 145 | 172 | 1 | 48.75 | 48.75 | 20 | 58 | 24.62 |
| 59 | 49 | 1 | 60.267 | 60.267 | 16.31 | 46.64 | 16.24 |
| 147 | 19 | 1 | 39.183 | 39.183 | 14 | 45.5 | 21.44 |
| 150 | 66 | 1 | 42.1 | 42.1 | 10.59 | 35.5 | 15.09 |
| 4 | 46 | 1 | 39.233 | 39.233 | 16.4 | 45.5 | 25.08 |
| 228 | 38 | 1 | 40.917 | 40.917 | 27.11 | 70.2 | 39.75 |
| 166 | 207 | 1 | 40.533 | 40.533 | 7.2 | 29.5 | 10.66 |
| 214 | 238 | 1 | 11.6 | 11.6 | 1.82 | 9.5 | 9.41 |
| 157 | 176 | 1 | 42.567 | 42.567 | 21.66 | 60 | 30.53 |