UK corporate landlords carrying both a charge and a distress signal

Ordered by · rank, org_id, rank

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 in property_title for this organisation. Exceeds title_count where the organisation 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 portfolio whose postcode the publisher left empty. Those rows carry no geography and are absent from 04_RELATIONSHIPS.
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

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.