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 | 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.12% |
| short_location | str | Short version of the job location | 97.12% |
| long_location | str | Long version of the job location | 97.12% |
| state_code | str | State code of the job location | 82.60% |
| latitude | float | Latitude of the job location | 95.39% |
| longitude | float | Longitude of the job location | 95.39% |
| postal_code | str | Postal code of the job location | 31.25% |
| remote | boolean | Whether the job is remote | 4.74% |
| hybrid | boolean | Whether the job is hybrid (partially remote) | 5.79% |
| salary_string | str | Salary information as a string | 100.00% |
| min_annual_salary | float | Minimum annual salary | 23.12% |
| min_annual_salary_usd | float | Minimum annual salary in USD | 23.12% |
| max_annual_salary | float | Maximum annual salary | 21.62% |
| max_annual_salary_usd | float | Maximum annual salary in USD | 21.61% |
| avg_annual_salary_usd | float | Average annual salary in USD | 21.40% |
| salary_currency | str | Currency of the salary | 25.20% |
| country_codes | array | List of country codes where the job is available | 99.98% |
| discovered_at | datetime | Timestamp when the job was discovered | 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 | 100.00% |
| hiring_team | json | Information about the hiring team | 8.34% |
| 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 | 71.89% |
| company.iso2 | str | Two-letter country code where the company is based | 59.68% |
| company.industry_id | integer | Industry classification ID | 72.24% |
| company.employee_count | integer | Number of employees at the company | 71.47% |
| company.annual_revenue_usd | float | Annual revenue in USD | 21.00% |
| company.total_funding_usd | float | Total funding raised in USD | 3.43% |
| company.funding_stage | str | Current funding stage (e.g., Series A, Series B) | 11.72% |
| company.last_funding_round_date | date | Date of the most recent funding round | 12.84% |
| company.founded_year | integer | Year the company was founded | 26.01% |
| company.yc_batch | str | Y Combinator batch (if applicable) | 0.23% |
| company.linkedin_id | str | LinkedIn company ID | 51.21% |
| company.linkedin_url | str | LinkedIn company URL | 61.36% |
| company.apollo_id | str | Apollo.io company ID | 28.83% |
| company.is_recruiting_agency | boolean | Whether the company is a recruiting agency | 9.07% |
| company.is_consulting_agency | boolean | Whether the company is a consulting agency | 0.00% |
| company.logo_url | str | URL of the company logo | 72.90% |
| company.annual_revenue_usd_readable | str | Human-readable annual revenue (e.g., "$1.5M") | 21.00% |
| company.last_funding_round_amount_readable | str | Human-readable last funding amount | 2.63% |
| company.long_description | str | Detailed description of the company | 99.82% |
| company.seo_description | str | SEO-optimized company description | 63.06% |
| company.city | str | City where the company is headquartered | 57.84% |
| company.postal_code | str | Postal code of company headquarters | 51.91% |
| company.alexa_ranking | integer | Alexa ranking of the company website | 15.80% |
| company.publicly_traded_symbol | str | Stock ticker symbol (if publicly traded) | 7.72% |
| company.publicly_traded_exchange | str | Stock exchange where the company is listed | 7.83% |
| 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 keywords related to the job | 58.25% |
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.