Dumfries - Castle Douglas - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:30:00	16:30:00	...	1
...	16:31:00	16:31:00	...	2
...	16:33:00	16:33:00	...	3
...	16:38:00	16:38:00	...	4
...	16:38:00	16:38:00	...	5
...	16:39:00	16:39:00	...	6
...	16:44:00	16:44:00	...	7
...	16:50:00	16:50:00	...	9
...	16:53:00	16:53:00	...	10
...	16:53:00	16:53:00	...	11
...	16:57:00	16:57:00	...	12
...	16:59:00	16:59:00	...	13
...	17:02:00	17:02:00	...	14
...	17:12:00	17:12:00	...	15
...	17:13:00	17:13:00	...	16
...	17:14:00	17:14:00	...	17
...	17:15:00	17:15:00	...	18
...	17:17:00	17:17:00	...	19

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
34232643	Whitesands	55.0686992366	-3.6159573982
34234626	Loreburne Centre	55.0665163226	-3.6097775657
34238492	Railway Station	55.0722541413	-3.6047140725
34234635	English Street	55.0696047174	-3.6059392352
34236483	Carlingwark Street	54.9379456596	-3.9338492489
34239257	Garroch Business Park	55.0587358208	-3.6478725216
34236243	Village	55.0361267165	-3.8282349295
34236249	Village	55.0106002783	-3.8673750758
34236387	Swimming Pool	54.9418754721	-3.9274962305
34235952	Royal Bank	54.9402587048	-3.9302602492
34236389	Markethill	54.9431513867	-3.92638631
34236392	Library	54.9421040326	-3.9278194243
34236273	Maxweltown West Church	55.0678285978	-3.6206048814
34239239	Ettrick Court	55.0649760072	-3.6249212691
34236247	Lochview Motel	55.0235739771	-3.8458887715
34236239	Brae	55.0493572249	-3.7821416575
34236237	Road End	55.0514292038	-3.7670172207
34236235	Road End	55.055640759	-3.7202179695