Data explorer

Dive into data from charities and foundations across Canada.

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

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, BN, province, city, or postal code radius
Narrow by charity type, category, and sub-category
Set minimum thresholds for revenue, assets, and gifts

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

Deep research

Write and run read-only SQL queries directly against the CRA database. Use the AI assistant to generate queries from plain English, or write your own with syntax highlighting and semantic autocomplete.

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