Rosewell - Fort Kinnaird - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
36234752	North Bridge	55.9524973734	-3.1885672039
36234756	South Bridge	55.9490191088	-3.1867952007
36234758	Surgeons' Hall	55.9458042428	-3.1847273323
36234796	St Partick Square	55.9430717999	-3.1829467067
36234798	Bernard Terrace	55.9413630671	-3.1812295202
36234784	Newington Road	55.9389210857	-3.1791379895
36234837	Salisbury Place	55.9371032788	-3.177545918
36234838	Minto Street	55.9348789583	-3.175237337
36234839	Mayfield Gardens	55.9326188134	-3.1729119335
36234842	East Savile Road	55.9306785086	-3.1709645881
36234843	Suffolk Road	55.9290049248	-3.1693135678
36234845	Lygon Road	55.9269410742	-3.1671228044
36235254	Cameron Toll Centre	55.9283758692	-3.1636288198
36235256	Cameron Toll	55.9285104511	-3.1598396386
36235257	Bridgend Cottages	55.9276317652	-3.1567724814
36253623	Craigmillar Cemetery	55.9257515556	-3.1531795784
36235258	Walter Scott Avenue	55.9232243154	-3.1495838717
36235259	Kingston Avenue	55.9212444292	-3.1450926715
36235262	Craigmillar Castle Road	55.9208030162	-3.1423113231
36253643	Little France Crescent	55.9221872058	-3.1383834311
36253636	Royal Infirmary	55.9219434279	-3.1326634389
36235642	Duke Street	55.9692682751	-3.1684130779
36235645	Academy Street	55.9700597091	-3.170231434
36237346	Foot of the Walk	55.9700326111	-3.1721372682
36237347	Stead's Place	55.9675134233	-3.1743681477
36237352	Balfour Street	55.965285927	-3.1761590242
36235683	Pilrig Street	55.9627728926	-3.1786779093
36235684	Shrubhill	55.9618727113	-3.1797878861
36232575	Elm Row	55.9585442953	-3.1839312654
36253587	Leith Street	55.9554548157	-3.186575728