Caernarfon - Beddgelert - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:22:00	08:22:00	...	1
...	08:22:00	08:22:00	...	2
...	08:23:00	08:23:00	...	3
...	08:25:00	08:25:00	...	4
...	08:26:00	08:26:00	...	5
...	08:26:00	08:26:00	...	6
...	08:27:00	08:27:00	...	7
...	08:28:00	08:28:00	...	8
...	08:28:00	08:28:00	...	9
...	08:29:00	08:29:00	...	10
...	08:29:00	08:29:00	...	11
...	08:30:00	08:30:00	...	12
...	08:31:00	08:31:00	...	13
...	08:32:00	08:32:00	...	14
...	08:34:00	08:34:00	...	15

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

stop_code	stop_name	stop_lat	stop_lon
gwnpmjp	Bus Station	53.1401163331	-4.2728112723
gwnptap	Turf Square	53.1409905515	-4.2741134495
gwnptad	Margaret Street Subway	53.140990239	-4.2684763714
gwndgad	Segontium	53.1366963143	-4.2649757901
gwndajw	Glan Gwna	53.1324963495	-4.2451112508
gwnpmwp	Maes Cadnant	53.1425061212	-4.2667768878
gwnpmgw	Ael y Garth	53.1433371291	-4.2661029117
gwnpmjg	Cae Berllan	53.1450242036	-4.2643823571
gwnptdm	Arfon Leisure Centre	53.1467083399	-4.2618689334
gwndgma	Tyddyn Pandy	53.1348638099	-4.2592132072
gwnptja	Ysgol Sir Hugh Oiwen	53.146047621	-4.2630454838
gwnptag	William Street Path	53.1402109832	-4.269736129
gwnpmwt	Maes Cadnant	53.1429300989	-4.2662310062
gwnptam	Cae Berllan	53.1450272166	-4.2646965455
gwntpgt	Asda	53.14298939	-4.2730228401