GLOBAL POSTINGS

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
ACTIVE_SOURCES_INFO	ARRAY	JSON	ARRAY	JSON	Source information for each active url.
ACTIVE_URLS	ARRAY	JSON	ARRAY	JSON	URLs for the job posting that are determined to be active at the time of the last periodic check.
BODY	VARCHAR	STRING	STRING	STRING	Job Posting Description
CERTIFICATIONS	ARRAY	JSON	ARRAY	JSON	Certifications by ID included in the posting.
CERTIFICATIONS_NAME	ARRAY	JSON	ARRAY	JSON	Certifications by Name included in the posting.
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	The standardized ID of the job’s employer.
COMPANY_IS_STAFFING	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Indicates whether the job's employer is a staffing or recruitement company.
COMPANY_NAME	VARCHAR	STRING	STRING	STRING	The standardized Name of the job’s employer.
COMPANY_RAW	VARCHAR	STRING	STRING	STRING	Raw company name of the posting
EXPIRED	DATE	DATE	DATE	DATE	Date posting expired (eg 2017-05-04).
ID	VARCHAR	STRING	STRING	STRING	A unique ID generated by Lightcast which identifies the job advertisement.
ISCO_08_1	VARCHAR	STRING	STRING	STRING	Level 1 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_1_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the level 1 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_2	VARCHAR	STRING	STRING	STRING	Level 2 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the level 2 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_3	VARCHAR	STRING	STRING	STRING	Level 3 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the level 3 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_4	VARCHAR	STRING	STRING	STRING	Level 4 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
ISCO_08_4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the level 4 ISCO-08 code for the occupation (taxonomy version: ISCO-08).)
LAA_ADMIN_AREA_1	VARCHAR	STRING	STRING	STRING	Code of the first level administrative area where the posting is located. (Eg. US53).
LAA_ADMIN_AREA_1_NAME	VARCHAR	STRING	STRING	STRING	Name of the first level administrative area where the posting is located. (Eg. Washington).
LAA_ADMIN_AREA_2	VARCHAR	STRING	STRING	STRING	Code of the second level administrative area where the posting is located. (Eg. US53063)
LAA_ADMIN_AREA_2_NAME	VARCHAR	STRING	STRING	STRING	Name of the second level administrative area where the posting is located. (Eg. Spokane)
LAA_COUNTRY	VARCHAR	STRING	STRING	STRING	2-digit country code where the posting is located. (Eg. US).
LAA_COUNTRY_NAME	VARCHAR	STRING	STRING	STRING	Name of the country where the posting is located. (Eg. United States)
LAA_METRO	VARCHAR	STRING	STRING	STRING	Metropolitan area code of where the posting is located. (Eg. US44060)
LAA_METRO_NAME	VARCHAR	STRING	STRING	STRING	Name of the metropolitan area of the posting. (Eg. Spokane-Spokane Valley, WA)
LANGUAGE	VARCHAR	STRING	STRING	STRING	The detected language of the BODY field.
LAST_UPDATED_TIMESTAMP	TIMESTAMP_TZ	TIMESTAMP	TIMESTAMP	TIMESTAMP_TZ	Timestamp when the posting enrichments or other fields were modified on this posting (in UTC time).
LOCATION	OBJECT	JSON	STRING	STRING	Approximate lat/lon of the job posting based on the city.
LOT_CAREER_AREA	VARCHAR	STRING	STRING	STRING	ID of the Career Area according to the Lightcast Occupation Taxonomy (taxonomy version: see the GLOBAL Postings 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 Postings Meta).
LOT_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
LOT_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the GLOBAL Postings 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 Postings Meta).
LOT_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
LOT_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the GLOBAL Postings 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 Postings 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_YEARS_EXPERIENCE	VARCHAR	STRING	STRING	STRING	Maximum years of experience listed in the posting (if mentioned).
MIN_YEARS_EXPERIENCE	VARCHAR	STRING	STRING	STRING	Minimum years of experience listed in the posting (if mentioned).
NAICS2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS4	VARCHAR	STRING	STRING	STRING	4-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS5	VARCHAR	STRING	STRING	STRING	5-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS6	VARCHAR	STRING	STRING	STRING	6-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS6_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 6-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS_2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the posting (taxonomy version: see the US Postings Meta).
NAICS_2017_2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_4	VARCHAR	STRING	STRING	STRING	4-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_5	VARCHAR	STRING	STRING	STRING	5-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_6	VARCHAR	STRING	STRING	STRING	6-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2017_6_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 6-digit NAICS code of the posting (taxonomy version: NAICS 2017).
NAICS_2022_2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_4	VARCHAR	STRING	STRING	STRING	4-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_5	VARCHAR	STRING	STRING	STRING	5-digit NAICS code of the posting (taxonomy version: NAICS 2022).
NAICS_2022_5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NAICS code of the posting (taxonomy version: NAICS 2022).
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	Nation ID of the posting (eg DEU).
NATION_NAME	VARCHAR	STRING	STRING	STRING	Nation Name of the posting (eg Germany
ORIGINAL_CURRENCY	VARCHAR	STRING	STRING	STRING	The national currency denomination in which the job posting advertised a salary range (which we then convert to USD for the standardized salary fields) eg EUR or GBP.
ORIGINAL_PAY_PERIOD	VARCHAR	STRING	STRING	STRING	The time unit of the advertised - and, therefore, pre-annualized - salary.
ORIGINAL_SALARY_AVERAGE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Midpoint between the upper and lower bounds, in the originally advertised currency denomination.
ORIGINAL_SALARY_FROM	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized lower bound of advertised salary in a job post, in the originally advertised currency denomination.
ORIGINAL_SALARY_TO	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized upper bound of advertised salary in a job post, in the originally advertised currency denomination.
POSTED	DATE	DATE	DATE	DATE	Date when the posting was created (eg 2017-03-29).
REMOTE_TYPE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	ID of the remote type.
REMOTE_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Name of the Remote type
SALARY_AVERAGE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized average advertised salary found in the posting.
SALARY_FROM	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized lower bound of advertised salary.
SALARY_TO	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized upper bound of advertised salary.
SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
SOFTWARE_SKILLS	ARRAY	JSON	ARRAY	JSON	ID of any skills that are also identified as Software or Programming Languages.
SOFTWARE_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of any skills that are also identified as Software or Programming Languages.
SOURCES	ARRAY	JSON	ARRAY	JSON	Source websites for the posting.
SOURCE_TYPES	ARRAY	JSON	ARRAY	JSON	The set of distinct types of the sources. Being distinct this array is not intended for matching a source type to a source but rather as a guide to what kinds of sources have displayed the posting.
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	Title ID according to the normalized Lightcast Title Library (taxonomy version: see the GLOBAL Postings Meta).
TITLE_CLEAN	VARCHAR	STRING	STRING	STRING	The cleaned - but not normalized - job title.
TITLE_NAME	VARCHAR	STRING	STRING	STRING	Title Name according to the normalized Lightcast Title Library (taxonomy version: see the GLOBAL Postings Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Title that is stated as such on the individual job posting.
URL	VARCHAR	STRING	STRING	STRING	URL of the job posting