The Charity Commission (UK) has an advanced search feature for its register, but appears to have no information in excel spreadsheets that would be ideal for geo mapping or comparing with other data. http://www.charitycommission.gov.uk/ShowCharity/RegisterOfCharities/AdvancedSearch.aspx In addition you can view an individual charity and see how it's income and expenditure has changed over the last few years, but there appears to be no way to access this data in a table format. Are there any tools which would enable this information to be collected and put in a table format? Even better, has anyone already done this?!

asked 23 May, 13:10

SLCVSP's gravatar image

SLCVSP
2613
accept rate: 0%


Have you looked at the data that has been scraped together to create OpenCharities:

http://opencharities.org/

Background blog post on the project is here:

http://countculture.wordpress.com/2010/09/06/introducing-open-charities-opening-up-the-charities-register/

link

answered 23 May, 13:48

ldodds's gravatar image

ldodds
161
accept rate: 0%

Yes but got lost amongst the info because there doesn't appear to be a search function to narrow the information down to local authority area and I've noticed sometimes key data is missing, e.g. for my own charity our more recent financial accounts are not listed although they do appear on the Charity Commission website. Are there ways around this? If so, how can I find out about them?

(23 May, 14:36) SLCVSP
1

It's possible to download a copy of the OpenCharities database: "Can we have a copy of the full database? Yes. The whole thing can be downloaded as a compressed CSV file from http://OpenCharities.org/charities.csv.zip under the same Share-Alike Attribution licence as the API data. Please Note: Even compressed, it's quite a big file (over 25MB), and may be too big for many spreadsheets." So you could upload it to Google Fusion Tables or a GIS?

(24 May, 22:18) psychemedia ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×13
×3
×2
×1
×1

Asked: 23 May, 13:10

Seen: 226 times

Last updated: 24 May, 22:18

powered by OSQA