Postings

Column Name	Snowflake	Big Query	Databricks	Parquet	Comment
BODY	VARCHAR	STRING	STRING	STRING	Full text of the posting from the source.
CERTIFICATIONS	ARRAY	JSON	ARRAY	JSON	IDs of certifications included in the posting. IDs are from the latest Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
CERTIFICATIONS_NAME	ARRAY	JSON	ARRAY	JSON	Names of certifications included in the posting. Names are from the latest Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
CITY	VARCHAR	STRING	STRING	STRING	ID of the city in which a job is located.
CITY_NAME	VARCHAR	STRING	STRING	STRING	Name of the city in which a job is located.
COMMON_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs for human skills (aka soft skills) included in the posting. These are the basic skills required in nearly every job posting (eg , communication or problem-solving). IDs are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
COMMON_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names for human skills (aka soft skills) included in the posting. These are the basic skills required in nearly every job posting (eg , communication or problem-solving). Names are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
COMPANY	VARCHAR	STRING	STRING	STRING	ID of the job’s employer. IDs are from the latest Lightcast Companies Taxonomy (taxonomy version: see the Company Direct Postings Meta).
COMPANY_NAME	VARCHAR	STRING	STRING	STRING	Name of the job’s employer. Names are from the latest Lightcast Companies Taxonomy (taxonomy version: see the Company Direct Postings Meta).
COMPANY_RAW_NAME	VARCHAR	STRING	STRING	STRING	Raw name of the job's employer.
EDUCATION_LEVELS	ARRAY	JSON	ARRAY	JSON	IDs for the level(s) of education required and/or preferred in job posts.
EDUCATION_LEVELS_MAX	VARCHAR	STRING	STRING	STRING	ID of the maximum education level requested in the posting.
EDUCATION_LEVELS_MAX_NAME	VARCHAR	STRING	STRING	STRING	Name of the maximum education level requested in the posting.
EDUCATION_LEVELS_MIN	VARCHAR	STRING	STRING	STRING	ID of the minimum education level requested in the posting.
EDUCATION_LEVELS_MIN_NAME	VARCHAR	STRING	STRING	STRING	Name of the minimum education level requested in the posting.
EDUCATION_LEVELS_NAME	ARRAY	JSON	ARRAY	JSON	Names for the level(s) of education required and/or preferred in job posts.
EMPLOYMENT_TYPE	VARCHAR	STRING	STRING	STRING	ID of the type of employment specified in the posting. Specifies whether this job is full time, part time, or possibly either.
EMPLOYMENT_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Name of the type of employment specified in the posting. Specifies whether this job is full time, part time, or possibly either. Possible values: Full-time (> 32 hours), Part-time (≤ 32 hours), Part-time / full-time.
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.
ID_FROM_SOURCE	VARCHAR	STRING	STRING	STRING	The ID as provided by the source.
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 Company Direct 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 Company Direct Postings Meta).
LOT_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Company Direct Postings Meta).
LOT_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the Company Direct 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 Company Direct Postings Meta).
LOT_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Company Direct Postings Meta).
LOT_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the Company Direct 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 Company Direct Postings Meta).
MAX_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Maximum years of experience listed in the posting.
MIN_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Minimum years of experience listed in the posting.
NAICS2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS4	VARCHAR	STRING	STRING	STRING	4-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS5	VARCHAR	STRING	STRING	STRING	5-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS6	VARCHAR	STRING	STRING	STRING	6-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
NAICS6_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 6-digit NAICS code of the posting (taxonomy version: see the Company Direct Postings Meta).
ONET	VARCHAR	STRING	STRING	STRING	ONET code of the posting (taxonomy version: see the Company Direct Postings Meta).
ONET_NAME	VARCHAR	STRING	STRING	STRING	ONET name of the posting (taxonomy version: see the Company Direct Postings Meta).
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	Annualized lower bound of advertised salary in a job post, in the originally advertised currency denomination.
ORIGINAL_SALARY_FROM	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	-
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	VARCHAR	STRING	STRING	STRING	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 converted to USD.
SALARY_FROM	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized lower bound of advertised salary converted to USD.
SALARY_TO	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Annualized upper bound of advertised salary converted to USD.
SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of skills requested in the posting. IDs are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of skills requested in the posting. Names are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
SOFTWARE_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs of any skills that are identified as Software or Programming Languages. IDs are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
SOFTWARE_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names of any skills that are identified as Software or Programming Languages. Names are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
SOURCE	Varchar	STRING	STRING	STRING	Source website for the posting.
SPECIALIZED_SKILLS	ARRAY	JSON	ARRAY	JSON	IDs for technical skills (aka hard skills). These are more specialized skills for a particular job (eg , Java or financial analysis). IDs are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
SPECIALIZED_SKILLS_NAME	ARRAY	JSON	ARRAY	JSON	Names for technical skills (aka hard skills). These are more specialized skills for a particular job (eg , Java or financial analysis). Names are from the latest Lightcast Skills Taxonomy (taxonomy version: see the Company Direct Postings Meta).
TITLE	VARCHAR	STRING	STRING	STRING	ID of the title. IDs are from the latest Lightcast Title Taxonomy (taxonomy version: see the Company Direct Postings Meta).
TITLE_NAME	VARCHAR	STRING	STRING	STRING	Name of the title. Names are from the latest Lightcast Title Taxonomy (taxonomy version: see the Company Direct Postings Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Raw job title stated on the individual job posting.
URL	VARCHAR	STRING	STRING	STRING	URL of the job posting.