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 |
|---|---|---|---|---|---|---|---|
| 10 | 150 | 3 | 27.85 | 26.311 | 14.533 | 41 | 33.66 |
| 81 | 71 | 3 | 71.65 | 75.233 | 22.73 | 72.33 | 18.4 |
| 101 | 136 | 3 | 45.3 | 43.511 | 16.91 | 51.67 | 23.53 |
| 10 | 9 | 3 | 25.183 | 34.011 | 9.59 | 30.39 | 19.27 |
| 4 | 16 | 3 | 29.383 | 34.517 | 16.08 | 45.67 | 29.83 |
| 261 | 58 | 3 | 42.117 | 42.944 | 17.683 | 50.33 | 24.97 |
| 65 | 118 | 3 | 54.5 | 50.956 | 19.133 | 57.17 | 23.77 |
| 218 | 181 | 3 | 44.5 | 48.061 | 21.91 | 62.67 | 29.01 |
| 246 | 99 | 3 | 49.1 | 46.889 | 23.737 | 80.17 | 30.7 |
| 136 | 33 | 3 | 45.9 | 45.739 | 14.803 | 45.34 | 19.56 |
| 16 | 117 | 3 | 41.017 | 46.1 | 18.42 | 53.83 | 26.13 |
| 40 | 111 | 3 | 14.633 | 15.906 | 5.127 | 17 | 19.01 |
| 149 | 19 | 3 | 65.683 | 67.972 | 23.62 | 67.06 | 20.97 |
| 26 | 211 | 3 | 36.067 | 39.461 | 5.653 | 23 | 8.65 |
| 116 | 184 | 3 | 35.5 | 34.694 | 12.29 | 36.5 | 21.3 |
| 83 | 175 | 3 | 24.467 | 25.756 | 11.367 | 32.67 | 26.12 |
| 241 | 10 | 3 | 73.133 | 73.656 | 19.7 | 63.67 | 16.08 |
| 77 | 247 | 3 | 59.9 | 55.267 | 19.147 | 57.14 | 21.84 |
| 4 | 184 | 3 | 29.067 | 27.844 | 15.69 | 43.33 | 34.03 |
| 152 | 16 | 3 | 49.3 | 39.917 | 15.96 | 48.33 | 28.33 |
| 217 | 155 | 3 | 37.117 | 37.383 | 10.78 | 35.17 | 17.87 |
| 256 | 219 | 3 | 25.917 | 26.272 | 15.757 | 43.5 | 37.41 |
| 218 | 93 | 3 | 19.667 | 20.961 | 8.29 | 25.5 | 25.97 |
| 157 | 151 | 3 | 33.133 | 32.283 | 10.27 | 40.67 | 19.13 |
| 67 | 35 | 3 | 41.217 | 41.6 | 11.333 | 38 | 17.64 |