Bangor - Caernarfon - 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:06:00	08:06:00	...	4
...	08:07:00	08:07:00	...	5
...	08:07:00	08:07:00	...	6
...	08:07:00	08:07:00	...	7
...	08:07:00	08:07:00	...	8
...	08:08:00	08:08:00	...	9
...	08:09:00	08:09:00	...	10
...	08:10:00	08:10:00	...	11
...	08:11:00	08:11:00	...	12
...	08:11:00	08:11:00	...	13
...	08:12:00	08:12:00	...	14
...	08:13:00	08:13:00	...	15
...	08:14:00	08:14:00	...	16
...	08:15:00	08:15:00	...	17
...	08:15:00	08:15:00	...	18
...	08:15:00	08:15:00	...	19
...	08:16:00	08:16:00	...	20
...	08:16:00	08:16:00	...	21
...	08:17:00	08:17:00	...	22
...	08:18:00	08:18:00	...	23
...	08:19:00	08:19:00	...	24
...	08:19:00	08:19:00	...	25
...	08:20:00	08:20:00	...	26
...	08:20:00	08:20:00	...	27
...	08:21:00	08:21:00	...	28
...	08:22:00	08:22:00	...	29
...	08:23:00	08:23:00	...	30
...	08:24:00	08:24:00	...	31
...	08:25:00	08:25:00	...	32

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

stop_code	stop_name	stop_lat	stop_lon
gwndwmj	Tan y Graig	53.2181464367	-4.1399130959
gwnpmjm	Bus Station	53.1402306676	-4.2734153973
gwnjpgd	Aber Pwll	53.1900305529	-4.1987632586
gwnjpgp	Bodarwydd	53.1870575092	-4.2049276962
gwnjpgt	Cloc	53.1860450425	-4.2071658243
gwnjpgw	Victoria Hotel	53.1840270839	-4.2093222081
gwnptpj	Arfon	53.1823410546	-4.2110315109
gwnptwm	Modurdy	53.1796817402	-4.2152796341
gwnptpw	Cerrig-yr-afon	53.174196612	-4.2249628198
gwnpwat	Plas Menai	53.1689097269	-4.2364942063
gwnpmtj	Griffiths Crossing	53.1650999867	-4.2430582679
gwnptgp	Waterloo Port	53.1510522542	-4.2632190308
gwnpmjw	Lï¿½n Campbell	53.1470933439	-4.2680953013
gwndgpw	Ffordd yr Hafod	53.1999390857	-4.1747303276
gwnjgdg	Lon ty golchi	53.2028716677	-4.1647716265
gwndwmg	Home Bargains	53.2160054143	-4.1414838939
gwnamam	Plaza	53.2225348961	-4.1328364816
gwnptgd	Tal Menai	53.1586186345	-4.253475343
gwnpmpt	Ferodo	53.1625816266	-4.2469211728
gwnpwjd	Faenol	53.1956140434	-4.184092867
gwnpmgm	Morrisons	53.1444082456	-4.2712285947
gwnpwag	Nant-y-Garth	53.1925538455	-4.1901498587
gwnpwdp	Santes Fair	53.1779341475	-4.2188410362
gwnamat	Ffordd Deiniol	53.2253692204	-4.1317039646
gwnamga	Bus Station	53.2279067613	-4.126046889
gwnajwg	West End	53.2213711797	-4.1355649232
gwnajgp	St David`s Church	53.2191395136	-4.1391836963
gwndjtg	Bryn Llwyd	53.2140179799	-4.1435115325
gwndjtm	Menai Retail Park	53.2111734603	-4.1476976924
gwndjpt	B&Q	53.2078637208	-4.1527435328
gwnpwgw	Ty-golchi	53.1971060455	-4.1811744052
gwntpjp	Llanfair Hall	53.1699221636	-4.2338087648