Havant - Portsmouth - The Hard
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 17:15:00 | 17:15:00 | ... | 1 |
|
| ... | 17:16:00 | 17:16:00 | ... | 2 |
|
| ... | 17:18:00 | 17:18:00 | ... | 3 |
|
| ... | 17:21:00 | 17:21:00 | ... | 4 |
|
| ... | 17:24:00 | 17:24:00 | ... | 5 |
|
| ... | 17:25:00 | 17:25:00 | ... | 6 |
|
| ... | 17:26:00 | 17:26:00 | ... | 7 |
|
| ... | 17:27:00 | 17:27:00 | ... | 8 |
|
| ... | 17:29:00 | 17:29:00 | ... | 9 |
|
| ... | 17:30:00 | 17:30:00 | ... | 10 |
|
| ... | 17:30:00 | 17:30:00 | ... | 11 |
|
| ... | 17:32:00 | 17:32:00 | ... | 12 |
|
| ... | 17:33:00 | 17:33:00 | ... | 13 |
|
| ... | 17:33:00 | 17:33:00 | ... | 14 |
|
| ... | 17:34:00 | 17:34:00 | ... | 15 |
|
| ... | 17:35:00 | 17:35:00 | ... | 16 |
|
| ... | 17:36:00 | 17:36:00 | ... | 17 |
|
| ... | 17:36:00 | 17:36:00 | ... | 18 |
|
| ... | 17:38:00 | 17:38:00 | ... | 19 |
|
| ... | 17:40:00 | 17:40:00 | ... | 20 |
|
| ... | 17:42:00 | 17:42:00 | ... | 21 |
|
| ... | 17:44:00 | 17:44:00 | ... | 22 |
|
| ... | 17:44:00 | 17:44:00 | ... | 23 |
|
| ... | 17:45:00 | 17:45:00 | ... | 24 |
|
| ... | 17:46:00 | 17:46:00 | ... | 25 |
|
| ... | 17:47:00 | 17:47:00 | ... | 26 |
|
| ... | 17:49:00 | 17:49:00 | ... | 27 |
|
| ... | 17:50:00 | 17:50:00 | ... | 28 |
|
| ... | 17:52:00 | 17:52:00 | ... | 29 |
|
| ... | 17:53:00 | 17:53:00 | ... | 30 |
|
| ... | 17:54:00 | 17:54:00 | ... | 31 |
|
| ... | 17:55:00 | 17:55:00 | ... | 32 |
|
| ... | 17:56:00 | 17:56:00 | ... | 33 |
|
| ... | 17:58:00 | 17:58:00 | ... | 34 |
|
| ... | 18:00:00 | 18:00:00 | ... | 35 |
|
| ... | 18:01:00 | 18:01:00 | ... | 36 |
|
| ... | 18:02:00 | 18:02:00 | ... | 37 |
|
| ... | 18:04:00 | 18:04:00 | ... | 38 |
|
| ... | 18:04:00 | 18:04:00 | ... | 39 |
|
| ... | 18:05:00 | 18:05:00 | ... | 40 |
|
| ... | 18:07:00 | 18:07:00 | ... | 41 |
|
| ... | 18:08:00 | 18:08:00 | ... | 42 |
|
| ... | 18:09:00 | 18:09:00 | ... | 43 |
|
| ... | 18:09:00 | 18:09:00 | ... | 44 |
|
| ... | 18:10:00 | 18:10:00 | ... | 45 |
|
| ... | 18:10:00 | 18:10:00 | ... | 46 |
|
| ... | 18:11:00 | 18:11:00 | ... | 47 |
|
| ... | 18:12:00 | 18:12:00 | ... | 48 |
|
| ... | 18:13:00 | 18:13:00 | ... | 49 |
|
| ... | 18:14:00 | 18:14:00 | ... | 50 |
|
| ... | 18:14:00 | 18:14:00 | ... | 51 |
|
| ... | 18:15:00 | 18:15:00 | ... | 52 |
|
| ... | 18:16:00 | 18:16:00 | ... | 53 |
|
| ... | 18:17:00 | 18:17:00 | ... | 54 |
|
| ... | 18:17:00 | 18:17:00 | ... | 55 |
|
| ... | 18:18:00 | 18:18:00 | ... | 56 |
|
| ... | 18:19:00 | 18:19:00 | ... | 57 |
|
| ... | 18:19:00 | 18:19:00 | ... | 58 |
|
| ... | 18:20:00 | 18:20:00 | ... | 59 |
|
| ... | 18:21:00 | 18:21:00 | ... | 60 |
|
| ... | 18:21:00 | 18:21:00 | ... | 61 |
|
| ... | 18:23:00 | 18:23:00 | ... | 62 |
|
| ... | 18:23:00 | 18:23:00 | ... | 63 |
|
| ... | 18:24:00 | 18:24:00 | ... | 64 |
|
| ... | 18:25:00 | 18:25:00 | ... | 65 |
|
| ... | 18:26:00 | 18:26:00 | ... | 66 |
|
| ... | 18:30:00 | 18:30:00 | ... | 67 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 15/10/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| hamgmgtw | Bus Station | 50.8523974211 | -0.983985431 | |
| hamgpatm | Exton Road | 50.8675914212 | -0.9661475224 | |
| hamgpdat | Froxfield Road | 50.8697145222 | -0.9642104413 | |
| hamgpdap | Shaldon Road | 50.8716124986 | -0.9642678681 | |
| hamgpatd | Worldham Road | 50.8727816033 | -0.9663027613 | |
| hamgpagt | Burghclere Road | 50.872455456 | -0.9690813742 | |
| hamgpadm | Baybridge Road | 50.8707986468 | -0.9698569285 | |
| hamgpama | New Lane | 50.867404236 | -0.9683685424 | |
| hamgmwdt | Wakefords Way | 50.8741753352 | -0.9734209899 | |
| hamgmwap | Knightwood Avenue | 50.8718851314 | -0.9737555319 | |
| hamgmwjp | Forestside Avenue | 50.8708135715 | -0.9725710544 | |
| hamgmwat | Douglas Gardens | 50.8661938306 | -0.9738804661 | |
| hamgmtdj | Liam Close | 50.8655653153 | -0.9760400017 | |
| hamgmwaw | Littlegreen Avenue | 50.8628396868 | -0.973897239 | |
| hamgmwdm | Dunhurst Close | 50.8605994273 | -0.9737758945 | |
| hamgmptm | Old Copse Road | 50.860045182 | -0.9772265213 | |
| hamgmpdp | The Parkway Centre | 50.8598762623 | -0.9795035716 | |
| hamgmjga | Leisure Centre | 50.8578646799 | -0.9829147303 | |
| hamgmagj | Barncroft Way | 50.86424195 | -0.9965879257 | |
| hamgmawt | Botley Drive | 50.8647510764 | -0.9930529341 | |
| hamgmdpg | Riders Lane | 50.8651887816 | -0.9895904585 | |
| hamgmgdt | Park Parade | 50.8665649057 | -0.9865054605 | |
| hamgmdpt | Bramdean Drive | 50.8697621472 | -0.9891363227 | |
| hamgmdmg | The Swallow | 50.8731527374 | -0.9902142083 | |
| hamgmgag | Crondall Avenue | 50.8733312174 | -0.9869414647 | |
| hamgmgpj | Silkstead Avenue | 50.873101707 | -0.9843313413 | |
| hamgmpgp | High Lawn Way | 50.8731708682 | -0.9788580209 | |
| hamgmtpg | Staunton Park | 50.8738783838 | -0.9744224036 | |
| hamgjtmd | Linkenholt Way | 50.8648292621 | -1.0032113726 | |
| hamgjpmw | Park House Farm Way | 50.8655503492 | -1.0076295734 | |
| hamgjpdp | Hulbert Road | 50.8649943135 | -1.0131122257 | |
| hamgjgpw | College Road | 50.8643770206 | -1.0209690688 | |
| hamgjdmt | Crookhorn Corner | 50.8642742998 | -1.028047685 | |
| hamgjdjp | Crookhorn Precinct | 50.8602547728 | -1.0291542471 | |
| hamjapat | Morelands School | 50.8572514417 | -1.0313477384 | |
| hamjapaw | Portsmouth Golf Course | 50.8556532519 | -1.0316507741 | |
| hamjmdpm | The Swallow | 50.8722018994 | -0.9904905695 | |
| hamjatpj | Martin Road Church | 50.8677860714 | -0.9708754431 | |
| pordtdm | Fort Purbrook | 50.8528050705 | -1.0341248055 | |
| porajad | Cliffdale Gardens | 50.8517474235 | -1.0576574825 | |
| poradaw | The George | 50.8534217459 | -1.0523105409 | |
| poradga | Farlington Avenue | 50.8531537175 | -1.0470027894 | |
| pordgaw | International Port | 50.8106656702 | -1.0867006967 | |
| pordgdg | Prospect Road | 50.806574696 | -1.0879442026 | |
| pordgdm | All Saints Church | 50.8052994749 | -1.0870181731 | |
| poragat | First Avenue | 50.8471560638 | -1.071613589 | |
| poragtw | QA Hospital North | 50.8506937727 | -1.0709325411 | |
| poragwa | Orkney Road | 50.8507593415 | -1.0678770295 | |
| poragwm | Chalkridge Road | 50.8507197474 | -1.0618120202 | |
| porajgd | Health Centre | 50.8444857654 | -1.069422385 | |
| porajgw | King George Playing Fields | 50.8407237317 | -1.0701647184 | |
| porapjg | Hilsea Crescent | 50.8341736386 | -1.071998913 | |
| porapjm | Hilsea Lido | 50.8352903674 | -1.072203987 | |
| pordamg | Oakwood Road | 50.8299705965 | -1.0749646918 | |
| pordamp | Doyle Avenue | 50.8269815421 | -1.0767985491 | |
| pordamw | Magdalen Road | 50.8258096256 | -1.0775741528 | |
| pordapa | Gladys Avenue | 50.823775471 | -1.0807660535 | |
| pordata | Mountbatten Centre | 50.8227497078 | -1.0841225112 | |
| pordawp | Stanley Road | 50.8154013365 | -1.0851037039 | |
| pordawt | Knox Road | 50.817189062 | -1.0848700472 | |
| pordgad | Mother Shipton | 50.8196147283 | -1.0845671182 | |
| pordgmp | City Shops South | 50.799440896 | -1.0910771384 | |
| pordgpt | City Shops North | 50.8027968665 | -1.0878332495 | |
| pordgtd | HMS Nelson | 50.7999409006 | -1.0975665479 | |
| pordgtj | Curzon Howe Road | 50.7998443261 | -1.1025349619 | |
| pordgwa | The Hard Interchange | 50.7978157685 | -1.1065468764 | |
| porgadt | QA Hospital Main | 50.8490324626 | -1.0723576335 |