Havant - Portsmouth - The Hard
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 10:45:00 | 10:45:00 | ... | 1 |
|
| ... | 10:47:00 | 10:47:00 | ... | 2 |
|
| ... | 10:49:00 | 10:49:00 | ... | 3 |
|
| ... | 10:49:00 | 10:49:00 | ... | 4 |
|
| ... | 10:50:00 | 10:50:00 | ... | 5 |
|
| ... | 10:51:00 | 10:51:00 | ... | 6 |
|
| ... | 10:52:00 | 10:52:00 | ... | 7 |
|
| ... | 10:53:00 | 10:53:00 | ... | 8 |
|
| ... | 10:53:00 | 10:53:00 | ... | 9 |
|
| ... | 10:54:00 | 10:54:00 | ... | 10 |
|
| ... | 10:55:00 | 10:55:00 | ... | 11 |
|
| ... | 10:56:00 | 10:56:00 | ... | 12 |
|
| ... | 10:57:00 | 10:57:00 | ... | 13 |
|
| ... | 10:57:00 | 10:57:00 | ... | 14 |
|
| ... | 10:58:00 | 10:58:00 | ... | 15 |
|
| ... | 10:59:00 | 10:59:00 | ... | 16 |
|
| ... | 10:59:00 | 10:59:00 | ... | 17 |
|
| ... | 11:00:00 | 11:00:00 | ... | 18 |
|
| ... | 11:01:00 | 11:01:00 | ... | 19 |
|
| ... | 11:02:00 | 11:02:00 | ... | 20 |
|
| ... | 11:04:00 | 11:04:00 | ... | 21 |
|
| ... | 11:04:00 | 11:04:00 | ... | 22 |
|
| ... | 11:05:00 | 11:05:00 | ... | 23 |
|
| ... | 11:06:00 | 11:06:00 | ... | 24 |
|
| ... | 11:08:00 | 11:08:00 | ... | 25 |
|
| ... | 11:09:00 | 11:09:00 | ... | 26 |
|
| ... | 11:10:00 | 11:10:00 | ... | 27 |
|
| ... | 11:11:00 | 11:11:00 | ... | 28 |
|
| ... | 11:12:00 | 11:12:00 | ... | 29 |
|
| ... | 11:15:00 | 11:15:00 | ... | 30 |
|
| ... | 11:17:00 | 11:17:00 | ... | 31 |
|
| ... | 11:19:00 | 11:19:00 | ... | 32 |
|
| ... | 11:20:00 | 11:20:00 | ... | 33 |
|
| ... | 11:21:00 | 11:21:00 | ... | 34 |
|
| ... | 11:21:00 | 11:21:00 | ... | 35 |
|
| ... | 11:22:00 | 11:22:00 | ... | 36 |
|
| ... | 11:23:00 | 11:23:00 | ... | 37 |
|
| ... | 11:25:00 | 11:25:00 | ... | 38 |
|
| ... | 11:27:00 | 11:27:00 | ... | 39 |
|
| ... | 11:28:00 | 11:28:00 | ... | 40 |
|
| ... | 11:28:00 | 11:28:00 | ... | 41 |
|
| ... | 11:30:00 | 11:30:00 | ... | 42 |
|
| ... | 11:31:00 | 11:31:00 | ... | 43 |
|
| ... | 11:32:00 | 11:32:00 | ... | 44 |
|
| ... | 11:34:00 | 11:34:00 | ... | 45 |
|
| ... | 11:37:00 | 11:37:00 | ... | 46 |
|
| ... | 11:38:00 | 11:38:00 | ... | 47 |
|
| ... | 11:38:00 | 11:38:00 | ... | 48 |
|
| ... | 11:39:00 | 11:39:00 | ... | 49 |
|
| ... | 11:41:00 | 11:41:00 | ... | 50 |
|
| ... | 11:42:00 | 11:42:00 | ... | 51 |
|
| ... | 11:43:00 | 11:43:00 | ... | 52 |
|
| ... | 11:43:00 | 11:43:00 | ... | 53 |
|
| ... | 11:45:00 | 11:45:00 | ... | 54 |
|
| ... | 11:45:00 | 11:45:00 | ... | 55 |
|
| ... | 11:46:00 | 11:46:00 | ... | 56 |
|
| ... | 11:47:00 | 11:47:00 | ... | 57 |
|
| ... | 11:48:00 | 11:48:00 | ... | 58 |
|
| ... | 11:48:00 | 11:48:00 | ... | 59 |
|
| ... | 11:49:00 | 11:49:00 | ... | 60 |
|
| ... | 11:50:00 | 11:50:00 | ... | 61 |
|
| ... | 11:51:00 | 11:51:00 | ... | 62 |
|
| ... | 11:52:00 | 11:52:00 | ... | 63 |
|
| ... | 11:55:00 | 11:55:00 | ... | 64 |
|
| ... | 11:56:00 | 11:56:00 | ... | 65 |
|
| ... | 11:57:00 | 11:57:00 | ... | 66 |
|
| ... | 12:00:00 | 12:00: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 | |
| hamgpatj | Exton Road | 50.867619149 | -0.9662321743 | |
| hamgpdam | Froxfield Road | 50.8695715491 | -0.9643130893 | |
| hamgpdag | Shaldon Road | 50.8715867862 | -0.9644105583 | |
| hamgpapa | Worldham Road | 50.8728890553 | -0.9672668309 | |
| hamgpajg | Burghclere Road | 50.8727677558 | -0.9688044505 | |
| hamgpadp | Baybridge Road | 50.8706366838 | -0.9698462861 | |
| hamgpaja | New Lane | 50.867724945 | -0.9690435869 | |
| hamgmwdj | Wakefords Way | 50.8742746109 | -0.9734614479 | |
| hamgmwag | Knightwood Avenue | 50.8718858808 | -0.9738407882 | |
| hamgmwgp | Forestside Avenue | 50.8708706431 | -0.9729250955 | |
| hamgmwpm | Martin Road Church | 50.8676082553 | -0.9711067307 | |
| hamgmwaj | Douglas Gardens | 50.8662391603 | -0.9739221025 | |
| hamgmtda | Liam Close | 50.8656921862 | -0.976150905 | |
| hamgmtwt | Horsebridge Road | 50.86338102 | -0.9740985023 | |
| hamgmwdg | Flexford Gardens | 50.8602858658 | -0.9739106533 | |
| hamgmpmw | Old Copse Road | 50.8601035129 | -0.9766995294 | |
| hamgmjag | Civic Centre | 50.8587253859 | -0.9836490412 | |
| hamgjwtd | Ashley Close | 50.8642520794 | -0.9977671206 | |
| hamgmawp | Botley Drive | 50.8646431837 | -0.9930552577 | |
| hamgmgat | Purbrook Way | 50.8652900283 | -0.9867462484 | |
| hamgmgdj | Park Parade | 50.8669167894 | -0.9866399383 | |
| hamgmdtd | Bramdean Drive | 50.8695345411 | -0.9888143824 | |
| hamgmdma | The Swallow | 50.8726701706 | -0.99056573 | |
| hamgmdwp | Crondall Avenue | 50.8732805997 | -0.9873263004 | |
| hamgmgpd | Bondfields Crescent | 50.8729919907 | -0.9851580478 | |
| hamgmpdt | High Lawn Way | 50.873056719 | -0.9791731893 | |
| hamgmtdp | Staunton Park | 50.8738633863 | -0.9757871547 | |
| hamgjtjm | Linkenholt Way | 50.8649828186 | -1.004344899 | |
| hamgjmjt | Asda Hypermarket | 50.8633567424 | -1.014070407 | |
| hamgjpgj | Hulbert Road | 50.8649032012 | -1.0129720491 | |
| hamgjgaj | College Road | 50.8643376724 | -1.0248633753 | |
| hamgjdpg | Crookhorn Corner | 50.8633740016 | -1.0279243047 | |
| hamgjdjw | Crookhorn Precinct | 50.8601984626 | -1.0288712456 | |
| hamjapap | Morelands School | 50.8577960124 | -1.0308676019 | |
| hamjapda | Portsmouth Golf Course | 50.8555808512 | -1.0315954446 | |
| pordtdj | Fort Purbrook | 50.8527681655 | -1.0340119174 | |
| porajam | The George | 50.8526801997 | -1.0529080199 | |
| porajap | Farlington Avenue | 50.8530604418 | -1.0465927059 | |
| pordgdj | Charles Dickens Birthplace | 50.8074436444 | -1.0875157058 | |
| pordgdp | All Saints Church | 50.8051530588 | -1.0866946152 | |
| poragaw | First Avenue | 50.8472519177 | -1.0712281639 | |
| poragtp | QA Hospital North | 50.850696139 | -1.0689721206 | |
| poragwd | Orkney Road | 50.8501364479 | -1.0675769213 | |
| poragwp | Chalkridge Road | 50.851153884 | -1.0598855368 | |
| poragwt | Cliffdale Gardens | 50.8515703498 | -1.0580019908 | |
| porajgt | Health Centre | 50.8442139885 | -1.0691721247 | |
| porajma | Donaldson Road | 50.8380345938 | -1.0712548751 | |
| porajmg | Highbury Buildings | 50.8403926159 | -1.0681119384 | |
| porajta | Cosham Interchange | 50.8412506425 | -1.0685777448 | |
| porapjd | Hilsea Crescent | 50.8335653893 | -1.0724085831 | |
| pordamd | Oakwood Road | 50.830541877 | -1.0744280226 | |
| pordamj | Doyle Avenue | 50.8278570762 | -1.0760713514 | |
| pordamt | Magdalen Road | 50.8260583532 | -1.0771859034 | |
| pordapd | Gladys Avenue | 50.8231926551 | -1.0821262331 | |
| pordatd | Mountbatten Centre | 50.8224100408 | -1.0843847007 | |
| pordawg | London Avenue | 50.8191290507 | -1.0834125386 | |
| pordawj | Angerstein Road | 50.8167448891 | -1.083274658 | |
| pordawm | Seagrove Road | 50.8146622632 | -1.0848910251 | |
| pordgap | Rudmore Roundabout | 50.8127235744 | -1.0853689147 | |
| pordgda | Estella Road | 50.8105151413 | -1.0858520273 | |
| pordgpa | City Shops South | 50.8000477399 | -1.091632978 | |
| pordgpw | St Agatha's | 50.802693866 | -1.0919222701 | |
| pordgta | HMS Nelson | 50.799856795 | -1.0971566527 | |
| pordgtg | Curzon Howe Road | 50.7997157174 | -1.1021826718 | |
| pordgwa | The Hard Interchange | 50.7978157685 | -1.1065468764 | |
| porgagj | QA Hospital Main | 50.8492431728 | -1.071714223 |