Caernarfon - Bethel - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:42:00	08:42:00	...	1
...	08:43:00	08:43:00	...	2
...	08:45:00	08:45:00	...	3
...	08:45:00	08:45:00	...	4
...	08:45:00	08:45:00	...	5
...	08:46:00	08:46:00	...	6
...	08:47:00	08:47:00	...	7
...	08:47:00	08:47:00	...	8
...	08:47:00	08:47:00	...	9
...	08:47:00	08:47:00	...	10
...	08:48:00	08:48:00	...	11
...	08:49:00	08:49:00	...	12
...	08:49:00	08:49:00	...	13
...	08:49:00	08:49:00	...	14
...	08:49:00	08:49:00	...	15
...	08:50:00	08:50:00	...	16
...	08:50:00	08:50:00	...	17
...	08:51:00	08:51:00	...	18
...	08:52:00	08:52:00	...	19

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

stop_code	stop_name	stop_lat	stop_lon
gwnpmjp	Bus Station	53.1401163331	-4.2728112723
gwnpmwa	Asda	53.1430354405	-4.2729654602
gwnptad	Margaret Street Subway	53.140990239	-4.2684763714
gwnpmwp	Maes Cadnant	53.1425061212	-4.2667768878
gwnpmgw	Ael y Garth	53.1433371291	-4.2661029117
gwnptdm	Arfon Leisure Centre	53.1467083399	-4.2618689334
gwnapgm	Cremlyn	53.1648074195	-4.2072423579
gwnapjd	Ysgol	53.1653148116	-4.2046054028
gwngjgj	Erw-Bian	53.1679462082	-4.1925915318
gwngjga	Cefn Llan	53.1705192612	-4.1866330507
gwnapgt	Erw Crossroads	53.1566083557	-4.2298863178
gwnapdw	Bron Gwynedd	53.1640570986	-4.2108541441
gwnapja	Capel Saron	53.1653163765	-4.2011196434
gwngjgt	Gors Bach Inn	53.1724359801	-4.181149315
gwnptja	Ysgol Sir Hugh Oiwen	53.146047621	-4.2630454838
gwnapga	Capel Cysegr	53.1652497446	-4.1988870948
gwnptaw	Ffordd Bethel	53.1484508858	-4.2557991
gwnptam	Cae Berllan	53.1450272166	-4.2646965455
gwntwma	Ffordd Bethel	53.1497168662	-4.2535174868