Core LMI Dat Occ Earn

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_AVG	FLOAT	FLOAT	DOUBLE	FLOAT	Average hourly earnings for each job.
EARN_P0	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 0 percentile.
EARN_P10	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 10 percentile.
EARN_P100	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 100 percentile.
EARN_P25	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 25 percentile.
EARN_P50	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 50 percentile.
EARN_P75	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 75 percentile.
EARN_P90	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly Earnings at the 90 percentile.
EMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of occupied positions. One worker might fill more than one position.
OCCID	VARCHAR	STRING	STRING	STRING	SOC code.
OCCID_NAME	VARCHAR	STRING	STRING	STRING	SOC name.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.