Aberystwyth - Penrhyncoch - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:45:00	08:45:00	...	1
...	08:46:00	08:46:00	...	2
...	08:48:00	08:48:00	...	3
...	08:49:00	08:49:00	...	4
...	08:52:00	08:52:00	...	5
...	08:53:00	08:53:00	...	6
...	08:57:00	08:57:00	...	7
...	08:58:00	08:58:00	...	8
...	08:59:00	08:59:00	...	9
...	09:00:00	09:00:00	...	10
...	09:01:00	09:01:00	...	11
...	09:02:00	09:02:00	...	12
...	09:03:00	09:03:00	...	13
...	09:05:00	09:05:00	...	14
...	09:05:00	09:05:00	...	15
...	09:05:00	09:05:00	...	16
...	09:06:00	09:06:00	...	17
...	09:08:00	09:08:00	...	18
...	09:10:00	09:10: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
cejdptj	Morrisons	52.4049744352	-4.0669264273
cejawgm	Glynpadarn	52.4081866556	-4.0616513852
cejawgp	Ambulance Station	52.4103280223	-4.065177154
cejadmp	Plas Avenue	52.4116362836	-4.0695464957
cejadmt	St David`s Road	52.4140345173	-4.074305463
cejadpd	Social Security	52.4160601304	-4.0787680207
cejadwd	Bus Station Stand 2	52.4144608795	-4.0812514066
cejadpg	Park Avenue	52.4131633934	-4.0824254572
cejadtd	Arriva Depot	52.4119610358	-4.080751367
cejawjm	Pwllhobi	52.4072072197	-4.0580036414
cejdmpg	Capel Dewi Crossroads	52.4222914711	-4.015952363
cejdmgp	Bungalows	52.4346579771	-4.0083668595
cejdmgw	Post Office	52.4375774136	-3.998451187
cejatgd	Village Hall	52.4384524011	-3.9892219012
cejdmpm	Plas Gogerddan	52.4332285307	-4.0168047045
cejadpj	Police Station	52.4100419065	-4.0773968834
cejajgw	Capel Dewi Turn	52.4115719251	-4.0118315291
cejadpw	St Padarn's RC Primary School	52.4135008828	-4.0739716202
cejgmpt	Canolfan Rheidol	52.4072814791	-4.070224718