Basingstoke - Hatch Warren - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	19:56:00	19:56:00	...	1
...	19:56:00	19:56:00	...	2
...	19:56:00	19:56:00	...	3
...	19:56:00	19:56:00	...	4
...	19:57:00	19:57:00	...	5
...	19:57:00	19:57:00	...	6
...	19:57:00	19:57:00	...	7
...	19:58:00	19:58:00	...	8
...	19:59:00	19:59:00	...	9
...	20:00:00	20:00:00	...	10
...	20:00:00	20:00:00	...	11
...	20:01:00	20:01:00	...	12
...	20:02:00	20:02:00	...	13
...	20:02:00	20:02:00	...	14
...	20:02:00	20:02:00	...	15
...	20:03:00	20:03:00	...	16
...	20:03:00	20:03:00	...	17
...	20:04:00	20:04:00	...	18
...	20:07:00	20:07:00	...	19
...	20:07:00	20:07:00	...	20
...	20:08:00	20:08:00	...	21
...	20:09:00	20:09:00	...	22
...	20:09:00	20:09:00	...	23
...	20:10:00	20:10:00	...	24
...	20:11:00	20:11:00	...	25
...	20:12:00	20:12:00	...	26
...	20:13:00	20:13:00	...	27
...	20:13:00	20:13:00	...	28
...	20:14:00	20:14:00	...	29
...	20:14:00	20:14:00	...	30
...	20:16:00	20:16:00	...	31
...	20:17:00	20:17:00	...	32
...	20:17:00	20:17:00	...	33
...	20:20:00	20:20:00	...	34
...	20:21:00	20:21:00	...	35
...	20:22:00	20:22:00	...	36
...	20:25:00	20:25:00	...	37

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
hamdwdpt	Sainsburys	51.2347206407	-1.139937965
hamdwgmg	Lavender Road	51.2411510855	-1.1364229403
hamdwdpj	Aster Road	51.2401698356	-1.1399366566
hamdwdpd	Fuzzy Drove	51.2433726819	-1.1401634645
hamdwdta	Buckingham Parade	51.2463813527	-1.1396632368
hamdwdwa	Kestrel Road South	51.2491114089	-1.1391824698
hamdwdwt	Fiveways	51.25182348	-1.1387019799
hamdwgjg	Fiveways	51.2534481019	-1.1370810797
hamdwpaj	Edgehill Close	51.2604865511	-1.1270605906
hamdwjpw	Cambrian Way	51.2556958745	-1.1321811342
hamdwtdt	Greenway	51.2636843387	-1.121797328
hamgatpw	Railway Station	51.2678809655	-1.0873448143
hamgawgw	Bus Station	51.2658951217	-1.0852198191
hamjdgtp	Heritage Park	51.2305904216	-1.129817516
hamjdgtw	Wedderburn Avenue	51.2285845944	-1.1321611139
hamjdgwa	Aurora Drive	51.2261295991	-1.1357874838
hamjdgwd	Broadmere Road	51.2296876244	-1.1427386095
hamjdgwg	Rycroft Meadow	51.2269270781	-1.1415153067
hamjdgwj	Blunt Road	51.2260528983	-1.1424767394
hamjdgwm	Play Park	51.2250394455	-1.1428392591
hamdwgpa	Priestdown	51.2282497508	-1.1355186408
hamjgpwt	Whitestones	51.2348089286	-1.1239512521
hamjgtad	Inglewood Drive	51.2356947271	-1.1269710833
hamjgtag	St Mark's Primary School	51.2352335255	-1.1302456067
hamjgtdp	Centurion Way	51.2360771166	-1.1312323801
hamjmamg	Shortwood Copse Lane	51.2308836406	-1.1439767557
hamjmpjd	Sinclair Drive	51.2665119896	-1.0975056543
hamjmtag	Magnus Drive	51.2396915382	-1.1311786424
hamjmtaj	Cropmark Way	51.2383703109	-1.1312608221
hamjmtam	Northgate Way	51.23482035	-1.1376013703
hamjmtdw	Hepplewhite Drive	51.2377417628	-1.1350256624
hamjtgtd	Belmont Heights	51.231599422	-1.1252439209
hamjtgtj	Britannia Drive	51.2247104907	-1.1408977941
hamjtgwd	Alderney Avenue	51.237395474	-1.1307635013
hamjtgwg	The Cornfields	51.2365416915	-1.1235888985
hamjtgwj	Highdowns	51.2337380383	-1.1226395247
hamjtjmt	Victory Roundabout	51.2672728306	-1.09124128