UK commercial property landlords, ranked by distress

Ordered by · rank, org_id

1. org_id Added by the build Our resolved organisation identifier. Stable across editions and the join key for every file in this pack.
2. rank Derived Position by distress_score within this edition. Ties broken by title_count then company_number so a rebuild is byte-identical. Not comparable across editions.
3. distress_score Derived 0-100. Weighted sum of the four components below, each scaled to 0-1. A landlord filing nothing we can read scores on its filing conduct and its insolvency notices alone, and 3,301 of the 13,269 are in that position — read has_financials before reading the score.
4. distress_drivers Derived Which components actually contributed, pipe-joined, each with the value behind it. The score's reasons, so it can be defended rather than quoted.
5. distress_signals Derived How many of the four components fired on this row. 0 means nothing in the open register or the insolvency feed says this landlord is in difficulty.
6. meets_headline_screen Derived True where the landlord carries a registered charge AND at least one of the four distress facts — balance-sheet insolvency, a current ratio below 1, overdue accounts, or a matched insolvency notice. 4,686 of 13,269. Deliberately a test on facts rather than on distress_signals, which counts only components whose scaled value is above zero and so drops a notice older than five years.
7. company_number Publisher record The UK company number. Eight characters, zero-padded, sometimes with a jurisdiction prefix (SC, NI, OC, SO). The strongest organisational identifier we hold.
8. legal_name Publisher record Registered name of the company at the time of the snapshot.
9. company_status Publisher record Register status, e.g. Active, Dissolved, Liquidation, In Administration.
10. title_count Derived Distinct title numbers held. Compare against the ten in the column above before assuming it is the whole portfolio.
11. largest_postcode_area Derived The postcode area holding most of this portfolio's titles.
12. titles_in_largest_area Derived Titles held in largest_postcode_area.
13. mortgages_outstanding Publisher record Number of outstanding mortgage charges. A secured-lending signal.
14. has_outstanding_charge Derived True where the register shows at least one outstanding charge. The existence of a charge only — no amount, no date, no chargeholder is published anywhere.
15. charges_per_title Derived mortgages_outstanding divided by title_count. A leverage proxy, and deliberately not a score component.
16. balance_sheet_insolvent Derived True where filed net assets are negative. An arithmetic test on filed accounts, never a determination by a court or an office holder.
17. net_assets Derived Net assets as filed, GBP.
18. current_ratio Derived current_assets divided by creditors_within_one_year, as computed on the resolved spine. Below 1 means the filed balance sheet cannot meet short-term liabilities from short-term assets.
19. working_capital Derived current_assets minus creditors_within_one_year, GBP.
20. has_financials Derived True where we hold a filed financial position. 9,968 of 13,269.
21. financials_period_end Derived Balance-sheet date of the latest filed accounts the score was computed from. A stale date is itself a signal and is published rather than hidden.
22. accounts_overdue_days Derived Days between accounts_next_due_date and register_as_of, where overdue.
23. overdue_filings Derived How many of the two statutory filings are past due at the register snapshot. 0, 1 or 2.
24. gazette_notice_count Derived Corporate insolvency notices matched to this landlord by normalised name. 0 means no notice matched, never that no notice exists.
25. latest_gazette_notice_date Derived published_at of the most recent matched notice.
26. latest_gazette_notice_type Derived notice_type of the most recent matched notice.
27. gazette_name_is_unique Derived False where the normalised name is shared with another company in the open spine, so the notice may belong to the other. 72 of 13,269.
28. register_as_of Derived The register snapshot this edition was cut from, derived from the register's own overdue flags rather than the clock.
29. gazette_as_of Derived The most recent notice date in the whole insolvency-notice feed, 2026-08-21, which is what notice recency is measured against.
30. registered_office_region Derived Statistical region of the registered office. Where the landlord is administered, not where the portfolio is.
31. release_id Added by the build The release this row was published in. Quote it in any support question and we can name the exact build it came from.

Ordered by · org_id

