Thurso - Wick via Halkirk - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	23:30:00	23:30:00	...	1
...	23:30:00	23:30:00	...	2
...	23:31:00	23:31:00	...	3
...	23:32:00	23:32:00	...	4
...	23:32:00	23:32:00	...	5
...	23:33:00	23:33:00	...	6
...	23:34:00	23:34:00	...	7
...	23:36:00	23:36:00	...	8
...	23:37:00	23:37:00	...	9
...	23:38:00	23:38:00	...	10
...	23:41:00	23:41:00	...	11
...	23:43:00	23:43:00	...	12
...	23:44:00	23:44:00	...	13
...	23:44:00	23:44:00	...	14
...	23:45:00	23:45:00	...	15
...	23:46:00	23:46:00	...	16
...	23:47:00	23:47:00	...	17
...	23:47:00	23:47:00	...	18
...	23:49:00	23:49:00	...	19
...	23:53:00	23:53:00	...	20
...	23:57:00	23:57:00	...	21
...	23:58:00	23:58:00	...	22
...	00:01:00	00:01:00	...	23
...	00:02:00	00:02:00	...	24
...	00:04:00	00:04:00	...	25
...	00:05:00	00:05:00	...	26
...	00:07:00	00:07:00	...	27
...	00:08:00	00:08:00	...	28
...	00:10:00	00:10:00	...	29
...	00:11:00	00:11:00	...	30
...	00:11:00	00:11:00	...	31
...	00:12:00	00:12:00	...	32

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
20/08/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
45343693	Mybster Rd End	58.4916996601	-3.3710818058
45343973	Geise Houses	58.5628478224	-3.5361908411
45343976	Thuster Mains	58.4509152764	-3.1995301566
45343979	Stirkoke Lodge	58.4455072528	-3.1645504197
45343983	Upper Milton Rd End	58.4426963745	-3.1273179523
45343986	Dunbar Hospital	58.58347251	-3.5376108217
45343989	Road End	58.5762245351	-3.5472673162
45345278	Georgemas House	58.5259549893	-3.4561846433
45345282	Sibster Rd End	58.5239124838	-3.4628139746
45345285	Fairview Court	58.5193803341	-3.4959850533
45345287	Skinnet Rd End	58.5333102995	-3.5015251678
45345292	Aimster Rd End	58.5499302292	-3.5158461685
45345294	Buckies Rd End	58.5551969211	-3.5254577469
45325879	Technical College	58.5866798705	-3.5345519155
45325937	Henderson Street	58.5850510833	-3.5363039577
45325945	Sinclair Square	58.5146359822	-3.4899463175
45325948	Spences Cottage	58.5135249334	-3.4296798942
45325953	Bain Place	58.4738145598	-3.3075602391
45325954	Bilbster Mains Rd End	58.4598260766	-3.235414901
45325957	Weir Crescent	58.4414907649	-3.1183203175
45325958	Co-Op	58.4403470872	-3.0978827213
45325962	Caithness General Hospital	58.4404486496	-3.0944085803
45325938	Bus Shelter	58.5717810266	-3.545540857
45325976	Braal Terrace	58.516190367	-3.4953170443
45325942	Mace Shop	58.5141174626	-3.4943705046
45325956	Fountain Cottages	58.4443299868	-3.1566823565
45325876	Miller Academy	58.5912884555	-3.5262030728
45325964	Town Hall	58.4421838235	-3.0931605512
45342343	Royal Bank of Scotland	58.5950623153	-3.5207926021
45342832	Georgemas Junction	58.5213505212	-3.4511174849
45326348	Bus Terminal	58.4428557464	-3.094414807
45325949	Post Office	58.4715999376	-3.3018714548