[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_145":146,"_147":148},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_84":66,"_85":86,"_64":-7,"_87":-5,"_13":88,"_89":90,"_11":91,"_92":93,"_94":95,"_96":-5,"_97":-5,"_98":-5,"_99":63,"_100":101,"_102":26,"_103":-5,"_104":-5,"_105":106},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":35,"_36":26,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":48,"_49":48,"_50":51,"_52":51,"_53":51,"_54":48,"_55":48,"_56":57,"_58":59,"_60":61,"_62":63},"query","handle","alexwein","id","ca79e12c-2799-11f0-9d52-569c3dd06744","name","judgeWordsDash","createdAt",["D",1746220192893],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","userId","b85dcfbf-50f1-466c-9e2b-28ac90e0dd23","pinnedFileId","ca7c4246-2799-11f0-9d52-569c3dd06744","pinPreview","pinMigrated","screenshotVersion","likeCount",2,"orgId","875ed3cd-ae4b-40bb-a45f-6a1970e11689","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_16":17,"_83":79},"org",{"_16":17,"_76":77,"_78":79,"_32":33,"_80":81,"_82":63},"branch",{"_64":65,"_20":66,"_18":67,"_68":19,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":21,"_75":17},"isOwned",false,"version",23,"main","ca7a1da4-2799-11f0-9d52-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Alex Wein","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycjh6emNHdk9mMnY5djU3OFZBbEdleGhQZFAifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":141,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":35,"_36":26,"_37":-5,"_38":-5,"_39":40,"_41":42,"_43":-5,"_44":-5,"_45":-5,"_46":-5,"_47":48,"_49":48,"_50":51,"_52":51,"_53":51,"_54":48,"_55":48,"_56":142,"_58":143,"_60":144,"_62":63},"tree",[136],[136],"counts",{"_124":125,"_126":127,"_128":125,"_129":130,"_131":132},"contents",[107],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":108,"_20":109,"_110":35,"_111":-5,"_112":67,"_113":65,"_114":26,"_22":115,"_64":116,"_117":118,"_119":120,"_121":63,"_122":-5,"_85":123},"caf43742-2799-11f0-9d52-569c3dd06744","main.tsx","fileId","parentId","branchId","branchVersion","latest",["D",1740539014307],22,"fileType","http","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\nfunction PieChart({ percentage }) {\n const angle = percentage * 360;\n return (\n \n );\n}\n\nfunction BarChart({ distribution }) {\n const maxValue = Math.max(...Object.values(distribution));\n const barWidth = 6;\n const gap = 2;\n const height = 40;\n\n const colors = {\n \"0\": \"#607D8B\",\n \"1\": \"#FF9800\",\n \"2\": \"#FFEB3B\",\n \"3\": \"#4CAF50\",\n \"4\": \"#2196F3\",\n \"5\": \"#9C27B0\",\n };\n\n return (\n \n );\n}\n\nfunction IntroBox() {\n return (\n

\n To one day improve my little word games, I \"made\"{\" \"}\n an app{\" \"}\n to let me rate whether words in the Wordnik word game list are \"real words\" or not. This page let's me track my\n progress as I judge. Both the Judge Words app and this dashboard were built leaning quite heavily on Val Town's\n Townie AI interface. If you're in the mood for a very simple word game, check out{\" \"}\n Loopy Letters{\" \"}- Alex.\n

