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 |
|---|---|---|---|---|---|---|---|
| 13 | 37 | 271 | 32.133 | 32.735 | 7.402 | 27.35 | 14.22 |
| 244 | 170 | 271 | 32.917 | 34.614 | 8.538 | 30.54 | 16.31 |
| 249 | 200 | 271 | 30.817 | 32.96 | 13.689 | 40.77 | 25.98 |
| 218 | 205 | 271 | 8.233 | 9.267 | 1.56 | 8.49 | 10.71 |
| 116 | 79 | 271 | 31.517 | 32.823 | 9.059 | 30.67 | 17.54 |
| 132 | 245 | 271 | 46.383 | 50.02 | 25.859 | 70.34 | 33.18 |
| 48 | 248 | 271 | 25.2 | 28.841 | 11.748 | 35.12 | 27.05 |
| 237 | 92 | 271 | 32.417 | 35.242 | 10.814 | 35.26 | 19.53 |
| 130 | 163 | 271 | 40.167 | 41.877 | 13.658 | 51.92 | 21.16 |
| 100 | 254 | 271 | 35.317 | 39.086 | 15.465 | 46.12 | 25.63 |
| 93 | 140 | 271 | 21.317 | 24.202 | 11.253 | 50.22 | 30.91 |
| 229 | 69 | 271 | 19.817 | 21.929 | 6.637 | 22.29 | 20.11 |
| 163 | 106 | 271 | 35.783 | 38.097 | 9.41 | 33.01 | 16.47 |
| 12 | 137 | 270 | 16.625 | 18.033 | 4.88 | 17.77 | 17.65 |
| 140 | 198 | 270 | 31.167 | 33.519 | 7.622 | 27.71 | 14.32 |
| 161 | 67 | 270 | 39.433 | 41.469 | 13.696 | 42.6 | 21.09 |
| 181 | 13 | 270 | 18.933 | 19.902 | 4.219 | 17.82 | 13.6 |
| 143 | 112 | 270 | 27.342 | 29.111 | 5.821 | 23.14 | 12.48 |
| 230 | 31 | 270 | 34.192 | 35.776 | 13.254 | 40.67 | 23.4 |
| 35 | 61 | 270 | 14.592 | 15.552 | 2.455 | 12.3 | 10.04 |
| 233 | 106 | 270 | 27.525 | 29.284 | 8.218 | 27.4 | 18.02 |
| 211 | 260 | 270 | 22.85 | 25.494 | 7.541 | 26.06 | 19.59 |
| 239 | 49 | 269 | 40.067 | 41.744 | 10.294 | 35.78 | 15.43 |
| 74 | 113 | 269 | 26.683 | 28.909 | 6.785 | 24.73 | 15.54 |
| 134 | 95 | 269 | 7.617 | 8.129 | 1.435 | 7.78 | 12.46 |