Caernarfon - Beddgelert - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:20:00	07:20:00	...	1
...	07:20:00	07:20:00	...	2
...	07:20:00	07:20:00	...	3
...	07:22:00	07:22:00	...	4
...	07:23:00	07:23:00	...	5
...	07:25:00	07:25:00	...	6
...	07:25:00	07:25:00	...	7
...	07:27:00	07:27:00	...	8
...	07:29:00	07:29:00	...	9
...	07:29:00	07:29:00	...	10
...	07:29:00	07:29:00	...	11
...	07:30:00	07:30:00	...	12
...	07:30:00	07:30:00	...	13
...	07:31:00	07:31:00	...	14
...	07:33:00	07:33:00	...	15
...	07:35:00	07:35:00	...	16
...	07:39:00	07:39:00	...	17
...	07:40:00	07:40:00	...	18
...	07:41:00	07:41:00	...	19
...	07:42:00	07:42:00	...	20
...	07:45:00	07:45:00	...	21
...	07:48:00	07:48:00	...	22
...	07:49:00	07:49:00	...	23
...	07:50:00	07:50:00	...	24

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
gwnamwp	Beddgelert	53.0114801109	-4.1034341568
gwndmwp	Whiteways	53.111914941	-4.2076990449
gwnptjg	Snowdonia Park Hotel	53.1060975165	-4.2023810851
gwnapwa	Betws Inn	53.0952809756	-4.188281132
gwnpagw	Station	53.05052381	-4.1328941624
gwndgad	Segontium	53.1366963143	-4.2649757901
gwndajw	Glan Gwna	53.1324963495	-4.2451112508
gwndmwg	Pant Waun	53.1143586585	-4.2126359345
gwndmwm	Pen y Clip	53.1155349706	-4.2151321372
gwndajt	Bryngwna	53.1312469258	-4.2412789516
gwndgma	Tyddyn Pandy	53.1348638099	-4.2592132072
gwndmtw	Glanrafon Bach	53.1235667203	-4.2250959262
gwnptjp	Caffi y Pentref	53.1097378481	-4.2043750833
gwntawd	Pont Alyn	53.0138998149	-4.110469168
gwntawg	Y Warws	53.0135291451	-4.1075440473
gwntawj	Coedwig Nant Colwyn	53.0266474633	-4.124676857
gwntawm	Cwellyn Arms	53.0547705141	-4.1357302723
gwntawp	Snowdon Ranger	53.0738498422	-4.144676541
gwntawt	Graianfryn	53.0878498956	-4.1748070936
gwntdag	Bod Hyfryd	53.1131972065	-4.2103050012
gwntpgt	Asda	53.14298939	-4.2730228401
gwntpwp	Ffridd Uchaf	53.0414654384	-4.1246150998