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 |
|---|---|---|---|---|---|---|---|
| 171 | 186 | 2 | 61.8 | 61.8 | 14.37 | 52.25 | 14.11 |
| 22 | 238 | 2 | 51.775 | 51.775 | 18.36 | 53.58 | 21.29 |
| 92 | 150 | 2 | 31.908 | 31.908 | 19.975 | 54.75 | 38.29 |
| 111 | 52 | 2 | 18.158 | 18.158 | 2.575 | 13.5 | 9.38 |
| 86 | 188 | 2 | 72.692 | 72.692 | 18.475 | 62.75 | 15.57 |
| 8 | 87 | 2 | 20.517 | 20.517 | 11.515 | 52 | 33.68 |
| 180 | 113 | 2 | 47.833 | 47.833 | 12.605 | 52 | 15.8 |
| 11 | 129 | 2 | 58.05 | 58.05 | 18.535 | 57 | 19.16 |
| 83 | 8 | 2 | 10.275 | 10.275 | 3.975 | 13.25 | 24.76 |
| 128 | 32 | 2 | 29.183 | 29.183 | 5.41 | 23.25 | 11.07 |
| 53 | 14 | 2 | 58.317 | 58.317 | 15.92 | 52.5 | 18.08 |
| 34 | 215 | 2 | 32.117 | 32.117 | 14.13 | 39.55 | 26.97 |
| 152 | 73 | 2 | 36.975 | 36.975 | 13.07 | 40.75 | 21.47 |
| 39 | 12 | 2 | 54.075 | 54.075 | 15.455 | 53.25 | 25.16 |
| 92 | 60 | 2 | 39.933 | 39.933 | 9.07 | 33.25 | 13.64 |
| 31 | 113 | 2 | 37.842 | 37.842 | 15.905 | 47 | 24.96 |
| 147 | 243 | 2 | 13.933 | 13.933 | 3.335 | 13 | 14.32 |
| 235 | 260 | 2 | 19.033 | 19.033 | 9.45 | 27.5 | 29.9 |
| 160 | 177 | 2 | 43.05 | 43.05 | 9.845 | 36.25 | 19.32 |
| 188 | 157 | 2 | 52.792 | 52.792 | 11.06 | 40.49 | 15.76 |
| 9 | 79 | 2 | 40.433 | 40.433 | 13.485 | 40.75 | 20.03 |
| 106 | 173 | 2 | 32.558 | 32.558 | 14.96 | 43.25 | 27.69 |
| 95 | 32 | 2 | 39.542 | 39.542 | 14.5 | 45.75 | 21.96 |
| 33 | 96 | 2 | 35.7 | 35.7 | 9.87 | 32.75 | 16.49 |
| 243 | 71 | 2 | 42.208 | 42.208 | 21.35 | 60.75 | 30.45 |