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 |
|---|---|---|---|---|---|---|---|
| 242 | 107 | 6 | 37.367 | 36.447 | 12.377 | 37.25 | 20.74 |
| 193 | 243 | 6 | 47.558 | 46.15 | 10.413 | 38.92 | 16.1 |
| 9 | 28 | 6 | 17.267 | 20.272 | 4.628 | 19.45 | 13.62 |
| 220 | 92 | 6 | 43.967 | 44.047 | 16.898 | 50.17 | 23.47 |
| 159 | 200 | 6 | 29.475 | 31.086 | 8.415 | 28.07 | 16.88 |
| 167 | 25 | 6 | 39.867 | 39.817 | 14.788 | 43.88 | 23.22 |
| 1 | 132 | 6 | 80.992 | 77.583 | 36.083 | 132.83 | 29.45 |
| 173 | 90 | 6 | 39.192 | 35.767 | 9.565 | 31.92 | 17.14 |
| 255 | 12 | 6 | 27.958 | 28.544 | 6.262 | 23.67 | 14.76 |
| 38 | 197 | 6 | 33.908 | 31.725 | 7.117 | 27.86 | 13.83 |
| 32 | 205 | 6 | 40.508 | 43.294 | 18.313 | 54.08 | 25.89 |
| 168 | 173 | 6 | 20.467 | 21.717 | 7.528 | 24.17 | 21.15 |
| 168 | 80 | 6 | 30.517 | 30.797 | 11.072 | 33.92 | 22.18 |
| 219 | 16 | 6 | 23.308 | 23.711 | 11.067 | 32.08 | 29.33 |
| 225 | 224 | 6 | 25.758 | 30.778 | 6.502 | 25.17 | 13.75 |
| 9 | 145 | 6 | 35.133 | 36.347 | 12.315 | 38.69 | 22.16 |
| 169 | 236 | 6 | 34.358 | 38.294 | 6.568 | 28.18 | 10.48 |
| 211 | 78 | 6 | 59.225 | 54.456 | 14.027 | 47.67 | 17.02 |
| 247 | 92 | 6 | 28.317 | 32.669 | 11.388 | 34.46 | 23.32 |
| 86 | 215 | 6 | 27.367 | 28.539 | 9.72 | 30.02 | 20.68 |
| 197 | 175 | 6 | 28.467 | 28.314 | 8.92 | 29.33 | 18.97 |
| 161 | 5 | 6 | 56.1 | 59.808 | 28.118 | 90.25 | 28.69 |
| 36 | 81 | 6 | 58.15 | 57.256 | 18.76 | 54.51 | 20.56 |
| 101 | 117 | 6 | 44.633 | 45.314 | 17.427 | 52.13 | 23.75 |
| 194 | 247 | 6 | 11.625 | 11.956 | 3.5 | 18.42 | 18.05 |