---
title: Technographics
description: Complete reference for 41 technographic fields tracking company technology adoption through job postings, including v2 schema and migration guide from v1
url: https://theirstack.com/en/docs/datasets/options/technographic
---

## 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 | \- |
| `keyword_id` | int | ID of the technology (previously called technology\_id) | \- |
| `keyword_slug` | str | Slug identifier for the technology (new in v2) | \- |
| `company_name` | str | Company name | \- |
| `subcategory_slug` | str | Slug identifier for the technology subcategory (new in v2) | \- |
| `is_recruiting_agency` | bool | Indicates if the company is a recruiting agency (new in v2) | \- |
| `confidence` | str | How confident we are that the company uses this technology | \- |
| `jobs` | int | Total number of jobs found mentioning this technology across all sources | \- |
| `jobs_last_180_days` | int | Total number of jobs from the given company mentioning this technology in the last 180 days across all sources | \- |
| `jobs_last_30_days` | int | Total number of jobs from the given company mentioning this technology in the last 30 days across all sources | \- |
| `jobs_last_7_days` | int | Total number of jobs from the given company mentioning this technology in the last 7 days across all sources | \- |
| `jobs_source_description` | int | Number of jobs from the given company mentioning this technology in the job description (new in v2) | \- |
| `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) | \- |
| `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) | \- |
| `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) | \- |
| `jobs_source_title` | int | Number of jobs from the given company mentioning this technology in the job title (new in v2) | \- |
| `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) | \- |
| `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) | \- |
| `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) | \- |
| `jobs_source_url` | int | Number of jobs from the given company mentioning this technology in the ATS URL (previously called jobs\_source\_final\_url) | \- |
| `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) | \- |
| `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) | \- |
| `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) | \- |
| `first_date_found` | date | Date when the technology was first mentioned by the company in a job post, across all sources | \- |
| `last_date_found` | date | Date when the technology was last mentioned by the company in a job post, across all sources | \- |
| `first_date_found_source_job_description` | date | Date when the job description first mentioned the technology | \- |
| `last_date_found_source_job_description` | date | Date when the job description last mentioned the technology | \- |
| `first_date_found_source_job_title` | date | Date when the job title first mentioned the technology (new in v2) | \- |
| `last_date_found_source_job_title` | date | Date when the job title last mentioned the technology (new in v2) | \- |
| `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) | \- |
| `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) | \- |
| `technology_rank_source_jobs` | float | Rank of the technology within its category based on mentions in job postings (previously called technology\_rank) | \- |
| `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) | \- |
| `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) | \- |
| `rank_1_tie_source_jobs` | bool | Indicates if this technology is tied for the most mentioned in its category (previously called rank\_1\_tie) | \- |
| `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) | \- |
| `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) | \- |
| `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) | \- |

### Differences from v1.0.0

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

## 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% |
| `technology_id` | int | ID of the technology | 100% |
| `company_name` | str | Company name | 100% |
| `confidence` | str | How confident we are that the company uses this technology | 100% |
| `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% |
| `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% |
| `jobs` | int | Number of jobs found mentioning this technology | 100% |
| `jobs_last_7_days` | int | Number of jobs from the given company mentioning this technology in the last 7 days | 100% |
| `jobs_last_30_days` | int | Number of jobs from the given company mentioning this technology in the last 30 days | 100% |
| `jobs_last_180_days` | int | Number of jobs from the given company mentioning this technology in the last 180 days | 100% |
| `first_date_found_source_job_description` | date | Date when the job description first mentioned the technology | 100% |
| `last_date_found_source_job_description` | date | Date when the job description last mentioned the technology | 100% |
| `technology_rank` | float | Rank of the technology within its category based on mentions in job postings | 100% |
| `technology_rank_180_days` | float | Rank of the technology within its category based on mentions in job postings over the last 180 days | 100% |
| `rank_1_tie` | bool | Indicates if this technology is tied for the most mentioned in its category | 100% |
| `rank_180_days_tie` | bool | Indicates if this technology is tied for the most mentioned in its category over the last 180 days | 100% |
| `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% |
| `jobs_source_final_url` | int | Number of jobs from the given company mentioning this technology in the ATS URL | 100% |
| `first_date_found_source_final_url` | date | Date when the job ATS URL first mentioned the technology | 100% |
| `last_date_found_source_final_url` | date | Date when the job ATS URL last mentioned the technology | 100% |

## Technologies

| Column | Type | Description | Fill Rate |
| --- | --- | --- | --- |
| `technology_id` | int | Internal ID of the technology | 100% |
| `name` | str | Name of the technology | 100% |
| `slug` | str | Slug of the technology | 100% |
| `url` | str | URL for more information about the technology | 100% |
| `description` | str | Description of the technology | 100% |
| `category` | str | Category of the technology | 100% |
| `category_slug` | str | Slug of the category of the technology | 100% |
| `parent_category` | str | Parent category of the technology | 100% |
| `parent_category_slug` | str | Slug of the parent category of the technology | 100% |
| `jobs` | int | Number of jobs found mentioning this technology | 100% |
| `companies` | int | Number of companies using this technology | 100% |
| `companies_found_last_week` | int | Number of companies found mentioning this technology in the last week | 100% |