|

Find that Charity

Organisation trustees

A list of organisations that are trustees of charities, ordered by how many charities they are trustees of.

Owned by david, visibility: Public

SQL query
with t as (select trustee_id, count(*) as org_count
from charity_ccewcharitytrustee cc 
where linked_charity_number = 0
	and individual_or_organisation = 'O'
group by trustee_id),
t_name as (select distinct on(trustee_id) trustee_id, trustee_name
from charity_ccewcharitytrustee)
select trustee_name as "Trustee name", org_count as "Number of charities"
from t inner join t_name on t.trustee_id = t_name.trustee_id
order by org_count desc 
limit 100

100 rows

Trustee name Number of charities
Ludlow Trust Company Ltd 156
LIVERPOOL CHARITY AND VOLUNTARY SERVICES 79
Ludlow Trust Company Ltd 47
HSBC TRUST COMPANY (UK) LIMITED 40
RHONDDA CYNON TAF CBC 34
Zedra Trust Company (UK) Limited 27
THE COUNCIL OF THE BOROUGH OF KIRKLEES 22
CARMARTHENSHIRE COUNTY COUNCIL 21
Caerphilly County Borough Council 19
BRISTOL CITY COUNCIL 17
SANDWELL MBC 17
THE COWDRAY TRUST LIMITED 15
SHEFFIELD CITY COUNCIL 14
REIGATE & BANSTEAD B C 14
Birmingham City Council 13
TANDRIDGE DISTRICT COUNCIL 13
HSBC TRUST CO (UK) LIMITED 13
Barnsley Metropolitan Borough Council 12
Apex Corporate Trustees UK Ltd 11
SOUTHWELL & NOTTINGHAM DIOCESAN BOARD OF FINANCE 11
CITY OF BRADFORD MDC 11
ELY DIOCESAN BOARD OF FINANCE 11
SG Kleinwort Hambros Trust Company (UK) Limited 11
Ludlow Trust Company Ltd 10
Lloyds Bank Plc 10
GATESHEAD COUNCIL 10
Messrs Hoare Trustees 9
Grace Baptist Trust Corporation 9
PEMBROKESHIRE COUNTY COUNCIL 9
Leicestershire County Council 9
THE SCOUT ASSOCIATION TRUST CORPORATION 9
The Society of Authors 9
Rathbones Trust Company Limited 8
Masonic Charitable Foundation 8
THE ST ALBANS DIOCESAN BOARD OF FINANCE 8
BRISTOL DIOCESAN BOARD OF FINANCE 8
LONDON BOROUGH OF CROYDON 8
THE COUNTY COUNCIL OF THE CITY AND COUNTY OF CARDIFF 8
CITY OF BRADFORD MDC 8
Ludlow Trust Co Ltd 8
WORCESTERSHIRE COUNTY COUNCIL 8
SOUTHEND ON SEA BOROUGH COUNCIL 8
BCP Council 8
HSBC TRUST COMPANY (UK) LTD 8
NONE 7
LLOYDS BANK PLC 7
THE SCOUT ASSOCIATION 7
CRIPPS TRUST CORPORATION LIMITED 7
THE DICKINSON TRUST LIMITED 7
RUNNYMEDE BOROUGH COUNCIL 7
THE YORKSHIRE CONGREGATIONAL UNION (INCORPORATED) 7
Mid Sussex District Council 7
SANDWELL MBC 7
BLACKROCK FUND MANAGERS LIMITED 7
Ludlow Trust Company Limited 7
RADNOR YOUNG FARMERS CLUBS 7
SWINDON BOROUGH COUNCIL 7
Staffordshire County Council 7
Wirral Council 7
Isle of Anglesey County Council 7
LANCASHIRE COUNTY COUNCIL 6
CCLA FUND MANAGERS LIMITED (MANAGER) 6
CHELMSFORD DIOCESAN BOARD OF FINANCE 6
DERBY CITY COUNCIL 6
ANCHOR HANOVER GROUP 6
HSBC TRUST COMPANY (UK) LIMITED 6
The Master and Keepers or Wardens and Commonalty of the Mystery or Art of Brewers in the City of London 6
HSBC TRUST COMPANY UK LIMITED 6
PORTSMOUTH DIOCESAN BOARD OF FINANCE 6
FAREHAM BOROUGH COUNCIL 6
MIDDLESBROUGH COUNCIL 6
WAKEFIELD MDC 6
HSBC TRUST COMPANY UK LIMITED 6
Apex Corporate Trustees UK Ltd 6
Rathbones Trust Company Limited 6
THE GOSPEL STANDARD TRUST 6
THE DEAN AND CHAPTER OF CANTERBURY 6
SMV Trustee Company Ltd 6
NEWCASTLE DIOCESAN SOCIETY 5
THURROCK COUNCIL 5
NORTH TYNESIDE COUNCIL 5
M&G Securities Limited 5
Guildford Borough Council 5
OLDHAM MBC FINANCE TEAM 5
BOROUGH OF TELFORD & WREKIN 5
OMBC FINANCE TEAM jamie kelly 5
HYNDBURN BOROUGH COUNCIL 5
THE BISHOP OF BRISTOL 5
HAMPSHIRE COUNTY COUNCIL 5
CALDERDALE MBC 5
National Museum of the Royal Navy 5
SG Kleinwort Hambros Trust Company (UK) Limited 5
STOCKPORT METROPOLITAN BOROUGH COUNCIL 5
BNY MELLON TRUST & DEPOSITARY (UK) LIMITED 5
The Master and Keepers or Wardens and Commonalty of the Mystery or Art of Brewers of the City of London 5
CROWBOROUGH TOWN COUNCIL 5
VICAR AND CHURCHWARDENS 5
Livability 5
HARTLEPOOL BOROUGH COUNCIL 5
LINCOLN DIOCESAN TRUST & BD OF FINANCE LTD 5
Copy and export data

Duration: 1024.73ms

SQL query
select org_count,
	count(*) filter(where individual_or_organisation = 'P') as trustee_count_individual,
	count(*) filter(where individual_or_organisation = 'O') as trustee_count_organisation,
	count(*) as trustee_count
from (
select trustee_id, individual_or_organisation, count(*) as org_count
from charity_ccewcharitytrustee cc 
where linked_charity_number = 0
group by trustee_id, individual_or_organisation
) as a
group by org_count
order by org_count asc

29 rows

org_count trustee_count_individual trustee_count_organisation trustee_count
1 765,701 4,986 770,687
2 51,883 406 52,289
3 8,740 107 8,847
4 2,381 58 2,439
5 787 34 821
6 302 18 320
7 133 16 149
8 108 12 120
9 37 6 43
10 23 3 26
11 20 5 25
12 9 1 10
13 2 3 5
14 5 2 7
15 2 1 3
16 2 0 2
17 3 2 5
19 2 1 3
20 1 0 1
21 0 1 1
22 2 1 3
26 2 0 2
27 0 1 1
28 1 0 1
34 0 1 1
40 0 1 1
47 0 1 1
79 0 1 1
156 0 1 1
Copy and export data

Duration: 1320.35ms