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 |
|---|---|---|---|---|---|---|---|
| 12 | 82 | 18 | 30.775 | 32.756 | 10.459 | 33.31 | 20.35 |
| 106 | 186 | 18 | 30.9 | 32.136 | 7.299 | 26.64 | 14.12 |
| 222 | 137 | 18 | 64.158 | 62.839 | 19.758 | 60.43 | 19.27 |
| 129 | 97 | 18 | 31.133 | 33.762 | 8.975 | 30.36 | 18.55 |
| 247 | 13 | 18 | 36.317 | 40.215 | 13.158 | 41.31 | 20.61 |
| 24 | 216 | 18 | 46.208 | 46.994 | 16.41 | 51.97 | 22.36 |
| 50 | 81 | 18 | 35.058 | 41.403 | 16.418 | 49.31 | 27.56 |
| 80 | 212 | 18 | 27.167 | 29.094 | 13.652 | 38.77 | 28.69 |
| 48 | 245 | 18 | 44.217 | 45.152 | 19.44 | 55.94 | 26.28 |
| 165 | 261 | 18 | 38.742 | 39.023 | 8.056 | 31.43 | 13.37 |
| 213 | 32 | 18 | 17.233 | 16.89 | 4.664 | 17.33 | 17.51 |
| 208 | 75 | 18 | 32.075 | 32.369 | 9.213 | 29.92 | 18.29 |
| 181 | 152 | 18 | 38 | 39.131 | 13.101 | 41.25 | 21.08 |
| 167 | 20 | 18 | 15.858 | 16.787 | 3.002 | 13.33 | 10.9 |
| 112 | 243 | 18 | 32.633 | 34.544 | 13.356 | 40.5 | 24.43 |
| 216 | 38 | 18 | 24 | 24.925 | 7.134 | 23.86 | 18.72 |
| 9 | 177 | 18 | 19.742 | 20.721 | 12.572 | 35.78 | 37.56 |
| 157 | 143 | 18 | 26.783 | 31.306 | 7.414 | 50.75 | 15.25 |
| 212 | 18 | 18 | 17.5 | 20.487 | 5.579 | 19.85 | 17.17 |
| 69 | 49 | 18 | 46.808 | 46.331 | 15.69 | 48.03 | 20.98 |
| 258 | 75 | 18 | 50.55 | 50.137 | 16.039 | 49.7 | 20.51 |
| 239 | 215 | 18 | 49.683 | 50.46 | 18.389 | 52.68 | 22.67 |
| 85 | 123 | 18 | 17.433 | 19.905 | 3.633 | 15.84 | 11.49 |
| 56 | 157 | 18 | 9.575 | 10.689 | 3.237 | 13.69 | 19.74 |
| 129 | 62 | 18 | 44.617 | 46.895 | 12.501 | 40.74 | 17.35 |