Galashiels - Balmoral circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:30:00	12:30:00	...	1
...	12:32:00	12:32:00	...	2
...	12:33:00	12:33:00	...	3
...	12:33:00	12:33:00	...	4
...	12:35:00	12:35:00	...	5
...	12:36:00	12:36:00	...	6
...	12:38:00	12:38:00	...	7
...	12:38:00	12:38:00	...	8
...	12:38:00	12:38:00	...	9
...	12:38:00	12:38:00	...	10
...	12:39:00	12:39:00	...	11
...	12:41:00	12:41:00	...	12
...	12:41:00	12:41:00	...	13
...	12:42:00	12:42:00	...	14
...	12:43:00	12:43:00	...	15
...	12:43:00	12:43:00	...	16
...	12:44:00	12:44:00	...	17
...	12:44:00	12:44:00	...	18
...	12:45:00	12:45:00	...	19
...	12:45:00	12:45:00	...	20
...	12:46:00	12:46:00	...	21
...	12:47:00	12:47:00	...	22
...	12:48:00	12:48:00	...	23
...	12:51:00	12:51:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
72725469	Hall Street	55.6195377177	-2.813641432
72725463	Asda	55.6152929501	-2.8032812984
72798458	Roxburgh Place	55.6173617399	-2.8152158583
72728506	Transport Interchange	55.6172551372	-2.8055125183
72724278	St John Street	55.6145098596	-2.8103143804
72724274	Balmoral Avenue	55.6142730395	-2.8162154627
72724272	Forest Crescent	55.61414034	-2.8199436149
72724295	Forest Avenue	55.6152592996	-2.8178871304
72724323	Forest Gardens	55.6164877529	-2.8209611266
72724328	Victoria Street Church	55.6176936375	-2.8166517354
72724294	Bank Street Gardens	55.6152836027	-2.8074407908
72724326	Iceland	55.6175003863	-2.8105666106
72724275	Burgh Chambers	55.6144370881	-2.8063596762
72725486	Hillside	55.6156906328	-2.8138316427
72725625	Balmoral Avenue	55.6130458444	-2.819682632
72725484	Balmoral Primary School	55.6131158091	-2.8226528668
72725473	Dean Street	55.6172264859	-2.8206748964
72726376	Victoria Street	55.6168844034	-2.818079745
72725479	Galapark Flats	55.6166527994	-2.8137245618