Canada Statcan Attributes

Snowflake table name : CYBERSYN.CANADA_STATCAN_ATTRIBUTES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
VARIABLE	A unique identifier for a variable joinable to the timeseries table	VARCHAR	chartered_bank_deposits_personal_chequable_excluding_personal_ch...
VARIABLE_NAME	Human-readable name for the variable	VARCHAR	Chartered bank deposits, personal, chequable (excluding personal...
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	Monthly
UNIT	Unit of measure for the variable, examples: persons, percent, CAD	VARCHAR	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	Government of Canada direct and guaranteed bonds
DEMOGRAPHIC_GROUP	The characetristic of the cohort described by the timeseries (e.g., 35 to 44 years, One parent census family, All households)	VARCHAR	Census-family households
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	Currency outside banks and chartered bank deposits, month-end, B...
STATISTIC	The specific metric provided by the timeseries (e.g., Median Total Income, Total Households)	VARCHAR	Currency outside banks and chartered bank deposits
DISCONTINUED	Boolean variable indicating whether StatCan discontinued the timeseries. These values will no longer be updated beyond the current date	BOOLEAN	False