|

Find that Charity

Account year ends

Showing when charities have their financial year end. Based on the latest financial years for active registered charities in England and Wales. Data from Charity Commission for England and Wales.

Owned by david, visibility: Public

SQL query
with a as (
  select extract(MONTH from latest_acc_fin_period_end_date) as financial_year_end_month,
    to_char(latest_acc_fin_period_end_date, 'FMMonth') as financial_year_end_month_name,
	count(*) as charities
from charity_ccewcharity
where latest_acc_fin_period_end_date is not null
and charity_registration_status = 'Registered'
group by extract(MONTH from latest_acc_fin_period_end_date), to_char(latest_acc_fin_period_end_date, 'FMMonth')
order by extract(MONTH from latest_acc_fin_period_end_date)
)
select a.financial_year_end_month_name as "Month of financial year end",
a.charities as "Number of charities",
round((a.charities / b.total_charities) * 100,1) as "Percent of charities" 
from a a, (select sum(charities) as total_charities from a) AS b

12 rows

Month of financial year end Number of charities Percent of charities
January 3,177 2.0
February 2,705 1.7
March 50,942 31.7
April 12,758 7.9
May 3,295 2.0
June 7,835 4.9
July 6,684 4.2
August 17,103 10.6
September 7,788 4.8
October 3,932 2.4
November 2,025 1.3
December 42,505 26.4
Copy and export data

Duration: 176.76ms

SQL query
with a as (
  select extract(MONTH from latest_acc_fin_period_end_date) as financial_year_end_month,
    to_char(latest_acc_fin_period_end_date, 'FMMonth') as financial_year_end_month_name,
	count(*) as charities
from charity_ccewcharity
where latest_acc_fin_period_end_date is not null
and charity_registration_status = 'Registered'
group by extract(MONTH from latest_acc_fin_period_end_date), to_char(latest_acc_fin_period_end_date, 'FMMonth')
order by extract(MONTH from latest_acc_fin_period_end_date)
)
select a.financial_year_end_month_name as "bar_label",
round((a.charities / b.total_charities) * 100,1) as "bar_quantity" 
from a a, (select sum(charities) as total_charities from a) AS b
SQL query
with t as (
  select count(*) as total_charities
  from charity_ccewcharity
  where latest_acc_fin_period_end_date is not null
  and charity_registration_status = 'Registered'
)
select to_char(latest_acc_fin_period_end_date, 'FMMonth FMDDth') as "Financial year end",
	count(*) as "Number of charities",
	round((count(*) / t.total_charities::float) * 100) as "Proportion of charities"
from charity_ccewcharity, t
where latest_acc_fin_period_end_date is not null
and charity_registration_status = 'Registered'
group by "Financial year end", t.total_charities
order by "Number of charities" desc
limit 10

10 rows

Financial year end Number of charities Proportion of charities
March 31st 50,134 31.0
December 31st 41,987 26.0
August 31st 16,494 10.0
April 5th 7,682 5.0
June 30th 7,402 5.0
September 30th 6,871 4.0
July 31st 6,191 4.0
October 31st 3,253 2.0
April 30th 3,196 2.0
May 31st 2,796 2.0
Copy and export data

Duration: 444.77ms