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 |
|---|---|---|---|---|---|---|---|
| 263 | 174 | 471 | 25.883 | 27.517 | 10.268 | 31.67 | 23.74 |
| 164 | 70 | 471 | 27.417 | 30.877 | 9.538 | 31.72 | 22.64 |
| 146 | 112 | 471 | 11.817 | 12.646 | 2.432 | 11.1 | 12.11 |
| 148 | 190 | 470 | 20.808 | 22.477 | 5.271 | 19.98 | 14.86 |
| 261 | 217 | 470 | 25.2 | 26.126 | 4.415 | 19.85 | 10.62 |
| 146 | 202 | 470 | 7.892 | 8.039 | 1.7 | 8.01 | 13.98 |
| 148 | 177 | 469 | 25.267 | 26.952 | 5.986 | 22.56 | 13.98 |
| 229 | 189 | 469 | 32.283 | 33.359 | 8.577 | 29.55 | 16.37 |
| 164 | 83 | 469 | 23.783 | 25.423 | 6.838 | 23.88 | 17.13 |
| 90 | 62 | 469 | 32.383 | 34.656 | 7.204 | 27.36 | 13.31 |
| 188 | 181 | 469 | 11.5 | 12.535 | 2.347 | 10.94 | 12.41 |
| 193 | 137 | 469 | 13.25 | 15.605 | 3.899 | 14.69 | 16.91 |
| 92 | 92 | 469 | 6.65 | 9.366 | 1.493 | 9.73 | 19.1 |
| 152 | 163 | 468 | 18.217 | 19.47 | 5.086 | 18.98 | 17.29 |
| 223 | 161 | 468 | 28.358 | 30.768 | 7.575 | 30.86 | 16.39 |
| 42 | 162 | 468 | 22.567 | 24.577 | 4.947 | 19.66 | 13.7 |
| 230 | 134 | 467 | 33.183 | 36.903 | 12.46 | 39.6 | 22.28 |
| 229 | 198 | 467 | 24.083 | 26.04 | 6.79 | 23.62 | 16.38 |
| 146 | 234 | 467 | 19.817 | 22.693 | 4.125 | 17.66 | 12.31 |
| 234 | 217 | 467 | 28.467 | 28.969 | 4.585 | 21.46 | 10.09 |
| 255 | 170 | 467 | 22.533 | 24.027 | 5.105 | 20.02 | 13.59 |
| 144 | 257 | 467 | 21.95 | 22.893 | 6.712 | 22.74 | 18.91 |
| 25 | 138 | 466 | 25.95 | 28.024 | 10.957 | 33.18 | 25.92 |
| 95 | 135 | 466 | 9.1 | 9.936 | 2.059 | 9.52 | 13.27 |
| 82 | 7 | 466 | 14.05 | 14.973 | 3.018 | 13 | 12.68 |