Cardigan - Poppet Sands - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:00:00	15:00:00	...	1
...	15:00:00	15:00:00	...	2
...	15:01:00	15:01:00	...	3
...	15:02:00	15:02:00	...	4
...	15:05:00	15:05:00	...	5
...	15:06:00	15:06:00	...	6
...	15:06:00	15:06:00	...	7
...	15:07:00	15:07:00	...	8
...	15:07:00	15:07:00	...	9
...	15:07:00	15:07:00	...	10
...	15:08:00	15:08:00	...	11
...	15:10:00	15:10:00	...	12
...	15:15:00	15:15:00	...	13
...	15:24:00	15:24:00	...	14
...	15:25:00	15:25:00	...	15
...	15:27:00	15:27:00	...	16
...	15:32:00	15:32:00	...	17
...	15:37:00	15:37:00	...	18
...	15:38:00	15:38:00	...	19
...	15:40:00	15:40:00	...	20
...	15:40:00	15:40:00	...	21
...	15:46:00	15:46:00	...	22
...	15:47:00	15:47:00	...	23
...	15:49:00	15:49:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
pemdjdp	Post Office	52.0817027785	-4.6801237901
pemdpwd	Car Park	52.1039844998	-4.6979773445
pemdtja	St Dogmaels	52.0887450691	-4.6820643116
pemdjdt	Post Office	52.0817922541	-4.6801437503
pemgmpg	Parc Noi	52.0831967243	-4.6832349429
pemdpmw	Feidr Fawr	52.083216678	-4.683148558
pemgtjg	David Street	52.0814438506	-4.6780647597
cejajpa	Rugby Ground	52.0875910067	-4.6532068856
cejamaj	Tesco	52.0895541921	-4.6470896182
cejajpw	Feidr Henffordd	52.0888095609	-4.649410528
cejamag	Castle	52.0812766781	-4.6600427772
cejamam	Tesco	52.0896417082	-4.6471969947
cejajta	Feidr Henffordd	52.0888043141	-4.649643798
cejajpg	Rugby Ground	52.0875128055	-4.6530854568
cejajtm	Grosvenor Hill	52.0819132739	-4.6613213622
cejajtj	Finch Square	52.0829504899	-4.6576024992
cejamad	Ship Inn	52.0839501041	-4.6607273447
cejajpd	Secondary School	52.0872057143	-4.6551401896
cejajpm	Council Offices	52.08320916	-4.6584936961