1. org_id Added by the build Our resolved organisation identifier. Stable across editions and the join key for every file in this pack.
2. company_number Publisher record The UK company number. Eight characters, zero-padded, sometimes with a jurisdiction prefix (SC, NI, OC, SO). The strongest organisational identifier we hold.
3. legal_name Publisher record Registered name of the company at the time of the snapshot.
4. company_status Publisher record Register status, e.g. Active, Dissolved, Liquidation, In Administration.
5. is_active Derived True where the register shows the company active. 13,101 of the 13,269 landlords are; 168 are not and are kept, because a dissolved landlord's titles are exactly what a broker is looking for.
6. incorporation_date Publisher record Date the company was incorporated.
7. age_years Derived Whole years from incorporation to the register snapshot.
8. sic_code_1 Publisher record Primary SIC 2007 code, extracted from the publisher's combined code-and-text field.
9. sic_description_1 Publisher record Primary SIC description.
10. sic_section Derived Single-letter SIC 2007 section derived from sic_code_1. 8,562 of 13,269 landlords are section L, real estate; 358 file no SIC code at all.
11. size_band Derived Our size banding — dormant, micro, small, medium, large — inferred from filed employees, turnover and balance-sheet totals, not declared by the company.
12. title_count Derived Distinct title numbers held. Compare against the ten in the column above before assuming it is the whole portfolio.
13. proprietorship_rows Derived Rows of property_title behind those titles. Exceeds titles where the landlord holds more than one proprietor position on the same title.
14. postcodes_held Derived Distinct property postcodes across the portfolio. A measure of how spread the holding is, not of how many buildings it is.
15. titles_without_postcode Derived Proprietorships in this landlord's portfolio that carry no postcode and are therefore in none of its rows here.
16. postcode_areas_held Derived Distinct postcode areas — the leading letters of the postcode, e.g. M for Manchester — across the portfolio.
17. largest_postcode_area Derived The postcode area holding most of this portfolio's titles.
18. titles_in_largest_area Derived Titles held in largest_postcode_area.
19. portfolio_concentration Derived titles_in_largest_area divided by the titles that carry a postcode. 1.0 is a portfolio in one postcode area; low values are a national holding.
20. mortgages_outstanding Publisher record Number of outstanding mortgage charges. A secured-lending signal.
21. has_outstanding_charge Derived True where the register shows at least one outstanding charge. The existence of a charge only — no amount, no date, no chargeholder is published anywhere.
22. charges_per_title Derived mortgages_outstanding divided by title_count. A leverage proxy, and deliberately not a score component.
23. accounts_overdue Derived True where the register shows the annual accounts past their due date. 398 of 13,269.
24. accounts_overdue_days Derived Days between accounts_next_due_date and register_as_of, where overdue.
25. accounts_next_due_date Publisher record Date the next set of accounts is due. Overdue filings are a risk signal.
26. confirmation_overdue Derived True where the confirmation statement is past its due date. 1,025 of 13,269.
27. overdue_filings Derived How many of the two statutory filings are past due at the register snapshot. 0, 1 or 2.
28. register_as_of Derived The register snapshot this edition was cut from, derived from the register's own overdue flags rather than the clock.
29. financials_period_end Derived Balance-sheet date of the latest filed accounts the score was computed from. A stale date is itself a signal and is published rather than hidden.
30. net_assets Derived Net assets as filed, GBP.
31. current_assets Derived Current assets as filed, GBP.
32. creditors_within_one_year Derived Creditors falling due within one year as filed, GBP.
33. current_ratio Derived current_assets divided by creditors_within_one_year, as computed on the resolved spine. Below 1 means the filed balance sheet cannot meet short-term liabilities from short-term assets.
34. working_capital Derived current_assets minus creditors_within_one_year, GBP.
35. balance_sheet_insolvent Derived True where filed net assets are negative. An arithmetic test on filed accounts, never a determination by a court or an office holder.
36. average_employees Derived Average employees during the latest filed period. Most property holding companies file none.
37. has_financials Derived True where we hold a filed financial position. 9,968 of 13,269.
38. gazette_notice_count Derived Corporate insolvency notices matched to this landlord by normalised name. 0 means no notice matched, never that no notice exists.
39. latest_gazette_notice_date Derived published_at of the most recent matched notice.
40. latest_gazette_notice_type Derived notice_type of the most recent matched notice.
41. gazette_name_is_unique Derived False where the normalised name is shared with another company in the open spine, so the notice may belong to the other. 72 of 13,269.
42. registered_office_postcode Publisher record Postcode of the registered office. The main join key into Location until a UPRN is resolved.
43. registered_office_region Derived Statistical region of the registered office. Where the landlord is administered, not where the portfolio is.
44. registered_office_town Derived Post town of the registered office, resolved from its postcode.
45. grid_address_id Derived Our resolved address identifier for the registered office. Two landlords sharing one are administered from the same place.
46. companies_at_address Derived How many companies are registered at this landlord's registered office, over the full UK register. A high count is a formation agent or a virtual office, not a finding.
47. release_id Added by the build The release this row was published in. Quote it in any support question and we can name the exact build it came from.

