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 |
|---|---|---|---|---|---|---|---|
| 209 | 39 | 70 | 58.158 | 56.575 | 12.953 | 46.62 | 15.03 |
| 87 | 159 | 70 | 30.25 | 32.958 | 10.835 | 33.96 | 22.82 |
| 157 | 229 | 70 | 15.55 | 18.05 | 5.958 | 50.06 | 22.4 |
| 11 | 22 | 70 | 8.808 | 10.145 | 1.489 | 8.63 | 8.87 |
| 216 | 88 | 70 | 39.242 | 44.525 | 18.771 | 49.8 | 26.61 |
| 179 | 244 | 70 | 28.142 | 28.357 | 8.315 | 28.26 | 19.48 |
| 68 | 252 | 70 | 39.058 | 42.679 | 15.669 | 47.52 | 23.82 |
| 157 | 80 | 70 | 7.5 | 10.187 | 2.529 | 12.68 | 17.02 |
| 37 | 68 | 70 | 34.575 | 38.741 | 7.579 | 29.56 | 13.01 |
| 106 | 62 | 70 | 12.55 | 13.343 | 2.384 | 11.22 | 11.33 |
| 237 | 35 | 69 | 51.667 | 54.809 | 14.041 | 46.71 | 16.37 |
| 247 | 136 | 69 | 13.683 | 14.744 | 3.274 | 13.47 | 14.13 |
| 229 | 98 | 69 | 39.517 | 41.74 | 12.887 | 40.36 | 20.11 |
| 244 | 223 | 69 | 25.883 | 27.037 | 7.932 | 26.67 | 18.83 |
| 41 | 97 | 69 | 35.9 | 37.32 | 12.026 | 37.78 | 20.45 |
| 218 | 203 | 69 | 12.717 | 13.677 | 3.078 | 12.72 | 14.15 |
| 49 | 45 | 69 | 14.35 | 15.516 | 3.301 | 17.64 | 13.93 |
| 68 | 147 | 69 | 32.933 | 34.936 | 11.028 | 35.37 | 20.16 |
| 45 | 71 | 69 | 34.7 | 36.121 | 7.669 | 28.98 | 13.51 |
| 90 | 102 | 69 | 34.65 | 36.86 | 9.538 | 32.57 | 17.31 |
| 256 | 260 | 69 | 16.683 | 17.383 | 5.126 | 18.12 | 18.99 |
| 42 | 205 | 69 | 38.683 | 42.67 | 18.159 | 51.67 | 27.01 |
| 47 | 78 | 69 | 8.85 | 8.874 | 1.246 | 10.28 | 9.2 |
| 229 | 55 | 69 | 40.983 | 43.423 | 19.216 | 54.8 | 28.13 |
| 189 | 68 | 69 | 28.117 | 30.119 | 5.879 | 23.88 | 12.63 |