Diagrams
Diagram Key Colours
White - company selected from search criteria
Blue - a person with significant control
Green - a company with significant control
Pink - 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
Company
Lookup (double click on node to expand)
|
# |
Scenario |
Download |
PSC
Degrees of Separation |
|
35 |
Most
used address for Companies and PSC in Lancashire shown in two pivot tables |
|
|
|
34 |
0 |
||
|
33 |
Filter
on “nationality” contains “dutch”. |
1 |
|
|
32 |
Barbers with no country of residence (ie
owned by other companies directly). |
Filter
on “country of residence” set to BLANK. |
0 |
|
31 |
Candy
(Anything with ‘candy’ in the company name) |
|
|
|
30 |
Address
in common with “khyb” |
|
|
|
29 |
1 |
||
|
28 |
1 |
||
|
27 |
People who are the PSC for both Barbers and Shop
Fitter companies |
0 |
|
|
26 |
Markets
with Supervised Business Register details matched where possible |
|
|
|
25 |
Shop
Fitters with Supervised Business Register details matched where possible |
|
|
|
24 |
Barbers
with Supervised Business Register details matched where possible |
|
|
|
23 |
Persons
of Significant Control Born after 2007 |
|
|
|
22 |
|
Case
Study – Companies Care Of.pptx |
0 |
|
21 |
The Naily case study raw
data.xlsx |
5 |
|
|
20 |
2 |
||
|
19 |
AABAN (subset) |
AABAN.xlsx company names with AABAN in title |
4 |
|
18 |
0 |
||
|
17 |
1 |
||
|
16 |
|
|
|
|
15 |
|
||
|
14 |
Hairdressers
(SIC 96020) |
|
|
|
13 |
Vape
shops (SIC 47260 or 47789) |
|
|
|
12 |
Sweet
shops (SIC 47240) |
|
|
|
11 |
1 |
||
|
10 |
1 |
||
|
9 |
4 |
||
|
8 |
1 |
||
|
7 |
2 |
||
|
6 |
0 |
||
|
5 |
Open Supply Hub Food and Agriculture
Accounts Over Due Extended |
0 |
|
|
4 |
0 |
||
|
3 |
0 |
||
|
2 |
0 |
||
|
1 |
0 |