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 |
|---|---|---|---|---|---|---|---|
| 70 | 210 | 6 | 51.617 | 54.306 | 20.218 | 59.3 | 26.38 |
| 74 | 102 | 6 | 25.842 | 30.2 | 14.388 | 40.33 | 30.21 |
| 202 | 92 | 6 | 28.367 | 33.058 | 8.768 | 30.67 | 17.89 |
| 157 | 65 | 6 | 24.333 | 30.933 | 6.557 | 29.19 | 20.22 |
| 167 | 129 | 6 | 27.233 | 28.183 | 7.733 | 26.13 | 16.94 |
| 255 | 150 | 6 | 31.992 | 32.261 | 18.008 | 50 | 33.89 |
| 150 | 87 | 6 | 29.658 | 36.194 | 14.803 | 50.88 | 28.59 |
| 149 | 17 | 6 | 31.183 | 33.897 | 6.663 | 25.92 | 12.06 |
| 62 | 63 | 6 | 18.083 | 23.139 | 4.343 | 18.25 | 12.55 |
| 126 | 233 | 6 | 26.1 | 32.608 | 8.11 | 29 | 20.26 |
| 17 | 260 | 6 | 14.775 | 17.578 | 6.965 | 22.17 | 26.56 |
| 28 | 73 | 6 | 18.1 | 17.719 | 4.26 | 16.42 | 14.9 |
| 37 | 254 | 6 | 41.983 | 42.044 | 19.507 | 54.3 | 28.2 |
| 50 | 59 | 6 | 25.175 | 25.372 | 9.853 | 29.42 | 24.44 |
| 227 | 155 | 6 | 33.733 | 33.608 | 7.6 | 25.63 | 14.41 |
| 92 | 238 | 6 | 34.867 | 34.967 | 12.892 | 40.59 | 23.61 |
| 74 | 29 | 6 | 53.008 | 50.733 | 23.985 | 66.67 | 29.89 |
| 61 | 208 | 6 | 43.2 | 44.336 | 16.728 | 50.25 | 23.67 |
| 89 | 95 | 6 | 36.358 | 39.767 | 13.552 | 42.25 | 22.07 |
| 243 | 37 | 6 | 31.908 | 40.467 | 16.417 | 46.55 | 26.56 |
| 119 | 200 | 6 | 16.4 | 18.206 | 7.842 | 23.5 | 25.4 |
| 76 | 182 | 6 | 41.592 | 43.892 | 19.217 | 54.83 | 27.46 |
| 198 | 33 | 6 | 33.675 | 35.947 | 6.37 | 24.97 | 12.06 |
| 223 | 72 | 6 | 35.475 | 40.944 | 14.3 | 44.17 | 23.12 |
| 144 | 122 | 6 | 53.567 | 57.844 | 16.617 | 53.67 | 18.16 |