Havant - Portsmouth - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:07:00	07:07:00	...	1
...	07:11:00	07:11:00	...	2
...	07:12:00	07:12:00	...	3
...	07:13:00	07:13:00	...	4
...	07:13:00	07:13:00	...	5
...	07:15:00	07:15:00	...	6
...	07:16:00	07:16:00	...	7
...	07:16:00	07:16:00	...	8
...	07:17:00	07:17:00	...	9
...	07:18:00	07:18:00	...	10
...	07:18:00	07:18:00	...	11
...	07:20:00	07:20:00	...	12
...	07:20:00	07:20:00	...	13
...	07:22:00	07:22:00	...	14
...	07:23:00	07:23:00	...	15
...	07:25:00	07:25:00	...	16
...	07:27:00	07:27:00	...	17
...	07:29:00	07:29:00	...	18
...	07:30:00	07:30:00	...	19
...	07:32:00	07:32:00	...	20
...	07:34:00	07:34:00	...	21
...	07:35:00	07:35:00	...	22
...	07:36:00	07:36:00	...	23
...	07:37:00	07:37:00	...	24
...	07:40:00	07:40:00	...	25

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

stop_code	stop_name	stop_lat	stop_lon
poramgw	Walton Road	50.8362751497	-1.0427026991
poramtd	Robinson Way	50.825202911	-1.0468335132
porapaw	Williams Road	50.8274250105	-1.0546826718
porapda	Sywell Crescent	50.8278710248	-1.0520185113
porapdm	Morrisons	50.8268027074	-1.047823227
porapdt	Norway Road	50.8292150947	-1.0614336928
porapga	Green Farm Gardens	50.8295697555	-1.0664105002
porapmj	Hilsea Park	50.8272743598	-1.0661297066
porapmp	Amberley Road	50.8257052134	-1.0655788851
porapta	Green Lane	50.8228684029	-1.0650676083
poraptd	College Park	50.8204483745	-1.064945566
poraptj	Copythorn Road	50.8163984135	-1.0645437846
poraptp	Chichester Road	50.8137904744	-1.0645390902
porapwd	Copnor Bridge	50.8090894895	-1.0636962227
porapwg	Hayling Avenue	50.806306954	-1.0632267191
porawjg	St Marys Church	50.8026051895	-1.0771795353
porawjp	Adames Road	50.8031923863	-1.0718462753
porawjw	Milton Road	50.8024207629	-1.0641842485
pordgjt	Clifton Street	50.7998577275	-1.0788655069
pordgjw	Canberra House	50.7996616398	-1.0859502279
pordgmd	Station Street	50.7988116421	-1.0899541539
pordgpa	City Shops South	50.8000477399	-1.091632978
pordgta	HMS Nelson	50.799856795	-1.0971566527
pordgtg	Curzon Howe Road	50.7997157174	-1.1021826718
porgatd	The Hard Interchange	50.7980064355	-1.1067844648