Data explorer

Explore charity and foundation data across Canada.

The CRA publishes informational and financial filings from every registered charity and foundation in Canada. This data explorer makes that data queryable — so foundation staff, researchers, and charity staff can analyze it in aggregate rather than searching one organization at a time.

Sign in to start exploring.

Three ways to search

Start with simple filters, layer in multi-condition logic, or drop into the SQL editor — pick the depth that matches the question.

Search

Filter the full CRA dataset by location, category, and financials to find matching charities and foundations. Click any result to view its full profile.

  • Filter by name, province, city, or postal code radius
  • Narrow by designation, category, and sub-category
  • Set minimum thresholds for revenue, assets, and gifts
Search form with filters for organization, category, and financials.

Advanced search

Build multi-condition filter queries across any combination of CRA datasets and fields. Combine conditions with AND, OR, NOT, and EITHER operators, and group them into nested logic blocks.

  • Query across identity, financial, gift, and trustee datasets
  • Combine conditions with AND, OR, NOT, and EITHER logic
  • Group conditions into nested filter blocks
  • Browse the full database schema before you build
Advanced search filter builder combining a category and a financial filter, with a list of matching organizations below.

Deep research

Write and run SQL queries by hand or with AI assistance. Answer complex questions such as which charities working in the poverty issue area received funding from foundations in 2024, and how much funding did they receive?

  • Full SQL editor with syntax highlighting and semantic autocomplete
  • Ask AI to generate a query from a plain-English description
  • Sort, filter, and paginate results — export to CSV
  • Save queries to your account and reload them later
SQL editor with a multi-line query joining gifts, identity, and category tables, with a results table below.

Research and organize

Drill into any organization's full filing history, and save the ones worth a second look into named projects.

Organization profiles

Open any charity or foundation to a six-tab profile, viewing detailed filing information from 2015 to 2024.

  • Summary, Programs, Operations, Financials, People, and Grants tabs
  • Switch fiscal year on every tab — all data within a year stays aligned
  • Identity, contact, and AI-generated description at a glance
  • Open inline as a popup, or in its own shareable page
Organization profile for THE CALGARY FOUNDATION showing identity, description, designation, and key stats including revenue, assets, and grants given.

Prospecting projects

Bookmark organizations into named projects as you research. Build, organize, and revisit shortlists of charities or foundations for funding, partnership, or due-diligence work.

  • Create as many projects as you need — one per fund, region, or thesis
  • Save any organization with one click from the search results or profile
  • Review and edit saved lists from your account at any time
Prospecting projects page listing several projects with their saved organizations, BN numbers, and edit controls.

Sign in to start exploring.