Colwyn Bay - Llandudno Junction - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:35:00	08:35:00	...	1
...	08:36:00	08:36:00	...	2
...	08:37:00	08:37:00	...	3
...	08:37:00	08:37:00	...	4
...	08:38:00	08:38:00	...	5
...	08:41:00	08:41:00	...	6
...	08:42:00	08:42:00	...	7
...	08:43:00	08:43:00	...	8
...	08:44:00	08:44:00	...	9
...	08:46:00	08:46:00	...	10
...	08:46:00	08:46:00	...	11
...	08:47:00	08:47:00	...	12
...	08:49:00	08:49:00	...	13
...	08:49:00	08:49:00	...	14
...	08:51:00	08:51:00	...	15
...	08:53:00	08:53:00	...	16
...	08:54:00	08:54:00	...	17
...	08:54:00	08:54:00	...	18
...	08:55:00	08:55:00	...	19
...	08:56:00	08:56:00	...	20
...	08:58:00	08:58:00	...	21
...	09:00:00	09:00:00	...	22
...	09:02:00	09:02:00	...	23
...	09:03:00	09:03:00	...	24
...	09:03:00	09:03:00	...	25
...	09:03:00	09:03:00	...	26
...	09:04:00	09:04:00	...	27
...	09:04:00	09:04:00	...	28
...	09:06:00	09:06:00	...	29
...	09:09:00	09:09: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