\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","children",[],[153],"files",[151],"counts",{"_174":32,"_175":176,"_177":32,"_178":32},"pulls","branches",1,"forks","envVars","contents",[181],{"_102":152,"_95":153,"_154":115,"_155":-5,"_156":139,"_157":138,"_158":108,"_104":182,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":183},["D",1740539014307],[153],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":193,"_179":198,"_201":-7,"_202":-5,"_203":-5,"_170":204,"_208":209},{"_102":103,"_95":96,"_104":194,"_106":-5,"_107":108,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":115,"_116":108,"_117":-5,"_118":119,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":195,"_133":196,"_136":197,"_148":22},["D",1746220192893],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_99":138,"_95":43,"_102":139,"_140":103,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},[199],{"_102":152,"_95":153,"_154":115,"_155":-5,"_156":139,"_157":138,"_158":108,"_104":182,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":200},[153],"readme","upstream","pull",[205],{"_102":152,"_95":153,"_154":115,"_155":-5,"_156":139,"_157":138,"_158":108,"_104":159,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":206,"_98":207},[],[153],"previews",[205],"actionData","errors"]