New v2.0.0 for the Technographics dataset

Includes new columns, and renames some existing ones for consistency. Now includes columns for the 3 current sources of technographics data we have: - Job titles - Job descriptions - Job URLs

Here are the columns which name has changed or have been added.

The following columns are renamed:

• technology_id → keyword_id
• technology_rank → technology_rank_source_jobs
• technology_rank_180_days → technology_rank_180_days_source_jobs
• rank_1_tie → rank_1_tie_source_jobs
• rank_180_days_tie → rank_180_days_tie_source_jobs
• relative_occurrence_within_category → relative_occurrence_within_category_source_jobs
• jobs_source_final_url → jobs_source_url
• first_date_found_source_final_url → first_date_found_source_job_url
• last_date_found_source_final_url → last_date_found_source_job_url

The following columns are added:

• keyword_slug - Slug identifier for the technology
• subcategory_slug - Slug identifier for the technology subcategory
• is_recruiting_agency - Indicates if the company is a recruiting agency
• jobs_source_description_last_180_days - Number of jobs mentioning this technology in the job description in the last 180 days
• jobs_source_description_last_30_days - Number of jobs mentioning this technology in the job description in the last 30 days
• jobs_source_description_last_7_days - Number of jobs mentioning this technology in the job description in the last 7 days
• jobs_source_title - Number of jobs mentioning this technology in the job title
• jobs_source_title_last_180_days - Number of jobs mentioning this technology in the job title in the last 180 days
• jobs_source_title_last_30_days - Number of jobs mentioning this technology in the job title in the last 30 days
• jobs_source_title_last_7_days - Number of jobs mentioning this technology in the job title in the last 7 days
• jobs_source_url_last_180_days - Number of jobs mentioning this technology in the ATS URL in the last 180 days
• jobs_source_url_last_30_days - Number of jobs mentioning this technology in the ATS URL in the last 30 days
• jobs_source_url_last_7_days - Number of jobs mentioning this technology in the ATS URL in the last 7 days
• first_date_found_source_job_title - Date when the job title first mentioned the technology
• last_date_found_source_job_title - Date when the job title last mentioned the technology
• rank_last_date_found_source_job_url - Rank of the technology within its category based on mentions in job ATS URLs as of the last date found
• relative_occurrence_within_category_180_days_source_jobs - Measures the relative occurrence of this technology among other technologies in the same category, in jobs by this company over the last 180 days