A collection of useful data and notes for using UK charity data.
Contributions/pull requests welcome, particularly keeping the lists of charities up-to-date.
This data is made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.
If you use these resources you should attribute this as the source. Also do let me know how you've used them as I'd love to find out.
The canonical versions of the files that show a relationship between different organisation identifiers are found in the relationships directory and follow a standard format. For more details of the file format see the readme file.
Older versions of these files have been deprecated.
A list of charities which are registered with both the Charity Commission for England and Wales (CCEW) and the Office of the Scottish Charity Regulator (OSCR)
Charity numbers of charities registered in England and Wales that are the result of re-registration of an older charity.
Dummy company numbers held by Companies House for charities that are Charitable Incorporated Organisations or Scottish Charitable Incorporated Organisations
Company numbers held by Companies House for charities that are also registered companies. Mainly focused on Scottish and Northern Irish charities as there are already company numbers in the England and Wales data.
Register of Mergers maintained by the Charity Commission for England and Wales, converted into CSV format with registration nunmbers extracted.
This file shouldn't be updated directly - it is generated by the script in scripts/ccew-register-of-mergers.py.
A list of charities that are part of a federation. The list is mainly based on keyword searching within the names of charities, rather than from official membership lists. This means that these should not be taken as an official list of the members of federal body. Some organisations will not be affiliated to the parent body, or may have been wrongly included based on words in their name.
A lookup from UK nonprofit organisations on the GRID database to their charity number, either in Scotland or England and Wales.
A set of alternative names for organisations, given an Org ID.
Read-across for activity, beneficiary and purpose categories for Charities from those used by the Charity Commission for England and Wales (CCEW) to the Office of the Scottish Charity Regulator (OSCR). NB These are many-to-many relationships, and lots of the categories don't match exactly.
Charity Commission for England and Wales lookup from area of operation names to GSS and ISO country codes. From the new (April 2021) Charity Commission data download.
See also:
- cc-aoo-gss-iso.csv - version from old Charity Commission format download.
- Originally kept in a Github gist
An outline of the fields available in the Charity Commission for England and Wales's register download, available from the full register download files.
Description of hierarchy of Part B fields from Charity Commission for England and Wales (from the old data extract that was discontinued in 2021)
Academy trusts with UK company number. Sourced from Whole of Government Accounts guidance, (spreadsheet)
A list of independent schools (sourced from what used to be Edubase) with their charity/company number if known.
Lookups for colleges in Oxford and Cambridge University to charity numbers
Lookups from universities (using HESA ID) to charity numbers (given as a Org ID).
Lookups from universities (using URN numbers) to royal charter numbers (given as a company number).
A list of suffixes for organisations registered on the Mutuals Public Register.
A list of registered social housing providers, with charity and company numbers.
Based on the list published by the Regulator of Social Housing. Only covers England.
Company numbers held by Companies House for organisations that are also registered companies.
A collection of definitions of classifications relevant to non profit organisations.