Knighton - Ludlow - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:45:00	07:45:00	...	1
...	07:52:00	07:52:00	...	2
...	07:53:00	07:53:00	...	3
...	07:54:00	07:54:00	...	4
...	07:55:00	07:55:00	...	5
...	07:57:00	07:57:00	...	6
...	07:58:00	07:58:00	...	7
...	07:59:00	07:59:00	...	8
...	08:00:00	08:00:00	...	9
...	08:01:00	08:01:00	...	10
...	08:03:00	08:03:00	...	11
...	08:05:00	08:05:00	...	12
...	08:07:00	08:07:00	...	13
...	08:09:00	08:09:00	...	14
...	08:12:00	08:12:00	...	15
...	08:15:00	08:15:00	...	16
...	08:24:00	08:24:00	...	17
...	08:29:00	08:29:00	...	18
...	08:30:00	08:30:00	...	19
...	08:33:00	08:33:00	...	20
...	08:35:00	08:35:00	...	21
...	08:36:00	08:36:00	...	22
...	08:37:00	08:37:00	...	23
...	08:38:00	08:38:00	...	24
...	08:40:00	08:40:00	...	25

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

stop_code	stop_name	stop_lat	stop_lon
heragdad	Lion Hotel	52.3595780557	-2.8755882537
heragdag	The Criftins	52.364458098	-2.8770358798
shradpwa	Crossroads	52.3788267873	-2.812622211
shragawm	Assembly Rooms	52.3671056911	-2.7208344065
shragdjg	Chase View Estate	52.3881585434	-2.7710630083
shramdjp	The Lodge	52.4026055409	-2.8853034557
shramawg	Rocke Cottage	52.4014564777	-2.8946286251
shramtga	Bridge	52.3730832922	-2.7209905129
shramtgj	Council Offices	52.3713232989	-2.7191698798
shramtgp	Compasses Inn	52.3691372054	-2.7179299872
shramtjg	Church	52.4025447111	-2.891005353
shramtjp	Green	52.3916176473	-2.9103738315
shramtjw	College	52.3740614651	-2.9263031346
shramtmd	Ladywell Jct	52.3610746034	-2.9439324929
shramtmj	Garage	52.3592843501	-2.9452012479
shramtmp	Railway Station	52.357381863	-2.9470108041
shramtmt	Railway Station	52.3573083039	-2.9472148043
shratmdp	Clive Restaurant	52.3883018075	-2.7642328397
shrawmjg	Chestnut Meadow	52.3607603597	-2.9506074423
shrawmjm	The Tyndings	52.3612145417	-2.9622477928
shrdajad	Racecourse	52.3887232941	-2.7432570425
shrdajaj	School	52.3781016827	-2.7265665155
shrdgpwa	Rail Crossing	52.3574580542	-2.9475997872
shrdgpwd	Rail Crossing	52.3575027633	-2.9476301116
powdmpw	Bus Station	52.3435194125	-3.0460198338