[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_104":105,"_106":107},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","rarefrog5","name","longlist","path","export.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/rarefrog5/longlist/code/export.ts","extension","id","f8e3f8b8-6a93-4c2d-b91c-3a7a50793f2d","fileId","204dde48-a87a-11f1-867b-1607ee4eb77e","parentId","branchId","780a019f-b3f0-478c-8bec-f5e9ea5e4951","branchVersion",41,"latest",true,"createdAt",["D",1788743069114],"version",4,"fileType","http","content","// Export page: downloads verification + recheck results grouped into clear\n// buckets so nothing is silently dropped. Recheck results are sorted by match\n// score (highest first) and include pod.link so you review the most-likely-real\n// first and stop when scores get too low to matter.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nfunction esc(v: unknown): string {\n const s = v === null || v === undefined ? \"\" : String(v);\n if (/[\",\\n\\r]/.test(s)) return `\"${s.replace(/\"/g, '\"\"')}\"`;\n return s;\n}\nfunction toCsv(rows: any[], fields: string[]): string {\n const lines = [fields.join(\",\")];\n for (const r of rows) lines.push(fields.map((f) => esc(r[f])).join(\",\"));\n return lines.join(\"\\n\");\n}\n\nconst PAGE = `\n\nVerification results\n\n

Podcast verification results

Loading…

First pass (original)

\n Verified (keep)\n Review me\n Not found\n

Second pass — recheck of the \"not found\" list (sorted by match score)

👆 Start here: review the highest scores first, then stop when they get too low to bother. Every row has a pod.link to click straight to the show.

\n Recheck verified (0.80+)\n Recheck review (0.35–0.79)\n Still not found (<0.35)\n All recheck results\n

FINAL LIST (merged verified + uncertain + your finds, enriched)

\n Download final list (CSV)\n

Everything

\n All results (CSV)\n\n`;\n\ntype Row = { queried_name?: unknown; status?: unknown; score?: unknown; record?: unknown };\nfunction recOf(r: Row): any {\n try { return JSON.parse((r.record as string) || \"{}\"); } catch { return {}; }\n}\nfunction rowToOut(r: Row) {\n const rec = recOf(r);\n const score = r.score === null || r.score === undefined ? \"\" : Math.round((r.score as number) * 100);\n return {\n queried_name: r.queried_name ?? \"\",\n status: r.status ?? \"\",\n score,\n matched_name: rec.name || \"\",\n itunes_id: rec.id ?? \"\",\n publisher: rec.pub || \"\",\n podlink: rec.link || \"\",\n };\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const download = url.searchParams.get(\"download\");\n const wantSummary = url.searchParams.has(\"summary\");\n\n const vr = await sqlite.execute(\"SELECT queried_name, status, score, record FROM verify_results\");\n const mainRows = vr.rows as Row[];\n const rr = await sqlite.execute(\"SELECT queried_name, status, score, record FROM recheck_results\");\n const recheckRows = rr.rows as Row[];\n\n if (wantSummary) {\n const c: any = { verified: 0, uncertain: 0, not_found: 0, duplicate: 0, total: mainRows.length, rch_verified: 0, rch_uncertain: 0, rch_notfound: 0, rch_total: recheckRows.length };\n for (const r of mainRows) { if ((r.status as string) in c) c[r.status as string]++; }\n for (const r of recheckRows) {\n if (r.status === \"verified\") c.rch_verified++;\n else if (r.status === \"uncertain\") c.rch_uncertain++;\n else if (r.status === \"not_found\") c.rch_notfound++;\n }\n return new Response(JSON.stringify(c), { headers: { \"Content-Type\": \"application/json\" } });\n }\n\n if (!download) return new Response(PAGE, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n\n const fields = [\"queried_name\", \"status\", \"score\", \"matched_name\", \"itunes_id\", \"publisher\", \"podlink\"];\n let csvRows: any[] = [];\n\n if (download === \"recheck_verified\" || download === \"recheck_uncertain\" ||\n download === \"recheck_notfound\" || download === \"recheck_all\") {\n const st = download.replace(\"recheck_\", \"\");\n let rows = recheckRows;\n if (st === \"verified\") rows = recheckRows.filter((r) => r.status === \"verified\");\n else if (st === \"uncertain\") rows = recheckRows.filter((r) => r.status === \"uncertain\");\n else if (st === \"notfound\") rows = recheckRows.filter((r) => r.status === \"not_found\");\n // sort by score descending so you review most-likely-real first\n rows = [...rows].sort((a, b) => {\n const sa = (a.score as number) || 0, sb = (b.score as number) || 0;\n return sb - sa;\n });\n csvRows = rows.map(rowToOut);\n const fname = st === \"notfound\" ? \"recheck_notfound\" : `recheck_${st}`;\n return new Response(toCsv(csvRows, fields), {\n headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": `attachment; filename=\"${fname}.csv\"` },\n });\n }\n\n // FINAL merged list\n if (download === \"final\") {\n const fr = await sqlite.execute(\n \"SELECT id, name, source, pub, genres, primary_genre, eps, release_date, feed, art, link FROM final_list ORDER BY name\",\n );\n const ff = [\"id\", \"name\", \"source\", \"pub\", \"genres\", \"primary_genre\", \"eps\", \"release_date\", \"feed\", \"art\", \"link\"];\n const out = (fr.rows as any[]).map((r) => ({\n id: r.id ?? \"\", name: r.name ?? \"\", source: r.source ?? \"\", pub: r.pub ?? \"\",\n genres: r.genres ?? \"\", primary_genre: r.primary_genre ?? \"\", eps: r.eps ?? \"\",\n release_date: r.release_date ?? \"\", feed: r.feed ?? \"\", art: r.art ?? \"\", link: r.link ?? \"\",\n }));\n return new Response(toCsv(out, ff), {\n headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": 'attachment; filename=\"final_list.csv\"' },\n });\n }\n\n // original buckets\n let rows = mainRows;\n if (download !== \"all\") rows = mainRows.filter((r) => r.status === download);\n csvRows = rows.map(rowToOut);\n const fname = (download === \"all\" ? \"all\" : download) || \"all\";\n return new Response(toCsv(csvRows, fields), {\n headers: { \"Content-Type\": \"text/csv\", \"Content-Disposition\": `attachment; filename=\"podcast_${fname}.csv\"` },\n });\n}\n","deleted",false,"label",[14],"cfe62995-5847-4c90-b90d-483a41dc5933",["D",1788530401973],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","userId","93474b45-6cda-4b01-9c86-872d85871021","pinnedFileId","ec528ff0-a868-11f1-a682-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a010ad-0285-700c-b1e3-70dfce8e2fe2","tursoName","cfe6299558474c90b90d483a41dc5933","tursoHostname","cfe6299558474c90b90d483a41dc5933-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789488693443],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_103":53},"org",{"_9":10,"_98":53,"_99":53,"_55":56,"_100":101,"_102":42},"branch",{"_35":30,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_137":138,"_139":140,"_141":142,"_143":42,"_144":42,"_145":42,"_146":32,"_147":-5,"_148":-7,"_149":-7,"_150":63,"_151":42,"_152":42,"_153":-5,"_154":42,"_155":42,"_156":42,"_157":-5},"ENV",{"_108":109,"_110":111,"_112":89,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136},"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"]