CANADA CORE LMI DAT_IND

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
AREAID	VARCHAR	STRING	STRING	STRING	ID of the geographic region.
AREAID_NAME	VARCHAR	STRING	STRING	STRING	Name of the geographic region.
AREAID_TYPE	VARCHAR	STRING	STRING	STRING	Geographic area type.
CLASSID	VARCHAR	STRING	STRING	STRING	ID of the class of worker.
CLASSID_NAME	VARCHAR	STRING	STRING	STRING	Name of the class of worker.
EARN	FLOAT	FLOAT	DOUBLE	FLOAT	Total earnings for the industry. Sum of wages and supplements. This figure is also for the whole industry, not for the average worker in the industry.
EMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of occupied positions. This is not quite the same as workers because one worker might fill more than one position.
INDID	VARCHAR	STRING	STRING	STRING	NAICS code.
INDID_NAME	VARCHAR	STRING	STRING	STRING	NAICS name.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.