Data Narratives for the Arts (DNA) Platform
SECTOR SNAPSHOT DASHBOARD
Use the dropdowns below to filter the data displayed on the dashboard. To reset your selection(s), hit the "Clear filters" button.
Gain access to deeper insights. Sign up for enhanced access now!
Not sure if your organization is reflected in the dataset? Find out
Questions about the DNA Platform? Email dna@massculture.ca
The total number of organizations as selected by the dropdown filters.
Overview
The average age is calculated by taking the duration from an organization's registration date to Dec 31 of the selected year and averaging all the ages of the displayed organizations and converting that value to years.
Data source: Annual T3010 Registered Charity Information Return
The median of all the ordered annual revenue ranges of the selected organizations.
Data source: Annual T3010 Registered Charity Information Return
Types of arts organizations
This bar chart shows the percentage of each type.
Organization type: a label to categorize organizations based on shared characteristics.
Revenue ranges of arts organizations
This bar chart shows the percent of the organizations selected that fall into each revenue range.
Revenue range: The revenue range of an arts organization is its annual reported income.
Disciplines of arts organizations
This bar chart shows the percent of the organizations selected that fall into an artistic discipline.
Discipline: The discipline of an arts organization shows the artistic discipline served by an arts organization.
Locations of arts organizations
The map shows the location of each selected organization.
Financial Summary
REVENUE
The average organizational revenue is calculated by taking the average of the reported total annual revenue of all organizations.
Data source: Annual T3010 Registered Charity Information Return
The total sum of all reported annual revenues from government sources (federal, provincial, and municipal) for the selected organizations.
Data source: Annual T3010 Registered Charity Information Return
Top revenue streams by organizational revenue ranges
This chart shows the top revenue streams as a percent of total revenue, for each defined revenue range. Each stream proportion is calculated by dividing the sum of the annual revenue that came from the revenue stream by the total annual revenue.
Note: The percentages will not add up to 100 because this chart is spotlighting 4 selected revenue categories, and not all the possible reported revenue categories.
Data source: Annual T3010 Registered Charity Information Return
Median annual revenue trends by revenue stream
This chart shows the median annual revenue over time for all the reported revenue streams.
How to use this chart
Select a revenue stream of interest from the dropdown menu to see it displayed on the line chart.
Data source: Annual T3010 Registered Charity Information Return
EXPENSES
The average organizational expenditure is calculated by taking the average of the reported total annual expenditure of all the selected organizations.
Data source: Annual T3010 Registered Charity Information Return
This metric is calculated by dividing the sum of annual reported expenditure on activities by the total annual expenditure.
Data source: Annual T3010 Registered Charity Information Return
Top expense categories by organizational revenue ranges
This chart shows expenditure on administration and activities as a percent of total revenue, for each defined revenue range. The proportion is calculated by dividing the sum of the annual expense that came from the expense category by the total annual expenditure.
Note: The percentages will not add up to 100 because this chart is spotlighting 2 selected expenditure categories, and not all the possible reported expenditure categories.
Data source: Annual T3010 Registered Charity Information Return
Median expenditure trends by revenue range
This chart shows the median annual expenditure over time for all the reported expense categories.
How to use this chart
Select an expense category of interest from the dropdown menu to see it displayed on the line chart.
Data source: Annual T3010 Registered Charity Information Return
Labour and Compensation Summary
This metric is calculated by ordering the top-paying salary ranges for all selected organizations from lowest to highest and taking the median of the ordered ranges.
Data source: Annual T3010 Registered Charity Information Return
This metric is calculated by averaging the total annual full-time compensation expenditure of the selected organizations.
Data source: Annual T3010 Registered Charity Information Return
Staff growth is calculated by subtracting the total sum of employees (full-time and part-time) in the previous year from the total employees in the more recent year, and dividing by the total employees in the previous year. It shows a blank value for 2013 because the data set starts in 2013 and thus has no previous year to reference.
Data source: Annual T3010 Registered Charity Information Return
Workforce composition
This chart shows the make-up of all reported full-time and part-time staff as a percentage of total staff.
Data source: Annual T3010 Registered Charity Information Return
Staff growth over time
This chart shows the annual staff growth rate for full-time and part-time staff of all selected organizations. Staff growth is calculated by subtracting the total employees in the previous year from the total employees in the more recent year, and dividing by the total employees in the previous year. It shows a blank value for 2013 because the data set starts in 2013 and thus has no previous year to reference.
Data source: Annual T3010 Registered Charity Information Return
Distribution of top paying salary by revenue ranges
This chart shows the count of organizations who report an annual top salary in the specified ranges for each defined revenue range.
Data source: Annual T3010 Registered Charity Information Return
About our data
The Data Narratives for the Arts (D.N.A) Platform leverages data from the T3010 Registered Charity Information Return filing which is mandatory for Canadian registered charities. This form serves as a comprehensive source of information about revenue, expenses, staffing, and other operational details, enabling us to gain insights into the non-profit arts sector.
Key data extracted from the T3010 form includes:
- Revenue Data: Captured in Section D (Financial Information) under "Revenue" (lines 4500–4700). This includes tax-receipted gifts, government funding, and other sources of income.
- Expenses Data: Found in Section D (Financial Information) under "Expenditures" (lines 4800–5100). This covers spending categories such as compensation, fundraising, and charitable activities.
- Compensation Data: Detailed in Schedule 3 (Compensation), where the number of full-time and part-time positions, along with total expenditures on employee compensation, are reported.
- Staffing Data: Summarized in Schedule 3 (Compensation), providing information on the number of employees and compensation brackets for the highest-paid positions.
DNA Platform Glossary
The Data Narratives for the Arts (DNA) Platform Glossary serves as a comprehensive guide to the terms and definitions used throughout our platform. It has been carefully crafted to provide clarity and ensure a shared understanding of the language and concepts that underpin our analysis of the arts sector.
Disciplines
To capture the diversity and depth of the arts sector, we have designed a structured framework to categorize and define the various disciplines that contribute to its vibrancy. This framework organizes organizations into distinct categories and subcategories, each reflecting specific areas of focus and specialization. The table below presents these categories and subcategories, along with their definitions, highlighting how each plays a vital role in shaping and sustaining the non-profit arts sector.
Data Error Flagging & Cleaning Choices
As highlighted by the 2009 Imagine Canada data quality report, the T3010 data set has many issues. The issues from that report have not gone away in the interim.
- We do not wish to remove outliers/likely erroneous values, as we want to be able to show them in the individual records.
- We also do not wish to include outliers/likely erroneous values in summarized values, as they are likely to throw the data off.
Instead, we flag outliers/likely erroneous values and exclude them from summary measures, retaining the values for individual record display, and the flagging can be noted then.
For the 2013-2022 arts organization dataset, 4,986 values were flagged in these reporting areas, a bit over 5% of the values reported for these columns for these year. These are the key values that error-finding was focused on, as they had the biggest impact on the data stories.
Another data issue is that of boxes that should add up to other boxes failing to do so. For the dashboard, we defined "Other Revenue Types" as "Total Revenue" - "Total Government Revenue" - "Fundraising Revenue" - "Total Tax Receipted Value" - "Gifts Without Receipt" - "Goods and Services Sales Revenue". In theory, adding up the "other revenue" box (and a few other revenue types not listed here), should add up to this "other revenue type" box. But it most certainly does not.
Doing it this way assumes that "total revenue" and some of these clear accounting categories are more reliable and any "Other Revenue Type" that is negative after this operations is declared to be zero.
T3010 lines flagged as errors
Use the table below to inspect the lines reported by each T3010 return that have been flagged by our error detection.
While there are certainly other areas of the T3010 that have data errors, these were the pieces that most obviously impacted the DNA so far. As we continue to develop measures for later phases, we'll continue to flag outliers/likely errors. The method of flagging is very straightforward, and new items can be very easily added to it.