Active companies in the London postal areas carrying at least one outstanding mortgage or charge registered against them. Around 112,000 companies, with the count of outstanding, part-satisfied and satisfied charges on every row. A company with a registered charge has borrowed against its assets, which makes this the closest thing the public register offers to a credit signal. Charge counts come straight from Companies House; the register does not publish amounts. Limited liability partnerships and limited partnerships do not declare SIC codes to Companies House, so a small share of rows carry a company type but no sector.
| Company Name | Company Number | Company Type | Incorporated | Status | Sic Code | Sic Description | Post Town | Postcode | Size Band | Mort Outstanding | Mort Part Satisfied | Mort Satisfied |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WALLHILL LIMITED | 01761650 | Private Limited Company | 1983-10-14 | Active | 68320 | Management of real estate on a fee or contract basis | LONDON | SW15 2BF | Small | 1 | 0 | 18 |
| BROWNS SEAFOODS LIMITED | 01761349 | Private Limited Company | 1983-10-13 | Active | 46380 | Wholesale of other food, including fish, crustaceans and molluscs | LONDON | NW10 7QY | Small | 1 | 0 | 0 |
| SOHO LIMITED | 01760921 | Private Limited Company | 1983-10-12 | Active | 68310 | Real estate agencies | LONDON | W1T 1UF | Micro | 1 | 0 | 0 |
| THE THIRD AGE TRUST | 01759471 | PRI/LBG/NSC (Private, Limited by guarantee, no share capital, use of 'Limited' exemption) | 1983-10-06 | Active | 85590 | Other education nec | LONDON | SE1 8EN | Group | 1 | 0 | 0 |
| AFENTRA PLC | 01757721 | Public Limited Company | 1983-09-30 | Active | 06100 | Extraction of crude petroleum | LONDON | EC4A 4AD | Group | 1 | 0 | 12 |
| TAMEDALE LIMITED | 01754872 | Private Limited Company | 1983-09-21 | Active | 41100 | Development of building projects | LONDON | EC1M 6AW | Small | 1 | 0 | 0 |
| LOON FUNG LIMITED | 01753513 | Private Limited Company | 1983-09-16 | Active | 46380 | Wholesale of other food, including fish, crustaceans and molluscs | LONDON | N17 0DX | Large | 1 | 0 | 3 |
| BURNING ISSUES LIMITED | 01752279 | Private Limited Company | 1983-09-13 | Active | 41100 | Development of building projects | LONDON | NW3 4QG | Small | 1 | 0 | 9 |
| CALYPSO VOICES LIMITED | 01752364 | Private Limited Company | 1983-09-13 | Active | 82990 | Other business support service activities nec | LONDON | W1D 5JB | Small | 1 | 0 | 0 |
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.
13 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% | WALLHILL LIMITED |
| company_number | Text | 100% | 01761650 |
| company_type | Text | 100% | Private Limited Company |
| incorporated | Date | 100% | 1983-10-14 |
| status | Text | 100% | Active |
| sic_code | Text | 97% | 68320 |
| sic_description | Text | 97% | Management of real estate on a fee or contract basis |
| post_town | Text | 98% | LONDON |
| postcode | Text | 100% | SW15 2BF |
| size_band | Text | 100% | Small |
| mort_outstanding | Number | 100% | 1 |
| mort_part_satisfied | Number | 100% | 0 |
| mort_satisfied | Number | 100% | 18 |
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 112,885 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.
112,885 rows, generated fresh on download.