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 |
|---|---|---|---|---|---|---|---|
| 121 | 44 | 7 | 75.65 | 78.336 | 43.579 | 117.71 | 33.73 |
| 71 | 161 | 7 | 69.817 | 63.75 | 12.777 | 49.07 | 12.62 |
| 148 | 156 | 7 | 30.3 | 33.338 | 19.414 | 53.36 | 35.95 |
| 52 | 178 | 7 | 26.867 | 25.793 | 7.269 | 25.14 | 17 |
| 246 | 46 | 7 | 49.017 | 49.748 | 20.52 | 58.07 | 25.39 |
| 26 | 139 | 7 | 61.983 | 66.352 | 21.924 | 63.54 | 20.47 |
| 127 | 213 | 7 | 22.8 | 26.445 | 9.246 | 29.43 | 22.54 |
| 55 | 197 | 7 | 38.533 | 38.814 | 16.844 | 46.95 | 26.28 |
| 118 | 14 | 7 | 49.1 | 47.402 | 15.913 | 48.99 | 21.47 |
| 182 | 241 | 7 | 19.967 | 20.126 | 5.304 | 18.79 | 16.5 |
| 241 | 250 | 7 | 24.183 | 25.093 | 5.883 | 21.39 | 14.56 |
| 149 | 151 | 7 | 61.2 | 57.307 | 22.007 | 63.81 | 23.58 |
| 49 | 203 | 7 | 46.883 | 51.207 | 15.549 | 48.77 | 18.92 |
| 167 | 32 | 7 | 25.083 | 24.452 | 4.853 | 18.86 | 13.56 |
| 100 | 30 | 7 | 58.933 | 62.964 | 19.749 | 62.86 | 20.54 |
| 31 | 213 | 7 | 10.717 | 12.664 | 3.28 | 12.79 | 17.51 |
| 56 | 147 | 7 | 24.567 | 29.481 | 12.111 | 36.36 | 26.14 |
| 61 | 221 | 7 | 41.5 | 38.888 | 13.221 | 39.94 | 20.83 |
| 200 | 235 | 7 | 21.617 | 32.307 | 7.639 | 29.5 | 16.97 |
| 76 | 236 | 7 | 65.9 | 65.419 | 18.4 | 59.86 | 16.95 |
| 61 | 156 | 7 | 50.717 | 48.214 | 23.59 | 66.64 | 29.87 |
| 60 | 231 | 7 | 33.017 | 36.198 | 15.117 | 44.21 | 26.24 |
| 129 | 133 | 7 | 25.083 | 30 | 13.011 | 38.07 | 28.52 |
| 85 | 232 | 7 | 33.267 | 33.1 | 8.594 | 29.5 | 15.84 |
| 125 | 6 | 7 | 28.533 | 29.279 | 13.019 | 38.14 | 27.43 |