GLOBAL PROFILES (PSEUDONYMIZED) PROFILES

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
CERTIFICATIONS	ARRAY	JSON	ARRAY	JSON	By ID, certifications associated with the profile.
CERTIFICATIONS_NAME	ARRAY	JSON	ARRAY	JSON	By ID, certifications associated with the profile.
CITY	VARCHAR	STRING	STRING	STRING	ID of the city associated with the profile.
CITY_NAME	VARCHAR	STRING	STRING	STRING	Name of the city associated with the profile.
COMMON_SKILLS	ARRAY	JSON	ARRAY	JSON	ID for Human skills (aka soft skills). These are the basic skills required in nearly every job posting (e.g., communication or problem-solving).
COMMON_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Name for Human skills (aka soft skills). These are the basic skills required in nearly every job posting (e.g., communication or problem-solving).
COMPANY	VARCHAR	STRING	STRING	STRING	ID of the employer associated with the profile. IDs are from the Lightcast Company Taxonomy (taxonomy version: see the Global Profiles Meta).
COMPANY_NAME	VARCHAR	STRING	STRING	STRING	Name of the employer name associated with the profile. Names are from the Lightcast Company Taxonomy (taxonomy version: see the Global Profiles Meta).
CURRENT_OCCUPATION_YEARS_OF_EXPERIENCE	FLOAT	FLOAT	DOUBLE	FLOAT	Number of years total that the individual has been employed in their current occupation.
ESTIMATED_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Estimated number of years of work experience reflected by the profile. Derived by summing all years of employment after completion of most recent degree.
ID	VARCHAR	STRING	STRING	STRING	A unique ID generated by Lightcast which identifies the profile.
JOB_LAST_UPDATED	DATE	DATE	DATE	DATE	Date when the job information for a profile was last updated.
LAA_ADMIN_AREA_1	VARCHAR	STRING	STRING	STRING	Code of the first level administrative area associated with the profile. (Eg. US53).
LAA_ADMIN_AREA_1_NAME	VARCHAR	STRING	STRING	STRING	Name of the first level administrative area associated with the profile (Eg. Washington).
LAA_ADMIN_AREA_2	VARCHAR	STRING	STRING	STRING	Code of the second level administrative area associated with the profile. (Eg. US53063).
LAA_ADMIN_AREA_2_NAME	VARCHAR	STRING	STRING	STRING	Name of the second level administrative area associated with the profile. (Eg. Spokane)
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).
LAA_METRO	VARCHAR	STRING	STRING	STRING	Metropolitan area code of associated with the profile. (Eg. US44060).
LAA_METRO_NAME	VARCHAR	STRING	STRING	STRING	Name of the metropolitan associated with the profile. (Eg. Spokane-Spokane Valley, WA).
LOCATION_LAST_UPDATED	DATE	DATE	DATE	DATE	Date when the location information for a profile was last updated.
LOT_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: see the Global 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 Global Profiles Meta).
LOT_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Global Profiles Meta).
LOT_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the Global 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 Global Profiles Meta).
LOT_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Global Profiles Meta).
LOT_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Global 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 Global 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).
MARKET	VARCHAR	STRING	STRING	STRING	Market ID of the posting (eg DEU_M_11000A).
MARKET_NAME	VARCHAR	STRING	STRING	STRING	Market Name of the posting (eg Berlin (DEU)).
MAX_EDULEVELS	VARCHAR	STRING	STRING	STRING	ID of the highest education level listed on the profile.
MAX_EDULEVELS_NAME	VARCHAR	STRING	STRING	STRING	Name of the highest education level listed on the profile.
MOST_RECENT_COMPANY	VARCHAR	STRING	STRING	STRING	Employer for the most recent work experience on the profile.
MOST_RECENT_COMPANY_END_MONTH	VARCHAR	STRING	STRING	STRING	Month and year the individual ended employment with the most recent employer.
MOST_RECENT_COMPANY_START_MONTH	VARCHAR	STRING	STRING	STRING	Month and year the individual began employment with the most recent employer.
MOVES_IN_MOST_RECENT_COMPANY	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Number of different roles the individual moved between while employed by the most recent employer.
MOVES_IN_PREVIOUS_COMPANY	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Number of different roles the individual moved between while employed by the preceding employer.
NATION	VARCHAR	STRING	STRING	STRING	ID of the nation associated with the profile.
NATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the nation associated with the profile.
PREVIOUS_COMPANY	VARCHAR	STRING	STRING	STRING	Preceding employer listed on the profile.
PREVIOUS_COMPANY_END_MONTH	VARCHAR	STRING	STRING	STRING	Month and year the individual ended employment with the preceding employer.
PREVIOUS_COMPANY_START_MONTH	VARCHAR	STRING	STRING	STRING	Month and year the individual began employment with the preceding employer.
SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of skills associated with the profile (taxonomy version: see the US Profiles Meta).
SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of skills associated with the profile (taxonomy version: see the US Profiles Meta).
SOURCES	ARRAY	JSON	ARRAY	JSON	Profile sources that went into constituting this merged profile.
SPECIALIZED_SKILLS	ARRAY	JSON	ARRAY	JSON	ID for Technical skills (aka hard skills). These are more specialized skills for a particular job (e.g., Java or financial analysis).
SPECIALIZED_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Name for Technical skills (aka hard skills). These are more specialized skills for a particular job (e.g., Java or financial analysis).
TITLE	VARCHAR	STRING	STRING	STRING	ID of the title associated with the profile (taxonomy version: see the Global Profiles Meta).
TITLE_NAME	VARCHAR	STRING	STRING	STRING	Name of the title associated with the profile (taxonomy version: see the Global Profiles Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Raw name of the title associated with the profile (taxonomy version: see the Global Profiles Meta).
YEARS_IN_CURRENT_ROLE	FLOAT	FLOAT	DOUBLE	FLOAT	Number of concurrent years the individual has been employed by their most recent role at the most recent employer.
YEARS_OF_WORK_HISTORY	FLOAT	FLOAT	DOUBLE	FLOAT	Number of total years the individual has been employed.
YEARS_WITH_MOST_RECENT_COMPANY	FLOAT	FLOAT	DOUBLE	FLOAT	Number of concurrent years the individual has been employed by the most recent employer.
YEARS_WITH_PREVIOUS_COMPANY	FLOAT	FLOAT	DOUBLE	FLOAT	Number of concurrent years the individual was employed by the preceding employer