Haddington - Port Seton - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
58232537	Rowanhill Drive	55.9657927754	-2.9543409659
58232749	St Joseph's	55.9558398054	-2.9516775909
58232743	A1 Roundabout	55.9506602833	-2.9556820762
58232879	Health Centre	55.9427905959	-2.9508611479
58234953	Fleets Road	55.9403007718	-2.960245792
58232897	Police Station	55.9433607577	-2.950330753
58232739	Fire Station	55.9473076989	-2.9558236525
58232747	Fowler Street	55.9486869335	-2.9564020828
58232738	Fa'side Lodge	55.9457084651	-2.9546474091
58235289	Harkness Crescent	55.9424677136	-2.9531107127
58232693	War Memorial	55.9219567771	-2.9666409565
5823287	Swan Road	55.9407712535	-2.9575197608
5824286	King's Road	55.9417391176	-2.9543736292
5823286	West Windygoul	55.9384850825	-2.9626342062
5823985	Castle Road	55.9374381171	-2.9632325629
5824679	Fa'side View	55.9361487195	-2.9638088586
5824782	Research Centre RE	55.9318628001	-2.9649509069
5823289	North Elphinstone	55.9273200625	-2.9633175808