Core LMI Dat Ind Race Ethn Hiresseps

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
AREAID	VARCHAR	STRING	STRING	STRING	Geographic region code.
AREAID	VARCHAR	STRING	STRING	STRING	Geographic region code.
AREAID_NAME	VARCHAR	STRING	STRING	STRING	Geographic region name.
AREAID_NAME	VARCHAR	STRING	STRING	STRING	Geographic region name.
AREAID_TYPE	VARCHAR	STRING	STRING	STRING	Geographic area type
AREAID_TYPE	VARCHAR	STRING	STRING	STRING	Geographic area type
CLASSID	VARCHAR	STRING	STRING	STRING	Class of worker ID.
CLASSID	VARCHAR	STRING	STRING	STRING	Class of worker ID.
CLASSID_NAME	VARCHAR	STRING	STRING	STRING	Class of worker name.
CLASSID_NAME	VARCHAR	STRING	STRING	STRING	Class of worker name.
EMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of occupied positions. This is not quite the same as workers because one worker might fill more than one position.
EMP	FLOAT	FLOAT	DOUBLE	FLOAT	The number of occupied positions. This is not quite the same as workers because one worker might fill more than one position.
ETHNICITYID	VARCHAR	STRING	STRING	STRING	Ethnicity by ID.
ETHNICITYID	VARCHAR	STRING	STRING	STRING	Ethnicity by ID.
ETHNICITYID_NAME	VARCHAR	STRING	STRING	STRING	Ethnicity by name.
ETHNICITYID_NAME	VARCHAR	STRING	STRING	STRING	Ethnicity by name.
HIRA	FLOAT	FLOAT	DOUBLE	FLOAT
HIRA	FLOAT	FLOAT	DOUBLE	FLOAT
INDID	VARCHAR	STRING	STRING	STRING	SOC code.
INDID	VARCHAR	STRING	STRING	STRING	SOC code.
INDID_NAME	VARCHAR	STRING	STRING	STRING	SOC name.
INDID_NAME	VARCHAR	STRING	STRING	STRING	SOC name.
RACEID	VARCHAR	STRING	STRING	STRING	Race ID.
RACEID	VARCHAR	STRING	STRING	STRING	Race ID.
RACEID_NAME	VARCHAR	STRING	STRING	STRING	Race name.
RACEID_NAME	VARCHAR	STRING	STRING	STRING	Race name.
SEP	FLOAT	FLOAT	DOUBLE	FLOAT
SEP	FLOAT	FLOAT	DOUBLE	FLOAT
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.
YEAR	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Year of data.

Updated about 2 hours ago

Did this page help you?