Rhyl - Rhyl Circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:30:00	18:30:00	...	1
...	18:33:00	18:33:00	...	2
...	18:36:00	18:36:00	...	3
...	18:37:00	18:37:00	...	4
...	18:39:00	18:39:00	...	5
...	18:40:00	18:40:00	...	6
...	18:41:00	18:41:00	...	7
...	18:42:00	18:42:00	...	8
...	18:43:00	18:43:00	...	9
...	18:45:00	18:45:00	...	10
...	18:46:00	18:46:00	...	11
...	18:46:00	18:46:00	...	12
...	18:47:00	18:47:00	...	13
...	18:48:00	18:48:00	...	14
...	18:49:00	18:49:00	...	15
...	18:50:00	18:50:00	...	16
...	18:52:00	18:52:00	...	17
...	18:53:00	18:53:00	...	18
...	18:55:00	18:55:00	...	19

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
dbgdgdt	Morrison	53.3169990598	-3.4886203564
dbgdmtj	Bus Station	53.3191486888	-3.488530046
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
dbgdapt	Ffordd Las	53.3153887561	-3.4887144215
dbgdapg	Cefndy Road	53.3129747124	-3.4833316608
dbgdamj	Ascot Drive	53.3111023773	-3.4806399962
dbgdajm	Patrick Avenue	53.3089163982	-3.4654801511
dbgdajt	Tarquin Drive	53.3089541224	-3.4631400183
dbgdagm	Cambrian Walk	53.3110003315	-3.4626846631
dbgdawp	Hen-Afon Road	53.3142860966	-3.464508283
dbgdawa	Trellewelyn Road	53.3151246383	-3.4679595736
dbgdadw	Derwen Hotel	53.3063397804	-3.4688587901
dbgdpgm	The Boulevard	53.3084354196	-3.4695010844
dbgdtaj	Llys Glan Aber	53.316583971	-3.4800791766
dbgjdwg	Diane Drive	53.310968846	-3.4754569696