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 |
|---|---|---|---|---|---|---|---|
| 74 | 90 | 386 | 27.333 | 29.485 | 6.806 | 25.15 | 15.21 |
| 230 | 62 | 386 | 37.783 | 40.126 | 9.695 | 34.02 | 15.8 |
| 140 | 36 | 386 | 30.625 | 32.613 | 8.386 | 29.07 | 16.08 |
| 90 | 82 | 385 | 29.683 | 32.026 | 8.462 | 29.19 | 16.92 |
| 74 | 145 | 385 | 17.95 | 20.201 | 5.624 | 19.46 | 18.69 |
| 144 | 195 | 385 | 20.25 | 21.637 | 5.052 | 18.84 | 15.32 |
| 244 | 132 | 385 | 44.3 | 47.564 | 20.56 | 52.41 | 28.63 |
| 233 | 228 | 385 | 27.2 | 29.101 | 10.357 | 32.08 | 22.77 |
| 225 | 37 | 384 | 7.625 | 8.747 | 1.285 | 7.73 | 9.27 |
| 50 | 260 | 384 | 24 | 25.724 | 6.168 | 22.77 | 15.34 |
| 263 | 213 | 384 | 19.733 | 22.188 | 7.061 | 23.1 | 21.13 |
| 196 | 196 | 384 | 5.175 | 7.441 | 1.411 | 9.74 | 32.57 |
| 209 | 189 | 384 | 19.125 | 19.794 | 3.904 | 16.05 | 12.66 |
| 10 | 79 | 384 | 40.483 | 42.58 | 15.104 | 51.99 | 24.64 |
| 125 | 36 | 384 | 26.942 | 28.314 | 6.22 | 23.71 | 13.96 |
| 232 | 36 | 383 | 19.483 | 20.702 | 4.849 | 18.46 | 15.02 |
| 43 | 12 | 383 | 28.95 | 30.109 | 6.875 | 25.97 | 14.66 |
| 13 | 188 | 383 | 28.917 | 29.926 | 7.106 | 25.67 | 15.1 |
| 230 | 56 | 383 | 29.167 | 31.58 | 9.266 | 30.92 | 19.09 |
| 263 | 83 | 383 | 22.333 | 23.617 | 6.083 | 21.57 | 16.42 |
| 233 | 127 | 383 | 22.233 | 25.31 | 9.705 | 29.87 | 25.63 |
| 61 | 76 | 383 | 22.4 | 23.578 | 4.302 | 18.22 | 11.46 |
| 138 | 60 | 383 | 22.383 | 24.203 | 8.801 | 27.89 | 23.7 |
| 261 | 225 | 383 | 30.933 | 31.799 | 6.405 | 24.76 | 12.64 |
| 75 | 223 | 383 | 19.633 | 21.874 | 5.997 | 21.78 | 18.58 |