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 |
|---|---|---|---|---|---|---|---|
| 124 | 101 | 1 | 19.433 | 19.433 | 12.68 | 34.97 | 39.15 |
| 254 | 46 | 1 | 18.117 | 18.117 | 6.13 | 19.5 | 20.3 |
| 81 | 127 | 1 | 41.617 | 41.617 | 5.76 | 28.5 | 8.3 |
| 190 | 200 | 1 | 49.083 | 49.083 | 22.54 | 63 | 27.55 |
| 89 | 23 | 1 | 36.65 | 36.65 | 16.62 | 47.5 | 27.21 |
| 151 | 187 | 1 | 70.767 | 70.767 | 22.69 | 71 | 19.24 |
| 259 | 153 | 1 | 15.833 | 15.833 | 4.29 | 16.5 | 16.26 |
| 18 | 4 | 1 | 59.117 | 59.117 | 12.59 | 45 | 12.78 |
| 39 | 252 | 1 | 33.733 | 33.733 | 14.41 | 43 | 25.63 |
| 11 | 68 | 1 | 65.8 | 65.8 | 15.21 | 51.5 | 13.87 |
| 28 | 195 | 1 | 46.05 | 46.05 | 12.27 | 43.5 | 15.99 |
| 41 | 30 | 1 | 68.25 | 68.25 | 25.63 | 73 | 22.53 |
| 147 | 144 | 1 | 41.733 | 41.733 | 12.85 | 41 | 18.47 |
| 160 | 49 | 1 | 28.233 | 28.233 | 5.69 | 23 | 12.09 |
| 102 | 211 | 1 | 30.833 | 30.833 | 10.59 | 52 | 20.61 |
| 159 | 56 | 1 | 23 | 23 | 11.3 | 32 | 29.48 |
| 258 | 159 | 1 | 32.217 | 32.217 | 15.81 | 43.5 | 29.44 |
| 39 | 196 | 1 | 39.917 | 39.917 | 9.41 | 35 | 14.14 |
| 2 | 61 | 1 | 31.583 | 31.583 | 12.5 | 36.5 | 23.75 |
| 52 | 20 | 1 | 58.383 | 58.383 | 18.63 | 55 | 19.15 |
| 160 | 91 | 1 | 40.583 | 40.583 | 12.06 | 40 | 17.83 |
| 31 | 259 | 1 | 12.3 | 12.3 | 3.33 | 12.5 | 16.24 |
| 206 | 182 | 1 | 72.933 | 72.933 | 12.67 | 52 | 10.42 |
| 154 | 49 | 1 | 23.95 | 23.95 | 6.9 | 23 | 17.29 |
| 19 | 13 | 1 | 3 | 3 | 0.82 | 4.5 | 16.4 |