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.
CERTIFICATIONS_RAW	ARRAY	JSON	ARRAY	JSON	Array of certifications.
CITY	VARCHAR	STRING	STRING	STRING	ID of the city for the profile’s reported place of residence.
CITY_NAME	VARCHAR	STRING	STRING	STRING	Name of the city for the profile’s reported place of residence.
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).
COMPANY_NAME_V2	VARCHAR	STRING	STRING	STRING	Name of the jobs employer. Names are from version 2 of the Lightcast Companies Taxonomy (taxonomy version: see the Global Profiles Meta).
COMPANY_V2	VARCHAR	STRING	STRING	STRING	ID of the jobs employer. IDs are from version 2 of the Lightcast Companies Taxonomy (taxonomy version: see the Global Profiles Meta).
COMPANY_WEBSITE	VARCHAR	STRING	STRING	STRING	Website URL of the employer associated with the profile.
COMPANY_WEBSITE_V2	VARCHAR	STRING	STRING	STRING	Website URL of the employer associated with the profile. Currently mirrors Company Website; will be sourced from Company Hub once available.
COMPLETION_SCORE	FLOAT	FLOAT	DOUBLE	FLOAT	Fraction of 11 equally-weighted base-profile components that are populated, from 0.00 to 1.00. Components: summary, at least one email, at least one phone number, and - on the profile's representative job - raw job title, raw company, raw job description and job start date, plus country, city or locality, at least one education record and at least one skill. Only information supplied by the source profile counts; Lightcast tagging and enrichment do not raise the score.
CURRENT_OCCUPATION_YEARS_OF_EXPERIENCE	FLOAT	FLOAT	DOUBLE	FLOAT	Number of years total that the individual has been employed in their current occupation.
DESCRIPTION_RAW	VARCHAR	STRING	STRING	STRING	Raw job description associated with the profile.
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.
ISCO_08_1	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	1-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_1_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 1-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_2	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	2-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_3	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	3-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_4	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	4-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
ISCO_08_4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit ISCO-08 occupation code of the job (taxonomy version: see the Global Profiles Meta).
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 for the profile’s reported place of residence (Eg. US53).
LAA_ADMIN_AREA_1_NAME	VARCHAR	STRING	STRING	STRING	Name of the first level administrative area for the profile’s reported place of residence (Eg. Washington).
LAA_ADMIN_AREA_2	VARCHAR	STRING	STRING	STRING	Code of the second level administrative area for the profile’s reported place of residence (Eg. US53063).
LAA_ADMIN_AREA_2_NAME	VARCHAR	STRING	STRING	STRING	Name of the second level administrative area for the profile’s reported place of residence (Eg. Spokane).
LAA_COUNTRY	VARCHAR	STRING	STRING	STRING	2-digit country code for the profile’s reported place of residence (Eg. US).
LAA_COUNTRY_NAME	VARCHAR	STRING	STRING	STRING	Name of the country for the profile’s reported place of residence (Eg. United States).
LAA_METRO	VARCHAR	STRING	STRING	STRING	Metropolitan area code for the profile’s reported place of residence (Eg. US44060).
LAA_METRO_NAME	VARCHAR	STRING	STRING	STRING	Name of the metropolitan area for the profile’s reported place of residence (Eg. Spokane-Spokane Valley, WA).
LAST_CONTACT_UPDATE_DATE	DATE	DATE	DATE	DATE	Date of the last update to contact information (email, phone, social). Changes tracked since February 2026 pipeline run.
LAST_EDUCATION_UPDATE_DATE	DATE	DATE	DATE	DATE	Date of the last update to education records (degree, institution, credential). Changes tracked since February 2026 pipeline run.
LAST_EXTERNAL_JOB_CHANGE_DATE	DATE	DATE	DATE	DATE	Date of the last external job change (company switch).
LAST_INTERNAL_JOB_CHANGE_DATE	DATE	DATE	DATE	DATE	Date of the last internal job change (promotion/lateral move) within the same employer.
LAST_PROFILE_UPDATE_DATE	DATE	DATE	DATE	DATE	Date of the last non-trivial update to the profile. Changes tracked since February 2026 pipeline run.
LAST_SKILLS_UPDATE_DATE	DATE	DATE	DATE	DATE	Date of the last update to normalized skills set. Changes tracked since February 2026 pipeline run.
LOCATION	OBJECT	JSON	STRING	STRING	The latitude/longitude coordinates associated with the profile location.
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_LEVEL	VARCHAR	STRING	STRING	STRING	Level ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Global Profiles Meta).
LOT_OCCUPATION_LEVEL_NAME	VARCHAR	STRING	STRING	STRING	Level name of the Occupation 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_LEVEL	VARCHAR	STRING	STRING	STRING	Level ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: LOT v7).
LOT_V7_OCCUPATION_LEVEL_NAME	VARCHAR	STRING	STRING	STRING	Level name of the Occupation 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).
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_NAME	VARCHAR	STRING	STRING	STRING	Employer for the most recent work experience on the profile.
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.
NAICS2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the job (taxonomy version: see the Global Profiles Meta).
NAICS2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the job (taxonomy version: see Global Profiles Meta).
NAICS3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the job (taxonomy version: see the Global Profiles Meta).
NAICS3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the job (taxonomy version: NAICS 2022).
NAICS_2022_2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the job (taxonomy version: NAICS 2022).
NAICS_2022_2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the job (taxonomy version: NAICS 2022).
NAICS_2022_3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the job (taxonomy version: NAICS 2022).
NAICS_2022_3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the job (taxonomy version: NAICS 2022).
PATENTS	ARRAY	JSON	ARRAY	JSON	Array of patents.
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_NAME	VARCHAR	STRING	STRING	STRING	Preceding employer listed on the profile.
PREVIOUS_COMPANY_START_MONTH	VARCHAR	STRING	STRING	STRING	Month and year the individual began employment with the preceding employer.
PROFILE_LANGUAGES	ARRAY	JSON	ARRAY	JSON	Array of languages spoken by the profile.
PROFILE_LAST_SEEN_DATE	DATE	DATE	DATE	DATE	Date of the last observed online activity of the profile.
PROFILE_TAGS	ARRAY	JSON	ARRAY	JSON	Array of descriptive tags linked to the profile.
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).
SUMMARY	VARCHAR	STRING	STRING	STRING	Summary of the profile.
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