Borth - Bow Street - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:05:00	08:05:00	...	1
...	08:05:00	08:05:00	...	2
...	08:06:00	08:06:00	...	3
...	08:07:00	08:07:00	...	4
...	08:09:00	08:09:00	...	5
...	08:11:00	08:11:00	...	6
...	08:13:00	08:13:00	...	7
...	08:14:00	08:14:00	...	8
...	08:14:00	08:14:00	...	9
...	08:15:00	08:15:00	...	10
...	08:15:00	08:15:00	...	11
...	08:24:00	08:24:00	...	12
...	08:25:00	08:25:00	...	13
...	08:30:00	08:30:00	...	14
...	08:33:00	08:33:00	...	15
...	08:35:00	08:35:00	...	16
...	08:36:00	08:36:00	...	17
...	08:38:00	08:38:00	...	18
...	08:40:00	08:40:00	...	19
...	08:42:00	08:42:00	...	20
...	08:43:00	08:43:00	...	21
...	08:45:00	08:45:00	...	22
...	08:47:00	08:47:00	...	23

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
24/08/2013 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
cejawgp	Ambulance Station	52.4103280223	-4.065177154
cejawjg	Rural Studies Institute	52.4114721455	-4.0542175549
cejawja	Lluest Lodge	52.4136081005	-4.0477145812
cejdwgj	Maesawelon	52.4160071603	-4.0545460318
cejamtp	School	52.4216561639	-4.0377926908
cejagtm	Grand Hotel	52.4907378199	-4.0512969556
cejagtp	Surgery	52.4855023413	-4.0509207173
cejdwdp	Canteen Stores	52.4814176506	-4.0510693828
cejdmjd	Maes y Garn	52.4498583175	-4.0212731414
cejdmjm	Cross Street	52.4464494357	-4.025016568
cejagwd	Post Office	52.442222803	-4.0276771579
cejdwgm	Beechfield	52.4160554023	-4.0543571073
cejamwd	Trefaenor	52.4194626547	-4.0398533388
cejadpw	St Padarn's RC Primary School	52.4135008828	-4.0739716202
cejagwa	Caerfelin	52.4434505708	-4.0268654148
cejagwm	Jewson	52.4407958597	-4.028567985
cejgajt	Llanbadarn Square	52.4082350883	-4.0593894412
cejgawp	Llanbadarn Crossroads	52.4136235231	-4.0478623397
cejgdaw	Llandre	52.4626053561	-4.0240652983
cejgdga	Dol-y-Bont	52.4722755655	-4.0285287788
cejgdgd	Glanwern	52.479421453	-4.0438047821
cejgmat	Penweddig School	52.4100115039	-4.0668238271
cejgmaw	Ysgol Penglais	52.4164016664	-4.0577113161