How complete are Charity Commission returns

Owned by david, visibility: Public

select case when extract(month from fin_period_end_date) < 4 then concat(extract(year from fin_period_end_date)-1,'-',extract(year from fin_period_end_date)) else concat(extract(year from fin_period_end_date),'-',extract(year from fin_period_end_date)+1) end as "Financial year", count(*) filter (where extract(month from fin_period_end_date)=4) as "April", count(*) filter (where extract(month from fin_period_end_date)=5) as "May", count(*) filter (where extract(month from fin_period_end_date)=6) as "June", count(*) filter (where extract(month from fin_period_end_date)=7) as "July", count(*) filter (where extract(month from fin_period_end_date)=8) as "August", count(*) filter (where extract(month from fin_period_end_date)=9) as "September", count(*) filter (where extract(month from fin_period_end_date)=10) as "October", count(*) filter (where extract(month from fin_period_end_date)=11) as "November", count(*) filter (where extract(month from fin_period_end_date)=12) as "December", count(*) filter (where extract(month from fin_period_end_date)=1) as "January", count(*) filter (where extract(month from fin_period_end_date)=2) as "February", count(*) filter (where extract(month from fin_period_end_date)=3) as "March", count(*) as "All data" from charity_ccewcharityarparta where total_gross_income is not null group by "Financial year"

17 rows

Duration: 810.38ms

select case when extract(month from fin_period_end_date) < 4 then concat(extract(year from fin_period_end_date)-1,'-',extract(year from fin_period_end_date)) else concat(extract(year from fin_period_end_date),'-',extract(year from fin_period_end_date)+1) end as "Financial year", count(*) filter (where extract(month from fin_period_end_date)=4) as "April", count(*) filter (where extract(month from fin_period_end_date)=5) as "May", count(*) filter (where extract(month from fin_period_end_date)=6) as "June", count(*) filter (where extract(month from fin_period_end_date)=7) as "July", count(*) filter (where extract(month from fin_period_end_date)=8) as "August", count(*) filter (where extract(month from fin_period_end_date)=9) as "September", count(*) filter (where extract(month from fin_period_end_date)=10) as "October", count(*) filter (where extract(month from fin_period_end_date)=11) as "November", count(*) filter (where extract(month from fin_period_end_date)=12) as "December", count(*) filter (where extract(month from fin_period_end_date)=1) as "January", count(*) filter (where extract(month from fin_period_end_date)=2) as "February", count(*) filter (where extract(month from fin_period_end_date)=3) as "March", count(*) as "All data" from charity_ccewcharityannualreturnhistory group by "Financial year"

21 rows

Duration: 1162.38ms

select extract(year from fin_period_end_date) as "Calendar year", count(*) filter (where extract(month from fin_period_end_date)=1) as "January", count(*) filter (where extract(month from fin_period_end_date)=2) as "February", count(*) filter (where extract(month from fin_period_end_date)=3) as "March", count(*) filter (where extract(month from fin_period_end_date)=4) as "April", count(*) filter (where extract(month from fin_period_end_date)=5) as "May", count(*) filter (where extract(month from fin_period_end_date)=6) as "June", count(*) filter (where extract(month from fin_period_end_date)=7) as "July", count(*) filter (where extract(month from fin_period_end_date)=8) as "August", count(*) filter (where extract(month from fin_period_end_date)=9) as "September", count(*) filter (where extract(month from fin_period_end_date)=10) as "October", count(*) filter (where extract(month from fin_period_end_date)=11) as "November", count(*) filter (where extract(month from fin_period_end_date)=12) as "December", count(*) as "All data" from charity_ccewcharityannualreturnhistory group by "Calendar year"

Duration: 1024.34ms