Rhyl - Rhyl Circular - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:00:00	17:00:00	...	1
...	17:02:00	17:02:00	...	2
...	17:02:00	17:02:00	...	3
...	17:03:00	17:03:00	...	4
...	17:04:00	17:04:00	...	5
...	17:05:00	17:05:00	...	6
...	17:06:00	17:06:00	...	7
...	17:07:00	17:07:00	...	8
...	17:10:00	17:10:00	...	9
...	17:11:00	17:11:00	...	10
...	17:12:00	17:12:00	...	11
...	17:13:00	17:13:00	...	12
...	17:13:00	17:13:00	...	13
...	17:14:00	17:14:00	...	14
...	17:15:00	17:15:00	...	15
...	17:16:00	17:16:00	...	16
...	17:18:00	17:18:00	...	17
...	17:20:00	17:20:00	...	18
...	17:22:00	17:22: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
dbgdmtj	Bus Station	53.3191486888	-3.488530046
dbgawaw	Clement Drive	53.3161727759	-3.4638673401
dbgdgap	Llys-y-Tywysog	53.3243339562	-3.4617744566
dbgdgag	Llys Dewi	53.3237173061	-3.4592760128
dbgawja	Lon Celynnen	53.3219174008	-3.4594397897
dbgdgjm	Parry`s Corner	53.3190479616	-3.4727481826
dbgdgdp	Millbank Road	53.3205218668	-3.482212235
dbgdgpj	Tongs Funeral Directors	53.3213460135	-3.4846129394
dbgdatp	Clifton Park Road South	53.3201558902	-3.4791068511
dbgdgdg	Clifton Park Road North	53.3217782192	-3.4773162894
dbgdapw	Hadley Crescent	53.3224846476	-3.4747132633
dbgdgdm	Mayfield Grove	53.322349599	-3.4710902668
dbgdatw	Ffordd Anwyl	53.321159281	-3.4692026633
dbgdawj	Ysgol Llewelyn	53.3150302306	-3.471243803
dbgdgpw	Trellewelyn Road	53.3150246871	-3.4680462106
dbgjapw	Millbank Road	53.3205694059	-3.4820036974
dbgjawm	Llys Tegid	53.3193281315	-3.4623990118
dbgjawp	Llys Gwynant	53.320571629	-3.4628919348