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 |
|---|---|---|---|---|---|---|---|
| 75 | 227 | 33 | 35.5 | 39.131 | 14.471 | 43.07 | 23.54 |
| 236 | 175 | 33 | 42.3 | 46.429 | 17.093 | 50.67 | 25.48 |
| 91 | 17 | 33 | 27.683 | 29.498 | 5.447 | 22.16 | 11.4 |
| 114 | 124 | 33 | 41.867 | 44.177 | 16.887 | 50.85 | 24.27 |
| 127 | 161 | 33 | 31.1 | 34.566 | 9.772 | 32.5 | 18.82 |
| 207 | 129 | 33 | 8.8 | 9.933 | 2.046 | 11.53 | 17.32 |
| 78 | 136 | 33 | 19.25 | 20.343 | 2.954 | 14.67 | 9.29 |
| 143 | 28 | 33 | 38.417 | 41.1 | 14.981 | 45.92 | 23.03 |
| 234 | 53 | 33 | 34.35 | 36.365 | 13.724 | 41.09 | 23.7 |
| 223 | 213 | 33 | 10.733 | 12.63 | 6.525 | 19.39 | 33.99 |
| 197 | 37 | 33 | 19.967 | 21.311 | 6.258 | 21.43 | 18.05 |
| 219 | 249 | 33 | 50.367 | 48.996 | 17.305 | 52.24 | 22.36 |
| 148 | 131 | 33 | 25.833 | 28.717 | 14.525 | 41.3 | 31.47 |
| 68 | 108 | 33 | 38.5 | 40.165 | 15.493 | 45.48 | 23.8 |
| 234 | 180 | 33 | 36.767 | 38.028 | 13.264 | 41.39 | 21.46 |
| 211 | 155 | 33 | 52.283 | 53.722 | 16.705 | 51.53 | 19.78 |
| 116 | 240 | 33 | 17.1 | 18.198 | 7.312 | 22.82 | 25.44 |
| 114 | 150 | 33 | 34.333 | 39.275 | 17.338 | 50.09 | 28.53 |
| 49 | 100 | 33 | 36 | 34.985 | 7.301 | 28.14 | 13.62 |
| 98 | 9 | 33 | 5.35 | 7.157 | 1.418 | 7.48 | 12.78 |
| 162 | 201 | 33 | 58.25 | 58.736 | 24.842 | 70.33 | 26.5 |
| 181 | 116 | 33 | 36.6 | 40.284 | 14.763 | 44.64 | 23.79 |
| 81 | 32 | 33 | 10.867 | 12.584 | 2.037 | 10.59 | 10.35 |
| 209 | 81 | 33 | 76.933 | 76.815 | 20.4 | 65.5 | 16.86 |
| 205 | 196 | 33 | 33.467 | 33.224 | 8.251 | 28.91 | 15.72 |