Melrose - Edinburgh - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	22:50:00	22:50:00	...	1
...	22:50:00	22:50:00	...	2
...	22:51:00	22:51:00	...	3
...	22:51:00	22:51:00	...	4
...	22:52:00	22:52:00	...	5
...	22:53:00	22:53:00	...	6
...	22:54:00	22:54:00	...	7
...	22:55:00	22:55:00	...	8
...	22:57:00	22:57:00	...	9
...	22:59:00	22:59:00	...	10
...	23:00:00	23:00:00	...	11
...	23:01:00	23:01:00	...	12
...	23:01:00	23:01:00	...	13
...	23:02:00	23:02:00	...	14
...	23:03:00	23:03:00	...	15
...	23:05:00	23:05:00	...	16
...	23:08:00	23:08:00	...	17
...	23:09:00	23:09:00	...	18
...	23:11:00	23:11:00	...	19
...	23:13:00	23:13:00	...	20
...	23:15:00	23:15:00	...	21

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

stop_code	stop_name	stop_lat	stop_lon
72726382	Tweedbank Loch	55.6013762681	-2.7693502662
72726374	Shops	55.6033935685	-2.7657551199
72726375	Shielswood Court	55.6062487412	-2.7661123509
72726372	Jura Drive	55.6061246783	-2.7615067915
72726394	Tweedbank Ind Est	55.6047104978	-2.7562573907
72725493	Abbey Car Park	55.5985897341	-2.7191946653
72725465	Health Centre	55.6158098815	-2.8039269451
72728487	Tweedbank Station	55.6053230786	-2.7574596235
72728481	Stance 8	55.6169055817	-2.8053783306
72723846	Galafoot Bridge	55.6027930218	-2.77836131
72723879	Archies Walk	55.6055488092	-2.7900347116
72723958	Fire Station	55.608932036	-2.7976429291
72723987	St Peter's School	55.6112072986	-2.8014832518
72723736	Borders General Hospital	55.596048777	-2.7414914217
72723749	Market Square	55.5973372484	-2.7197906488
72723769	St Dunstan's Lane	55.598288802	-2.721474392
72725494	Gibson Park	55.5989826761	-2.7241850232
72725382	Weirhill Place	55.5996606315	-2.728053984
72725376	Holy Trinity Church	55.5991445637	-2.7317262718
72725425	Ormiston Terrace	55.5988419735	-2.7342439549
72725842	Darnick Vale	55.5985828223	-2.7399839873