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