Newton Stewart - Port William - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:20:00	08:20:00	...	1
...	08:22:00	08:22:00	...	2
...	08:24:00	08:24:00	...	3
...	08:25:00	08:25:00	...	4
...	08:29:00	08:29:00	...	5
...	08:30:00	08:30:00	...	6
...	08:32:00	08:32:00	...	7
...	08:33:00	08:33:00	...	8
...	08:35:00	08:35:00	...	9
...	08:37:00	08:37:00	...	10
...	08:39:00	08:39:00	...	11
...	08:40:00	08:40:00	...	12
...	08:40:00	08:40:00	...	13
...	08:42:00	08:42:00	...	14
...	08:43:00	08:43:00	...	15
...	08:46:00	08:46:00	...	16
...	08:47:00	08:47:00	...	17
...	08:47:00	08:47:00	...	18
...	08:47:00	08:47:00	...	19
...	08:48:00	08:48:00	...	20

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

stop_code	stop_name	stop_lat	stop_lon
34236942	Main Street	54.7008518426	-4.3647627409
34236939	Boyack Road	54.7009945653	-4.3675804279
34236943	Boyack Road	54.7015827026	-4.368763304
34236924	St John Street	54.7362001866	-4.4147478153
34236926	The Grapes	54.7340759902	-4.4148854915
34236956	Village	54.7368406664	-4.5489513463
34236983	Square	54.7597110672	-4.5841367424
34236962	Barsalloch	54.7421896962	-4.5731848376
34236959	Beach	54.7365009521	-4.5527051887
34236923	Bus Depot	54.7377076674	-4.4153346738
34236928	Clydesdale Bank	54.732669479	-4.415997891
34236932	High Street	54.7301109226	-4.4180822983
34236936	Low Balcray	54.7127841254	-4.4034030585
34236938	Prestrie Farm	54.7074054389	-4.3917522746
34236937	Prestrie Farm	54.707470127	-4.3916629395
34236946	Drury Lane	54.7136194859	-4.4273321765
34236948	Glasserton	54.718805674	-4.4532487613
34236949	Craiglemine	54.7231857617	-4.4769952703
34236953	Cairndoon	54.7224349487	-4.4986760717
34238769	A746 Jct	54.7152437352	-4.4471332256