UK CORE LMI DAT_OCC

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
ANNUAL_EARN_AVG	FLOAT	FLOAT	DOUBLE	FLOAT	Average annual earnings for each job.
ANNUAL_EARN_PCT10	FLOAT	FLOAT	DOUBLE	FLOAT	Annual earnings at the 10th percentile.
ANNUAL_EARN_PCT25	FLOAT	FLOAT	DOUBLE	FLOAT	Annual earnings at the 25th percentile.
ANNUAL_EARN_PCT50	FLOAT	FLOAT	DOUBLE	FLOAT	Annual earnings at the 50th percentile.
ANNUAL_EARN_PCT75	FLOAT	FLOAT	DOUBLE	FLOAT	Annual earnings at the 75th percentile.
ANNUAL_EARN_PCT90	FLOAT	FLOAT	DOUBLE	FLOAT	Annual earnings at the 90th percentile.
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_PCT10	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly earnings at the 10th percentile.
EARN_PCT25	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly earnings at the 25th percentile.
EARN_PCT50	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly earnings at the 50th percentile.
EARN_PCT75	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly earnings at the 75th percentile.
EARN_PCT90	FLOAT	FLOAT	DOUBLE	FLOAT	Hourly earnings at the 90th percentile.
EMP	VARCHAR	STRING	STRING	STRING	The number of occupied positions. One worker might fill more than one position.
GROWTH	VARCHAR	STRING	STRING	STRING	Growth is the net (non-negative) change for each year and is calculated at the lowest level and aggregated up. For these reasons, it often differs from job change as calculated by subtracting the job counts of an earlier year from the job counts from a later year. The growth metric is a component of the openings metric (growth + replacements = openings).
OCCID	VARCHAR	STRING	STRING	STRING	SOC code.
OCCID_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the SOC code.
REPLACEMENTS	VARCHAR	STRING	STRING	STRING	Replacements is the number of existing jobs that are estimated to have been vacated in the year. Replacements takes into account job openings that are created but that are not due to growth in the occupation.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.