Canada STATCAN Attributes

Snowflake table name : CYBERSYN.CANADA_STATCAN_ATTRIBUTES

View data source documentation here.

Name	Description	Type	Example
VARIABLE	A unique identifier for a variable joinable to the timeseries table	VARCHAR	Household_income:_Other_elderly_families,_Median_after-tax_incom...
VARIABLE_NAME	Human-readable name for the variable	VARCHAR	Household income: Other elderly families, Median after-tax incom...
SEASONALLY_ADJUSTED	Boolean variable indicating whether the value is seasonally adjusted. StatCan includes seasonally adjusted figures and trend-cycle figures, which are a smoothed version of seasonally adjusted figures.	BOOLEAN	False
FREQUENCY	Frequency of the variable measurement.	VARCHAR	Annual
UNIT	Unit of measure for the variable, examples: persons, percent, CAD	VARCHAR	2022 Constant CAD
TREND_CYCLE	Boolean variable indicating whether the figure provided is the trend-cycle value, when applicable	BOOLEAN	False
NAICS	The North American Industry Classification System code of the cohort of the timeseries	VARCHAR	Food, beverage and tobacco wholesaler-distributors
NAPCS	The North American Product Classification System code of the cohort for Industrial Product Price data	VARCHAR	Ceramic tile, and other structural and architectural ceramic pro...
PRODUCT_GROUP	Product group for which CPI or retail price data is being provided	VARCHAR	Other household services
SEX	Sex of the individuals in the group being measured. Applicable to Labour Force Data	VARCHAR	Both sexes
CURRENCY	Foreign currency or index for which the average monthly exchange rate is expressed in Canadian dollars	VARCHAR	Swiss franc
INCOME_OR_CONSUMPTION_CATEGORY	The source of income or category of goods consumed by the economic unit (e.g., Household net saving, Government transfers)	VARCHAR	Child benefits
DEMOGRAPHIC_GROUP	The characteristic of the cohort described by the timeseries (e.g., 35 to 44 years, One parent census family, All households)	VARCHAR	Other elderly families
PROPERTY_TYPE	The characteristics of living situation for census_groups (e.g., Single-detached house, Movable dwelling) or the new housing price measured (e.g. House, Land)	VARCHAR	Total units
REPORT	The dataset from Statcan from which the time series originates	VARCHAR	Income and government transfers by economic family type
STATISTIC	The specific metric provided by the timeseries (e.g., Median Total Income, Total Households)	VARCHAR	Median after-tax income
DISCONTINUED	Boolean variable indicating whether StatCan discontinued the timeseries. These values will no longer be updated beyond the current date	BOOLEAN	False