Ordered by · org_id, postcode_area

1. org_id Added by the build Our resolved organisation identifier. Stable across editions and the join key for every file in this pack.
2. postcode_area Derived The leading letters of the property's outward postcode code, e.g. M for Manchester. Derived from the postcode string; no lookup table is published upstream.
3. titles Derived Distinct registered title numbers this landlord holds in this postcode area.
4. proprietorship_rows Derived Rows of property_title behind those titles. Exceeds titles where the landlord holds more than one proprietor position on the same title.
5. postcodes Derived Distinct full postcodes held in this area.
6. share_of_portfolio Derived titles divided by the landlord's titles that carry a postcode at all. Sums to 1.0 across a landlord's rows, and deliberately does not use title_count as the denominator — the titles with no postcode are not in this file and would make every share look smaller than it is.
7. area_rank Derived 1 for the postcode area holding most of this landlord's titles, counting down. Ties broken alphabetically so a rebuild is identical.
8. title_count Derived Distinct title numbers held. Compare against the ten in the column above before assuming it is the whole portfolio.
9. titles_without_postcode Derived Proprietorships in this landlord's portfolio that carry no postcode and are therefore in none of its rows here.
10. legal_name Publisher record Registered name of the company at the time of the snapshot.
11. release_id Added by the build The release this row was published in. Quote it in any support question and we can name the exact build it came from.

Ordered by · org_id

1. org_id Added by the build Our resolved organisation identifier. Stable across editions and the join key for every file in this pack.
2. company_number Publisher record The UK company number. Eight characters, zero-padded, sometimes with a jurisdiction prefix (SC, NI, OC, SO). The strongest organisational identifier we hold.
3. legal_name Publisher record Registered name of the company at the time of the snapshot.
4. name_normalised Derived Upper-cased, non-alphanumerics replaced by spaces, runs of spaces collapsed. The exact expression 05_EVENTS/gazette_notices.csv matches on, so that join can be reproduced or challenged.
5. companies_house_number Derived UK company number as the resolved spine holds it, accepting both spellings of the scheme.
6. other_company_numbers Derived Any further UK company numbers the same resolved organisation carries, pipe-joined. Non-null only where entity resolution merged more than one registration.
7. lei Derived Legal Entity Identifier, where we hold one. Held for 1,120 of the 13,269 landlords.
8. charity_number Derived Charity register number, where the landlord is also a registered charity. Held for 322 of 13,269 — housing associations and almshouse trusts.
9. identifier_count Derived How many identifiers of any scheme we hold against this organisation. A one means the company number is the only way in.
10. hm_land_registry_title_numbers Derived Up to the first ten registered title numbers held, pipe-joined and ordered. The complete list is 05_EVENTS/titles.csv.
11. title_count Derived Distinct title numbers held. Compare against the ten in the column above before assuming it is the whole portfolio.
12. largest_postcode_area Derived The postcode area holding most of this portfolio's titles.
13. registered_office_postcode Publisher record Postcode of the registered office. The main join key into Location until a UPRN is resolved.
14. grid_address_id Derived Our resolved address identifier for the registered office. Two landlords sharing one are administered from the same place.
15. registered_office_town Derived Post town of the registered office, resolved from its postcode.
16. registered_office_region Derived Statistical region of the registered office. Where the landlord is administered, not where the portfolio is.
17. country Derived Country of the registered office, resolved through a postcode directory rather than from the register's own address line.
18. release_id Added by the build The release this row was published in. Quote it in any support question and we can name the exact build it came from.