Havant - Portsmouth - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:36:00	08:36:00	...	1
...	08:36:00	08:36:00	...	2
...	08:37:00	08:37:00	...	3
...	08:38:00	08:38:00	...	4
...	08:39:00	08:39:00	...	5
...	08:39:00	08:39:00	...	6
...	08:40:00	08:40:00	...	7
...	08:41:00	08:41:00	...	8
...	08:41:00	08:41:00	...	9
...	08:42:00	08:42:00	...	10
...	08:43:00	08:43:00	...	11
...	08:44:00	08:44:00	...	12
...	08:45:00	08:45:00	...	13
...	08:47:00	08:47:00	...	14
...	08:48:00	08:48:00	...	15
...	08:50:00	08:50:00	...	16
...	08:51:00	08:51:00	...	17
...	08:53:00	08:53:00	...	18
...	08:54:00	08:54:00	...	19
...	08:55:00	08:55:00	...	20
...	08:56:00	08:56:00	...	21
...	08:57:00	08:57:00	...	22
...	09:00:00	09:00:00	...	23

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
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