Postings Experimental

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.
BENEFIT	ARRAY	JSON	ARRAY	JSON	ID of the Benefits Subcategory according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_CATEGORIES	ARRAY	JSON	ARRAY	JSON	ID of the Benefits Category according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_CATEGORIES_NAME	ARRAY	JSON	ARRAY	JSON	Name of the Benefits Category according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_CATEGORY	ARRAY	JSON	ARRAY	JSON	ID of the Benefits Category according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_CATEGORY_NAME	ARRAY	JSON	ARRAY	JSON	Name of the Benefits Category according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_NAME	ARRAY	JSON	ARRAY	JSON	Name of the Benefits Subcategory according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_SUBCATEGORY	ARRAY	JSON	ARRAY	JSON	ID of the Benefits Subcategory according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BENEFIT_SUBCATEGORY_NAME	ARRAY	JSON	ARRAY	JSON	Name of the Benefits Subcategory according to the Lightcast Benefits Taxonomy (taxonomy version: see the GLOBAL Postings Meta).
BODY	VARCHAR	STRING	STRING	STRING	Job Posting Description
CANDIDATE_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of an ideal candidate for a job.
CERTIFICATIONS	ARRAY	JSON	ARRAY	JSON	IDs of certifications requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
CERTIFICATIONS_NAME	ARRAY	JSON	ARRAY	JSON	Names of certifications requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
COMMON_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of common skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
COMMON_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of common skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
COMPANY	VARCHAR	STRING	STRING	STRING	Company ID of the posting
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	Company name of the posting
COMPANY_NAME_V2	VARCHAR	STRING	STRING	STRING	Name of the job's employer. Names are from version 2 of the Lightcast Companies Taxonomy (taxonomy version: see the US Postings Meta).
COMPANY_RAW	VARCHAR	STRING	STRING	STRING	Raw company name of the posting
COMPANY_V2	VARCHAR	STRING	STRING	STRING	ID of the job's employer. IDs are from version 2 of the Lightcast Companies Taxonomy (taxonomy version: see the US Postings Meta).
CONDITIONS_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Conditions of employment.
EMPLOYER_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of the employer advertizing the job.
EMPLOYMENT_TYPE	VARCHAR	STRING	STRING	STRING	Employment type ID
EMPLOYMENT_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Employment type name
EXPIRED	DATE	DATE	DATE	DATE	Date when the posting expired
ID	VARCHAR	STRING	STRING	STRING	Posting ID
ISCED_LEVELS	ARRAY	JSON	ARRAY	JSON	International Standard Classification of Education levels
ISCED_LEVELS_NAME	ARRAY	JSON	ARRAY	JSON	International Standard Classification of Education levels names
ISCED_UK_EDLEVELS	ARRAY	JSON	ARRAY	JSON	International Standard Classification of Education UK levels
ISCED_UK_EDLEVELS_NAME	ARRAY	JSON	ARRAY	JSON	International Standard Classification of Education UK levels names
ISCED_US_CA_EDLEVELS	ARRAY	JSON	ARRAY	JSON	International Standard Classification of Education US and CA levels
ISCED_US_CA_EDLEVELS_NAME	ARRAY	JSON	ARRAY	JSON	International Standard Classification of Education US and CA levels names
ISCO_08_1	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 1 code
ISCO_08_1_NAME	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 1 name
ISCO_08_2	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 2 code
ISCO_08_2_NAME	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 2 name
ISCO_08_3	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 3 code
ISCO_08_3_NAME	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 3 name
ISCO_08_4	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 4 code
ISCO_08_4_NAME	VARCHAR	STRING	STRING	STRING	International Standard Classification of Occupations (2008) level 4 name
JOB_DESCRIPTION	VARCHAR	STRING	STRING	STRING	Description of the job.
LAA_ADMIN_AREA_1	VARCHAR	STRING	STRING	STRING
LAA_ADMIN_AREA_1_NAME	VARCHAR	STRING	STRING	STRING
LAA_ADMIN_AREA_2	VARCHAR	STRING	STRING	STRING
LAA_ADMIN_AREA_2_NAME	VARCHAR	STRING	STRING	STRING
LAA_COUNTRY	VARCHAR	STRING	STRING	STRING
LAA_COUNTRY_NAME	VARCHAR	STRING	STRING	STRING
LAA_METRO	VARCHAR	STRING	STRING	STRING
LAA_METRO_NAME	VARCHAR	STRING	STRING	STRING
LANGUAGE	VARCHAR	STRING	STRING	STRING	ISO Language Code of the Job Text
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.
LOCATION_RAW	VARCHAR	STRING	STRING	STRING	Raw scraped location of this posting
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_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).
MAX_YEARS_EXPERIENCE	VARCHAR	STRING	STRING	STRING	Maximum years of experience requested in the posting
MIN_YEARS_EXPERIENCE	VARCHAR	STRING	STRING	STRING	Minimum years of experience requested in the posting
NACE_REVISION2_1	VARCHAR	STRING	STRING	STRING	NACE classification
NACE_REVISION2_1_NAME	VARCHAR	STRING	STRING	STRING	NACE classification
NACE_REVISION2_2	VARCHAR	STRING	STRING	STRING
NACE_REVISION2_2_NAME	VARCHAR	STRING	STRING	STRING	NACE classification
NACE_RULE	VARCHAR	STRING	STRING	STRING	NACE classification
NACE_SCORE	VARCHAR	STRING	STRING	STRING	NACE classification
NACE_SIMILARITY	VARCHAR	STRING	STRING	STRING	NACE classification
NAICS2	VARCHAR	STRING	STRING	STRING	Level 2 NAICS code of the posting
NAICS2_NAME	VARCHAR	STRING	STRING	STRING	Level 2 NAICS name of the posting
NATION_ISO2_COUNTRY	VARCHAR	STRING	STRING	STRING
NATION_ISO2_COUNTRY_NAME	VARCHAR	STRING	STRING	STRING
NUTS_2021_1	VARCHAR	STRING	STRING	STRING	Level 1 NUTS code of the posting
NUTS_2021_1_NAME	VARCHAR	STRING	STRING	STRING	Level 1 NUTS name of the posting
NUTS_2021_2	VARCHAR	STRING	STRING	STRING	Level 2 NUTS code of the posting
NUTS_2021_2_NAME	VARCHAR	STRING	STRING	STRING	Level 2 NUTS name of the posting
ORIGINAL_CURRENCY	VARCHAR	STRING	STRING	STRING	Currency that advertised salary was originally published in prior to conversion to USD
ORIGINAL_PAY_PERIOD	VARCHAR	STRING	STRING	STRING	Original pay period of the posting
ORIGINAL_SALARY_AVERAGE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Average advertised salary found in the posting in its originally published currency
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
REMOTE_TYPE	VARCHAR	STRING	STRING	STRING	Remote type ID
REMOTE_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Remote type name
SALARY_AVERAGE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Average advertised salary found in the posting and converted to USD
SALARY_FROM	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Minimum advertised salary found in the posting and converted to USD
SALARY_TO	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Maximum advertised salary found in the posting and converted to USD
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	IDs of software skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
SOFTWARE_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of software skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
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	IDs of specialized skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
SPECIALIZED_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of specialized skills requested in the posting (taxonomy version: see the GLOBAL Postings Meta).
TITLE	VARCHAR	STRING	STRING	STRING	Emsi Job title ID of the posting (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	Emsi Job title name of the posting (taxonomy version: see the GLOBAL Postings Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Raw job title name of the posting
TRANSLATED_TITLE	VARCHAR	STRING	STRING	STRING	Translated title
URL	VARCHAR	STRING	STRING	STRING	URL of the job posting