Merthyr Tydfil - Bargoed - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	06:46:00	06:46:00	...	1
...	06:46:00	06:46:00	...	2
...	06:46:00	06:46:00	...	3
...	06:47:00	06:47:00	...	4
...	06:48:00	06:48:00	...	5
...	06:48:00	06:48:00	...	6
...	06:48:00	06:48:00	...	7
...	06:50:00	06:50:00	...	8
...	06:50:00	06:50:00	...	9
...	06:51:00	06:51:00	...	10
...	06:51:00	06:51:00	...	11
...	06:51:00	06:51:00	...	12
...	06:52:00	06:52:00	...	13
...	06:53:00	06:53:00	...	14
...	06:53:00	06:53:00	...	15
...	06:54:00	06:54:00	...	16
...	06:54:00	06:54:00	...	17
...	06:55:00	06:55:00	...	18
...	06:55:00	06:55:00	...	19
...	06:56:00	06:56:00	...	20
...	06:57:00	06:57:00	...	21
...	06:59:00	06:59:00	...	22
...	07:00:00	07:00:00	...	23
...	07:01:00	07:01:00	...	24
...	07:01:00	07:01:00	...	25
...	07:02:00	07:02:00	...	26
...	07:04:00	07:04:00	...	27
...	07:05:00	07:05:00	...	28
...	07:06:00	07:06:00	...	29
...	07:06:00	07:06:00	...	30
...	07:07:00	07:07:00	...	31
...	07:07:00	07:07:00	...	32
...	07:07:00	07:07:00	...	33
...	07:08:00	07:08:00	...	34
...	07:08:00	07:08:00	...	35
...	07:10:00	07:10:00	...	36
...	07:12:00	07:12:00	...	37
...	07:14:00	07:14:00	...	38
...	07:15:00	07:15:00	...	39
...	07:16:00	07:16:00	...	40
...	07:17:00	07:17:00	...	41
...	07:17:00	07:17:00	...	42
...	07:20:00	07:20:00	...	43
...	07:21:00	07:21:00	...	44
...	07:22:00	07:22:00	...	45
...	07:22:00	07:22:00	...	46
...	07:23:00	07:23:00	...	47
...	07:24:00	07:24:00	...	48

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
cpydpmd	The Royal	51.7605757996	-3.2857399137
cpydpta	Library	51.7595751136	-3.2843349831
cpydpgt	Harvards Row	51.7590249791	-3.2820155743
cpydpjm	Queens Square	51.7558401115	-3.2813603148
cpydpgp	Wellington Way	51.7529277437	-3.28045209
cpydmwp	Maerdy Crossing	51.7510557046	-3.2789649495
cpydpad	Maerdy View	51.7505356057	-3.2780086287
cpydpag	Maerdy View	51.7504222157	-3.2776867241
cpyagaw	Rhymney Comprehensive	51.7472552898	-3.2728895573
cpyagda	Rhymney Comprehensive	51.7472182362	-3.2729899139
cpyadwj	Carnytyla Terrace	51.7453659843	-3.2696642492
cpyadwm	Carnytyla Terrace	51.7453022798	-3.2697348871
cpyagap	Prospect Place	51.7442608259	-3.2679240834
cpyagat	Prospect Place	51.7443772126	-3.2679707963
cpyagdt	Elim Tabernacle Church	51.7428786546	-3.2643512617
cpyagdw	Warn`s Terrace	51.7433168758	-3.2654063627
cpyadwd	School	51.7424499171	-3.262412925
cpyadwg	School	51.742369017	-3.2624106696
cpyagaj	McLarens Arms	51.7423060158	-3.2599031984
cpyagam	McLarens Arms	51.7422361228	-3.2597129633
cpyagdp	Charles Street	51.7432473846	-3.2559607217
cpydpaj	The Square	51.7479394089	-3.281093226
cpydpaw	Sunny View	51.743031196	-3.2801577253
cpydmtm	Brynhyfryd Bottom	51.7442452297	-3.2842622079
cpydmtw	Brynhyfryd Middle	51.7449380023	-3.2842239191
cpydpdm	Brynhyfryd Top	51.7466054075	-3.2863281292
cpyawjw	Heol y Bryn	51.7454257788	-3.2938557513
cpyawmd	Pontlottyn Road	51.7434529822	-3.2950015753
cpydmwd	Community Centre	51.7410579026	-3.2969318092
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
cpydpap	Station Terrace	51.7398672884	-3.2988963877
cpydjwg	Mount Pleasant	51.7322569864	-3.2983885364
cpydmat	Parc Cwm Darran	51.7223707187	-3.2857124426
cpydgpt	Ogilvie Terrace	51.716356608	-3.2707187862
cpydgmw	Bargoed Terrace	51.7141493259	-3.2677908727
cpyawaj	Library	51.7089777484	-3.2654173642
cpyawda	Darran Hotel	51.7078049564	-3.2632715895
cpyawat	New Road	51.7059514642	-3.2600360443
cpyagmt	Groesfaen Terrace	51.6962210245	-3.2475392577
cpyagpw	Puzzle House	51.6977680512	-3.2390013087
cpyagma	Factory Road	51.696084504	-3.2349329078
cpyagjp	Viaduct	51.6948518265	-3.2315860127
cpyjpad	Station	51.6927347005	-3.2294017315
cpyjpjw	Interchange	51.6913320395	-3.2285390661