Broadford - Lochcarron - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:50:00	07:50:00	...	1
...	07:55:00	07:55:00	...	2
...	07:55:00	07:55:00	...	3
...	07:55:00	07:55:00	...	4
...	07:56:00	07:56:00	...	5
...	07:56:00	07:56:00	...	6
...	07:57:00	07:57:00	...	7
...	07:58:00	07:58:00	...	8
...	07:59:00	07:59:00	...	9
...	08:00:00	08:00:00	...	10
...	08:01:00	08:01:00	...	11
...	08:02:00	08:02:00	...	12
...	08:03:00	08:03:00	...	13
...	08:03:00	08:03:00	...	14
...	08:05:00	08:05:00	...	15
...	08:07:00	08:07:00	...	16
...	08:08:00	08:08:00	...	17
...	08:14:00	08:14:00	...	18
...	08:18:00	08:18:00	...	19
...	08:20:00	08:20:00	...	20
...	08:45:00	08:45:00	...	21
...	08:49:00	08:49:00	...	22
...	08:50:00	08:50:00	...	23
...	08:55:00	08:55:00	...	24
...	08:58:00	08:58:00	...	25
...	09:00:00	09:00:00	...	26

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
45324272	Bus Shelter	57.3184176601	-5.6797767296
45327647	Public Hall	57.3420109733	-5.5645821859
45323929	Houses	57.2975043699	-5.7231418692
45324684	Road End	57.3151713411	-5.6929773117
45324686	Primary School	57.287247658	-5.7154964283
45328393	Post Office	57.3997208477	-5.4936368525
45324269	High School	57.3344148298	-5.6649033139
45328763	Hotel	57.4226524783	-5.4296047421
45329287	Church	57.4147778849	-5.4731982243
45323763	Harbour Slipway	57.2805487732	-5.7161320223
45346482	Road End	57.4314378324	-5.4472775821
45346484	New Kelso Rd End	57.4271894512	-5.4376120431
45346485	Achintee Rd End	57.4196461585	-5.4304063225
45346487	Craft Shop	57.409650094	-5.4438956021
45346493	Station	57.3948453858	-5.4550095787
45346494	Attadale Gardens Rd End	57.3916326984	-5.45578912
45346496	Road End	57.3620415915	-5.5095814652
45346498	Road End	57.3490435126	-5.5517940163
45346728	Colonel's Road	57.3973141624	-5.5077613673
45346729	Church Street	57.3980531379	-5.5018872517
45346734	Police Station	57.398564171	-5.4987055072
45346736	Rockvilla Hotel	57.4023763709	-5.4844304455
45346738	Lochcarron Hotel	57.4037047075	-5.4806095749
45346742	Kirkton Road	57.4065174418	-5.4780451619
45346745	Industrial Estate	57.4202020576	-5.4658979676
45346747	Smithy	57.4267324306	-5.4556170621