[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","logan1","name","housing","path","cron/calibration.ts","project",{"_22":48,"_11":12,"_35":49,"_50":-5,"_51":44,"_52":53,"_54":53,"_55":56,"_57":-5,"_58":59,"_60":61,"_62":34,"_63":-5,"_64":-5,"_65":38,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/logan1/housing/code/cron/calibration.ts","extension","id","017f86ea-b754-4874-bc78-ae51d294917e","calibration.ts","fileId","c7f3415c-af7c-11f1-98c5-1607ee4eb77e","parentId","041eaecc-aef2-11f1-9a8e-1607ee4eb77e","branchId","a4c5838e-3adb-4640-ab71-e9f3d2b72f0a","branchVersion",67,"latest",true,"createdAt",["D",1789308589025],"version",0,"fileType","script","content","// Weekly calibration report (Part 6). Markdown over the last 7/90 days: price medians by area x beds x parking,\n// days-on-market, source yield funnel, pushes per day, scam-gate counts, vibe distribution, and a push-threshold\n// recommendation. Admin: ?job=calibration[&email=1]; cron/enrich.ts emails it Sundays 18:00 ET. The weekly-review\n// scheduled task saves the markdown to phase3/calibration/YYYY-MM-DD.md.\nimport { email } from \"https://esm.town/v/std/email\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { ensureSchema, logPoll, PUSH_THRESHOLD, today } from \"../lib/core.ts\";\nimport { p25 } from \"../lib/enrich.ts\";\n\nconst NOT_SIGNAL = `source not like 'signal-%' and source <> 'cl-parking'`;\nconst median = (v: number[]) => { const s = [...v].sort((a, b) => a - b); return s.length ? (s.length % 2 ? s[(s.length - 1) / 2] : (s[s.length / 2 - 1] + s[s.length / 2]) / 2) : null; };\nconst q = async (sql: string, args: any[] = []) => (await sqlite.execute({ sql, args })).rows as any[];\nconst money = (n: number | null) => n == null ? \"-\" : `$${Math.round(n).toLocaleString(\"en-US\")}`;\nconst table = (head: string[], rows: (string | number | null)[][]) => [`| ${head.join(\" | \")} |`, `|${head.map(() => \"---\").join(\"|\")}|`, ...rows.map((r) => `| ${r.map((x) => x == null ? \"-\" : String(x)).join(\" | \")} |`)].join(\"\\n\");\n\nexport async function calibrationReport(): Promise<{ markdown: string; pushesPerDay: number; recommendation: string }> {\n await ensureSchema();\n const since90 = new Date(Date.now() - 90 * 86400000).toISOString().slice(0, 10);\n const since7 = new Date(Date.now() - 7 * 86400000).toISOString().slice(0, 10);\n const L: string[] = [`# Housing calibration - ${today()}`, \"\", `Window: prices/DOM last 90 days (since ${since90}), activity last 7 days (since ${since7}). Fit score rules unchanged (max 13, push at ${PUSH_THRESHOLD}).`, \"\"];\n\n // 1. price by area x beds x parking bucket\n const px = await q(`select area, beds, case when parking_type in ('garage','offstreet') then 'off-street' else 'street/unknown' end park, price from listings where price is not null and first_seen >= ? and ${NOT_SIGNAL}`, [since90]);\n const groups = new Map();\n for (const r of px) { const k = `${r.area}|${r.beds}|${r.park}`; (groups.get(k) || groups.set(k, []).get(k)!).push(Number(r.price)); }\n const prow = [...groups.entries()].sort().map(([k, v]) => { const [area, beds, park] = k.split(\"|\"); return [area, beds === \"1.5\" ? \"1+den\" : beds, park, v.length, money(median(v)), money(p25(v))]; });\n L.push(\"## Price by area x beds x parking (asking, listings seen in window)\", \"\", table([\"Area\", \"Beds\", \"Parking\", \"n\", \"Median\", \"P25\"], prow), \"\");\n\n // 2. days on market by area (gone/dead rows: posted_at|first_seen -> gone_at|last_seen; active rows: age so far)\n const dom = await q(`select area, status, gone_at, posted_at, first_seen, last_seen from listings where ${NOT_SIGNAL} and first_seen >= ?`, [since90]);\n const domBy = new Map();\n for (const r of dom) {\n const start = Date.parse(String(r.posted_at || r.first_seen)); const g = domBy.get(r.area) || domBy.set(r.area, { gone: [], active: [] }).get(r.area)!;\n if (r.status === \"dead\" || r.gone_at) g.gone.push(Math.round((Date.parse(String(r.gone_at || r.last_seen)) - start) / 86400000));\n else g.active.push(Math.round((Date.now() - start) / 86400000));\n }\n L.push(\"## Days on market by area\", \"\", table([\"Area\", \"Gone (n)\", \"Gone median d\", \"Gone P25 d\", \"Active (n)\", \"Active median age d\"],\n [...domBy.entries()].sort().map(([a, g]) => [a, g.gone.length, median(g.gone) ?? \"-\", p25(g.gone) ?? \"-\", g.active.length, median(g.active) ?? \"-\"])), \"\");\n\n // 3. source yield funnel\n const funnel = await q(`select source, count(*) inserted, sum(score >= ${PUSH_THRESHOLD}) hot, sum(pushed) pushed, sum(status in ('contacted','touring','applied')) acted, sum(status='dead') dead, sum(license='no') nobbl from listings where ${NOT_SIGNAL} group by source order by inserted desc`);\n L.push(\"## Source yield funnel (all time)\", \"\", table([\"Source\", \"Inserted\", `Score >= ${PUSH_THRESHOLD}`, \"Pushed\", \"Status changed by Logan\", \"Dead\", \"NO BBL\"],\n funnel.map((r) => [r.source, r.inserted, r.hot, r.pushed, r.acted, r.dead, r.nobbl])), \"\");\n\n // 4. pushes per day (poll_log pushed counts + quiet-hours queue)\n const ppd = await q(`select substr(ts,1,10) day, sum(pushed) pushed from poll_log where ts >= ? group by day order by day`, [since7]);\n const totalPushed = ppd.reduce((a, r) => a + Number(r.pushed || 0), 0);\n const days = Math.max(1, ppd.length);\n const pushesPerDay = Math.round((totalPushed / 7) * 100) / 100;\n L.push(\"## Pushes per day (last 7 days)\", \"\", table([\"Day\", \"Pushed\"], ppd.map((r) => [r.day, r.pushed])), \"\", `Total ${totalPushed} over 7 days = **${pushesPerDay}/day** (${days} days with polls logged).`, \"\");\n\n // 5. scam-gate flags\n const scam = await q(`select coalesce(license,'null') license, count(*) n, sum(anomaly) anomaly, sum(license='no' and anomaly=1) both_flags from listings where ${NOT_SIGNAL} and status <> 'dead' group by license`);\n L.push(\"## Scam-gate flags (active rows)\", \"\", table([\"License\", \"n\", \"Price anomaly\", \"NO BBL + anomaly (suppressed)\"], scam.map((r) => [r.license, r.n, r.anomaly, r.both_flags])), \"\");\n\n // 6. vibe distribution of score >= 8 rows\n const vibe = await q(`select coalesce(v.vibe_score, -1) vs, count(*) n from listings l left join vibe v on v.rowid_pk=l.rowid_pk where l.score >= ${PUSH_THRESHOLD} and l.status <> 'dead' and ${NOT_SIGNAL.replace(/source/g, \"l.source\")} group by vs order by vs`);\n L.push(`## Vibe score of score >= ${PUSH_THRESHOLD} rows`, \"\", table([\"Vibe\", \"n\"], vibe.map((r) => [Number(r.vs) < 0 ? \"no coordinates\" : `${r.vs}/5`, r.n])), \"\");\n\n // 7. recommendation\n let recommendation = `Push threshold ${PUSH_THRESHOLD} is fine (${pushesPerDay}/day is inside 0.3-2).`;\n if (pushesPerDay > 2) recommendation = `${pushesPerDay} pushes/day > 2: raise PUSH_THRESHOLD to ${PUSH_THRESHOLD + 1} or require dog=true for pushes.`;\n else if (pushesPerDay < 0.3) recommendation = `${pushesPerDay} pushes/day < 0.3: lower PUSH_THRESHOLD to ${PUSH_THRESHOLD - 1} for one week, or widen price/beds gates; check the source health line first.`;\n L.push(\"## Recommendation\", \"\", recommendation, \"\");\n return { markdown: L.join(\"\\n\"), pushesPerDay, recommendation };\n}\n\nexport async function sendCalibration(): Promise<{ sent: boolean; subject: string }> {\n const r = await calibrationReport();\n const subject = `Housing calibration ${today()}: ${r.pushesPerDay} pushes/day`;\n await email({ subject, text: r.markdown });\n await logPoll(\"calibration\", true, {}, r.recommendation);\n return { sent: true, subject };\n}\n","deleted",false,"label",[47,24],"cron","b7ccec7e-ebe9-4364-ba98-e367c8d8849b",["D",1789248987477],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","DC housing search pipeline","imageUrl","userId","87445237-7d14-45c7-b3a2-72e031f10ec1","pinnedFileId","0544e21c-aef2-11f1-a6f0-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a09786-a61b-74b5-8910-af3116d3de5c","tursoName","b7ccec7eebe94364ba98e367c8d8849b","tursoHostname","b7ccec7eebe94364ba98e367c8d8849b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519256886],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_101":102,"_103":104,"_58":59,"_105":106,"_107":44},"branch",{"_37":91,"_11":92,"_22":30,"_93":48,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":12,"_100":10},"isOwned",71,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Logan","avatar","https://lh3.googleusercontent.com/a/ACg8ocIFxddfJftSiTFZN49YShT3nY7q8GOQ7dXYM2vJ6XkajnQMGA=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_84":-5,"_142":143,"_144":145,"_146":147,"_148":44,"_149":44,"_150":44,"_151":34,"_152":-5,"_153":-7,"_154":-7,"_155":38,"_156":44,"_157":44,"_158":-5,"_159":44,"_160":44,"_161":44,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":92,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]