Core LMI Dat Unemp Occ

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.
EMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of occupied positions. One worker might fill more than one position.
MONTH	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Month of data.
OCCID	VARCHAR	STRING	STRING	STRING	SOC code.
OCCID_NAME	VARCHAR	STRING	STRING	STRING	SOC name.
TWELVEMONTHEMPAVERAGE	FLOAT	FLOAT	DOUBLE	FLOAT	The average employment over the last 12 months.
TWELVEMONTHUNEMPAVERAGE	FLOAT	FLOAT	DOUBLE	FLOAT	The average unemployment over the last 12 months.
UNEMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of unemployed people in the area.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.