Heath Hospital - Sports Village - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:35:00	17:35:00	...	1
...	17:35:00	17:35:00	...	2
...	17:36:00	17:36:00	...	3
...	17:37:00	17:37:00	...	4
...	17:39:00	17:39:00	...	5
...	17:41:00	17:41:00	...	6
...	17:42:00	17:42:00	...	7
...	17:44:00	17:44:00	...	8
...	17:45:00	17:45:00	...	9
...	17:46:00	17:46:00	...	10
...	17:47:00	17:47:00	...	11
...	17:47:00	17:47:00	...	12
...	17:49:00	17:49:00	...	13
...	17:50:00	17:50:00	...	14
...	17:51:00	17:51:00	...	15
...	17:53:00	17:53:00	...	16
...	17:55:00	17:55:00	...	17
...	17:56:00	17:56:00	...	18
...	18:00:00	18:00:00	...	19
...	18:04:00	18:04:00	...	20
...	18:08:00	18:08:00	...	21
...	18:09:00	18:09:00	...	22
...	18:10:00	18:10:00	...	23
...	18:12:00	18:12:00	...	24
...	18:13:00	18:13:00	...	25
...	18:15:00	18:15:00	...	26
...	18:16:00	18:16:00	...	27
...	18:18:00	18:18:00	...	28
...	18:18:00	18:18:00	...	29
...	18:20:00	18:20:00	...	30
...	18:21:00	18:21:00	...	31
...	18:23:00	18:23:00	...	32
...	18:24:00	18:24:00	...	33
...	18:26:00	18:26:00	...	34
...	18:27:00	18:27:00	...	35
...	18:29:00	18:29:00	...	36
...	18:31:00	18:31:00	...	37

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

stop_code	stop_name	stop_lat	stop_lon
cdipagd	West Grove 1	51.4840264368	-3.1677995196
cdimwjm	Infirmary 1	51.4848019121	-3.1657742458
cdidawd	Woodville Road	51.4946731971	-3.1767579484
cdiatwd	Monthermer Road	51.4957538825	-3.1792779359
cdiatdm	Gladstone School	51.4974443358	-3.1828510528
cdidwjd	Childrens Unit	51.5082876572	-3.1882760863
cdidwtd	Main Entrance	51.5061730773	-3.188422787
cdidwmt	Heath Park Way	51.5085808781	-3.1912809046
cdidtam	Interchange Bay 6	51.5043332437	-3.1969189859
cdijtmd	Maitland Street	51.5037774551	-3.1949881497
cdijtmg	Newfoundland Rd	51.5025109911	-3.1904310132
cdijtgp	Companies House	51.5005458393	-3.1873687291
cdijtja	Heath Hotel	51.4989435016	-3.1848779711
cdidatm	Strathnairn Street	51.491895264	-3.1713136071
cdimwmj	Northcote Lane	51.4900138412	-3.1697241848
cdipada	St Peter's Street	51.4874068618	-3.166949717
cdiajmg	Wyndham Arcade Stop NA	51.4773067918	-3.1770596459
cdimagp	Stockland St	51.467685558	-3.1886316475
cdimagw	Wilfred Brook House	51.4663522386	-3.1879923509
cdijwtw	Bromsgrove Street	51.4651804362	-3.1873860773
cdidtd	Clive Street	51.4627737478	-3.186186384
cdijam	Staples	51.460341023	-3.1866702838
cditawa	Cardiff Bay Asda	51.457519669	-3.184682767
cdidtmw	Clare Road	51.4741833761	-3.1871879143
cdiagtp	Durham Street	51.4707823024	-3.186509306
cdimadp	North Clive Street	51.4688199956	-3.1884883704
cdimtdj	Fitzhamon Embankment	51.4762869318	-3.1836858946
cdimpjd	Beauchamp Street	51.4766707641	-3.1866333292
cdimadg	Dunleavy Drive	51.4533391536	-3.1908207147
cditdwa	Watkiss Way	51.4483236076	-3.1835236916
cditdwp	Watkiss Way	51.4495307145	-3.1868648298
cditgmw	Dunleavy Drive	51.4544270848	-3.1881720263
cditgtw	Watkiss Way	51.4514654744	-3.1876058082
cditgwp	Bute Terrace	51.4775326613	-3.1733647252
cditmjd	Dental Hospital	51.5066399369	-3.1920371729
cditmpa	Churchill Way	51.4814066912	-3.1726145144
cditpgj	Wood Street	51.4775873938	-3.1786652456