Core LMI Dat Ind

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
AREAID	VARCHAR	STRING	STRING	STRING	Geographic region code.
AREAID_NAME	VARCHAR	STRING	STRING	STRING	Geographic region name.
AREAID_TYPE	VARCHAR	STRING	STRING	STRING	Geographic area type.
CLASSID	VARCHAR	STRING	STRING	STRING	Class of worker ID.
CLASSID_NAME	VARCHAR	STRING	STRING	STRING	Class of worker name.
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. One worker might fill more than one position.
ESTAB	FLOAT	FLOAT	DOUBLE	FLOAT	The number of physical business locations.
INDID	VARCHAR	STRING	STRING	STRING	SIC code.
INDID_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the SIC code.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.