Tregaron - Aberystwyth - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:05:00	14:05:00	...	1
...	14:06:00	14:06:00	...	2
...	14:06:00	14:06:00	...	3
...	14:07:00	14:07:00	...	4
...	14:08:00	14:08:00	...	5
...	14:08:00	14:08:00	...	6
...	14:10:00	14:10:00	...	7
...	14:17:00	14:17:00	...	8
...	14:18:00	14:18:00	...	9
...	14:21:00	14:21:00	...	10
...	14:24:00	14:24:00	...	11
...	14:25:00	14:25:00	...	12
...	14:27:00	14:27:00	...	13
...	14:27:00	14:27:00	...	14
...	14:29:00	14:29:00	...	15
...	14:32:00	14:32:00	...	16
...	14:37:00	14:37:00	...	17
...	14:39:00	14:39:00	...	18
...	14:41:00	14:41:00	...	19
...	14:45:00	14:45:00	...	20
...	14:45:00	14:45:00	...	21
...	15:00:00	15:00:00	...	22

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
15/10/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
cejdwaj	Talbot Hotel	52.2197411527	-3.9330071855
cejdwpm	St John the Baptist's	52.2914665356	-3.9020364932
cejdwdm	Tynygraig Old PO	52.3079654847	-3.91873307
cejdapd	New Cross Turn	52.3625955067	-3.9996324119
cejdagj	St Michael's Church	52.3666347114	-3.9619770245
cejdptp	Neuadd Goffa	52.3994462044	-4.0704310894
cejadmj	Holiday Village	52.407998517	-4.0805942145
cejdmdm	Plas Helyg	52.4046239454	-4.0771716458
cejdmap	First Avenue	52.4027924016	-4.0749686601
cejadmg	Fire Station	52.4093950106	-4.0850267661
cejdwjw	New Cross Inn	52.3738400762	-4.0072803287
cejampj	Cnwch Coch	52.3573988748	-3.9457661917
cejampt	Cnwch Coch Turn	52.3532536428	-3.93866786
cejapdg	Trawscoed Bridge	52.3390169956	-3.9579354561
cejdwpj	Old Post Office	52.2889335144	-3.8906816743
cejdpap	Wellington House	52.2841468037	-3.8626071418
cejdpat	St David`s Church	52.2810340882	-3.8632828697
cejadjd	Smithy House	52.3459753759	-3.9601662997
cejdwjg	St Afan`s Church	52.3311724376	-3.93252098
cejdtwg	Mill Street	52.4121062245	-4.0847576803
cejdwtm	Bus Station Stand 5	52.4144306352	-4.080926478
cejgjgw	Wenallt	52.328458149	-3.9461392434