2013 Charities Listings
|General Information||CSV||Bilingual (English and French)||Download|
|Activities Outside Canada - Countries Where Program was Carried||CSV||Bilingual (English and French)||Download|
|Directors/Officers||CSV||Bilingual (English and French)||Download|
|Qualified Donees||CSV||Bilingual (English and French)||Download|
|Financial data||CSV||Bilingual (English and French)||Download|
|Identification||CSV||Bilingual (English and French)||Download|
|Charitable Programs||CSV||Bilingual (English and French)||Download|
|Private / Public Foundations||CSV||Bilingual (English and French)||Download|
|Activities Outside Canada - Details on Financial||CSV||Bilingual (English and French)||Download|
|Activities Outside Canada - Exported Goods||CSV||Bilingual (English and French)||Download|
|Activities Outside Canada - Financial Resources Used||CSV||Bilingual (English and French)||Download|
|Compensation||CSV||Bilingual (English and French)||Download|
|Gifts in Kind||CSV||Bilingual (English and French)||Download|
|Political Activities - Description||CSV||Bilingual (English and French)||Download|
|Political Activities - Funding||CSV||Bilingual (English and French)||Download|
|Political Activities - Resources||CSV||Bilingual (English and French)||Download|
|Registered Charity Information Return||English||Download|
|Registered Charity Information Return||French||Download|
|Completing the Registered Charity Information Return||English||Download|
|Completing the Registered Charity Information Return||French||Download|
- The information on this page (the dataset metadata) is also available in JSON format
Link to JSON format
Nice work. Adding the data dictionary might seem small, but is a massive improvement in usability. I would suggest that you should also include examples of the relevant forms and reference works here (e.g., T3010, T1236, T4033, etc.) the same way as on the 2012 datasets page.You might also potentially want a link to Charities Directorate, particularly the page where the various Guidance documents are referenced - frequently these are analytically relevant. I've worked with this dataset for about 15 years and probably have as much experience as anyone with it. Very good to see the open data offerings mature like this. Again, nice work.
The string variables in the financial data screw the file...
Good morning Martin, We have received the following counsel from the data holder: The Financial Data (fnncldt.csv) file has been reviewed both in comma separated value (CSV) format and converted to excel and SAS format to ensure all variables and records are correctly formatted and delineated - with specific attention being given to the string variables. In all instances, the financial data file is consistent and correctly formatted. Please ensure you are using comma separated value to read in the file. Hope this helps! Karin - the Open-ouvert team
Stanley Y. Su
The columns 5450, 5460, 2730, 2740 do not seem to be aligned correctly.The Data Dictionary says 5450 is an "Amount" variable but it is actually mixed up with some text info. Can you check please?
Hi Stanley, Thank you for highlighting the issue for us. I've notified the data owner and will get back to you as soon as possible. Best, Yassine, on behalf of the Open Government Team
Hi Stanley, We've received this response from the data owners: "Thank you for sending us your comment/question. We appreciate ongoing feedback from our users. After review and analysis by our technical team, it was discovered that two fields were missing from the column names of the “General Information” file. New fields had been added to the 2013 dataset and had not been reflected in the column names. The column names have since been corrected and updated. Thank you again for bringing this to our attention." Best, The OG Team
The Title on the page says "2013 Charities Listing". The following source has most recent list of charities operating in Canada. http://www.cra-arc.gc.ca/ebci/haip/srch/basicsearchresult-eng.action?k=&s=registered&p=1&b=true I am wondering if this page is going to be updated with latest data (as of late 2015, or early 2016) ? Thanks.
Hi Prashanth, The Charities Listings on the Open Data Portal provide a snapshot of charities data at a given point in time. The dataset is created once most charities returns for a particular year have been submitted to the CRA. Listings for more recent years are refreshed biannually while others are refreshed annually. The 2014 Charities Listings will be available on the portal in June-July of this year. The charities data on the CRA’s website [http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html] also provides an up-to-date view of T3010 annual returns and the registration status of charities.