Lockerbie - Dumfries - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	22:00:00	22:00:00	...	1
...	22:00:00	22:00:00	...	2
...	22:01:00	22:01:00	...	3
...	22:03:00	22:03:00	...	4
...	22:03:00	22:03:00	...	5
...	22:03:00	22:03:00	...	6
...	22:04:00	22:04:00	...	7
...	22:05:00	22:05:00	...	8
...	22:05:00	22:05:00	...	9
...	22:06:00	22:06:00	...	10
...	22:10:00	22:10:00	...	11
...	22:14:00	22:14:00	...	12
...	22:14:00	22:14:00	...	13
...	22:16:00	22:16:00	...	14
...	22:18:00	22:18:00	...	15
...	22:19:00	22:19:00	...	16
...	22:20:00	22:20:00	...	17
...	22:21:00	22:21:00	...	18
...	22:30:00	22:30:00	...	19
...	22:30:00	22:30:00	...	20
...	22:31:00	22:31:00	...	21
...	22:31:00	22:31:00	...	22
...	22:32:00	22:32:00	...	23
...	22:35:00	22:35:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
34232642	Whitesands	55.0684986646	-3.6154951426
34238492	Railway Station	55.0722541413	-3.6047140725
34234246	Crown Inn	55.1203569762	-3.355966203
34234259	Bridge Street	55.1217217585	-3.3544600124
34234387	Bridge Street	55.122167902	-3.351511329
34239329	Highfields	55.0916010557	-3.5151205525
34234562	Village	55.0900644285	-3.5165510067
34234537	Bruce Street	55.1282172745	-3.4468698596
34232827	Academy Street	55.0719004393	-3.6104010107
34234236	Sydney Place	55.1242047141	-3.3517996864
34232826	Buccleuch Street	55.0698551744	-3.6148607006
34234582	St Marys Industrial Estate	55.0723096287	-3.6018657176
34234583	Lockerbie Road	55.0732659526	-3.5933676752
34234585	Lockerbie Road	55.072844681	-3.5980810628
34234579	Lockerbie Road	55.0732865052	-3.5876672128
34234569	Lochar Moss	55.0825563727	-3.5482731308
34234548	Ryemuir	55.1092847983	-3.494986822
34234546	Hunter House	55.1195398823	-3.4787170551
34234543	Blackrig Farm	55.1252658653	-3.467464497
34234538	Hospital	55.1271913577	-3.4522749624
34234234	Alexandra Drive	55.1268347812	-3.3520767601
34234574	Lockerbie Rd	55.0783201414	-3.5744575642
34238738	Broomhouses	55.1314463854	-3.3543815033
34234567	Lockerbie Road	55.073986733	-3.5863479219