Newton Stewart - Port William - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:47:00	18:47:00	...	1
...	18:49:00	18:49:00	...	2
...	18:51:00	18:51:00	...	3
...	18:52:00	18:52:00	...	4
...	18:56:00	18:56:00	...	5
...	18:57:00	18:57:00	...	6
...	18:59:00	18:59:00	...	7
...	19:00:00	19:00:00	...	8
...	19:01:00	19:01:00	...	9
...	19:04:00	19:04:00	...	10
...	19:04:00	19:04:00	...	11
...	19:06:00	19:06:00	...	12
...	19:07:00	19:07:00	...	13
...	19:07:00	19:07:00	...	14
...	19:09:00	19:09:00	...	15
...	19:10:00	19:10:00	...	16
...	19:10:00	19:10:00	...	17
...	19:13:00	19:13:00	...	18
...	19:14:00	19:14:00	...	19
...	19:14:00	19:14:00	...	20
...	19:14:00	19:14:00	...	21
...	19:15:00	19:15:00	...	22
...	19:18:00	19:18:00	...	23
...	19:21:00	19:21:00	...	24
...	19:25:00	19:25:00	...	25
...	19:32:00	19:32:00	...	26
...	19:32:00	19:32:00	...	27
...	19:35:00	19:35:00	...	28
...	19:36:00	19:36:00	...	29
...	19:37:00	19:37:00	...	30
...	19:37:00	19:37:00	...	31
...	19:38:00	19:38:00	...	32
...	19:40:00	19:40:00	...	33

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
34235258	Dashwood Square	54.9558578033	-4.4842817904
34236942	Main Street	54.7008518426	-4.3647627409
34236939	Boyack Road	54.7009945653	-4.3675804279
34236943	Boyack Road	54.7015827026	-4.368763304
34236863	Main Street	54.8318292117	-4.4562711552
34236895	Pheasant Inn	54.7924155419	-4.4337802722
34239423	Bridgehouse Farm	54.7702143384	-4.4394900872
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
34236839	Moss of Cree	54.9342677271	-4.4625611134
34236843	Baltersan	54.922066758	-4.4631420127
34236846	A714	54.9121628632	-4.4639254773
34236848	Carsegowan	54.8987967873	-4.4661036257
34236852	Culquhirk	54.8811942532	-4.4537711224
34236862	Whauphill Jct	54.843360671	-4.4647757661
34236962	Barsalloch	54.7421896962	-4.5731848376
34236959	Beach	54.7365009521	-4.5527051887
34236896	Castlewigg	54.7568080478	-4.4351861945
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
34239428	Halfway House	54.7084459842	-4.3995912681
34239429	Halfway House	54.7085097566	-4.3995484623
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