Every active UK company whose primary SIC code sits in retail trade, around 388,500 companies. Shops, online retailers, market stalls and specialist retailers, with the SIC description alongside the code so food retail can be separated from clothing, electricals or pharmacy without a lookup. Deliberately sold apart from wholesale and the motor trade, which are separate divisions and separate businesses, so you are not paying for 270,000 rows you will filter out.
| Company Name | Company Number | Incorporated | Status | Sic Code | Sic Description | Post Town | Postcode | Size Band |
|---|---|---|---|---|---|---|---|---|
| TERESA-DELI LTD | 07621734 | 2011-05-04 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | DAVENTRY | NN11 4LX | Small |
| KRISHNA CONVENIENCE STORE LIMITED | 07619765 | 2011-05-03 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | OLDHAM | OL9 8HR | Small |
| ZAGGIM LIMITED | 07617668 | 2011-04-28 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | HOVE | BN3 2WB | Micro |
| AMAN SUPERSTORES LTD | 07615476 | 2011-04-27 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | SLOUGH | SL1 1EL | Small |
| ABI EXNING STORES LIMITED | 07615324 | 2011-04-27 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | NEWMARKET | CB8 7EW | Micro |
| ARS TRADERS LTD | 07616161 | 2011-04-27 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | WINCHESTER | SO23 7PJ | Small |
| M & S SUPERMARKET (GLOS) LIMITED | 07614341 | 2011-04-26 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | BIRMINGHAM | B1 1SB | Small |
| HEBDEN TEA COMPANY LTD | 07611475 | 2011-04-21 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | YORK | YO1 7LZ | Micro |
| RIHA NEWS LTD | 07611062 | 2011-04-20 | Active | 47110 | Retail sale in non-specialised stores with food, beverages or tobacco predominating | CATERHAM | CR3 5PX | Micro |
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.
9 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% | TERESA-DELI LTD |
| company_number | Text | 100% | 07621734 |
| incorporated | Date | 100% | 2011-05-04 |
| status | Text | 100% | Active |
| sic_code | Text | 100% | 47110 |
| sic_description | Text | 100% | Retail sale in non-specialised stores with food, beverages or tobacco predominating |
| post_town | Text | 100% | DAVENTRY |
| postcode | Text | 100% | NN11 4LX |
| size_band | Text | 100% | Small |
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 384,768 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.
384,768 rows, generated fresh on download.