Galashiels - Langlee circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:00:00	12:00:00	...	1
...	12:01:00	12:01:00	...	2
...	12:04:00	12:04:00	...	3
...	12:05:00	12:05:00	...	4
...	12:06:00	12:06:00	...	5
...	12:07:00	12:07:00	...	6
...	12:08:00	12:08:00	...	7
...	12:08:00	12:08:00	...	8
...	12:09:00	12:09:00	...	9
...	12:10:00	12:10:00	...	10
...	12:11:00	12:11:00	...	11
...	12:11:00	12:11:00	...	12
...	12:14:00	12:14:00	...	13
...	12:15:00	12:15:00	...	14
...	12:15:00	12:15:00	...	15
...	12:18:00	12:18:00	...	16
...	12:18:00	12:18:00	...	17
...	12:19:00	12:19:00	...	18
...	12:20:00	12:20:00	...	19
...	12:21:00	12:21:00	...	20
...	12:22:00	12:22:00	...	21
...	12:25:00	12:25:00	...	22

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

stop_code	stop_name	stop_lat	stop_lon
72726386	Langlee Road	55.6098636614	-2.7813429171
72726384	Marmion Road	55.6097266799	-2.7788637902
72726397	Kenilworth Avenue	55.6104944597	-2.7739737362
72725478	Melrose Road	55.6139820483	-2.7948560223
72725476	Melrose Road	55.6137571934	-2.7935020103
72725459	Ellwyn Crescent	55.6155948113	-2.7997151975
72725465	Health Centre	55.6158098815	-2.8039269451
72725463	Asda	55.6152929501	-2.8032812984
72728504	Transport Interchange	55.6173259691	-2.8056727458
72724298	Ellwyn Crescent	55.6157920532	-2.7997827209
72724249	Langlee Primary School	55.6118669559	-2.7856373281
72723979	Winston Road	55.6111878251	-2.7751621439
72724238	Hawthorn Road	55.6114659204	-2.7808985333
72724242	Hawthorn Road	55.6116047152	-2.781679174
72723973	Woodstock Ave Shelter	55.609999472	-2.7755196831
72724264	Broom Drive	55.6135399786	-2.7769072835
72724269	Hawthorn Rd Terminus	55.6142925967	-2.772984869
72724267	Broom Drive	55.6136571783	-2.7768460978
72724253	Langlee Primary School	55.6121064826	-2.7861183789
72724286	Market Street Fountain	55.614787791	-2.8063192465