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 |
|---|---|---|---|---|---|---|---|
| 80 | 182 | 1 | 39.75 | 39.75 | 14.5 | 44.5 | 21.89 |
| 108 | 79 | 1 | 42.217 | 42.217 | 17.9 | 52 | 25.44 |
| 195 | 222 | 1 | 28.6 | 28.6 | 18.8 | 50 | 39.44 |
| 188 | 208 | 1 | 46.9 | 46.9 | 20.5 | 58.5 | 26.23 |
| 58 | 249 | 1 | 17.5 | 17.5 | 3.58 | 14 | 12.27 |
| 174 | 70 | 1 | 25.8 | 25.8 | 12.33 | 35.5 | 28.67 |
| 195 | 215 | 1 | 34.633 | 34.633 | 26.05 | 68 | 45.13 |
| 46 | 148 | 1 | 59.9 | 59.9 | 24.25 | 67 | 24.29 |
| 119 | 70 | 1 | 15.2 | 15.2 | 8 | 23 | 31.58 |
| 240 | 195 | 1 | 36.6 | 36.6 | 23.7 | 64 | 38.85 |
| 135 | 31 | 1 | 27.083 | 27.083 | 13.5 | 39.5 | 29.91 |
| 55 | 93 | 1 | 49.733 | 49.733 | 21.27 | 60.5 | 25.66 |
| 254 | 22 | 1 | 49.65 | 49.65 | 27.73 | 75.5 | 33.51 |
| 250 | 184 | 1 | 10.517 | 10.517 | 3.48 | 12 | 19.85 |
| 200 | 98 | 1 | 39.25 | 39.25 | 18.88 | 53.5 | 28.86 |
| 18 | 58 | 1 | 15.317 | 15.317 | 7.34 | 22 | 28.75 |
| 253 | 114 | 1 | 38.5 | 38.5 | 12.08 | 39 | 18.83 |
| 150 | 180 | 1 | 34.1 | 34.1 | 10.23 | 28.71 | 18 |
| 12 | 153 | 1 | 32.817 | 32.817 | 15.34 | 43.5 | 28.05 |
| 244 | 124 | 1 | 43.167 | 43.167 | 21.03 | 57.3 | 29.23 |
| 207 | 34 | 1 | 37.817 | 37.817 | 8.49 | 32 | 13.47 |
| 130 | 120 | 1 | 32.517 | 32.517 | 15.66 | 52 | 28.9 |
| 187 | 244 | 1 | 26.2 | 26.2 | 8.33 | 27.5 | 19.08 |
| 121 | 167 | 1 | 27.667 | 27.667 | 13.7 | 39.5 | 29.71 |
| 175 | 242 | 1 | 28.883 | 28.883 | 13.15 | 38 | 27.32 |