Scenarios

#

Scenario

Based on Jan 2026 Data Refresh

Download

Date

19

PLASP area residential care (excluding  adult care) where there is no match to OFSTED Child Social List and not on the CQC List

Using SIC 87900 – Other residential care activities n.e.c. (not elsewhere classified) and

SIC 87200 – Residential care activities for learning disabilities, mental health and substance abuse

but not 87300 - Residential care activities for the elderly and disabled

 

PLASP_Residential_Care_not_adult_nomatch_OFSTED_and_CQC.xlsx

30/03/2026

18

List of Companies Incorporated since 2018 with Accounts Next Due before 2025 and with a single PSC

IncSince2018ODACBefore2025SinglePSC.xlsx

24/03/2026

17

List of companies with “Account”, “Book Keeper” or “Tax” in the company name

Account-or-Book_Keeper-or-Tax.xlsx

06/03/2026

16

List of Authorised Corporate Service Providers (ACSPs) with No Match to Companies at Companies House

ACSP_No_CH_Match.xlsx

05/03/2026

15

Solicitors based on SIC69102 (excludes Barristers and other legal work such as patent agents, notaries public, bailiffs, and arbitrators.)

SolicitorsSIC69102.xlsx

04/03/2026

14

Shopfitters based on SIC43320 or SIC43390

ShopfittersSIC43320or43390.xlsx

04/03/2026

13

Addresses with more >49 Companies registered where the first line of address starts with “C/O” or “CARE OF”

AddressCareofCountOver49Companies.xlsx

17/06/2026

12

Preston Full set all Companies with PSC, CQC List, DEFRA List, Ethical Supplier s List, FSA List, GLAA List, OFSTEAD child List, OSH List, Supervised Business Reg List and Visa List

 

PRESTONFULL.xlsx

16/02/2026

11

CQC registered organisations with Company, PSC, Visa, Ethical Supplier and GLAA data located in the Northwest 

NWROCUCQC.xlsx

16/02/2026

10

Construction companies with SIC 41100 or 41201 or 41202

ConstructionSIC41100or41201or41202.xlsx

11/02/2026

9

Har and Nail Companies SIC 96020

HairOrNailSIC96020.xlsx

11/02/2026

8

Companies with “Convenience” or “24x7” in the name

 

ConvenienceOr24x7.xlsx

11/02/2026

7

Companies with Anti-Laundering PSC

CompaniesWithAntiLaunderingPSC.xlsx

11/02/2026

6

Addresses where there are 50 or more Companies Registered with PFA included

AddressCountOver49Companies.xlsx

14/02/2026

5

Companies with “Bob Shop” in the company name and associated Persons with Significant Control

BobShops.xlsx

14/02/2026

4

Companies with “Candy” in the company name and associated Persons with Significant Control

CandyShops.xlsx

14/02/2026

3

Companies with “Khyber” in the company name and associated Persons with Significant Control

Khyber.xlsx

14/02/2026

2

CQC for Lancs combines with Visa and Ethical Supplier Lists

CQCLancsVisaESL.xlsx

14/02/2026

1

Nelson Lancs – Companies and/or Persons of Significant control who are registered in Post Code area “BB9”

BB9-Nelson-Lancs.xlsx

12/01/2026

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

3D Diagrams

Company Lookup

Enter a company number or Persons of Significant Control into the input box and click the “Search” button to create a 3d diagram.

Right-click on a Node and press “Search” button to expand the node

Left-click to go to Companies house website for that company or PSC

More than one Company, or Persons of Significant Control, can be entered when

separate by a comma “,”

A column of company numbers can be pasted from Excel into the input box.

The “Focus” button jumps to the node in the input box.

The “Add Layer” button expands every node by one layer.

The “Print Diagram” button creates a PDF version of the graph which can then be printed and assembled.

The “Clear” button removes the current diagram

 

 

Diagram Key Colours:                                                                              

White     - company selected from search criteria

Blue       - a person with significant control

Green    - a company with significant control

Red        - dissolved company

 

Diagram Actions:

Cursor on background:

Hold Left-click = rotate

Mouse Wheel = zoom in and out

Hold Right-click = pan

 

Cursor on nodes and links:

Right-click = go to Companies house data

 

 

Archive of 2025 Scenarios