CA POSTINGS (NO BODY)

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).
CD	VARCHAR	STRING	STRING	STRING	ID of the Census District (taxonomy version: see the CA Postings Meta).
CD_2016	VARCHAR	STRING	STRING	STRING	ID of the Census District (taxonomy version: SGC 2016).
CD_2016_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census District (taxonomy version: SGC 2016).
CD_2021	VARCHAR	STRING	STRING	STRING	ID of the Census District (taxonomy version: SGC 2021).
CD_2021_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census District (taxonomy version: SGC 2021).
CD_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census District (taxonomy version: see the CA Postings Meta).
CERTIFICATIONS	ARRAY	JSON	ARRAY	JSON	IDs of certifications included in the posting. IDs are from the latest Skills Taxonomy (taxonomy version: see the CA 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 CA Postings Meta).
CIP2	ARRAY	JSON	ARRAY	JSON	2-digit CIP code of any educational requirements mentioned.
CIP2_NAME	ARRAY	JSON	ARRAY	JSON	Name belonging to the 2-digit CIP code(s) of any educational requirements mentioned.
CIP4	ARRAY	JSON	ARRAY	JSON	4-digit CIP code of any educational requirements mentioned.
CIP4_NAME	ARRAY	JSON	ARRAY	JSON	Name belonging to the 4-digit CIP code(s) of any educational requirements mentioned.
CITY	VARCHAR	STRING	STRING	STRING	ID of the city in which a job is located. Neighborhoods within a city are standardized to the city name.
CITY_NAME	VARCHAR	STRING	STRING	STRING	Name of the city in which a job is located. Neighborhoods within a city are standardized to the city name.
CMA	VARCHAR	STRING	STRING	STRING	ID of the Census Metropolitan Area (taxonomy version: see the CA Postings Meta).
CMA_2016	VARCHAR	STRING	STRING	STRING	ID of the Census Metropolitan Area (taxonomy version: SGC 2016).
CMA_2016_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census Metropolitan Area (taxonomy version: SGC 2016).
CMA_2021	VARCHAR	STRING	STRING	STRING	ID of the Census Metropolitan Area (taxonomy version: SGC 2021).
CMA_2021_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census Metropolitan Area (taxonomy version: SGC 2021).
CMA_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census Metropolitan Area (taxonomy version: see the CA Postings Meta).
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 CA 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 CA 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 CA Postings Meta).
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	Name of the job’s employer. Names are from the latest Lightcast Companies Taxonomy (taxonomy version: see the CA Postings Meta).
COMPANY_RAW	VARCHAR	STRING	STRING	STRING	The raw name of the job’s employer.
CSD	VARCHAR	STRING	STRING	STRING	Name of the Census Subdivision (taxonomy version: see the CA Postings Meta).
CSD_2016	VARCHAR	STRING	STRING	STRING	Name of the Census Subdivision (taxonomy version: SGC 2016).
CSD_2016_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census Subdivision (taxonomy version: SGC 2016).
CSD_2021	VARCHAR	STRING	STRING	STRING	Name of the Census Subdivision (taxonomy version: SGC 2021).
CSD_2021_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census Subdivision (taxonomy version: SGC 2021).
CSD_NAME	VARCHAR	STRING	STRING	STRING	Name of the Census Subdivision (taxonomy version: see the CA Postings Meta).
DUPLICATES	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Specifies the quantity of duplicate posts found for the individual job.
EDUCATION_LEVELS	ARRAY	JSON	ARRAY	JSON	IDs for the level(s) of education required and/or preferred in job posts.
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.
IS_INTERNSHIP	BOOLEAN	BOOLEAN	BOOLEAN	BOOLEAN	Specifies whether the job is an internship.
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 CA 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 CA Postings Meta).
LOT_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the CA Postings Meta).
LOT_OCCUPATION_GROUP	VARCHAR	STRING	STRING	STRING	ID of the Occupation Group according to the Lightcast Occupation Taxonomy (taxonomy version: see the CA 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 CA Postings Meta).
LOT_OCCUPATION_NAME	VARCHAR	STRING	STRING	STRING	Name of the Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the CA Postings Meta).
LOT_SPECIALIZED_OCCUPATION	VARCHAR	STRING	STRING	STRING	ID of the Specialized Occupation according to the Lightcast Occupation Taxonomy (taxonomy version: see the CA 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 CA 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).
MAX_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Maximum years of experience listed in the posting (if mentioned).
MIN_YEARS_EXPERIENCE	NUMBER	BIGNUMERIC	DECIMAL	DECIMAL	Minimum years of experience listed in the posting (if mentioned).
NAICS2	VARCHAR	STRING	STRING	STRING	2-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS3	VARCHAR	STRING	STRING	STRING	3-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS4	VARCHAR	STRING	STRING	STRING	4-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS5	VARCHAR	STRING	STRING	STRING	5-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS6	VARCHAR	STRING	STRING	STRING	6-digit NAICS code of the posting (taxonomy version: see the CA Postings Meta).
NAICS6_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 6-digit NAICS code of the posting (taxonomy version: see the CA 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).
NOC1	VARCHAR	STRING	STRING	STRING	1-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC1_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 1-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC2	VARCHAR	STRING	STRING	STRING	2-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC3	VARCHAR	STRING	STRING	STRING	3-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC4	VARCHAR	STRING	STRING	STRING	4-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC5	VARCHAR	STRING	STRING	STRING	5-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NOC code of the posting. (taxonomy version: see the CA Postings Meta).
NOC_2021_1	VARCHAR	STRING	STRING	STRING	1-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_1_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 1-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_2	VARCHAR	STRING	STRING	STRING	2-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_2_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 2-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_3	VARCHAR	STRING	STRING	STRING	3-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_3_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 3-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_4	VARCHAR	STRING	STRING	STRING	4-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_4_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 4-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_5	VARCHAR	STRING	STRING	STRING	5-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
NOC_2021_5_NAME	VARCHAR	STRING	STRING	STRING	Name belonging to the 5-digit NOC code of the posting (taxonomy version: Canada NOC 2021).
ORIGINAL_PAY_PERIOD	VARCHAR	STRING	STRING	STRING	The time unit of the advertised - and, therefore, pre-annualized - salary.
POSTED	DATE	DATE	DATE	DATE	Date when the posting was created (eg 2017-03-29).
PROVINCE	VARCHAR	STRING	STRING	STRING	ID of the province (taxonomy version: see the CA Postings Meta).
PROVINCE_2016	VARCHAR	STRING	STRING	STRING	ID of the province (taxonomy version: SGC 2016).
PROVINCE_2016_NAME	VARCHAR	STRING	STRING	STRING	Name of the province (taxonomy version: SGC 2016).
PROVINCE_2021	VARCHAR	STRING	STRING	STRING	ID of the province (taxonomy version: SGC 2021).
PROVINCE_2021_NAME	VARCHAR	STRING	STRING	STRING	Name of the province (taxonomy version: SGC 2021).
PROVINCE_NAME	VARCHAR	STRING	STRING	STRING	Name of the province (taxonomy version: see the CA Postings Meta).
REMOTE_TYPE	VARCHAR	STRING	STRING	STRING	ID of the remote type.
REMOTE_TYPE_NAME	VARCHAR	STRING	STRING	STRING	Name of the remote type.
SALARY	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. IDs are from the latest Lightcast Skills Taxonomy (taxonomy version: see the CA 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 CA 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 CA 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 CA 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 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 CA 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 CA Postings Meta).
TITLE	VARCHAR	STRING	STRING	STRING	ID of the title. IDs are from the latest Lightcast Title Taxonomy (taxonomy version: see the CA Postings Meta).
TITLE_CLEAN	VARCHAR	STRING	STRING	STRING	The cleaned - but not normalized - job title.
TITLE_NAME	VARCHAR	STRING	STRING	STRING	Name of the title. Names are from the latest Lightcast Title Taxonomy (taxonomy version: see the CA Postings Meta).
TITLE_RAW	VARCHAR	STRING	STRING	STRING	Raw job title stated on the individual job posting.
URL	ARRAY	JSON	ARRAY	JSON	URL of the unique job posting (not recommended as a job source feed).