US PROFILES (PSEUDONYMIZED) JOBS

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
CITY_RAW	VARCHAR	STRING	STRING	STRING	The raw name of the country associated with the job.
COMPANY	VARCHAR	STRING	STRING	STRING	Standardized ID of the employer associated with the job (taxonomy version: see the US Profiles Meta).
COMPANY_NAME	VARCHAR	STRING	STRING	STRING	Standardized Company name associated with the job (taxonomy version: see the US Profiles Meta).
COMPANY_NAME_RAW	VARCHAR	STRING	STRING	STRING	Raw name of the company
COMPANY_RAW	VARCHAR	STRING	STRING	STRING	The raw name of the job’s employer.
END_DATE	DATE	DATE	DATE	DATE	Date when the job ended.
ID	VARCHAR	STRING	STRING	STRING	A unique ID generated by Lightcast which identifies the profile.
IS_CURRENT	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Specifies whether the job is identified as the current job.
LAA_COUNTRY	VARCHAR	STRING	STRING	STRING	2-digit country code associated with the profile. (Eg. US).
LAA_COUNTRY_NAME	VARCHAR	STRING	STRING	STRING	Name of the country associated with the profile. (Eg. United States).
LOT_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_SPECIALIZED_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the US Profiles Meta).
LOT_V6_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V6_SPECIALIZED_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v6).
LOT_V7_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_CAREER_AREA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_GROUP_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_SPECIALIZED_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
NAICS6	VARCHAR	STRING	STRING	STRING	6 Digit NAICS name associated with the job.
NAICS6_NAME	VARCHAR	STRING	STRING	STRING	6 Digit NAICS ID associated with the job.
NAICS_2022_6	VARCHAR	STRING	STRING	STRING	6-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_6_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 6-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NATION	VARCHAR	STRING	STRING	STRING	3 letter nation code of the profile.
NATION_NAME	VARCHAR	STRING	STRING	STRING	Nation name of profile.
NATION_RAW	VARCHAR	STRING	STRING	STRING	Standardized Name of the country associated with the profile.
ONET	VARCHAR	STRING	STRING	STRING	ONET ID associated with the job.
ONET_2019	VARCHAR	STRING	STRING	STRING	ONET 2019 ID associated with the job.
ONET_2019_NAME	VARCHAR	STRING	STRING	STRING	ONET 2019 name associated with the job.
ONET_NAME	VARCHAR	STRING	STRING	STRING	ONET name associated with the job.
SOC_2	VARCHAR	STRING	STRING	STRING	2 digit SOC code of the posting (taxonomy version: see the US Profiles Meta).
SOC_2021_2	VARCHAR	STRING	STRING	STRING	2 digit SOC code of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019
SOC_2021_2_NAME	VARCHAR	STRING	STRING	STRING	2 digit SOC name of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019).
SOC_2021_3	VARCHAR	STRING	STRING	STRING	2 digit SOC code of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019
SOC_2021_3_NAME	VARCHAR	STRING	STRING	STRING	3 digit SOC name of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019).
SOC_2021_4	VARCHAR	STRING	STRING	STRING	2 digit SOC code of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019
SOC_2021_4_NAME	VARCHAR	STRING	STRING	STRING	4 digit SOC name of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019).
SOC_2021_5	VARCHAR	STRING	STRING	STRING	2 digit SOC code of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019
SOC_2021_5_NAME	VARCHAR	STRING	STRING	STRING	5 digit SOC name of the posting (taxonomy version: Lightcast SOC 2021, should be used with ONET 2019).
SOC_2_NAME	VARCHAR	STRING	STRING	STRING	2 digit SOC name of the posting (taxonomy version: see the US Profiles Meta).
SOC_3	VARCHAR	STRING	STRING	STRING	3 digit SOC code of the posting (taxonomy version: see the US Profiles Meta).
SOC_3_NAME	VARCHAR	STRING	STRING	STRING	3 digit SOC name of the posting (taxonomy version: see the US Profiles Meta).
SOC_4	VARCHAR	STRING	STRING	STRING	4 digit SOC code of the posting (taxonomy version: see the US Profiles Meta).
SOC_4_NAME	VARCHAR	STRING	STRING	STRING	4 digit SOC name of the posting (taxonomy version: see the US Profiles Meta).
SOC_5	VARCHAR	STRING	STRING	STRING	5 digit SOC code of the posting (taxonomy version: see the US Profiles Meta).
SOC_5_NAME	VARCHAR	STRING	STRING	STRING	5 digit SOC name of the posting (taxonomy version: see the US Profiles Meta).
START_DATE	DATE	DATE	DATE	DATE	Date when the job started.
STATE_RAW	VARCHAR	STRING	STRING	STRING	The raw name of the state associated with the job.
TITLE	VARCHAR	STRING	STRING	STRING	Title ID associated with the job (taxonomy version: see the US Profiles Meta).
TITLE_NAME	VARCHAR	STRING	STRING	STRING	Title name associated with the job (taxonomy version: see the US Profiles Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Raw name of the job title.