43:["$","title",null,{"children":"Interviewer Phone Screen Dashboard | Alexey Komissarouk | Observable"}] 4b:[] 47:{"id":"2a1f7b7fb63769df","slug":"interviewer-phone-screen-dashboard","title":"Interviewer Phone Screen Dashboard","thumbnail":"184ffdb2d3a328b63cd680120cd4a194eade69d6a61ca15b036531fede53953f","access_level":"public","create_time":"$D2018-02-26T20:08:58.872Z","update_time":"$D2018-02-26T20:29:32.510Z","view_time":null,"first_public_time":"$D2018-02-26T21:09:26.157Z","has_unpublished_edits":null,"fork":{"id":"98653bb8e2751776","slug":"candidates-per-week","title":"Candidates per week","owner":{"id":"e4de2a2f8080099d","login":"opendoor","name":"Opendoor"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e14ef6c8566ebea1","login":"alexeymk","name":"Alexey Komissarouk","avatar_url":"https://avatars-next.observableusercontent.com/0f6d561d4d7c5f25de8ea2c87156dea3b3b50b961c90f1294c4c5cf8ca6fdb8f","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":994,"publish_version":994,"role":null,"authored":false,"authors":[{"type":"individual","id":"0c73579b7872f3ef","login":"alexeymk","name":"Alexey Komissarouk","avatar_url":"https://avatars-next.observableusercontent.com/0f6d561d4d7c5f25de8ea2c87156dea3b3b50b961c90f1294c4c5cf8ca6fdb8f","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"0c73579b7872f3ef","login":"alexeymk","name":"Alexey Komissarouk","avatar_url":"https://avatars-next.observableusercontent.com/0f6d561d4d7c5f25de8ea2c87156dea3b3b50b961c90f1294c4c5cf8ca6fdb8f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Interviewer Phone Screen Dashboard","cells":[{"id":0,"value":"md`# Interviewer Phone Screen Dashboard`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":953,"value":"viewof interviewer = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"query = lever(`\n select c.name, \n f.fields->0->>'value' as score, \n (CASE \n WHEN c.archived IS NULL THEN stages.text ELSE ar.text \n END) as current_state, \n f.completed_at as interview_date\n from public.feedback f \n INNER JOIN public.users u ON u.id = f.user\n INNER JOIN public.candidates c ON f.candidate = c.id\n INNER JOIN public.stages ON c.stage = stages.id \n LEFT JOIN public.archive_reasons ar ON ar.id = (c.archived->>'reason')::uuid\n WHERE u.username = '${interviewer}'\n AND f.text = 'Tech Phone Interview'\n AND f.completed_at IS NOT NULL\n ORDER BY 4 desc\n`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"html`\n \n \n ${query.fields.map((f) => ``)}\n \n ${query.rows.map((r) => `\n \n ${query.fields.map((f) => ``).join('')}\n \n `)}\n

${f.name}
${r[f.name]}

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"lever = async function(sql) {\n const response = await fetch(`https://opendoor-lever.herokuapp.com/db?q=${sql}`, {credentials: 'include'})\n return response.json()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"_ = require('lodash')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"vegalite = require(\"@observablehq/vega-lite@0.1\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 42:null