The UK filling station list, cleaned

Brands

The feed carries 1,522 different brand strings. 627 of them are spellings, capitalisations or local names of a major brand (“Texaco East Sheen”, “Sainsbury's Local”) and are mapped to one of the 34 brands we recognise, 29 of which have stations today. A forecourt under a fuel brand and a dealer group is filed under the brand a driver sees. The 917 stations left without a major brand are independents, not errors. The raw string is kept in brand_raw.

Names and addresses

Names and address lines are recapitalised (“MILTON KEYNES” becomes “Milton Keynes”), nothing more. They are not checked against any address register.

Postcodes

Postcodes are reformatted with their space, whether or not the retailer typed it, then split into 2,421 districts (BA1) and 122 areas (BA). The split relies on the inward code always being a digit and two letters, so a postcode typed without a space still lands in the right district.

Nation

The feed's country field mixes ENGLAND, England, UK, E and blanks, so the nation comes from the postcode wherever the postcode settles it: BT for Northern Ireland, AB, DD, DG, EH, FK, G, HS, IV, KA, KW, KY, ML, PA, PH, TD, ZE for Scotland, CF, LD, LL, NP, SA for Wales. Border areas such as CH, SY and HR straddle England and Wales; there the declared field is used, and a station with no usable field is counted in England.

Positions

A position is corrected only when the corrected point falls inside the UK and the reported one does not: latitude and longitude swapped, or the minus sign of the longitude lost. Each correction is flagged in coordinates_fix. Today no station needs it. No station is left outside the UK. Nothing else is moved: a forecourt placed at the wrong end of its street stays there.

Fuels

Each station declares the grades it sells, separately from the prices it reports. 8,145 stations declare at least one:

• Diesel (B7_STANDARD): 8,047 stations
• Unleaded (E10): 7,928 stations
• Super unleaded (E5): 6,274 stations
• Premium diesel (B7_PREMIUM): 4,173 stations
• B10 diesel (B10): 63 stations
• HVO (HVO): 56 stations

A grade that is not declared proves nothing: retailers fill the list unevenly.

Opening hours

Hours are converted to the OpenStreetMap opening_hours syntax (“Mo-Fr 06:00-22:00; Sa-Su 07:00-22:00”, or “24/7”) for 7,688 stations, 3,228 of them open around the clock. The rest (458) leave at least one day as 00:00 to 00:00 without ticking “24 hours”, which means the field was never filled in, not that the station is shut. Rather than publish half a week, the column is left blank for them.

Arrivals and departures

A station arrives on the first day it reports a price and leaves after 7 days without one. Since 7 Sep 2026: 95 arrivals, 12 stations no longer reporting and 19 returns after a gap, which is why a departure is never called a closure unless the feed says so. They are listed in stations-changes.csv and on the new stations and no longer reporting pages.