| |

Find that Charity

Data completeness

How complete are Charity Commission returns

Owned by david, visibility: Public

SQL query
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

Financial year April May June July August September October November December January February March All data
2006-2007 0 0 0 0 0 0 0 0 0 6 12 462 480
2007-2008 20 9 25 53 116 23 10 4 120 7 10 470 867
2008-2009 24 8 19 52 138 31 5 5 112 128 99 2,895 3,516
2009-2010 333 102 251 261 651 323 159 76 1,055 109 97 2,814 6,231
2010-2011 302 114 216 238 629 230 110 42 690 57 28 1,525 4,181
2011-2012 102 39 79 92 209 100 43 23 366 45 32 1,324 2,454
2012-2013 114 44 107 111 229 95 56 31 428 462 374 7,411 9,462
2013-2014 1,798 453 980 927 2,593 1,112 550 299 4,506 480 398 7,538 21,634
2014-2015 1,913 468 1,071 979 2,686 1,135 531 285 4,674 502 392 7,455 22,091
2015-2016 1,899 459 1,105 1,004 2,694 1,126 534 291 4,830 247 187 5,533 19,909
2016-2017 1,132 324 696 803 2,190 775 394 257 4,073 547 767 26,254 38,212
2017-2018 6,203 1,684 4,231 4,147 10,401 4,328 2,189 1,193 25,967 1,692 1,493 33,177 96,705
2018-2019 7,313 1,962 4,801 4,421 10,964 4,310 2,149 1,116 24,854 1,621 1,474 33,105 98,090
2019-2020 7,318 1,997 4,902 4,456 11,026 4,417 2,190 1,132 25,607 1,694 1,533 33,550 99,822
2020-2021 7,447 2,030 4,964 4,175 9,753 4,255 2,207 1,146 25,696 1,654 1,513 32,852 97,692
2021-2022 7,227 1,883 4,385 3,589 8,542 3,952 2,107 1,084 24,589 1,414 830 9,773 69,375
2022-2023 1,715 354 766 467 858 207 45 2 0 0 0 0 4,414
Copy and export data

Duration: 1642.67ms

SQL query
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

Financial year April May June July August September October November December January February March All data
2002-2003 0 0 1 0 0 0 0 0 0 0 0 0 1
2003-2004 0 0 0 0 0 0 0 0 2 1,132 683 8,135 9,952
2004-2005 1,558 312 991 980 2,164 2,306 1,472 352 6,448 1,199 715 9,719 28,216
2005-2006 1,933 409 1,011 1,078 2,408 2,435 1,512 360 6,682 1,205 685 9,624 29,342
2006-2007 1,898 423 1,038 1,114 2,451 2,407 1,401 333 5,898 1,082 634 8,537 27,216
2007-2008 1,717 412 973 1,075 2,461 2,372 1,378 363 6,379 983 642 8,892 27,647
2008-2009 1,807 448 1,011 1,150 2,607 2,430 1,362 361 6,265 663 324 8,216 26,644
2009-2010 1,697 393 728 786 1,831 1,093 546 234 4,240 511 276 5,942 18,277
2010-2011 1,205 305 675 704 1,730 957 471 216 3,660 524 322 6,019 16,788
2011-2012 1,237 342 776 747 1,928 1,074 570 277 4,480 635 413 7,435 19,914
2012-2013 1,537 428 922 869 2,085 1,192 586 278 4,115 595 393 7,138 20,138
2013-2014 1,512 443 942 869 2,183 1,127 583 290 4,075 497 424 7,297 20,242
2014-2015 1,563 471 991 894 2,306 1,148 577 294 4,207 506 427 7,353 20,737
2015-2016 1,657 504 1,095 956 2,413 1,205 580 312 4,641 568 439 7,766 22,136
2016-2017 1,961 511 1,154 1,017 2,671 1,275 653 349 4,992 681 1,536 41,250 58,050
2017-2018 10,755 2,853 7,029 6,316 16,322 7,912 4,033 2,095 43,125 3,421 2,909 54,860 161,630
2018-2019 13,512 3,454 8,205 7,104 18,189 8,435 4,214 2,115 43,615 3,455 2,909 54,862 170,069
2019-2020 13,566 3,483 8,338 7,136 18,177 8,435 4,174 2,146 43,845 3,489 2,923 54,750 170,462
2020-2021 13,593 3,524 8,503 7,188 18,278 8,425 4,220 2,182 44,167 3,466 2,933 54,706 171,185
2021-2022 13,528 3,552 8,523 7,172 18,136 8,363 4,219 2,181 44,487 3,479 1,556 15,365 130,561
2022-2023 2,877 604 1,339 861 1,921 520 151 15 0 0 0 0 8,288
Copy and export data

Duration: 2601.28ms

SQL query
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"

21 rows

Calendar year January February March April May June July August September October November December All data
2002 0 0 0 0 0 1 0 0 0 0 0 0 1
2003 0 0 0 0 0 0 0 0 0 0 0 2 2
2004 1,132 683 8,135 1,558 312 991 980 2,164 2,306 1,472 352 6,448 26,533
2005 1,199 715 9,719 1,933 409 1,011 1,078 2,408 2,435 1,512 360 6,682 29,461
2006 1,205 685 9,624 1,898 423 1,038 1,114 2,451 2,407 1,401 333 5,898 28,477
2007 1,082 634 8,537 1,717 412 973 1,075 2,461 2,372 1,378 363 6,379 27,383
2008 983 642 8,892 1,807 448 1,011 1,150 2,607 2,430 1,362 361 6,265 27,958
2009 663 324 8,216 1,697 393 728 786 1,831 1,093 546 234 4,240 20,751
2010 511 276 5,942 1,205 305 675 704 1,730 957 471 216 3,660 16,652
2011 524 322 6,019 1,237 342 776 747 1,928 1,074 570 277 4,480 18,296
2012 635 413 7,435 1,537 428 922 869 2,085 1,192 586 278 4,115 20,495
2013 595 393 7,138 1,512 443 942 869 2,183 1,127 583 290 4,075 20,150
2014 497 424 7,297 1,563 471 991 894 2,306 1,148 577 294 4,207 20,669
2015 506 427 7,353 1,657 504 1,095 956 2,413 1,205 580 312 4,641 21,649
2016 568 439 7,766 1,961 511 1,154 1,017 2,671 1,275 653 349 4,992 23,356
2017 681 1,536 41,250 10,755 2,853 7,029 6,316 16,322 7,912 4,033 2,095 43,125 143,907
2018 3,421 2,909 54,860 13,512 3,454 8,205 7,104 18,189 8,435 4,214 2,115 43,615 170,033
2019 3,455 2,909 54,862 13,566 3,483 8,338 7,136 18,177 8,435 4,174 2,146 43,845 170,526
2020 3,489 2,923 54,750 13,593 3,524 8,503 7,188 18,278 8,425 4,220 2,182 44,167 171,242
2021 3,466 2,933 54,706 13,528 3,552 8,523 7,172 18,136 8,363 4,219 2,181 44,487 171,266
2022 3,479 1,556 15,365 2,877 604 1,339 861 1,921 520 151 15 0 28,688
Copy and export data

Duration: 1821.58ms