Rhyl - Rhyl Circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	13:30:00	13:30:00	...	1
...	13:31:00	13:31:00	...	2
...	13:32:00	13:32:00	...	3
...	13:33:00	13:33:00	...	4
...	13:34:00	13:34:00	...	5
...	13:34:00	13:34:00	...	6
...	13:36:00	13:36:00	...	7
...	13:36:00	13:36:00	...	8
...	13:37:00	13:37:00	...	9
...	13:37:00	13:37:00	...	10
...	13:38:00	13:38:00	...	11
...	13:38:00	13:38:00	...	12
...	13:39:00	13:39:00	...	13
...	13:40:00	13:40:00	...	14
...	13:41:00	13:41:00	...	15
...	13:43:00	13:43:00	...	16
...	13:46:00	13:46:00	...	17
...	13:48:00	13:48:00	...	18
...	13:50:00	13:50:00	...	19
...	13:51:00	13:51:00	...	20
...	13:52:00	13:52:00	...	21
...	13:55:00	13:55:00	...	22

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
dbgdmtj	Bus Station	53.3191486888	-3.488530046
dbgdagp	Clwyd Retail Park	53.3034317889	-3.4677534766
dbgdaga	Derwen Hotel	53.3057579244	-3.4686587174
dbgdgjt	Pendyffryn Road	53.3147691658	-3.4749125647
dbgdawd	Llys Glan Aber	53.316510782	-3.4801817263
dbgdgtd	Victoria Road	53.3172322118	-3.482893857
dbgdapa	Arriva Depot	53.3162321696	-3.4931572319
dbgdawm	Gwynfryn Avenue	53.3155644947	-3.4911974369
dbgdgad	Morrison	53.3160007097	-3.4893812243
dbgdgtg	Victoria Road	53.3141228961	-3.4864187114
dbgdawt	Kingsley Avenue	53.3152737618	-3.4842370229
dbgdgtj	Viola Avenue	53.3106320576	-3.4772465225
dbgdatg	Diane Drive	53.3110959453	-3.4753562843
dbgdgjp	Llys Pen-y-cefndy	53.3111481287	-3.4733167345
dbgdgmw	South Drive	53.3088061229	-3.4685982637
dbgdgpw	Trellewelyn Road	53.3150246871	-3.4680462106
dbgdadw	Derwen Hotel	53.3063397804	-3.4688587901
dbgdpgm	The Boulevard	53.3084354196	-3.4695010844
dbgdpgp	Tower Gardens	53.310660677	-3.4720241167
dbgjdwd	Ascot Drive	53.3112109506	-3.4805837146
dbgjgat	Daniel Drive	53.3123676056	-3.4633468415