\n );\n}\n\nfunction Dashboard() {\n const [stats, setStats] = useState([]);\n\n useEffect(() => {\n fetch(\"/stats\")\n .then(response => response.json())\n .then(setStats);\n }, []);\n\n const grandTotal = stats.length > 0 ? stats[0] : null;\n\n return (\n

Word Judgment Dashboard

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {grandTotal && (\n \n \n \n \n \n \n \n \n \n )}\n {stats.slice(1).map(stat => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

Word Length	Total Words	Judged Words	% Judged	Pie Chart	Avg Rating	Rating Distribution
Grand Total	{grandTotal.totalWords}	{grandTotal.judgedWords}	{(grandTotal.percentJudged * 100).toFixed(2)}%	\n \n	{grandTotal.avgRating.toFixed(2)}	\n \n
{stat.wordLength}	{stat.totalWords}	{stat.judgedWords}	{(stat.percentJudged * 100).toFixed(2)}%	\n \n	{stat.avgRating.toFixed(2)}	\n \n

\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // Handle stats request\n if (new URL(request.url).pathname === \"/stats\") {\n const stats = await sqlite.execute(`\n WITH WordStats AS (\n SELECT \n length(word) as wordLength,\n COUNT(*) as totalWords,\n COUNT(judgment) as judgedWords,\n AVG(judgment) as avgRating,\n json_object(\n '0', COUNT(CASE WHEN judgment = 0 THEN 1 END),\n '1', COUNT(CASE WHEN judgment = 1 THEN 1 END),\n '2', COUNT(CASE WHEN judgment = 2 THEN 1 END),\n '3', COUNT(CASE WHEN judgment = 3 THEN 1 END),\n '4', COUNT(CASE WHEN judgment = 4 THEN 1 END),\n '5', COUNT(CASE WHEN judgment = 5 THEN 1 END)\n ) as distribution\n FROM judgments\n GROUP BY length(word)\n\n UNION ALL\n\n SELECT \n 'total' as wordLength,\n COUNT(*) as totalWords,\n COUNT(judgment) as judgedWords,\n AVG(CASE WHEN judgment > 0 THEN judgment END) as avgRating,\n json_object(\n '0', COUNT(CASE WHEN judgment = 0 THEN 1 END),\n '1', COUNT(CASE WHEN judgment = 1 THEN 1 END),\n '2', COUNT(CASE WHEN judgment = 2 THEN 1 END),\n '3', COUNT(CASE WHEN judgment = 3 THEN 1 END),\n '4', COUNT(CASE WHEN judgment = 4 THEN 1 END),\n '5', COUNT(CASE WHEN judgment = 5 THEN 1 END)\n ) as distribution\n FROM judgments\n )\n SELECT \n wordLength, \n totalWords, \n judgedWords, \n CAST(judgedWords AS FLOAT) / totalWords as percentJudged, \n COALESCE(avgRating, 0) as avgRating,\n distribution\n FROM WordStats\n ORDER BY \n CASE WHEN wordLength = 'total' THEN 0 ELSE 1 END,\n CAST(wordLength AS INTEGER)\n `);\n\n return new Response(JSON.stringify(stats.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // Render HTML\n return new Response(\n `\n \n \n Word Judgment Dashboard\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}\n\nconst styles = {\n container: {\n fontFamily: \"\\\"Roboto Mono\\\", monospace\",\n maxWidth: \"1100px\",\n margin: \"0 auto\",\n padding: \"20px\",\n },\n introBox: {\n backgroundColor: \"#f0f0f0\",\n border: \"1px solid #ddd\",\n borderRadius: \"5px\",\n padding: \"15px\",\n marginBottom: \"20px\",\n },\n table: {\n width: \"100%\",\n borderCollapse: \"collapse\",\n marginBottom: \"20px\",\n },\n cell: {\n padding: \"8px\",\n border: \"1px solid #ddd\",\n },\n cellNumber: {\n padding: \"8px\",\n border: \"1px solid #ddd\",\n textAlign: \"right\",\n },\n cellCenter: {\n padding: \"8px\",\n border: \"1px solid #ddd\",\n textAlign: \"center\",\n },\n grandTotal: {\n backgroundColor: \"#f5f5f5\",\n fontWeight: \"bold\",\n },\n grandTotalCell: {\n padding: \"8px\",\n border: \"2px solid #aaa\",\n },\n grandTotalCellNumber: {\n padding: \"8px\",\n border: \"2px solid #aaa\",\n textAlign: \"right\",\n },\n grandTotalCellCenter: {\n padding: \"8px\",\n border: \"2px solid #aaa\",\n textAlign: \"center\",\n },\n sourceLink: {\n color: \"#666\",\n textDecoration: \"none\",\n fontSize: \"0.8em\",\n },\n};","deleted","label",[109],"pulls",0,"branches",1,"forks","envVars",{"_133":125,"_135":125},"connections",{"_133":125,"_134":125},"count","unfilledCount","emptyCount",{"_18":108,"_20":109,"_110":35,"_111":-5,"_112":67,"_113":65,"_114":26,"_22":137,"_64":116,"_117":118,"_119":120,"_121":63,"_122":-5,"_138":139,"_85":140},["D",1740539014307],"children",[],[109],["D",1746220192893],{"_16":17,"_83":79},{"_16":17,"_76":77,"_78":79,"_32":33,"_80":81,"_82":63},{"_64":65,"_20":66,"_18":67,"_68":19,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":21,"_75":17},"ctx",{"_56":-5,"_104":178,"_179":180,"_181":182,"_183":63,"_184":63,"_185":63,"_186":26,"_187":-5,"_188":-7,"_189":-7,"_190":125,"_191":63,"_192":63,"_193":-5,"_194":63,"_195":63,"_196":63,"_197":-5},"ENV",{"_149":150,"_151":152,"_153":66,"_154":155,"_156":157,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177},"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"]

Search