Turned Out

Hawaii Voting Report

Report date ${nice} ·\n Data fetched ${fmtHst(fetchedIso)} ·\n Download spreadsheet (.xlsx) ·\n Source: Hawaii Office of Elections.\n Unofficial data, subject to change.\n Click any row to see voting growth over time for that D/P.\n Est. columns: straight-line best fit of each precinct's last 5 reports,\n projected to election day (Aug 8) and capped at ballots sent.

`];\n\n if (audit) {\n let line: string;\n if (audit.error) {\n line = `⚠ OOE web cross-check unavailable: ${audit.error}`;\n } else if (audit.ok) {\n line = `✓ Cross-checked against the ` +\n `OOE web summary at ${fmtHst(audit.when)}: ` +\n `all county and statewide sums match.`;\n } else {\n line = `⚠ Cross-check vs the OOE web summary ` +\n `at ${fmtHst(audit.when)}: ${audit.diffs.length} value(s) differ ` +\n `(see table at bottom; the web page refreshes during the day while ` +\n `PDFs are a morning snapshot, so small “Sent” drift is normal).`;\n }\n parts.push(`

${line}

`);\n }\n\n parts.push(\n `` +\n HEADERS.map((h) => ``).join(\"\") +\n `` +\n ``,\n );\n const totals = new Array(9).fill(0);\n let estTotal = 0;\n for (const { dp, county, nums } of combined) {\n nums.forEach((v, i) => totals[i] += v);\n const est = estimateFinal(dp, nums[7], nums[8], history);\n estTotal += est;\n parts.push(\n `` +\n nums.map((v) => ``).join(\"\") +\n `` +\n `` +\n ``,\n );\n }\n parts.push(\n `` +\n totals.map((v) => ``).join(\"\") +\n `` +\n `` +\n `

