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 |
|---|---|---|---|---|---|---|---|
| 55 | 89 | 24 | 29.017 | 30.585 | 6.21 | 24.4 | 12.65 |
| 56 | 43 | 24 | 30.75 | 31.915 | 8.807 | 51.21 | 18.1 |
| 260 | 202 | 24 | 15.7 | 15.854 | 3.424 | 13.58 | 12.96 |
| 164 | 203 | 24 | 37.425 | 42.209 | 19.583 | 58.29 | 29.88 |
| 219 | 61 | 24 | 32.442 | 33.271 | 10.705 | 34.07 | 19.97 |
| 17 | 95 | 24 | 29.625 | 31.756 | 8.627 | 29.19 | 18.46 |
| 4 | 28 | 24 | 35.617 | 37.324 | 13.963 | 42.4 | 24.08 |
| 21 | 155 | 24 | 19.842 | 22.229 | 4.474 | 18.06 | 12.93 |
| 51 | 229 | 24 | 41.1 | 45.474 | 14.509 | 44.43 | 21.76 |
| 217 | 226 | 24 | 14.8 | 18.551 | 4.406 | 17.38 | 18.54 |
| 76 | 237 | 24 | 49.958 | 51.509 | 16.228 | 49.17 | 19.46 |
| 157 | 140 | 24 | 21.417 | 24.423 | 5.78 | 45.04 | 16.53 |
| 68 | 86 | 24 | 76.808 | 77.853 | 25.585 | 79.98 | 25.29 |
| 145 | 16 | 24 | 25.792 | 30.044 | 13.087 | 38.48 | 29.79 |
| 201 | 117 | 24 | 9.958 | 11.099 | 2.348 | 10.38 | 13.69 |
| 7 | 24 | 24 | 29.067 | 29.444 | 6.661 | 24.46 | 14.41 |
| 256 | 39 | 24 | 44.608 | 47.099 | 10.776 | 38.9 | 14.57 |
| 235 | 152 | 24 | 20.383 | 20.668 | 4.576 | 18.33 | 13.91 |
| 88 | 118 | 24 | 31.133 | 33.353 | 16.217 | 45.46 | 30.44 |
| 163 | 81 | 24 | 39.175 | 41.599 | 15.978 | 47.23 | 24.77 |
| 75 | 77 | 24 | 42.692 | 50.299 | 17.283 | 51.9 | 23.95 |
| 112 | 121 | 24 | 33.525 | 30.879 | 10.664 | 32.62 | 22.18 |
| 50 | 120 | 24 | 18.933 | 19.598 | 7.575 | 23.81 | 25.13 |
| 71 | 106 | 24 | 27.075 | 27.448 | 5.049 | 20.5 | 11.47 |
| 88 | 150 | 24 | 34.908 | 34.291 | 15.901 | 45.48 | 29.4 |