Longman - Nairn Academy - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:50:00	15:50:00	...	1
...	15:52:00	15:52:00	...	2
...	15:55:00	15:55:00	...	3
...	16:02:00	16:02:00	...	4
...	16:03:00	16:03:00	...	5
...	16:05:00	16:05:00	...	6
...	16:11:00	16:11:00	...	7
...	16:17:00	16:17:00	...	8
...	16:20:00	16:20:00	...	9
...	16:20:00	16:20:00	...	10
...	16:20:00	16:20:00	...	11
...	16:20:00	16:20:00	...	12
...	16:20:00	16:20:00	...	13
...	16:20:00	16:20:00	...	14
...	16:22:00	16:22:00	...	15
...	16:25:00	16:25:00	...	16
...	16:26:00	16:26:00	...	17
...	16:30:00	16:30:00	...	18
...	16:37:00	16:37:00	...	19
...	16:39:00	16:39:00	...	20
...	16:48:00	16:48:00	...	21
...	16:52:00	16:52:00	...	22

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
05/06/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
45327269	Fraser Park	57.5819069134	-3.8787091589
45327275	Tradespark Road	57.5792627129	-3.8951310971
45327276	Duncan Drive	57.5793871005	-3.8850185889
45327278	Duncan Drive	57.579750691	-3.8841342071
45327279	Beech Avenue	57.5807379108	-3.8805891242
45327296	Lochloy Road	57.5857131784	-3.8643684384
45327297	Lochloy Road	57.5855578447	-3.8645445012
45327329	Layby	57.5508950439	-3.987098097
4532726	Fraser Park	57.581993954	-3.8788976407
45342942	Milton of Culloden	57.4945076565	-4.1544784926
45343742	Lower Cullernie Rd End	57.5019567483	-4.1279946562
45327938	Delnies Woods Caravan Site	57.5713807455	-3.9326468191
45328294	Clubhouse	57.5858434253	-3.8591892899
45329465	Clubhouse	57.5856685172	-3.8613048641
45328342	Longman Drive	57.4910113912	-4.2228704322
45328454	Nairn Academy	57.5777561744	-3.8829272547
45327267	St Ninian Road	57.5862614174	-3.8667886886
45327268	St Ninian Road	57.586538982	-3.8668530973
45329676	Ardersier Rd End	57.5446597856	-4.0041370426
45329289	Caledonian Stadium	57.4962568804	-4.2189003248
45327257	Bus Station	57.5848704693	-3.8715350884
45327258	Layby	57.5227728633	-4.0632237016