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 |
|---|---|---|---|---|---|---|---|
| 145 | 126 | 8 | 26.867 | 31.86 | 10.069 | 32.69 | 19.73 |
| 116 | 71 | 8 | 63.908 | 61.908 | 19.699 | 61.69 | 19.78 |
| 248 | 247 | 8 | 25.333 | 24.792 | 4.787 | 19.56 | 12.12 |
| 222 | 62 | 8 | 27.808 | 27.904 | 4.697 | 20.52 | 10.19 |
| 15 | 134 | 8 | 27.133 | 27.473 | 9.6 | 29.73 | 23.36 |
| 225 | 125 | 8 | 43.292 | 42.508 | 6.307 | 32.75 | 9.68 |
| 45 | 139 | 8 | 47.4 | 52.971 | 20.844 | 60.06 | 26.13 |
| 113 | 53 | 8 | 36.242 | 41.065 | 15.379 | 45.75 | 23.15 |
| 26 | 134 | 8 | 62.875 | 69.592 | 20.245 | 66.12 | 18.36 |
| 97 | 38 | 8 | 57.133 | 57.498 | 19.898 | 60.59 | 24.3 |
| 135 | 78 | 8 | 40.333 | 44.26 | 14.548 | 43.5 | 20.59 |
| 11 | 5 | 8 | 32.975 | 35.994 | 16.438 | 49.19 | 29.54 |
| 203 | 258 | 8 | 23.55 | 22.775 | 8.783 | 25.78 | 23.99 |
| 76 | 131 | 8 | 31.7 | 33.515 | 13 | 39.03 | 23.89 |
| 254 | 183 | 8 | 19.208 | 18.858 | 4.663 | 17.69 | 14.92 |
| 122 | 225 | 8 | 31.392 | 34.085 | 11.704 | 35.1 | 21.25 |
| 222 | 141 | 8 | 61.792 | 60.71 | 21.921 | 58.76 | 22.51 |
| 142 | 203 | 8 | 59.6 | 55.806 | 22.09 | 64.19 | 25.01 |
| 135 | 232 | 8 | 44.65 | 41.562 | 12.976 | 44.12 | 22.77 |
| 48 | 109 | 8 | 53.317 | 55.296 | 23.806 | 66.88 | 26.29 |
| 131 | 140 | 8 | 51.158 | 49.338 | 16.328 | 48.39 | 20.66 |
| 150 | 227 | 8 | 29.85 | 29.975 | 11.476 | 34.69 | 24.42 |
| 51 | 226 | 8 | 33.85 | 35.475 | 15.312 | 45.12 | 27.14 |
| 117 | 132 | 8 | 24.117 | 25.838 | 10.885 | 32.69 | 26.03 |
| 70 | 124 | 8 | 33.125 | 32.712 | 11.189 | 34.38 | 21.81 |