Dictionary: Base Job Posting Data

this data dictionary shows all available data points, explains their values, and provides raw job posting data samples all tables have snippets of the professional network job postings dataset all personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes dictionary base job posting data docid\ qy8fexqi23khu xijtkkb dictionary base job posting data docid\ qy8fexqi23khu xijtkkb dictionary base job posting data docid\ qy8fexqi23khu xijtkkb job posting information repeat fields data point description data type example values id identification key for a job posting record each record in the dataset has its id value id in the job table becomes job id later in the other tables of the dataset number (integer) 204184 job id job posting record id assigned in the database number (integer) 117902 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 the last time we scraped the job posting profile 0 job posting was successfully scraped note we revisit and rescrape job postings with deleted = 0 flags, as they are still active number (integer) deleted 0 data point description data type time posted job ad publish date (as displayed on the professional network) s tring title job title s tring description job description note contains control characters s tring seniority s eniority level s tring employment type full time or part time work s tring location job location s tring url job posting url s tring hash job posting url, processed by the md5 algorithm s tring company id company identification key, relating directly to the company table integer company name company name s tring company url company p rofile url s tring external url external url provided by the company referring to the job posting s tring application active one of two values is possible 0 – the last time we scraped the job posting, the job posting was deactivated 1 – the last time we scraped the job posting, it was still active number (integer) salary offered salary s tring applicants count number of applicants s tring professional network job id job identifier on the professional network integer country job location (country) s tring last updated ux unix timestamp of the last record update integer redirected url url where we are redirected while trying to access the job posting s tring redirected url hash redirected url processed by the md5 algorithm s tring the main job table data sample main job table { "id" 6946, "created" "2020 08 21 11 16 17", "last updated" "2021 02 24 22 30 06", "time posted" "6 months ago", "title" "energy procurement negotiator", "description" "responsibilities will include · produce tenders and issue them to suppliers within appropriate deadlines · initiate price and contract term negotiations with suppliers · ensure contract recommendations are accurate and sent out in a timely manner · enter manual and electronic offers accurately, to create like for like cost analysis · working closely with other teams and supporting the wider busines with knowledge of energy contracting and pricing · issuing recommendations to clients via e mail, and following up via telephone · processing of acceptances · ensuring system details are maintained and updated accurately · develop networks and relationships with energy supplier contacts · ensure tender fees are invoiced upon completion of work · ongoing contract management and resolution of client queries", "seniority" "associate", "employment type" "full time", "location" "owlsmoor, england, united kingdom", "url" "https //www professional network com/jobs/view/energy procurement negotiator at energy company 2002092926", "hash" "e9dccd36998f1c4a341fc1e234f57a2e", "company id" 23087523, "company name" "energy company", "company url" "https //www professional network com/company/energy company", "external url" null, "deleted" 1, "application active" 0, "salary" "£23,000 00 £28,000 00", "applicants count" "55 applicants", "professional network job id" 2002092926, "country" "united kingdom", "last updated ux" 1614205806, "redirected url" "https //www professional network com/jobs/view/energy procurement negotiator at energy company 2002092926", "redirected url hash" "e9dccd36998f1c4a341fc1e234f57a2e", functions repeat fields data point description data type example values id record identification key number (integer) 204184 job id job posting record id assigned in the database number (integer) 117902 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the job posting profile 0 job posting was successfully scraped note we revisit and rescrape job postings with deleted = 0 flags, as they are still active number (integer) deleted 0 data point description data type job functions collection consists of record metadata and job function list objects a rray of objects function id identification key relating to the job function list table integer job function list information on the job functions in the job ad o bject function job function title s tring hash job function title processed by the md5 algorithm s tring job functions table data sample job functions "job functions collection" \[ { "id" 11853, "job id" 6946, "function id" 10, "deleted" 1, "created" "2020 08 21 11 16 17", "last updated" "2020 12 18 09 55 00", "job function list" { "id" 10, "created" "2020 08 14 14 11 38", "last updated" "2020 08 14 14 11 38", "function" "general business", "hash" "90cfa53847d7670be539c44ee419364d" } } ], industries repeat fields data point description data type example values id record identification key number (integer) 204184 job id job posting record id assigned in the database number (integer) 117902 created the time and date when we first scraped the record string 2019 12 07 22 07 18 last updated the time and date when we last scraped the record string 2020 09 06 04 51 48 deleted one of two values 1 or 0 1 the last time we scraped the job posting profile 0 job posting was successfully scraped note we revisit and rescrape job postings with deleted = 0 flags, as they are still active number (integer) deleted 0 data point description data type job industries collection consists of record metadata and job industry list objects a rray of objects industry id identification key relating to the job industry list table integer job industry list contains information on the job industry o bject industry job industry title s tring hash job industry title processed by the md5 algorithm s tring industries table data sample industries "job industries collection" \[ { "id" 15821, "job id" 6946, "industry id" 47, "deleted" 0, "created" "2020 08 21 11 16 17", "last updated" "2020 12 18 10 15 45", "job industry list" { "id" 47, "created" "2020 08 14 14 11 53", "last updated" "2020 08 14 14 11 53", "industry" "oil & energy", "hash" "66c19aa77111f14ce7e7658269459917" } } ] status data point description data type job status log collection a rray of objects id record identification key n umber (integer) job id job posting record id assigned in the database number (integer) status status of the job string created the time and date when we first scraped the record string last updated the time and date when we last scraped the record string deleted one of two values 1 or 0 1 – the last time we scraped the job posting profile 0 – job posting was successfully scraped note we revisit and rescrape job postings with deleted = 0 flags, as they are still active number (integer) industries table data sample industries "job status log collection" \[ { "created" "2025 03 01 10 30 00", "deleted" 0, "id" 3003, "job id" 889977, "last updated" "2025 03 10 16 45 00", "status" "active" } ]