Galashiels - Langlee circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:10:00	18:10:00	...	1
...	18:11:00	18:11:00	...	2
...	18:14:00	18:14:00	...	3
...	18:15:00	18:15:00	...	4
...	18:16:00	18:16:00	...	5
...	18:17:00	18:17:00	...	6
...	18:18:00	18:18:00	...	7
...	18:18:00	18:18:00	...	8
...	18:19:00	18:19:00	...	9
...	18:20:00	18:20:00	...	10
...	18:21:00	18:21:00	...	11
...	18:21:00	18:21:00	...	12
...	18:24:00	18:24:00	...	13
...	18:25:00	18:25:00	...	14
...	18:25:00	18:25:00	...	15
...	18:28:00	18:28:00	...	16
...	18:28:00	18:28:00	...	17
...	18:29:00	18:29:00	...	18
...	18:30:00	18:30:00	...	19
...	18:31:00	18:31:00	...	20
...	18:32:00	18:32:00	...	21
...	18:35:00	18:35: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