Charity Data for England and Wales
- Prof. Alasdair Rutherford - University of Stirling [profile]
- Dr Diarmuid McDonnell - University of Birmingham [profile]
Repository
This repository hosts Python scripts for downloading charity data from the Charity Commission for England and Wales, and converting the relational database tables (.bcp) to CSV files. The scripts are as follows:
- ew_download.py - downloads latest copy of the data download and calls on the other two scripts to convert the files to a more open data format (CSV)
- fimport.py - unzips downloaded files and calls on bcp.py
- bcp.py - converts relational database tables (.bcp) to CSV files
Pre-requisites
You must have Python installed on your machine. Python is an open source programming language that can be downloaded and installed using the Anaconda distribution.
We recommended using Sublime Text to write and run the Python scripts, but there are other text editors/IDEs available.
Acknowledgements
The following files convert the relational database tables (.bcp) to CSV files and were produced by NCVO:
- bcp.py
- fimport.py
Final comments
This materials in this repository are free to use, adapt and share. The scripts are in "beta" phase, meaning they are not likely free of error and should continue to be tested by multiple users. This repository is likely to be updated on a semi-regular basis. If you would like to collaborate on developing the repository further, or have an idea for a research project employing these datasets, then don't hesitate to get in contact.