← Browse Dives
Full screen
Screenshot of Jev jobs
Loading Interactive Dive...

Jev jobs

The Jev jobs dashboard as a Dive: 50 jobs a page, five typed questions and one free-text question answered by prompt_jev() in SQL, one call per job, results sorted by match score.

DashboardMotherDuckSQL
Author: Dumky de Wilde  ·  September 21, 2026    Region: us-east-1

AI Prompts Used

1Prompt 1
Build a Dive over the public share
md:_share/jev_jobs_public/b4600052-1467-4f33-87a3-7474c5644ca0 (attach it as
jev_jobs_public). It holds one table, `jobs` — 10,000 job postings with job_id,
listed_date, company, title, location, description — and a macro
prompt_jev(input, instructions, type := 'noul', criteria := NULL) that answers a
question about a text: a probability when type is 'noul', one label from
`criteria` when it is 'choice'.

Show the jobs as a table, 50 a page, newest first: listed date, title and
company, location, then one column per question.

Two actions above the table. "Extract features" runs five fixed questions over
the 50 jobs on the page in one statement — is this a data role (noul), role
family (choice), seniority (choice), does it state a base salary (noul), does it
manage people (noul). Render a probability as a percentage with a small bar, a
choice as a label chip. "Ask" takes one free-text yes/no question, runs it as a
noul over the same 50 jobs, adds a Match column, and sorts in SQL with
ORDER BY try_cast(matches AS DOUBLE) DESC NULLS LAST; add a "matches only"
checkbox that keeps rows at 0.50 and above.

Every click is LLM spend, so confirm first and state exactly how many
prompt_jev() calls it costs. Paging clears both results. Clicking a row opens
the full description with its per-question answers.

Style it quiet and editorial: off-white paper, near-black ink, one accent color,
no card chrome, small uppercase labels.

Comments

Log in to leave a comment.

No comments yet. Be the first!