|

Find that Charity

vocabularies

Showing available vocabularies

Owned by david, visibility: Public

Query parameters

SQL query
select slug, title, description from ftc_vocabulary fv

17 rows

slug title description
ccni_purposes Purposes (CCNI)
ccni_theme Theme (CCNI)
ccni_beneficiaries Beneficiaries (CCNI)
oscr_activities Activities (OSCR)
oscr_beneficiaries Beneficiaries (OSCR)
oscr_purposes Purposes (OSCR)
ccew_theme Theme (CCEW)
ccew_beneficiaries Beneficiaries (CCEW)
ccew_activities Activities (CCEW)
icnpo International Classification of Non Profit Organisations (ICNPO)
ccni_what the charity does What the charity does (CCNI) What the charity does as chosen by the organisation in their annual return to Charity Commission for Northern Ireland. Organisations can chose multiple categories.
ccni_who the charity helps Who the charity helps (CCNI) Who the charity helps as chosen by the organisation in their annual return to Charity Commission for Northern Ireland. Organisations can chose multiple categories.
ccni_how the charity works How the charity works (CCNI) How the charity works as chosen by the organisation in their annual return to Charity Commission for Northern Ireland. Organisations can chose multiple categories.
ch_sic Companies House SIC Codes
icnptso International Classification of Non-profit and Third Sector Organizations (ICNP/TSO) ICNP/TSO categories have been automatically assigned from a machine learning model, as part of the [UK Charity Classification](https://charityclassification.org.uk/) project.
ukcat UK Charity Activity Tags These tags are taken from a project to classify all UK charities using a common set of tags. The tags are applied using keyword searching, so may be incorrect for particular cases. Visit [charityclassification.org.uk](https://charityclassification.org.uk/) for more information on the project. If you have any feedback on the classification system or how it has been applied there is a form on the project homepage.
scale Scale of operation - null -
Copy and export data

Duration: 1.93ms

SQL query
select v.title,
	ve.code,
    ve.title,
    ve.current
from ftc_vocabulary v
	inner join ftc_vocabularyentries ve
    	on v.id = ve.vocabulary_id
where v.slug = %(slug)s
order by ve.code

0 rows

title code title current
Copy and export data

Duration: 2.19ms

SQL query
with has_classification as (
select distinct oc.org_id
from ftc_vocabulary v
	inner join ftc_vocabularyentries ve
    	on v.id = ve.vocabulary_id
     inner join ftc_organisationclassification oc
     	on ve.id = oc.vocabulary_id
where v.slug = %(slug)s
  )
select source_id as source,
	count(*) as organisations,
    sum(case when (c.org_id is not null) then 1 else 0 end) as has_classification,
    sum(case when (c.org_id is null) then 1 else 0 end) as no_classification,
    sum(case when (c.org_id is null and o."active") then 1 else 0 end) as no_classification_active
from ftc_organisation o left outer join has_classification c on o.org_id = c.org_id
group by source

26 rows

source organisations has_classification no_classification no_classification_active
casc 7,531 0 7,531 7,276
ccew 341,241 0 341,241 168,858
ccni 7,746 0 7,746 7,123
companies 233,380 0 233,380 228,929
gias 50,017 0 50,017 27,075
gor 989 0 989 764
hesa 607 0 607 607
lae 367 0 367 347
lani 36 0 36 11
las 32 0 32 32
mutuals 31,383 0 31,383 9,999
nhsods-eccg 122 0 122 122
nhsods-ecsu 24 0 24 19
nhsods-ect 4 0 4 4
nhsods-ensa 185 0 185 178
nhsods-epraccur 15,663 0 15,663 12,227
nhsods-espha 14 0 14 14
nhsods-etr 214 0 214 211
nhsods-wlhb 7 0 7 7
nideptofeducation 1,133 0 1,133 1,133
oscr 52,367 0 52,367 25,416
pla 22 0 22 22
ror 4,816 0 4,816 4,754
rsl 1,609 0 1,609 1,609
schoolsscotland 2,458 0 2,458 2,458
walesschools 1,570 0 1,570 1,570
Copy and export data

Duration: 670.64ms