D/P	County	${h}	% Cast	Est. Voted (Aug 8)	Est. % Cast
${dp}	${county}	${v.toLocaleString(\"en-US\")}	${pctOf(nums[7], nums[8])}	${est.toLocaleString(\"en-US\")}	${pctOf(est, nums[8])}
TOTAL	Statewide	${v.toLocaleString(\"en-US\")}	${pctOf(totals[7], totals[8])}	${estTotal.toLocaleString(\"en-US\")}	${pctOf(estTotal, totals[8])}

`,\n );\n\n if (audit && audit.diffs.length > 0) {\n parts.push(\n `

OOE web cross-check differences

` +\n `

This report is built from the official daily PDFs. The OOE web ` +\n `page's summary table refreshes during the day, so its “Sent” counts ` +\n `can run slightly ahead of the morning PDF snapshot.

` +\n `` +\n `` +\n audit.diffs.map((d) =>\n `` +\n `` +\n `` +\n ``\n ).join(\"\") + `

County	Column	OOE web	This report (PDF)	Diff
${d.county}	${d.column}	${d.web.toLocaleString(\"en-US\")}	${d.pdf.toLocaleString(\"en-US\")}	${(d.web - d.pdf >= 0 ? \"+\" : \"\") + (d.web - d.pdf).toLocaleString(\"en-US\")}

`,\n );\n }\n\n parts.push(\n ``,\n );\n // Client script: no backticks or dollar-brace inside, so it can live in this\n // template literal untouched.\n parts.push(``);\n parts.push(\"\");\n return parts.join(\"\\n\");\n}\n","label",[134],"e4f904a3-41c3-4929-8bed-db2dafedb9f5","http.ts",15,["D",1784923973607],4,"http","// http.ts — Val Town HTTP trigger. Serves the report page and the .xlsx.\n// URL: https://-.val.run/\n\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\n\n// std/blob's get() throws ValTownBlobNotFoundError on missing keys.\nasync function tryGet(key: string) {\n try {\n return await blob.get(key);\n } catch {\n return null;\n }\n}\n\nexport default async function (req: Request): Promise {\n const path = new URL(req.url).pathname;\n\n if (path === \"/AbsenteeVoting.xlsx\") {\n const b = await tryGet(\"xlsx\");\n if (!b) return new Response(\"Not built yet\", { status: 404 });\n return new Response(await b.arrayBuffer(), {\n headers: {\n \"content-type\":\n \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"content-disposition\": 'attachment; filename=\"AbsenteeVoting.xlsx\"',\n \"cache-control\": \"public, max-age=300\",\n },\n });\n }\n\n const b = await tryGet(\"html\");\n if (!b) {\n return new Response(\n \"Report not built yet. Run the cron val once, then reload.\",\n { status: 503, headers: { \"content-type\": \"text/plain\" } },\n );\n }\n return new Response(await b.text(), {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"public, max-age=300\",\n },\n });\n}","turnedout",[145],"cdc2bd3c-1e72-4b33-bad9-9818687f4b4d","cron.ts","c5c538a4-879a-11f1-95c9-1607ee4eb77e",25,["D",1785396504216],5,"interval","// cron.ts — Val Town CRON trigger. Schedule: 0 14-20 * * 1-5 (hourly 4–10 AM HST weekdays).\n// Fetches the newest report set, parses + verifies, stores outputs in blob storage.\n// Keeps a per-day history of votes per D/P for the growth view.\n\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\nimport {\n auditWebSums, BASE, buildHtml, buildXlsx, DpHist, PAGE_URL, parseTokens,\n pdfToTokens, REPORTS, Sheets, WebAudit,\n} from \"./shared.ts\";\n\nconst BACKFILL_DAYS = 13;\n\nasync function discoverLatest(): Promise {\n // PDFs generate ~3:11 AM HST at predictable URLs; the page's links lag.\n // Probe today (HST) back through 7 days, then fall back to the page.\n const hstNow = new Date(Date.now() - 10 * 3600 * 1000);\n for (let back = 0; back < 8; back++) {\n const d = new Date(hstNow.getTime() - back * 86400 * 1000);\n const ds = d.toISOString().slice(0, 10).replaceAll(\"-\", \"\");\n const r = await fetch(`${BASE}/AbsenteeReconState-${ds}.pdf`);\n if (r.ok) {\n const head = new Uint8Array((await r.arrayBuffer()).slice(0, 5));\n if (new TextDecoder().decode(head) === \"%PDF-\") return ds;\n }\n }\n const html = await (await fetch(PAGE_URL)).text();\n const dates = [...html.matchAll(/AbsenteeReconState-(\\d{8})\\.pdf/g)]\n .map((m) => m[1]);\n if (dates.length === 0) {\n throw new Error(\"No report found by URL probe or page scrape\");\n }\n return dates.sort().at(-1)!;\n}\n\n// D/P -> [voted, total] from the four county sheets.\nfunction dpMap(sheets: Sheets): Record {\n const m: Record = {};\n for (const { labelHdr, rows } of sheets) {\n if (labelHdr !== \"D/P\") continue;\n for (const r of rows) m[r[0]] = [r[8] as number, r[9] as number];\n }\n return m;\n}\n\n// Fetch + parse the four county PDFs for one past date; null if any is missing\n// (weekends/holidays have no report).\nasync function fetchDay(ds: string): Promise | null> {\n const m: Record = {};\n for (const [key, , prefix] of REPORTS) {\n if (key === \"State\") continue;\n const resp = await fetch(`${BASE}/${prefix}-${ds}.pdf`);\n if (!resp.ok) return null;\n const buf = new Uint8Array(await resp.arrayBuffer());\n if (new TextDecoder().decode(buf.slice(0, 5)) !== \"%PDF-\") return null;\n for (const r of parseTokens(await pdfToTokens(buf))) {\n m[r[0]] = [r[8] as number, r[9] as number];\n }\n }\n return m;\n}\n\nexport default async function () {\n const latest = await discoverLatest();\n const have = (await blob.getJSON(\"meta\") as { report_date?: string } | undefined)\n ?.report_date ?? \"\";\n const history = (await blob.getJSON(\"history\") as DpHist | undefined) ?? {};\n if (have >= latest && history[latest]) {\n console.log(`Already have report ${have}; nothing to do.`);\n return;\n }\n\n const sheets: Sheets = [];\n for (const [key, name, prefix] of REPORTS) {\n const resp = await fetch(`${BASE}/${prefix}-${latest}.pdf`);\n if (!resp.ok) throw new Error(`Fetch failed for ${prefix}-${latest}.pdf`);\n const rows = parseTokens(await pdfToTokens(new Uint8Array(await resp.arrayBuffer())));\n sheets.push({ name, labelHdr: key === \"State\" ? \"County\" : \"D/P\", rows });\n console.log(`${name}: ${rows.length} rows`);\n }\n\n history[latest] = dpMap(sheets);\n // Backfill recent missing days (reports stay up at their dated URLs).\n const base = Date.UTC(\n +latest.slice(0, 4), +latest.slice(4, 6) - 1, +latest.slice(6),\n );\n for (let back = 1; back <= BACKFILL_DAYS; back++) {\n const ds = new Date(base - back * 86400 * 1000)\n .toISOString().slice(0, 10).replaceAll(\"-\", \"\");\n if (history[ds]) continue;\n try {\n const m = await fetchDay(ds);\n if (m) {\n history[ds] = m;\n console.log(`Backfilled ${ds}`);\n }\n } catch (e) {\n console.log(`Backfill ${ds} skipped: ${e}`);\n }\n }\n\n // Cross-check our sums against the OOE web page's summary table. Never\n // aborts the run — the result is published on the page instead.\n let audit: WebAudit;\n try {\n const pageHtml = await (await fetch(PAGE_URL)).text();\n audit = auditWebSums(pageHtml, sheets, new Date().toISOString());\n } catch (e) {\n audit = { when: new Date().toISOString(), ok: false, error: String(e), diffs: [] };\n }\n console.log(\n audit.error\n ? `Web cross-check unavailable: ${audit.error}`\n : audit.ok\n ? \"Web cross-check: all sums match the OOE web table.\"\n : `Web cross-check: ${audit.diffs.length} difference(s) vs OOE web table.`,\n );\n\n // All parsed and verified — only now touch storage.\n await blob.setJSON(\"history\", history);\n await blob.set(\"xlsx\", buildXlsx(sheets, latest));\n await blob.set(\"html\", buildHtml(sheets, latest, new Date().toISOString(), history, audit));\n await blob.setJSON(\"meta\", { report_date: latest, updated: new Date().toISOString() });\n console.log(`Stored report ${latest} (${Object.keys(history).length} days of history).`);\n}\n",[154],"pulls","branches",1,"forks","envVars",{"_170":62,"_172":62},"connections",{"_170":62,"_171":62},"count","unfilledCount","emptyCount",{"_42":153,"_32":154,"_30":155,"_136":-5,"_40":41,"_39":156,"_138":25,"_37":183,"_13":158,"_33":159,"_35":160,"_24":48,"_142":-5,"_177":184,"_27":185},{"_42":144,"_32":145,"_30":57,"_136":-5,"_40":41,"_39":146,"_138":25,"_37":180,"_13":148,"_33":149,"_35":150,"_24":48,"_142":151,"_177":181,"_27":182},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":48,"_37":176,"_13":140,"_33":34,"_35":141,"_24":48,"_142":-5,"_177":178,"_27":179},["D",1785396571152],"children",[],[134],["D",1784923973607],[],[145],["D",1785396504216],[],[154],["D",1784884388277],["D",1789473046147],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":48},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":224,"_225":226,"_227":228,"_229":48,"_230":48,"_231":48,"_232":25,"_233":-5,"_234":-7,"_235":-7,"_236":62,"_237":48,"_238":48,"_239":-5,"_240":48,"_241":48,"_242":48,"_243":-5},"ENV",{"_195":196,"_197":198,"_199":89,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v28