Hawaii Absentee Voting Report

Report date ${nice} ·\n Download spreadsheet (.xlsx) ·\n Source: Hawaii Office of Elections.\n Unofficial data, subject to change.

`];\n for (const { name, labelHdr, rows } of sheets) {\n parts.push(\n `

${name}

` +\n HEADERS.map((h) => ``).join(\"\") + \"\",\n );\n const totals = new Array(9).fill(0);\n for (const r of rows) {\n const nums = r.slice(1) as number[];\n nums.forEach((v, i) => totals[i] += v);\n parts.push(\n `` +\n nums.map((v) => ``).join(\"\") +\n \"\",\n );\n }\n parts.push(\n `` +\n totals.map((v) => ``).join(\"\") +\n \"

${labelHdr}	${h}
${r[0]}	${v.toLocaleString(\"en-US\")}
TOTAL	${v.toLocaleString(\"en-US\")}

\",\n );\n }\n parts.push(\"\");\n return parts.join(\"\\n\");\n}","label",[132],"0fc25f8a-f11d-4efb-a43f-6e88a9115450",["D",1784923548086],"turnedout",[27],"a9a9cdb5-3117-4e08-b9e9-ff04c3df9c0d","cron.ts","c5c538a4-879a-11f1-95c9-1607ee4eb77e",10,["D",1784923479390],"// 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\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\nimport {\n BASE,\n buildHtml,\n buildXlsx,\n PAGE_URL,\n parseTokens,\n pdfToTokens,\n REPORTS,\n Sheets,\n} from \"./shared.ts\";\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\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 if (have >= 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 // All five parsed and verified — only now touch storage.\n await blob.set(\"xlsx\", buildXlsx(sheets, latest));\n await blob.set(\"html\", buildHtml(sheets, latest));\n await blob.setJSON(\"meta\", {\n report_date: latest,\n updated: new Date().toISOString(),\n });\n console.log(`Stored report ${latest}.`);\n}",[147],"pulls","branches",1,"forks","envVars",{"_161":61,"_163":61},"connections",{"_161":61,"_162":61},"count","unfilledCount","emptyCount",{"_42":146,"_32":147,"_30":148,"_134":-5,"_40":41,"_39":149,"_136":24,"_37":174,"_13":138,"_33":34,"_35":151,"_23":24,"_140":-5,"_168":175,"_26":176},{"_42":142,"_32":27,"_30":31,"_134":-5,"_40":41,"_39":14,"_136":24,"_37":171,"_13":61,"_33":34,"_35":36,"_23":24,"_140":144,"_168":172,"_26":173},{"_42":131,"_32":132,"_30":133,"_134":-5,"_40":41,"_39":135,"_136":24,"_37":167,"_13":138,"_33":34,"_35":139,"_23":24,"_140":-5,"_168":169,"_26":170},["D",1784923402602],"children",[],[132],["D",1784923548086],[],[27],["D",1784923479390],[],[147],["D",1784884388277],["D",1789473046147],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":24},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_125":215,"_216":217,"_218":219,"_220":24,"_221":24,"_222":24,"_223":57,"_224":-5,"_225":-7,"_226":-7,"_227":61,"_228":24,"_229":24,"_230":-5,"_231":24,"_232":24,"_233":24,"_234":-5},"ENV",{"_186":187,"_188":189,"_190":88,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214},"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 · v11