Aberystwyth - Penrhyncoch - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:40:00	07:40:00	...	1
...	07:42:00	07:42:00	...	2
...	07:48:00	07:48:00	...	3
...	07:50:00	07:50:00	...	4
...	07:51:00	07:51:00	...	5
...	07:53:00	07:53:00	...	6
...	07:54:00	07:54:00	...	7
...	07:57:00	07:57:00	...	8
...	07:58:00	07:58:00	...	9
...	08:03:00	08:03:00	...	10
...	08:04:00	08:04:00	...	11
...	08:05:00	08:05:00	...	12
...	08:06:00	08:06:00	...	13
...	08:07:00	08:07:00	...	14
...	08:08:00	08:08:00	...	15
...	08:09:00	08:09:00	...	16
...	08:10:00	08:10:00	...	17
...	08:12:00	08:12:00	...	18
...	08:12:00	08:12:00	...	19
...	08:12:00	08:12:00	...	20
...	08:13:00	08:13:00	...	21
...	08:15:00	08:15:00	...	22
...	08:17:00	08:17:00	...	23

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
cejatmd	Glanrafon Ind Est	52.4027329383	-4.0412128746
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
cejdjpj	Pont Tyngelli	52.4354902043	-3.9538838518
cejajgw	Capel Dewi Turn	52.4115719251	-4.0118315291
cejatgp	Salem Turn	52.4380619927	-3.9830251113
cejadpw	St Padarn's RC Primary School	52.4135008828	-4.0739716202
cejgdjm	Ty Pen y Bont	52.4336679568	-3.9444324202
cejgmpt	Canolfan Rheidol	52.4072814791	-4.070224718