Dictionary
Complete reference for 41 technographic fields tracking company technology adoption through job postings, including v2 schema and migration guide from v1
Technographics v2
| Column | Type | Description | Fill Rate |
|---|---|---|---|
| company_id | str | ID of the company, meant to be used only as a join key between the company and the company_technologies datasets. Will change in the future | 100.00% |
| keyword_id | int | ID of the technology (previously called technology_id) | 100.00% |
| keyword_slug | str | Slug identifier for the technology (new in v2) | 100.00% |
| company_name | str | Company name | 100.00% |
| subcategory_slug | str | Slug identifier for the technology subcategory (new in v2) | 100.00% |
| is_recruiting_agency | bool | Indicates if the company is a recruiting agency (new in v2) | 100.00% |
| confidence | str | How confident we are that the company uses this technology | 100.00% |
| jobs | int | Total number of jobs found mentioning this technology across all sources | 100.00% |
| jobs_last_180_days | int | Total number of jobs from the given company mentioning this technology in the last 180 days across all sources | 100.00% |
| jobs_last_30_days | int | Total number of jobs from the given company mentioning this technology in the last 30 days across all sources | 100.00% |
| jobs_last_7_days | int | Total number of jobs from the given company mentioning this technology in the last 7 days across all sources | 100.00% |
| jobs_source_description | int | Number of jobs from the given company mentioning this technology in the job description (new in v2) | 100.00% |
| jobs_source_description_last_180_days | int | Number of jobs from the given company mentioning this technology in the job description in the last 180 days (new in v2) | 100.00% |
| jobs_source_description_last_30_days | int | Number of jobs from the given company mentioning this technology in the job description in the last 30 days (new in v2) | 100.00% |
| jobs_source_description_last_7_days | int | Number of jobs from the given company mentioning this technology in the job description in the last 7 days (new in v2) | 100.00% |
| jobs_source_title | int | Number of jobs from the given company mentioning this technology in the job title (new in v2) | 100.00% |
| jobs_source_title_last_180_days | int | Number of jobs from the given company mentioning this technology in the job title in the last 180 days (new in v2) | 100.00% |
| jobs_source_title_last_30_days | int | Number of jobs from the given company mentioning this technology in the job title in the last 30 days (new in v2) | 100.00% |
| jobs_source_title_last_7_days | int | Number of jobs from the given company mentioning this technology in the job title in the last 7 days (new in v2) | 100.00% |
| jobs_source_url | int | Number of jobs from the given company mentioning this technology in the ATS URL (previously called jobs_source_final_url) | 100.00% |
| jobs_source_url_last_180_days | int | Number of jobs from the given company mentioning this technology in the ATS URL in the last 180 days (new in v2) | 100.00% |
| jobs_source_url_last_30_days | int | Number of jobs from the given company mentioning this technology in the ATS URL in the last 30 days (new in v2) | 100.00% |
| jobs_source_url_last_7_days | int | Number of jobs from the given company mentioning this technology in the ATS URL in the last 7 days (new in v2) | 100.00% |
| first_date_found | date | Date when the technology was first mentioned by the company in a job post, across all sources | 100.00% |
| last_date_found | date | Date when the technology was last mentioned by the company in a job post, across all sources | 100.00% |
| first_date_found_source_job_description | date | Date when the job description first mentioned the technology | 100.00% |
| last_date_found_source_job_description | date | Date when the job description last mentioned the technology | 100.00% |
| first_date_found_source_job_title | date | Date when the job title first mentioned the technology (new in v2) | 100.00% |
| last_date_found_source_job_title | date | Date when the job title last mentioned the technology (new in v2) | 100.00% |
| first_date_found_source_job_url | date | Date when the job ATS URL first mentioned the technology (previously called first_date_found_source_final_url) | 100.00% |
| last_date_found_source_job_url | date | Date when the job ATS URL last mentioned the technology (previously called last_date_found_source_final_url) | 100.00% |
| technology_rank_source_jobs | float | Rank of the technology within its category based on mentions in job postings (previously called technology_rank) | 100.00% |
| technology_rank_180_days_source_jobs | float | Rank of the technology within its category based on mentions in job postings over the last 180 days (previously called technology_rank_180_days) | 100.00% |
| rank_last_date_found_source_job_url | float | Rank of the technology within its category based on mentions in job ATS URLs as of the last date found (new in v2) | 100.00% |
| rank_1_tie_source_jobs | bool | Indicates if this technology is tied for the most mentioned in its category (previously called rank_1_tie) | 100.00% |
| rank_180_days_tie_source_jobs | bool | Indicates if this technology is tied for the most mentioned in its category over the last 180 days (previously called rank_180_days_tie) | 100.00% |
| relative_occurrence_within_category_source_jobs | float | Measures the relative occurrence of this technology among other technologies in the same category, in jobs by this company (previously called relative_occurrence_within_category) | 100.00% |
| relative_occurrence_within_category_180_days_source_jobs | float | Measures the relative occurrence of this technology among other technologies in the same category, in jobs by this company over the last 180 days (new in v2) | 100.00% |
Differences from v1.0.0
The following columns are renamed:
technology_id→keyword_idtechnology_rank→technology_rank_source_jobstechnology_rank_180_days→technology_rank_180_days_source_jobsrank_1_tie→rank_1_tie_source_jobsrank_180_days_tie→rank_180_days_tie_source_jobsrelative_occurrence_within_category→relative_occurrence_within_category_source_jobsjobs_source_final_url→jobs_source_urlfirst_date_found_source_final_url→first_date_found_source_job_urllast_date_found_source_final_url→last_date_found_source_job_url
The following columns are added:
keyword_slug- Slug identifier for the technologysubcategory_slug- Slug identifier for the technology subcategoryis_recruiting_agency- Indicates if the company is a recruiting agencyjobs_source_description_last_180_days- Number of jobs mentioning this technology in the job description in the last 180 daysjobs_source_description_last_30_days- Number of jobs mentioning this technology in the job description in the last 30 daysjobs_source_description_last_7_days- Number of jobs mentioning this technology in the job description in the last 7 daysjobs_source_title- Number of jobs mentioning this technology in the job titlejobs_source_title_last_180_days- Number of jobs mentioning this technology in the job title in the last 180 daysjobs_source_title_last_30_days- Number of jobs mentioning this technology in the job title in the last 30 daysjobs_source_title_last_7_days- Number of jobs mentioning this technology in the job title in the last 7 daysjobs_source_url_last_180_days- Number of jobs mentioning this technology in the ATS URL in the last 180 daysjobs_source_url_last_30_days- Number of jobs mentioning this technology in the ATS URL in the last 30 daysjobs_source_url_last_7_days- Number of jobs mentioning this technology in the ATS URL in the last 7 daysfirst_date_found_source_job_title- Date when the job title first mentioned the technologylast_date_found_source_job_title- Date when the job title last mentioned the technologyrank_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 foundrelative_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
Technographics v1 (deprecated)
| Column | Type | Description | Fill Rate |
|---|---|---|---|
| company_id | str | ID of the company, meant to be used only as a join key between the company and the company_technologies datasets. Will change in the future | 100.00% |
| technology_id | int | ID of the technology | 100.00% |
| company_name | str | Company name | 100.00% |
| confidence | str | How confident we are that the company uses this technology | 100.00% |
| first_date_found | date | Date when the technology was first mentioned by the company in a job post, in the ATS URL or in the job description | 100.00% |
| last_date_found | date | Date when the technology was last mentioned by the company in a job post, in the ATS URL or in the job description | 100.00% |
| jobs | int | Number of jobs found mentioning this technology | 100.00% |
| jobs_last_7_days | int | Number of jobs from the given company mentioning this technology in the last 7 days | 100.00% |
| jobs_last_30_days | int | Number of jobs from the given company mentioning this technology in the last 30 days | 100.00% |
| jobs_last_180_days | int | Number of jobs from the given company mentioning this technology in the last 180 days | 100.00% |
| first_date_found_source_job_description | date | Date when the job description first mentioned the technology | 100.00% |
| last_date_found_source_job_description | date | Date when the job description last mentioned the technology | 100.00% |
| technology_rank | float | Rank of the technology within its category based on mentions in job postings | 100.00% |
| technology_rank_180_days | float | Rank of the technology within its category based on mentions in job postings over the last 180 days | 100.00% |
| rank_1_tie | bool | Indicates if this technology is tied for the most mentioned in its category | 100.00% |
| rank_180_days_tie | bool | Indicates if this technology is tied for the most mentioned in its category over the last 180 days | 100.00% |
| relative_occurrence_within_category | float | Measures the relative occurrence of this technology among other technologies in the same category, in jobs by this company | 100.00% |
| jobs_source_final_url | int | Number of jobs from the given company mentioning this technology in the ATS URL | 100.00% |
| first_date_found_source_final_url | date | Date when the job ATS URL first mentioned the technology | 100.00% |
| last_date_found_source_final_url | date | Date when the job ATS URL last mentioned the technology | 100.00% |
Technologies
| Column | Type | Description | Fill Rate |
|---|---|---|---|
| technology_id | int | Internal ID of the technology | 100.00% |
| name | str | Name of the technology | 100.00% |
| slug | str | Slug of the technology | 100.00% |
| url | str | URL for more information about the technology | 100.00% |
| description | str | Description of the technology | 100.00% |
| category | str | Category of the technology | 100.00% |
| category_slug | str | Slug of the category of the technology | 100.00% |
| parent_category | str | Parent category of the technology | 100.00% |
| parent_category_slug | str | Slug of the parent category of the technology | 100.00% |
| jobs | int | Number of jobs found mentioning this technology | 100.00% |
| companies | int | Number of companies using this technology | 100.00% |
| companies_found_last_week | int | Number of companies found mentioning this technology in the last week | 100.00% |
How is this guide?
Last updated on