⛽ London Gas Stations: Ratings & Info

🔥 Power Up: Insights into London's Gas

@kaggle.kanchana1990_london_gas_stations_ratings_and_info

Table List

1 table(15.72 KB)

Gas Stations London

@kaggle.kanchana1990_london_gas_stations_ratings_and_info.gas_stations_london

15.72 KB
117 rows
8 columns

title Title	address Address	website Website	phone Phone	totalscore TotalScore	rank Rank	reviewscount ReviewsCount	categoryname CategoryName
Texaco	190-214 Plumstead High St, London SE18 1JH, United Kingdom	https://texaco.co.uk/	nan	4.1	107	191	Gas station
Esso	77-83 Park Ln, London W1K 7HB, United Kingdom	https://www.esso.co.uk/en-gb/find-station/ESSO-LONDON-ESSOMFGPARKLANE-100347239?utm_source=google&utm_medium=organic&utm_campaign=gmb	+44 20 7493 7908	3.7	2	239	Gas station
Shell	Grosvenor Rd, Pimlico, London SW1V 3JY, United Kingdom	https://find.shell.com/gb/fuel/11589596-embankment/en_GB	+44 20 7828 1295	2.8	1	51	Gas station
Shell	139-149 Whitechapel Rd, London E1 1DT, United Kingdom	https://find.shell.com/gb/fuel/10018923-shell-whitechapel/en_GB	+44 20 7377 8525	3.3	20	62	Gas station
Shell	109-113 York Wy, London N7 9QE, United Kingdom	https://find.shell.com/gb/fuel/12038454-shell-camden-town/en_GB	+44 20 7424 9746	3.8	19	137	Gas station
Esso	383-393, Edgware Rd, London W2 1BT, United Kingdom	https://www.esso.co.uk/en-gb/find-station/ESSO-LONDON-ESSOMFGTHEVALE-100343244?utm_source=google&utm_medium=organic&utm_campaign=gmb	+44 20 7724 8386	3.6	17	261	Gas station
TotalEnergies Filling Station	1270 London Rd, Norbury, London SW16 4DH, United Kingdom	http://www.totalenergies.com/	+44 20 8679 6233	3.6	18	67	Gas station
TotalEnergies Service Station	197-205 Leytonstone Rd, London E15 1LN, United Kingdom	https://totalenergies.com/customers/consumers/service-stations	+44 20 8503 1083	4	16	135	Gas station
Shell	237-239 Roehampton Ln, London SW15 4JZ, United Kingdom	https://find.shell.com/gb/fuel/10018869-shell-little-waitrose-roehampton/en_GB	+44 20 8785 2056	3.5	15	57	Gas station
Texaco	127-139 Bow Rd, Bow, London E3 2GG, United Kingdom	http://texaco.co.uk/	+44 20 8981 4314	3.9	14	187	Gas station


CREATE TABLE gas_stations_london (
  "title" VARCHAR,
  "address" VARCHAR,
  "website" VARCHAR,
  "phone" VARCHAR,
  "totalscore" DOUBLE,
  "rank" BIGINT,
  "reviewscount" BIGINT,
  "categoryname" VARCHAR
);