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 |
|---|---|---|---|---|---|---|---|
| 162 | 8 | 42 | 17.75 | 19.369 | 4.796 | 17.85 | 15.47 |
| 107 | 98 | 42 | 33.575 | 34.731 | 13.02 | 39.08 | 23.81 |
| 215 | 244 | 42 | 40.025 | 45.094 | 16.788 | 52.84 | 25.86 |
| 93 | 7 | 42 | 17.325 | 23.502 | 8.133 | 25.58 | 21.58 |
| 243 | 164 | 42 | 32.133 | 32.63 | 9.868 | 32.92 | 19.14 |
| 236 | 120 | 42 | 19.683 | 22.139 | 5.776 | 20.88 | 17.83 |
| 260 | 4 | 42 | 18.4 | 20.403 | 6.335 | 41.43 | 21.04 |
| 161 | 251 | 42 | 43.417 | 44.363 | 19.884 | 56.79 | 28.48 |
| 26 | 11 | 42 | 14.533 | 15.537 | 2.727 | 12.76 | 10.91 |
| 80 | 237 | 42 | 25.2 | 28.455 | 6.803 | 24.83 | 15.37 |
| 237 | 155 | 42 | 54.467 | 57.125 | 22.076 | 64.77 | 23.47 |
| 116 | 242 | 42 | 23.35 | 24.852 | 7.91 | 25.95 | 20.43 |
| 223 | 81 | 42 | 21.158 | 21.785 | 12.427 | 34.75 | 35.51 |
| 69 | 234 | 42 | 45.4 | 44.762 | 9.62 | 35.2 | 14.21 |
| 89 | 210 | 42 | 19.233 | 19.621 | 3.91 | 16.3 | 12.66 |
| 97 | 243 | 42 | 38.55 | 47.736 | 15.963 | 49.14 | 22.87 |
| 106 | 37 | 42 | 24.225 | 26.986 | 5.547 | 21.87 | 13.03 |
| 256 | 83 | 42 | 14.35 | 15.936 | 5.12 | 17.63 | 21.18 |
| 209 | 34 | 42 | 16.95 | 16.991 | 3.074 | 13.8 | 11.4 |
| 29 | 150 | 42 | 7.867 | 8.457 | 1.599 | 12.94 | 13.71 |
| 230 | 57 | 42 | 35.442 | 37.796 | 12.04 | 38.6 | 20.05 |
| 68 | 73 | 42 | 36.058 | 39.513 | 13.36 | 41.73 | 21.83 |
| 7 | 225 | 42 | 30.2 | 32.071 | 7.644 | 27.68 | 15.64 |
| 222 | 155 | 42 | 15.9 | 19.006 | 5.288 | 18.97 | 18.5 |
| 69 | 24 | 42 | 28.842 | 29.556 | 4.835 | 20.17 | 10.52 |