Rhyl - Denbigh Lenten Pool - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:42:00	12:42:00	...	1
...	12:42:00	12:42:00	...	2
...	12:42:00	12:42:00	...	3
...	12:43:00	12:43:00	...	4
...	12:43:00	12:43:00	...	5
...	12:44:00	12:44:00	...	6
...	12:45:00	12:45:00	...	7
...	12:46:00	12:46:00	...	8
...	12:46:00	12:46:00	...	9
...	12:48:00	12:48:00	...	10
...	12:49:00	12:49:00	...	11
...	12:49:00	12:49:00	...	12
...	12:51:00	12:51:00	...	13
...	12:51:00	12:51:00	...	14
...	12:52:00	12:52:00	...	15
...	12:53:00	12:53:00	...	16
...	12:53:00	12:53:00	...	17
...	12:54:00	12:54:00	...	18
...	12:54:00	12:54:00	...	19
...	12:55:00	12:55:00	...	20
...	12:55:00	12:55:00	...	21
...	12:55:00	12:55:00	...	22
...	12:56:00	12:56:00	...	23
...	12:57:00	12:57:00	...	24
...	12:57:00	12:57:00	...	25
...	12:57:00	12:57:00	...	26
...	12:58:00	12:58:00	...	27
...	12:58:00	12:58:00	...	28
...	13:07:00	13:07:00	...	29
...	13:07:00	13:07:00	...	30
...	13:10:00	13:10:00	...	31
...	13:14:00	13:14:00	...	32
...	13:15:00	13:15:00	...	33
...	13:16:00	13:16:00	...	34
...	13:19:00	13:19:00	...	35
...	13:20:00	13:20:00	...	36
...	13:21:00	13:21:00	...	37
...	13:23:00	13:23:00	...	38
...	13:24:00	13:24:00	...	39
...	13:26:00	13:26:00	...	40
...	13:28:00	13:28:00	...	41
...	13:30:00	13:30:00	...	42
...	13:31:00	13:31:00	...	43
...	13:32:00	13:32:00	...	44
...	13:33:00	13:33:00	...	45
...	13:34:00	13:34:00	...	46
...	13:35:00	13:35:00	...	47
...	13:38:00	13:38:00	...	48

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

stop_code	stop_name	stop_lat	stop_lon
dbgatgt	College	53.2799615873	-3.4734584949
dbgatgp	Meadow Brook Farm	53.2828312359	-3.4696572424
dbgadgj	Glan Clwyd Hospital	53.2729239845	-3.4943015421
dbgdgwd	Ashley Court	53.256634579	-3.449180847
dbgdjaj	Plough Hotel	53.2584591866	-3.4506817188
dbgdgwm	Plas Elwy Hotel	53.2598375835	-3.4519127377
dbgdgwg	Fountain Garage	53.2564621227	-3.4463567618
dbgagtp	Ysgol Frongoch	53.1894237873	-3.4098389809
dbgagtj	Lidl	53.1861923925	-3.4132200669
dbgagmt	Police Station	53.1848418522	-3.4164232004
dbgagmp	Library and Museum	53.1835083074	-3.4197015221
dbgagpa	Lenten Pool	53.1835008144	-3.4225895583
dbgajwp	Nant-y-Patrick	53.2299131207	-3.4309445789
dbgamaj	Thatched Cottage	53.2345141398	-3.4303339249
dbgajwm	Llannerch Equestrian Centre	53.2377140388	-3.4318641265
dbgdjpg	Bryn Polyn	53.2403925478	-3.4333921198
dbgdjtp	Bryn Polyn Nurseries	53.2438188544	-3.4347804818
dbgdjtj	Oriel House Hotel	53.2466439847	-3.4360739981
dbgdjpd	Bryn Asaph	53.2493197701	-3.4370779058
dbgdjpt	HM Stanley Hospital	53.2529502247	-3.4379340953
dbgdjmw	Bishops Walk	53.2534383042	-3.4384601156
dbgdmad	Village Hall	53.2240490748	-3.4214168951
dbgdjwt	College Farm	53.2204672986	-3.4179731302
dbgajtj	Plas Newydd	53.216257457	-3.4144193902
dbgajpw	Coed Estyn	53.2078077004	-3.4098286161
dbgajtm	Tyddyn-y-Parc	53.2028427989	-3.409291323
dbgajtd	Plas Clough	53.1988630026	-3.4090709148
dbgdaja	Marsh Warden	53.2885848271	-3.4703648192
dbgdama	Vicarage Lane	53.2921322793	-3.4648004433
dbgatpm	Ffordd Dewi	53.2937599428	-3.4618253765
dbgdagt	Highland Close	53.2973500883	-3.4600873754
dbgdagd	Bryn Cwybr	53.300361302	-3.4637765786
dbgdagp	Clwyd Retail Park	53.3034317889	-3.4677534766
dbgdaga	Derwen Hotel	53.3057579244	-3.4686587174
dbgdgpg	The Boulevard	53.3088694338	-3.4700263031
dbgdgpt	Tower Gardens	53.3108553995	-3.4722709746
dbgdgjt	Pendyffryn Road	53.3147691658	-3.4749125647
dbgdawd	Llys Glan Aber	53.316510782	-3.4801817263
dbgdgtd	Victoria Road	53.3172322118	-3.482893857
dbgdgmd	Bus Station	53.3189023303	-3.4888217241
dbgdjpj	Cathedral	53.2574528594	-3.4424925212
dbgatgw	Ty Isaf	53.2789501977	-3.4774583304
dbgdpdm	Gloddaeth Villas	53.1925783634	-3.4083857929
dbgdpga	Lowther Arms	53.2667002094	-3.4981179565
dbgdpgj	Vicarage Close	53.2678890582	-3.4965100987
dbgdpjg	Llys Morgan	53.3130324445	-3.47287128
dbgjapg	Angorfa Court	53.2559718539	-3.4400741745
dbgjdtm	Tweedmill Shopping Outlet	53.2352709361	-3.4286960172