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 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 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],"85701357-8063-4a4b-8f80-543015faaae2","cron.ts","c5c538a4-879a-11f1-95c9-1607ee4eb77e",18,["D",1784925876192],"interval","// cron.ts — Val Town CRON trigger. Schedule: 0 14 * * 1-5 (4:00 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 BASE,\n buildHtml,\n buildXlsx,\n DpHist,\n PAGE_URL,\n parseTokens,\n pdfToTokens,\n REPORTS,\n Sheets,\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(\n ds: string,\n): 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 =\n (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(\n await pdfToTokens(new Uint8Array(await resp.arrayBuffer())),\n );\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),\n +latest.slice(4, 6) - 1,\n +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 // 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(\n \"html\",\n buildHtml(sheets, latest, new Date().toISOString(), history),\n );\n await blob.setJSON(\"meta\", {\n report_date: latest,\n updated: new Date().toISOString(),\n });\n console.log(\n `Stored report ${latest} (${Object.keys(history).length} days of history).`,\n );\n}",[154],"pulls","branches",1,"forks","envVars",{"_169":62,"_171":62},"connections",{"_169":62,"_170":62},"count","unfilledCount","emptyCount",{"_42":153,"_32":154,"_30":155,"_136":-5,"_40":41,"_39":156,"_138":48,"_37":182,"_13":148,"_33":158,"_35":159,"_24":48,"_142":-5,"_176":183,"_27":184},{"_42":144,"_32":145,"_30":57,"_136":-5,"_40":41,"_39":146,"_138":25,"_37":179,"_13":148,"_33":149,"_35":150,"_24":48,"_142":151,"_176":180,"_27":181},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":48,"_37":175,"_13":140,"_33":34,"_35":141,"_24":48,"_142":-5,"_176":177,"_27":178},["D",1784933084740],"children",[],[134],["D",1784923973607],[],[145],["D",1784925876192],[],[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":223,"_224":225,"_226":227,"_228":48,"_229":48,"_230":48,"_231":25,"_232":-5,"_233":-7,"_234":-7,"_235":62,"_236":48,"_237":48,"_238":-5,"_239":48,"_240":48,"_241":48,"_242":-5},"ENV",{"_194":195,"_196":197,"_198":89,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222},"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 · v24