Merthyr Tydfil - Bargoed - Transport Data Hub

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

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
cpyawag	Bailey Street	51.7126661524	-3.2677493902
cpydpam	The Square	51.7477131092	-3.2812316788
cpydpda	Sunny View	51.7430848136	-3.2801882095
cpydmtp	Brynhyfryd Bottom	51.7438486134	-3.2843523494
cpydmwa	Brynhyfyd Middle	51.7449837377	-3.2841527924
cpydpdp	Brynhyfyd Top	51.7466511442	-3.286257002
cpyawma	Heol-y-Bryn	51.7455349199	-3.2937429905
cpyawmg	Pontlottyn Road	51.7434878202	-3.295103962
cpydmwg	Community Centre	51.7411206643	-3.2969480903
cpydpdg	Pleasant View	51.7402301352	-3.2969805184
cpydpdj	Pleasant View	51.7400500398	-3.2970043267
cpyawmt	Heol Iago Playground	51.7385284971	-3.2963669576
cpyawmj	Coronation Crescent	51.7373844298	-3.2949294191
cpyawmp	Glan-y-nant	51.7385579194	-3.2945140082
cpydpat	Station Terrace	51.7400200976	-3.2989007707
cpydjwj	Mount Pleasant	51.7321398121	-3.2984141392
cpydmaw	Parc Cwm Darran	51.7223338128	-3.2857982608
cpydgpw	Ogilvie Terrace	51.7164422698	-3.2711120304
cpyawad	Bargoed Terrace	51.7143619362	-3.2680863189
cpyawam	Library	51.709332629	-3.2658614709
cpyawdg	Darran Hotel	51.7075867315	-3.2634970739
cpyawaw	New Road	51.7050457592	-3.2589688914
cpyagmp	Groesfaen Terrace	51.6961620901	-3.2488543288
cpyagta	Puzzle House	51.697668256	-3.2390854001
cpyagmd	Factory Road	51.6959769393	-3.2349010409
cpyagjt	Viaduct	51.6948733321	-3.2321074703
cpyagtg	Station	51.6927240458	-3.229560591
cpyjpjw	Interchange	51.6913320395	-3.2285390661