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 |
|---|---|---|---|---|---|---|---|
| 107 | 195 | 278 | 25.258 | 26.908 | 7.34 | 24.93 | 17.45 |
| 186 | 190 | 278 | 36.15 | 37.757 | 8.103 | 30.41 | 13.67 |
| 100 | 71 | 278 | 46.425 | 48.27 | 11.788 | 41.07 | 15.78 |
| 243 | 238 | 278 | 16.033 | 17.391 | 5.68 | 19.32 | 21.8 |
| 4 | 151 | 278 | 25.542 | 26.679 | 7.016 | 24.68 | 16.86 |
| 112 | 49 | 278 | 14.042 | 15.536 | 3.65 | 14.15 | 15.24 |
| 234 | 173 | 278 | 34.383 | 36.337 | 9.321 | 32.33 | 16.47 |
| 50 | 227 | 278 | 29.742 | 31.547 | 10.207 | 32.48 | 20.08 |
| 238 | 128 | 278 | 16.608 | 17.979 | 7.177 | 22.62 | 25.77 |
| 106 | 195 | 277 | 7.933 | 8.905 | 1.606 | 8.18 | 11.64 |
| 239 | 235 | 277 | 20.917 | 23.547 | 7.576 | 24.75 | 21.47 |
| 186 | 182 | 277 | 36.8 | 39.802 | 13.043 | 41.01 | 21.35 |
| 170 | 159 | 277 | 21.1 | 23.788 | 7.178 | 23.85 | 19.98 |
| 79 | 67 | 277 | 27.717 | 28.994 | 10.831 | 33.34 | 23.48 |
| 97 | 140 | 277 | 24.033 | 25.115 | 7.899 | 25.88 | 21.11 |
| 72 | 76 | 277 | 16 | 16.603 | 2.973 | 13.68 | 11.09 |
| 107 | 258 | 277 | 34.233 | 35.138 | 10.643 | 34.5 | 19.65 |
| 256 | 129 | 277 | 16.667 | 17.855 | 5.896 | 20.31 | 21.15 |
| 48 | 174 | 277 | 29.15 | 31.183 | 14.041 | 40.95 | 28.66 |
| 255 | 158 | 277 | 25.033 | 26.005 | 4.799 | 20.01 | 11.73 |
| 90 | 54 | 277 | 25.483 | 26.87 | 6.103 | 22.44 | 14.5 |
| 4 | 225 | 277 | 25.35 | 26.711 | 5.13 | 20.87 | 12.27 |
| 7 | 92 | 276 | 16.708 | 18.329 | 6.607 | 21.53 | 23.21 |
| 142 | 160 | 276 | 32.808 | 34.376 | 8.331 | 29.85 | 15.23 |
| 242 | 242 | 276 | 4.55 | 5.964 | 1.089 | 6.86 | 37.56 |