Skip to main content

​
Column Mapping

Each export column has two names:
NameDescription
sourceColumnThe internal field name used in Jobo’s database
outputNameThe column header that appears in your exported file
Currently these are identical (e.g., salary_min → salary_min). Custom column renaming is planned for a future release.
Select only the columns you need to reduce file size and processing time. Exports with fewer columns are faster to generate and smaller to download, especially in CSV and JSON formats.

​
Available Columns

ColumnTypeDescription
iduuidUnique job identifier
titlestringJob title
company_namestringCompany name
company_iduuidCompany identifier
descriptionstring (HTML)Full job description in HTML
listing_urlstringOriginal job listing URL
apply_urlstringDirect application URL
citystringJob city
statestringJob state/region
countrystringJob country (ISO 3166-1 alpha-2)
salary_minnumberMinimum salary
salary_maxnumberMaximum salary
salary_currencystringSalary currency code (USD, EUR, GBP, etc.)
salary_periodstringSalary period (yearly, monthly, hourly)
employment_typestringFull-time, Part-time, Contract, Internship
workplace_typestringRemote, Hybrid, On-site
experience_levelstringEntry, Mid, Senior, Lead, Executive
is_remotebooleanWhether the job is remote
sourcestringATS source identifier (e.g., greenhouse, workday)
date_posteddatetimeWhen the job was originally posted
created_atdatetimeWhen added to Jobo’s system
updated_atdatetimeLast update timestamp

​
Tips for Selecting Columns

Select id, title, company_name, listing_url, city, country, and date_posted for a lightweight export suitable for quick scans or feeding into a search index.
Include salary_min, salary_max, salary_currency, salary_period, title, city, country, and experience_level for compensation benchmarking.
Select all columns for a complete snapshot. Use Parquet format for maximum compression and query performance.

​
Example Record

A full JSON record with all columns selected: 
{
  "id": "550e8400-e29b-41d4-a716-446655440000",
  "title": "Senior Software Engineer",
  "company_name": "Acme Corp",
  "company_id": "7c9e6679-7425-40de-944b-e07fc1f90ae7",
  "description": "<p>We are looking for a Senior Software Engineer to join our team...</p>",
  "listing_url": "https://boards.greenhouse.io/acme/jobs/123",
  "apply_url": "https://boards.greenhouse.io/acme/jobs/123/apply",
  "city": "San Francisco",
  "state": "California",
  "country": "US",
  "salary_min": 150000,
  "salary_max": 200000,
  "salary_currency": "USD",
  "salary_period": "yearly",
  "employment_type": "Full-time",
  "workplace_type": "Remote",
  "experience_level": "Senior",
  "is_remote": true,
  "source": "greenhouse",
  "date_posted": "2025-02-01T00:00:00Z",
  "created_at": "2025-02-01T12:00:00Z",
  "updated_at": "2025-02-10T08:30:00Z"
}
The description field contains HTML. If you need plain text, strip tags in your processing pipeline or use a Pipeline with a Liquid template to extract text before export.