Aberdeen - Inverness - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	19:59:00	19:59:00	...	1
...	20:00:00	20:00:00	...	2
...	20:01:00	20:01:00	...	3
...	20:02:00	20:02:00	...	4
...	20:03:00	20:03:00	...	5
...	20:05:00	20:05:00	...	6
...	20:05:00	20:05:00	...	7
...	20:05:00	20:05:00	...	8
...	20:05:00	20:05:00	...	9
...	20:09:00	20:09:00	...	10
...	20:11:00	20:11:00	...	11
...	20:17:00	20:17:00	...	12
...	20:25:00	20:25:00	...	13
...	20:28:00	20:28:00	...	14
...	20:30:00	20:30:00	...	15
...	20:40:00	20:40:00	...	16
...	20:40:00	20:40:00	...	17
...	20:42:00	20:42:00	...	18

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

stop_code	stop_name	stop_lat	stop_lon
23625267	Market Place	57.2837673904	-2.3744299208
23625248	Middlemuir Road	57.284716511	-2.3814231229
23627962	Davah Court	57.2840052465	-2.3848991802
23625237	Gordon House	57.2839591962	-2.3910859085
23624956	Old Chapel Road	57.2894756327	-2.3965196773
23624959	Gordon Road	57.2909804789	-2.3950261046
23624968	Brandsbutt	57.2920724718	-2.393411861
23623524	The Square	57.4475687448	-2.7860024874
23623487	Market Street	57.4435791373	-2.7919312893
23623962	St Sairs Cottage	57.3813116432	-2.5958942161
23624964	Burghmuir Circle	57.2849921103	-2.3939997982
23624278	Lawrence Road	57.3432257392	-2.5481247749
23624958	North Street	57.2942222531	-2.3953595273
23628757	Steven Road	57.442154541	-2.7941995408
23624749	Home Farm	57.3208820825	-2.4616482088
23628424	Farm	57.397615275	-2.6164754219
23632327	Bainshole	57.403506917	-2.650623824
23629564	Milton of Inveramsay	57.3138834947	-2.4341684333