Every active UK company whose main declared activity is public houses and bars. Around 27,000 companies. SIC class 56302. THE CAVEAT THAT MATTERS: tenanted and leased pubs are usually registered to the tenant company rather than the pub company that owns the building, so a large branded estate can appear here as hundreds of unrelated small companies, or not at all. Drinks wholesale, EPOS, gaming machines, insurance and property services sell into this list.
| Company Name | Company Number | Incorporated | Status | Sic Code | Sic Description | Post Town | Postcode | Size Band | Accounts Next Due |
|---|---|---|---|---|---|---|---|---|---|
| OLD OAK TREE LIMITED | 07182223 | 2010-03-09 | Active | 56302 | Public houses and bars | YORK | YO1 7DN | Small | 2026-12-31 |
| RICHMOND RA LTD | 07181859 | 2010-03-09 | Active | 56302 | Public houses and bars | LONDON | SE1 7JS | Small | 2027-12-31 |
| O. HINES LIMITED | 07183023 | 2010-03-09 | Active | 56302 | Public houses and bars | WEST MIDLANDS | DY1 1UA | Unknown | 2026-12-31 |
| VINECHIME LIMITED | 07181569 | 2010-03-08 | Active | 56302 | Public houses and bars | TEWKESBURY | GL20 8FD | Small | 2026-12-31 |
| THE MASONS ARMS (TEDDINGTON) LIMITED | 07179254 | 2010-03-05 | Active | 56302 | Public houses and bars | HAMPTON HILL | TW12 1NL | Small | 2026-12-31 |
| STOCK BAR LIMITED | 07178099 | 2010-03-04 | Active | 56302 | Public houses and bars | CONGLETON | CW12 4TR | Micro | 2027-04-30 |
| THE LITTLE COTSWOLD PUB COMPANY LIMITED | 07177237 | 2010-03-04 | Active | 56302 | Public houses and bars | BOURTON ON THE WATER | GL54 2BY | Small | 2026-12-31 |
| ZEBRAS BAR SALES LTD | 07177581 | 2010-03-04 | Active | 56302 | Public houses and bars | TONBRIDGE | TN10 3ED | Micro | 2026-12-31 |
| MODERATION PUBLIC HOUSE LTD | 07178807 | 2010-03-04 | Active | 56302 | Public houses and bars | ASHFORD | TW15 3QN | Small | 2026-12-31 |
Prepared by DataSteak from Companies House, October 2026 snapshot. Original data published by the source; the cut, cleaning and typing are ours.
Source: Companies House · Office for National Statistics · See Attributions for licensing information.
10 fields, with types, how much of each is filled in, and a real example from the data.
| Column | Type | Populated | Example |
|---|---|---|---|
| company_name | Text | 100% | OLD OAK TREE LIMITED |
| company_number | Text | 100% | 07182223 |
| incorporated | Date | 100% | 2010-03-09 |
| status | Text | 100% | Active |
| sic_code | Text | 100% | 56302 |
| sic_description | Text | 100% | Public houses and bars |
| post_town | Text | 100% | YORK |
| postcode | Text | 100% | YO1 7DN |
| size_band | Text | 100% | Small |
| accounts_next_due | Date | 100% | 2026-12-31 |
Measured from this product's own query rather than the dataset as a whole, so it describes what you would actually be buying.
Companies incorporated in the last 90 days with a registered address in the London postal…
£249.00 · View → IT & TechnologyActive companies in the London postal areas whose primary SIC code sits in division 62 or…
£199.00 · View → MixedCompanies in the London postal areas currently marked as proposed for strike off, meaning…
£249.00 · View →It's generated on demand. When you buy, the query runs against the live data and builds your file right then, so it's current as of your purchase. You download it straight away.
A one-off download of this exact cut, all 27,160 rows and every column shown above, as a CSV file that opens in Excel or Google Sheets. It's a snapshot of the data as it is today. It does not include ongoing updates or API access, neither of which is available yet.
Yes, on request. We can turn on API access for this dataset against your account, and you issue your own key from your dashboard. It returns the same data as the file, over HTTP, in JSON, with the edition date on every response so your systems can tell when there is something new to pull.
It is not a live feed. The data changes when the register is refreshed, roughly monthly, and the API serves whatever the current edition is. Access is arranged per dataset rather than bought from the site, so ask us and we will set it up.
Yes. The preview above is real data, and the 15-row sample download gives you every column so you can check the format and quality first.
Yes. A commercial and internal-business licence is included. Redistribution as-is is restricted; enterprise redistribution rights are available on request.
The price shown includes UK VAT at 20%, so it is the amount you pay with nothing added at the end, and checkout shows the split before you commit. A VAT invoice is raised and emailed automatically when payment goes through, carrying our VAT number and the tax breakdown, so a UK VAT-registered business can reclaim the VAT without asking us for anything. More on pricing and licensing.
27,160 rows, generated fresh on download.