2013 Charities Listings A searchable list of Canadian charities with information about their finances and activities 2015-02-05 2016-12-01 Canada Revenue Agency open-ouvert@tbs-sct.gc.ca Society and CultureRegistered CharitiesT3010Registered Charity Information Returncharitiesfinancial informationcontact informationreceipttaxactivitiesdirectorsdonationCanada Revenue Agency General InformationCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/cr.csv Activities Outside Canada - Countries Where Program was CarriedCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/cntry.csv Directors/OfficersCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/drctrs.csv Qualified DoneesCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/qlddn.csv Financial dataCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/fnncldt.csv IdentificationCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/dntfctn.csv Charitable ProgramsCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/pgm.csv Private / Public FoundationsCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch1.csv Activities Outside Canada - Details on FinancialCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch2d.csv Activities Outside Canada - Exported GoodsCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch2g.csv Activities Outside Canada - Financial Resources UsedCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch2r.csv CompensationCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch3.csv Gifts in KindCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch5.csv Political Activities - DescriptionCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch7d.csv Political Activities - FundingCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch7f.csv Political Activities - ResourcesCSV http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/sch7r.csv Data DictionaryPDF http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/lstngsdctnry-eng.pdf Data DictionaryPDF http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/lstngsdctnry-fra.pdf Codes ListsPDF http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/lstngsdtsts-eng.pdf Codes ListsPDF http://www.cra-arc.gc.ca/gncy/stts/opendata/charity/2013/lstngsdtsts-fra.pdf Registered Charity Information ReturnPDF http://www.cra-arc.gc.ca/formspubs/prioryear/t3010/t3010-13e.pdf Registered Charity Information ReturnPDF http://www.cra-arc.gc.ca/formspubs/prioryear/t3010/t3010-13f.pdf Completing the Registered Charity Information ReturnPDF http://www.cra-arc.gc.ca/formspubs/prioryear/t4033/t4033-13e.pdf Completing the Registered Charity Information ReturnPDF http://www.cra-arc.gc.ca/formspubs/prioryear/t4033/t4033-13f.pdf

2013 Charities Listings

A searchable list of Canadian charities with information about their finances and activities

Resources

Resource Name Resource Type Format Language Links
General Information Dataset CSV English
French
Access
Activities Outside Canada - Countries Where Program was Carried Dataset CSV English
French
Access
Directors/Officers Dataset CSV English
French
Access
Qualified Donees Dataset CSV English
French
Access
Financial data Dataset CSV English
French
Access
Identification Dataset CSV English
French
Access
Charitable Programs Dataset CSV English
French
Access
Private / Public Foundations Dataset CSV English
French
Access
Activities Outside Canada - Details on Financial Dataset CSV English
French
Access
Activities Outside Canada - Exported Goods Dataset CSV English
French
Access
Activities Outside Canada - Financial Resources Used Dataset CSV English
French
Access
Compensation Dataset CSV English
French
Access
Gifts in Kind Dataset CSV English
French
Access
Political Activities - Description Dataset CSV English
French
Access
Political Activities - Funding Dataset CSV English
French
Access
Political Activities - Resources Dataset CSV English
French
Access
Data Dictionary Guide PDF English Access
Data Dictionary Guide PDF French Access
Codes Lists Guide PDF English Access
Codes Lists Guide PDF French Access
Registered Charity Information Return Guide PDF English Access
Registered Charity Information Return Guide PDF French Access
Completing the Registered Charity Information Return Guide PDF English Access
Completing the Registered Charity Information Return Guide PDF French Access

Geographic Information

Geographic Region Name:

  • Atlantic
  • Quebec
  • Ontario
  • Prairies
  • Alberta
  • British Columbia
  • Territories

Comments (12)

Further to my comment earlier today, I think I have solved my problem. I wasn't waiting longer enough for the dataset to open. I have 83,990 unique records in the identification file. The same list with 201 duplicates to make 84,191 records in each of the general information and financial files. Does this make sense? Thank you for your consideration and assistance.

Hi Katherine, Thank you for your comment. I will need to consult the data owner on your question and will post a response here once I receive it. Regards, Momin The Open Government team

Hello, The reason why there are duplicate records is as follows: If a registered charity receives approval to change its fiscal period-end, the charity will have a transition period that is not a full 12 months. Therefore, the charity must file a separate information return for the months of transition. For example: if a charity's fiscal period-end was originally December 31st, and the charity received approval to change its fiscal period-end to March 31st, a completed T3010 return is required for the original fiscal period of January 1st to December 31st as well as another completed T3010 return for the transition period of January 1st to March 31st. If you require additional information on fiscal period-end please refer to the following link: https://www.canada.ca/en/revenue-agency/services/charities-giving/charities/operating-a-registered-charity/making-requests-that-require-approval/asking-a-fiscal-period-end-change.html The Charities Listings datasets on the Open Data Portal provide a snapshot of charities data at a given point in time. The charities data on the CRA’s web pages should be consulted for the most current information. If you would like to obtain more recent information, you can complete an online request: Charities Listings request form (http://www.cra-arc.gc.ca/chrts-gvng/lstngs/rqstfrm-eng.html) or contact CRA at 1-877-442-2899. ___________________________ CRA Open Data Team

Hello, Can you provide control totals for # of records in each dataset? This is my first time using the open data, and I'm also getting familiar with transition from Windows to Mac. In the datasets(identification and general information), I'm only coming up with about 21K records and I was expecting 85K. Am I getting the full dataset? If not, do you have any suggestions about what is happening? If it is the full dataset, why so few records? Thank you,

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.

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 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

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.