Bridlington - Scarborough - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:50:00	07:50:00	...	1
...	07:50:41	07:50:41	...	2
...	07:51:35	07:51:35	...	3
...	07:52:27	07:52:27	...	4
...	07:53:18	07:53:18	...	5
...	07:53:46	07:53:46	...	6
...	07:54:28	07:54:28	...	7
...	07:54:50	07:54:50	...	8
...	08:01:00	08:01:00	...	9
...	08:02:24	08:02:24	...	10
...	08:03:00	08:03:00	...	11
...	08:04:20	08:04:20	...	12
...	08:07:00	08:07:00	...	13
...	08:07:27	08:07:27	...	14
...	08:10:00	08:10:00	...	15
...	08:10:58	08:10:58	...	16
...	08:14:34	08:14:34	...	17
...	08:17:15	08:17:15	...	18
...	08:18:17	08:18:17	...	19
...	08:19:01	08:19:01	...	20
...	08:20:00	08:20:00	...	21
...	08:20:53	08:20:53	...	22
...	08:21:18	08:21:18	...	23
...	08:22:15	08:22:15	...	24
...	08:22:59	08:22:59	...	25
...	08:24:19	08:24:19	...	26
...	08:29:18	08:29:18	...	27
...	08:32:00	08:32:00	...	28
...	08:34:44	08:34:44	...	29
...	08:34:53	08:34:53	...	30
...	08:36:00	08:36:00	...	31
...	08:37:15	08:37:15	...	32
...	08:44:00	08:44:00	...	33
...	08:47:00	08:47:00	...	34
...	08:48:02	08:48:02	...	35
...	08:52:28	08:52:28	...	36
...	08:57:00	08:57:00	...	37
...	08:58:13	08:58:13	...	38
...	08:59:06	08:59:06	...	39
...	09:01:03	09:01:03	...	40
...	09:02:24	09:02:24	...	41
...	09:03:04	09:03:04	...	42
...	09:03:37	09:03:37	...	43
...	09:04:31	09:04:31	...	44
...	09:07:50	09:07:50	...	45
...	09:09:00	09:09:00	...	46

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

stop_code	stop_name	stop_lat	stop_lon
22000441	Bridlington Marton Road	54.0959377979	-0.206818551
22000443	Bridlington Marton Road	54.0968929949	-0.2021588441
22000447	Bridlington Marton Road	54.0984228536	-0.191478891
22000476	Bridlington Fortyfoot	54.0961285941	-0.1877555035
22000478	Bridlington Fortyfoot	54.0939404284	-0.1874991751
22000485	Bridlington Flamborough Rd	54.0892738716	-0.1856231193
22000586	Bridlington Scarborough Rd	54.0971495182	-0.210926013
22001608	Bridlington Fortyfoot	54.0921523524	-0.1869501822
22001628	Bridlington Prospect Street	54.0842858221	-0.1928428558
22011683	Huntow Cottages	54.1309577096	-0.2274075584
22001251	Bridlington Bus Station	54.0839213371	-0.1895258413
32000816	St Andrew's Church	54.2743561029	-0.4024725782
32000818	Avenue Victoria	54.2705431641	-0.401652567
32000820	Holbeck Road	54.267138031	-0.3983753813
32000822	Seacliff	54.2653786721	-0.3965242235
32000825	Wheatcroft Avenue	54.2630161108	-0.3925778011
32000856	East Lea View	54.2328866496	-0.3764574608
32000858	Killerby Lane	54.2294596285	-0.3656380386
32000865	Muston Crossing	54.2191268155	-0.3163054334
32000868	Hazel Road	54.2150911249	-0.3009491189
32000871	Grove Road	54.2137034491	-0.2949790481
32000873	The Croft	54.2129786768	-0.291405012
32000874	Bus Station	54.2098411024	-0.2913658316
32000875	Clarence Drive	54.2098992788	-0.2954730932
32000877	Wharfedale	54.2088775807	-0.2969565726
32000879	Grange Avenue	54.2066074782	-0.3004232845
32000880	Secondary School	54.2044798956	-0.3018905443
32000882	Mill Farm	54.2005602913	-0.3050408334
32000901	Primrose Valley Holiday Village	54.1832865106	-0.2924762796
32000906	Watson's Lane	54.1630142481	-0.2714840485
32000908	The Dotterel	54.1553732062	-0.2683107775
32000912	The Gill	54.1667599138	-0.2544773614
32000913	Primrose Valley Lane End	54.1865105459	-0.2948108848
32000915	Nursing Home	54.1872363391	-0.2940147056
32000916	Nursing Home	54.1873171896	-0.2940113766
32000917	Holiday Village	54.1902453201	-0.2818435423
32000918	Blue Dolphin	54.2288787656	-0.3214161694
32000921	Blue Dolphin	54.2306547175	-0.326314972
32000923	Crow's Nest	54.2279523618	-0.3395409908
32000925	Flower Of May	54.2291335865	-0.3424238205
32000930	Cayton Village Caravan Park	54.2353728586	-0.376191087
32000934	Haven Holiday Park	54.2406493691	-0.3668991959
32006568	Valley Bridge Stop W	54.2784681407	-0.4034808456
32006578	University	54.2616270451	-0.3908661836
32096793	The Bay Holiday Vill	54.1783257269	-0.2887426859
32000627	West Square Stop V	54.2799439206	-0.4063268843