Dictionary
Explore all 60 job dataset fields including column names, data types, descriptions, and fill rates showing data completeness metrics for each field
| Column | Type | Description | Fill Rate |
|---|---|---|---|
| id | integer | Unique identifier for the job | 100.00% |
| url | str | URL of the job posting. If we have a URL where the job board redirects to, where the job is originally posted, this URL will be returned here. Otherwise, the value of this field will be the same as the value of the | 100.00% |
| job_title | str | Title of the job position | 100.00% |
| date_posted | date | Date when the job was posted | 100.00% |
| company_name | str | Name of the company offering the job | 100.00% |
| description | str | Full description of the job | 100.00% |
| location | str | Location of the job | 97.03% |
| short_location | str | Short version of the job location | 97.03% |
| long_location | str | Long version of the job location | 97.03% |
| state_code | str | State code of the job location | 87.56% |
| latitude | float | Latitude of the job location | 97.19% |
| longitude | float | Longitude of the job location | 97.19% |
| postal_code | str | Postal code of the job location | 29.63% |
| remote | boolean | Whether the job is remote | 5.40% |
| hybrid | boolean | Whether the job is hybrid (partially remote) | 7.16% |
| salary_string | str | Salary information as a string | 100.00% |
| min_annual_salary | float | Minimum annual salary | 23.08% |
| min_annual_salary_usd | float | Minimum annual salary in USD | 23.07% |
| max_annual_salary | float | Maximum annual salary | 21.67% |
| max_annual_salary_usd | float | Maximum annual salary in USD | 21.67% |
| avg_annual_salary_usd | float | Average annual salary in USD | 21.47% |
| salary_currency | str | Currency of the salary | 25.49% |
| country_codes | array | List of country codes where the job is available | 99.98% |
| discovered_at | datetime | Timestamp when the job was discovered by TheirStack. Will be equal or greater than the value of the | 100.00% |
| source_url | str | URL of the job board where the job was found | 100.00% |
| seniority | str | Seniority level of the job position. One of the following values: | 100.00% |
| hiring_team | json | Information about the hiring team | 8.49% |
| company.id | str | Unique identifier for the company | 100.00% |
| company.name | str | Name of the company | 100.00% |
| company.domain | str | Company website domain | 70.69% |
| company.possible_domains | array | List of possible company domains | - |
| company.iso2 | str | Two-letter country code where the company is based | 56.11% |
| company.industry_id | integer | Industry classification ID | 68.79% |
| company.employee_count | integer | Number of employees at the company | 70.32% |
| company.annual_revenue_usd | float | Annual revenue in USD | 20.33% |
| company.total_funding_usd | float | Total funding raised in USD | 3.15% |
| company.funding_stage | str | Current funding stage (e.g., Series A, Series B) | 10.55% |
| company.last_funding_round_date | date | Date of the most recent funding round | 11.74% |
| company.founded_year | integer | Year the company was founded | 24.75% |
| company.yc_batch | str | Y Combinator batch (if applicable) | 0.15% |
| company.linkedin_id | str | LinkedIn company ID | 50.07% |
| company.linkedin_url | str | LinkedIn company URL | 57.87% |
| company.apollo_id | str | Apollo.io company ID | 27.07% |
| company.is_recruiting_agency | boolean | Whether the company is a recruiting agency | 8.85% |
| company.is_consulting_agency | boolean | Whether the company is a consulting agency | 0.00% |
| company.logo_url | str | URL of the company logo | 69.55% |
| company.annual_revenue_usd_readable | str | Human-readable annual revenue (e.g., "$1.5M") | 20.33% |
| company.last_funding_round_amount_readable | str | Human-readable last funding amount | 2.51% |
| company.long_description | str | Detailed description of the company | 99.79% |
| company.seo_description | str | SEO-optimized company description | 60.70% |
| company.city | str | City where the company is headquartered | 54.43% |
| company.postal_code | str | Postal code of company headquarters | 48.72% |
| company.alexa_ranking | integer | Alexa ranking of the company website | 15.55% |
| company.publicly_traded_symbol | str | Stock ticker symbol (if publicly traded) | 7.49% |
| company.publicly_traded_exchange | str | Stock exchange where the company is listed | 7.59% |
| company.investors | str | List of company investors | 100.00% |
| company.num_jobs | integer | Total number of jobs posted by this company | 100.00% |
| company.num_jobs_last_30_days | integer | Number of jobs posted in the last 30 days | 100.00% |
| keyword_slugs | array | List of technology slugs of technologies mentioned in the job title, description, or URL | 57.84% |
| locations | array | List of Location objects, as described here | 69.07% |
| employment_statuses | array | Array containing one or more employment status values. Possible values: | 88.76% |
| workplace_types | array | Array containing one or more workplace type values. Possible values: | 50.56% |
FAQS
How is this guide?
Last updated on
Data workflow
Learn how we transform raw job postings into high-quality, normalized data through our 5-step workflow covering acquisition, extraction, deduplication, enrichment, and quality assurance
Freshness
Discover how we collect job data with multi-tiered scraping frequencies from 10 minutes to daily.