Core LMI Dat Occ Hires Seps

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.
HIRES	FLOAT	FLOAT	DOUBLE	FLOAT	The number of hires made in that occupation. For more information, see https://kb.economicmodeling.com/glossary/hires/.
OCCID	VARCHAR	STRING	STRING	STRING	SOC code.
OCCID_NAME	VARCHAR	STRING	STRING	STRING	SOC name.
SEPS	FLOAT	FLOAT	DOUBLE	FLOAT	The number of separations from that occupation. Like hires, separations come from the Quarterly Workforce Indicators (QWI) dataset from the Census Bureau.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.