Yardley - Solihull via Olton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:50:00	16:50:00	...	1
...	16:50:00	16:50:00	...	2
...	16:51:00	16:51:00	...	3
...	16:52:00	16:52:00	...	4
...	16:53:00	16:53:00	...	5
...	16:53:00	16:53:00	...	6
...	16:54:00	16:54:00	...	7
...	16:54:00	16:54:00	...	8
...	16:56:00	16:56:00	...	9
...	16:56:00	16:56:00	...	10
...	16:58:00	16:58:00	...	11
...	16:58:00	16:58:00	...	12
...	16:58:00	16:58:00	...	13
...	16:59:00	16:59:00	...	14
...	17:00:00	17:00:00	...	15
...	17:00:00	17:00:00	...	16
...	17:00:00	17:00:00	...	17
...	17:02:00	17:02:00	...	18
...	17:03:00	17:03:00	...	19
...	17:04:00	17:04:00	...	20
...	17:05:00	17:05:00	...	21
...	17:07:00	17:07:00	...	22
...	17:08:00	17:08:00	...	23
...	17:10:00	17:10:00	...	24
...	17:11:00	17:11:00	...	25
...	17:12:00	17:12:00	...	26
...	17:13:00	17:13:00	...	27
...	17:14:00	17:14:00	...	28
...	17:15:00	17:15:00	...	29
...	17:17:00	17:17:00	...	30

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

stop_code	stop_name	stop_lat	stop_lon
nwmgdjwm	Olton Station	52.4383507201	-1.8049867521
nwmgdmag	Chelmscote Rd	52.4368193774	-1.7978151576
nwmadtaw	Station Rd	52.4139890468	-1.7801151622
nwmadtga	Solihull Hospital	52.4165908945	-1.7772939641
nwmadtja	Grove Rd	52.4199777328	-1.776012366
nwmadtjg	Lode Heath School	52.4244385939	-1.7769603553
nwmadtjt	Rowood Drive	52.4267031795	-1.7764783358
nwmadtma	Henley Crescent	52.4310077055	-1.78036886
nwmadtmt	Dovehouse Lane	52.4341197853	-1.7811918112
nwmadtpa	Old Lode Lane	52.4390236389	-1.7835212239
nwmwatwg	Highwood Ave	52.4402913495	-1.7885608517
nwmgdmtd	Dene Court Rd	52.4382647217	-1.7966170241
nwmgdmtw	Fernhill Rd	52.4444121154	-1.8008553054
nwmgdmwd	Barrington Rd	52.4412343606	-1.8036794526
nwmadwdt	The Lyndon	52.4481120198	-1.7984991975
nwmtpwmd	Bosworth Rd	52.4497340391	-1.8061725269
nwmgmtjw	The Vineries	52.449573901	-1.807203207
nwmtpwag	The Journeys End	52.4532459173	-1.8097329227
nwmdapap	Swan Island	52.4619715973	-1.8131099608
nwmdapga	Clay Lane	52.4618770175	-1.8101667463
nwmdapgd	Sunnymead Rd	52.4607598705	-1.8031953543
nwmpwjdt	Pierce Avenue	52.4453011301	-1.8002627998
nwmpwjtm	Shalford Rd	52.4493773296	-1.8024809
nwmtagdg	Gotham Rd	52.4584008192	-1.8009983211
nwmpwjtp	Wichnor Rd	52.4572436787	-1.8025340498
nwmtgmwt	Measham Grove	52.4552274509	-1.806486906
nwmtgpad	Aldershaw Rd	52.4554741687	-1.8089433877
nwmtgmwd	Cambridge Way	52.4508557463	-1.8104642139
nwmtgmwj	Chapelfields Junior School	52.4465403764	-1.7994479892
nwmtwmtp	Gilbertstone Ave	52.4558796519	-1.8040117506