Aberdeen - Kemnay or Alford - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
23628963	Midmill Business Park	57.2234901696	-2.3468912856
23625354	Torryburn	57.231167422	-2.3480400629
23629475	East Park Road	57.2332169046	-2.3475458705
23625367	Tuach Road	57.2348915342	-2.3461701219
23625352	The Square	57.2377842883	-2.3460812793
23625386	Broomhill Roundabout	57.2151742674	-2.3427733502
23625485	Glasgoforest	57.2051590104	-2.3114628408
23629367	Sunnyside View	57.2286740739	-2.3466252853
23625363	Tumulus Road	57.2223755324	-2.3471623379
23234837	Woolmanhill Hospital	57.1500124489	-2.1067674097
23235476	Northern Hotel	57.1618436086	-2.116241834
23235459	Ashgrove Road	57.1607395593	-2.1153125512
23235265	Berryden Retail Park	57.1550275982	-2.1139723546
23235342	Chestnut Row	57.1566783995	-2.1162255959
23235379	Belmont Road	57.1589871926	-2.1160510063
23234942	Rosemount Place	57.1518602554	-2.1098800817
23235678	Burnett Place	57.1650149329	-2.115888053
23235785	Barron Street	57.1676158921	-2.1202450227
23235848	Don Street	57.1701006911	-2.1238249965
23235869	Queen Street	57.1711569967	-2.1274997494
23235878	Society Lane	57.1719076183	-2.1313224633
23235894	Anderson Road	57.1722989303	-2.1350282562
23235892	Smithfield Lane	57.1724645487	-2.1396428481
23235924	North Anderson Drive	57.1728011676	-2.1438281676
23235928	Manor Drive	57.1733431966	-2.1489074369
23235937	Manor Drive	57.1736461828	-2.1509428459
23235938	Auchmill Terrace	57.1739098024	-2.155740011
23235968	Cairnfield Place	57.1756442887	-2.162214072
23235982	Newton Terrace	57.1771725663	-2.1681419895
23235978	Howes Road	57.1768587195	-2.1743098183
23236262	Cloverfield Gardens	57.1794944393	-2.1842797707
23236347	Greenburn Road	57.1842309802	-2.1945103263
23236748	Chapel of Stoneywood Road	57.1915789542	-2.2266650803
23236747	Blackfriars Street	57.1497275365	-2.1037420666
23234967	Rosemount Terrace	57.1529725364	-2.1117015639
23234694	Union Terrace Gardens	57.1468971789	-2.1045934874
23234569	Bridge Street	57.1450759201	-2.1018120762
23234742	Wallace Statue	57.1478678791	-2.1039516953
23234842	John Street	57.1503015528	-2.104817977
23236825	Bishopton Farm	57.1968429387	-2.2634681835
23234585	Union Square Bus Station	57.1443708857	-2.0959602693