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 |
|---|---|---|---|---|---|---|---|
| 165 | 166 | 4 | 59.842 | 59.033 | 15.812 | 52.12 | 16.37 |
| 47 | 71 | 4 | 85.083 | 81.85 | 22.1 | 72.75 | 18.05 |
| 203 | 71 | 4 | 42.008 | 42.212 | 13.435 | 43.09 | 19.52 |
| 73 | 192 | 4 | 9.067 | 9.092 | 1.61 | 8.25 | 10.89 |
| 51 | 252 | 4 | 27.033 | 26.842 | 6.988 | 23.44 | 16.72 |
| 147 | 20 | 4 | 14.792 | 17.75 | 4.055 | 15.88 | 14.11 |
| 171 | 135 | 4 | 17.517 | 19.962 | 4.383 | 16.88 | 13.91 |
| 134 | 76 | 4 | 24.1 | 25.863 | 5.547 | 20.91 | 13.81 |
| 146 | 9 | 4 | 30.392 | 37.383 | 10.15 | 34.25 | 18.09 |
| 136 | 31 | 4 | 17.617 | 17.017 | 2.56 | 13 | 9.43 |
| 144 | 117 | 4 | 49.908 | 50.154 | 25.955 | 70.33 | 32.36 |
| 137 | 187 | 4 | 54.067 | 52.696 | 20.492 | 60.12 | 23.86 |
| 218 | 258 | 4 | 25.542 | 25.8 | 6.06 | 21.89 | 14.21 |
| 177 | 113 | 4 | 44.5 | 46.304 | 7.34 | 30.07 | 9.74 |
| 212 | 100 | 4 | 45.058 | 45.408 | 11.988 | 41.62 | 17.86 |
| 177 | 249 | 4 | 47.258 | 49.975 | 11.107 | 40.68 | 13.39 |
| 55 | 52 | 4 | 32.833 | 30.792 | 8.84 | 28.88 | 17.57 |
| 138 | 2 | 4 | 50.567 | 49.258 | 18.215 | 54.25 | 22.09 |
| 153 | 182 | 4 | 22.242 | 21.85 | 5.537 | 19.88 | 15.29 |
| 85 | 244 | 4 | 73.392 | 71.975 | 18.625 | 62.5 | 15.75 |
| 169 | 59 | 4 | 12.208 | 11.9 | 1.512 | 9.12 | 7.69 |
| 93 | 218 | 4 | 38.633 | 34.696 | 9.212 | 30.25 | 17.47 |
| 5 | 140 | 4 | 85.342 | 81.617 | 29.637 | 88.62 | 23.05 |
| 242 | 72 | 4 | 62.633 | 62.767 | 20.705 | 63.25 | 20.25 |
| 202 | 168 | 4 | 26.758 | 25.712 | 6.5 | 23.5 | 15.92 |