Derby - Allenton - Derby - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:00:00	18:00:00	...	1
...	18:04:00	18:04:00	...	2
...	18:05:00	18:05:00	...	3
...	18:06:00	18:06:00	...	4
...	18:07:00	18:07:00	...	5
...	18:08:00	18:08:00	...	6
...	18:08:00	18:08:00	...	7
...	18:08:00	18:08:00	...	8
...	18:10:00	18:10:00	...	9
...	18:12:00	18:12:00	...	10
...	18:13:00	18:13:00	...	11
...	18:14:00	18:14:00	...	12
...	18:15:00	18:15:00	...	13
...	18:16:00	18:16:00	...	14
...	18:17:00	18:17:00	...	15
...	18:18:00	18:18:00	...	16
...	18:19:00	18:19:00	...	17
...	18:20:00	18:20:00	...	18
...	18:21:00	18:21:00	...	19
...	18:22:00	18:22:00	...	20
...	18:23:00	18:23:00	...	21
...	18:24:00	18:24:00	...	22
...	18:26:00	18:26:00	...	23
...	18:27:00	18:27:00	...	24
...	18:29:00	18:29:00	...	25
...	18:30:00	18:30:00	...	26
...	18:31:00	18:31:00	...	27
...	18:34:00	18:34:00	...	28
...	18:35:00	18:35:00	...	29
...	18:37:00	18:37:00	...	30
...	18:38:00	18:38:00	...	31
...	18:39:00	18:39:00	...	32
...	18:42:00	18:42:00	...	33
...	18:44:00	18:44:00	...	34
...	18:45:00	18:45:00	...	35
...	18:48:00	18:48:00	...	36

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
dbyamgwa	Cavendish	52.9029776744	-1.4845296514
dbyamgwg	Crewe Street	52.9047977188	-1.4834227064
dbyamgwm	Sikh Temple	52.9069745884	-1.4816869349
dbyamwma	Stanhope Street	52.9074589737	-1.4793913643
dbyagtmp	Lower Dale Road	52.9095948202	-1.4785628165
dbyagtpj	Dashwood Street	52.9128409705	-1.4767393763
dbyagtpt	Charnwood Street	52.9149028999	-1.4775027178
dbyamwad	Roundhouse Road	52.9169942434	-1.458709027
dbyamwaj	Pride Parkway Egg	52.9155070985	-1.4558870941
dbyadapd	Alvaston Park	52.9034725981	-1.4428057821
dbyadapg	Meadow Lane	52.9021582611	-1.4385855426
dbyamjtg	Pride Park Park-and-Ride	52.9127107618	-1.4479514815
dbyamwga	Rawlinson Avenue	52.8979153857	-1.4801151725
dbyamwgp	Showcase Cinemas	52.8974982487	-1.4751997238
dbyamwgw	Osmaston Park Sainsbury's	52.8958052745	-1.472499907
dbyamwjd	Arkwright Street	52.8959242942	-1.4669390128
dbyadtdm	Varley Street	52.8914347363	-1.4542116196
dbyadpwj	Amber Street	52.8954672461	-1.463258176
dbyadpwp	Tower Street	52.8937046617	-1.4591477245
dbyamptj	The Mitre	52.8916940707	-1.450016884
dbyamptp	Ashby Street	52.8919099058	-1.446164512
dbyampwa	Coleman Street	52.8922886015	-1.4425626932
dbyampwd	Matthew Street	52.8928844644	-1.4392850121
dbyadgwg	Wyndham Street	52.8939029426	-1.4341585999
dbyadjat	Barrett Street	52.8950587441	-1.4295949957
dbyadapm	Wye Street	52.8976904789	-1.4310172723
dbyadapj	Spencer Street	52.9001112106	-1.4353265371
dbyampap	Mercedes Benz	52.9129725879	-1.4520822053
dbyampdp	Harrow Street	52.9075160155	-1.4481959162
dbyapgam	Orient Way	52.9117233335	-1.4501945693
dbyapgap	Victoria Way	52.9116794564	-1.4484850464
dbyapgaw	Royal Scot Way	52.9102887307	-1.4490528839
dbyapgdm	Leopold Street	52.9164165	-1.4782727177
dbyptmga	Bus Station	52.9220947638	-1.4714815424
dbyadapt	Blue Peter	52.896290921	-1.427854486
dbyagpjt	Babington Lane	52.9195535951	-1.4761825677