|

Find that Charity

Reserves

The table shows various statistics about the reserves held by charities in England and Wales, based on data from the Charity Commission register of charities. The columns in the table are:

The figures only relate to charities with over £500,000 in a year as smaller charities don't return these figures in the annual return. "Zero reserves" actually means less than £10,000 in reserves.

The line chart shows the proportion of charities with zero reserves, by year. The latest year is likely to be incomplete.

Owned by david, visibility: Public

SQL query
select ar_cycle_reference,
	sum(case when reserves > 10000 then 0 else 1 end) as no_reserves,
	sum(case when reserves > 10000 then 1 else 0 end) as with_reserves,
	sum(case when reserves > 10000 then 0 else 1 end) / count(*)::float as no_reserves_pc,
	count(*) as all_charities,
	max(ar_received_date) as latest_recieved,
	max(fin_period_end_date) as latest_fye
from charity_ccewcharityarpartb cc 
where extract('year' from fin_period_end_date) >= 2016
group by ar_cycle_reference 
order by ar_cycle_reference

7 rows

ar_cycle_reference no_reserves with_reserves no_reserves_pc all_charities latest_recieved latest_fye
AR16 141 741 0.1598639455782313 882 2019-12-13 2016-12-31
AR17 669 5,192 0.11414434396860604 5,861 2021-08-19 2017-12-31
AR18 1,193 10,624 0.10095624947110096 11,817 2022-03-31 2018-12-31
AR19 1,325 10,727 0.10994025887819449 12,052 2022-12-12 2019-12-31
AR20 1,254 10,724 0.10469193521456002 11,978 2023-03-03 2020-12-31
AR21 1,122 11,205 0.09101971282550499 12,327 2023-03-17 2021-12-31
AR22 555 6,377 0.08006347374495096 6,932 2023-03-19 2022-12-31
Copy and export data

Duration: 131.31ms

SQL query
select ar_cycle_reference as chartjs_line_label,
	(sum(case when reserves > 10000 then 0 else 1 end) / count(*)::float) * 100 as chartjs_line_value
from charity_ccewcharityarpartb cc 
where extract('year' from fin_period_end_date) >= 2016
group by chartjs_line_label
order by chartjs_line_label