Colwyn Bay - Llandudno Junction - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:40:00	15:40:00	...	1
...	15:43:00	15:43:00	...	2
...	15:43:00	15:43:00	...	3
...	15:44:00	15:44:00	...	4
...	15:46:00	15:46:00	...	5
...	15:49:00	15:49:00	...	6
...	15:51:00	15:51:00	...	7
...	15:53:00	15:53:00	...	8
...	15:53:00	15:53:00	...	9
...	15:55:00	15:55:00	...	10
...	15:56:00	15:56:00	...	11
...	15:57:00	15:57:00	...	12
...	15:59:00	15:59:00	...	13
...	15:59:00	15:59:00	...	14
...	16:02:00	16:02:00	...	15
...	16:04:00	16:04:00	...	16
...	16:05:00	16:05:00	...	17
...	16:05:00	16:05:00	...	18
...	16:06:00	16:06:00	...	19
...	16:07:00	16:07:00	...	20
...	16:09:00	16:09:00	...	21
...	16:12:00	16:12:00	...	22
...	16:15:00	16:15:00	...	23
...	16:16:00	16:16:00	...	24
...	16:16:00	16:16:00	...	25
...	16:16:00	16:16:00	...	26
...	16:17:00	16:17:00	...	27
...	16:17:00	16:17:00	...	28
...	16:19:00	16:19:00	...	29
...	16:22:00	16:22:00	...	30

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
cnwgatw	Ship Hotel	53.3091314585	-3.7520637374
cnwdgmw	Tesco	53.2827338965	-3.8112258234
cnwdgjt	Station	53.284392939	-3.8085357762
cnwdgjp	Station	53.2842427055	-3.809549512
cnwatjm	Preswylfa	53.2837562276	-3.8042785909
cnwatjt	Trem yr Afon	53.2827127155	-3.7989693887
cnwatja	Capel Pensarn	53.2822160662	-3.7943433791
cnwatjg	Narrow Lane	53.2833334645	-3.7947652286
cnwaptg	Nurseries	53.28435173	-3.7735812373
cnwdmgj	Post Office	53.2911220657	-3.762609114
cnwdmgt	Llys Ednyfed	53.2929559858	-3.7613942797
cnwdwaw	West End	53.2994706117	-3.7389427276
cnwdwda	Egerton Road	53.2984379485	-3.7363947588
cnwajmg	Pwllycrochan Avenue	53.2972198243	-3.7336143168
cnwajmj	Railway Station	53.2962417357	-3.7248116428
cnwawtw	Bryn Defaid	53.3081324869	-3.7558052043
cnwawtj	Bron-y-nant Cemetery	53.2982201495	-3.7592249976
cnwdadw	Methodist Church	53.3083103376	-3.7436848218
cnwawmw	Newton Mount	53.3128290873	-3.7451299708
cnwawta	Church	53.3118653761	-3.741563126
cnwdtwg	Fiveways	53.3016701143	-3.7428439349
cnwdjwt	Black Cat Roundabout	53.2788976822	-3.7902295174
cnwgpdj	High Lane	53.3072261505	-3.7477381189
cnwgpdp	School	53.3109885284	-3.7504886561
cnwgpjw	Business Park	53.2889407247	-3.7654298279
cnwgpmd	Dolwyd Crescent	53.2833756575	-3.7769459914
cnwjawa	Cambrian Drive North	53.3053365662	-3.7619039676
cnwjawd	Cambrian Drive South	53.3032501798	-3.7619531179
cnwjdat	Narrow Lane	53.2832523799	-3.7947768305
cnwjwag	WAG Offices	53.2843128736	-3.7930061418