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 |
|---|---|---|---|---|---|---|---|
| 254 | 3 | 48 | 10.292 | 10.008 | 1.71 | 8.91 | 10.56 |
| 42 | 259 | 48 | 23.1 | 26.285 | 9.435 | 29.84 | 23.32 |
| 41 | 259 | 48 | 27.167 | 29.765 | 10.377 | 33.03 | 22.41 |
| 69 | 250 | 48 | 21.492 | 22.87 | 6.057 | 21.77 | 17.23 |
| 144 | 149 | 48 | 35.867 | 36.249 | 11.772 | 37.05 | 20.83 |
| 4 | 35 | 48 | 33.9 | 36.723 | 9.08 | 30.92 | 15.54 |
| 65 | 12 | 48 | 11.458 | 12.655 | 2.805 | 12.84 | 14.59 |
| 116 | 209 | 48 | 41.15 | 41.867 | 11.126 | 37.35 | 17.15 |
| 219 | 262 | 48 | 35.342 | 35.848 | 16.916 | 51.91 | 30.38 |
| 237 | 177 | 48 | 45.367 | 49.476 | 12.562 | 42.74 | 16.46 |
| 134 | 48 | 48 | 37.633 | 41.949 | 12.346 | 51.91 | 19.73 |
| 43 | 165 | 48 | 47.483 | 52.469 | 15.263 | 49.19 | 18.67 |
| 255 | 85 | 48 | 25.725 | 28.192 | 6.586 | 23.82 | 15.07 |
| 91 | 261 | 47 | 37.4 | 39.146 | 9.519 | 31.46 | 15.22 |
| 145 | 127 | 47 | 30.383 | 31.29 | 11.299 | 35.47 | 23.5 |
| 56 | 92 | 47 | 13.05 | 13.544 | 3.47 | 13.66 | 16.87 |
| 36 | 62 | 47 | 19.433 | 22.036 | 4.236 | 17.49 | 12.58 |
| 121 | 98 | 47 | 7.05 | 8.874 | 1.985 | 13.66 | 16.06 |
| 93 | 223 | 47 | 13.5 | 16.225 | 5.889 | 19.56 | 23.68 |
| 196 | 87 | 47 | 29.4 | 30.795 | 11.483 | 43.6 | 23.89 |
| 125 | 70 | 47 | 34.217 | 38.946 | 11.269 | 37.88 | 19.72 |
| 213 | 51 | 47 | 14.9 | 17.105 | 6.073 | 19.9 | 24.35 |
| 151 | 60 | 47 | 27.917 | 28.682 | 8.379 | 27.87 | 19.37 |
| 190 | 17 | 47 | 13.467 | 14.837 | 2.612 | 12.06 | 11.16 |
| 37 | 249 | 47 | 22.883 | 24.584 | 5.263 | 20.38 | 13.33 |