Borth - Bow Street - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:25:00	15:25:00	...	1
...	15:26:00	15:26:00	...	2
...	15:27:00	15:27:00	...	3
...	15:27:00	15:27:00	...	4
...	15:28:00	15:28:00	...	5
...	15:30:00	15:30:00	...	6
...	15:35:00	15:35:00	...	7
...	15:37:00	15:37:00	...	8
...	15:38:00	15:38:00	...	9
...	15:39:00	15:39:00	...	10
...	15:39:00	15:39:00	...	11
...	15:41:00	15:41:00	...	12
...	15:47:00	15:47:00	...	13
...	15:48:00	15:48:00	...	14
...	15:54:00	15:54:00	...	15
...	15:55:00	15:55:00	...	16
...	15:55:00	15:55:00	...	17
...	15:55:00	15:55:00	...	18
...	15:56:00	15:56:00	...	19
...	15:56:00	15:56:00	...	20
...	15:58:00	15:58:00	...	21
...	16:00:00	16:00:00	...	22
...	16:02:00	16:02:00	...	23
...	16:03:00	16:03:00	...	24
...	16:04:00	16:04:00	...	25
...	16:05:00	16:05:00	...	26

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
cejawgt	Ambulance Station	52.4103308464	-4.0650155494
cejawjt	St Padarn's Church	52.4090727633	-4.0618838583
cejawgw	War Memorial	52.4084699817	-4.0598414672
cejawjd	Rural Studies Institute	52.4113472193	-4.0551968917
cejadpt	National Library	52.4178649815	-4.0671176692
cejamtw	Trefaenor	52.419351038	-4.0400687793
cejatmg	Glanwern	52.479291267	-4.0435336734
cejaptm	Dol-y-Bont	52.472238871	-4.0285712624
cejawpd	Llandre	52.462566145	-4.0242548674
cejagtw	Caerfelin	52.4435905393	-4.0270925567
cejagwj	Jewson	52.4405936618	-4.0288235334
cejadmw	Llanbadarn Road	52.4140807275	-4.0742341093
cejadpa	Plas Avenue	52.4116732495	-4.0694894117
cejamwj	School	52.4215635331	-4.0379501948
cejdwgt	Waunfawr University Top	52.4189661373	-4.060183747
cejadtp	Waun Crossroads	52.4192113213	-4.0615922765
cejadjw	Bronglais Hospital	52.416568426	-4.0728656478
cejdmjw	Rhydypennau Farm	52.4533435125	-4.0193723289
cejdmjg	Maes y Garn	52.4497549632	-4.0215333021
cejdmjp	Cross Street	52.4465662328	-4.0250219268
cejagwg	Post Office	52.4421730891	-4.0279544375
cejgdgj	Canteen Stores	52.481433577	-4.0511879399
cejgdgm	Surgery	52.4855454756	-4.0510258232
cejgdgp	Grand Hotel	52.49078764	-4.051534957
cejgmat	Penweddig School	52.4100115039	-4.0668238271
cejgmaw	Ysgol Penglais	52.4164016664	-4.0577113161