[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_104":85,"_27":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":49,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","ca7c4246-2799-11f0-9d52-569c3dd06744","name","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 AreaChart({ timeSeriesData }) {\n const width = 1000;\n const height = 300;\n const margin = { top: 20, right: 20, bottom: 30, left: 50 };\n const chartWidth = width - margin.left - margin.right;\n const chartHeight = height - margin.top - margin.bottom;\n\n const dates = timeSeriesData.map(d => new Date(d.date));\n const minDate = new Date(Math.min(...dates));\n const maxDate = new Date(Math.max(...dates));\n\n const xScale = (date) => (\n ((date - minDate) / (maxDate - minDate)) * chartWidth\n );\n\n const yScale = (value) => (\n chartHeight - (value / timeSeriesData[timeSeriesData.length - 1].total) * chartHeight\n );\n\n const area = (judgment) => {\n let d = `M${xScale(new Date(timeSeriesData[0].date))},${chartHeight}`;\n for (let point of timeSeriesData) {\n d += `L${xScale(new Date(point.date))},${yScale(point[judgment])}`;\n }\n d += `L${xScale(new Date(timeSeriesData[timeSeriesData.length - 1].date))},${chartHeight}Z`;\n return d;\n };\n\n const colors = {\n judgment0: \"#607D8B\",\n judgment1: \"#FF9800\",\n judgment2: \"#FFEB3B\",\n judgment3: \"#4CAF50\",\n judgment4: \"#2196F3\",\n judgment5: \"#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. - Alex.\n

\n Play Loopy Letters\n

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

Word Judgment Dashboard

\n \n

Cumulative Judgments Over Time

\n {timeSeriesData.length > 0 && }\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(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 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 // Handle time series request\n if (new URL(request.url).pathname === \"/time-series\") {\n const timeSeries = await sqlite.execute(`\n WITH RECURSIVE\n dates(date) AS (\n SELECT DATE(MIN(judged_at)) FROM judgments\n UNION ALL\n SELECT DATE(date, '+1 day')\n FROM dates\n WHERE date < DATE(CURRENT_DATE)\n ),\n daily_counts AS (\n SELECT\n DATE(judged_at) as date,\n SUM(CASE WHEN judgment = 0 THEN 1 ELSE 0 END) as judgment0,\n SUM(CASE WHEN judgment = 1 THEN 1 ELSE 0 END) as judgment1,\n SUM(CASE WHEN judgment = 2 THEN 1 ELSE 0 END) as judgment2,\n SUM(CASE WHEN judgment = 3 THEN 1 ELSE 0 END) as judgment3,\n SUM(CASE WHEN judgment = 4 THEN 1 ELSE 0 END) as judgment4,\n SUM(CASE WHEN judgment = 5 THEN 1 ELSE 0 END) as judgment5\n FROM judgments\n GROUP BY DATE(judged_at)\n )\n SELECT\n dates.date,\n COALESCE(SUM(daily_counts.judgment0) OVER (ORDER BY dates.date), 0) as judgment0,\n COALESCE(SUM(daily_counts.judgment1) OVER (ORDER BY dates.date), 0) as judgment1,\n COALESCE(SUM(daily_counts.judgment2) OVER (ORDER BY dates.date), 0) as judgment2,\n COALESCE(SUM(daily_counts.judgment3) OVER (ORDER BY dates.date), 0) as judgment3,\n COALESCE(SUM(daily_counts.judgment4) OVER (ORDER BY dates.date), 0) as judgment4,\n COALESCE(SUM(daily_counts.judgment5) OVER (ORDER BY dates.date), 0) as judgment5,\n COALESCE(SUM(daily_counts.judgment0 + daily_counts.judgment1 + daily_counts.judgment2 + daily_counts.judgment3 + daily_counts.judgment4 + daily_counts.judgment5) OVER (ORDER BY dates.date), 0) as total\n FROM dates\n LEFT JOIN daily_counts ON dates.date = daily_counts.date\n ORDER BY dates.date\n `);\n\n return new Response(JSON.stringify(timeSeries.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

Word Judgment Dashboard

\n \n

Cumulative Judgments Over Time

\n {timeSeriesData.length > 0 && }\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 \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 areaChart: {\n marginBottom: \"30px\",\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};","createdAt",["D",1740509345142],"branchVersion","branchId","ca7a1da4-2799-11f0-9d52-569c3dd06744","id","ca79e12c-2799-11f0-9d52-569c3dd06744","judgeWordsDash",["D",1746220192893],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","b85dcfbf-50f1-466c-9e2b-28ac90e0dd23","pinnedFileId","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",{"_95":94,"_103":99},"org",{"_95":94,"_96":97,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","alexwein","handle","displayName","Alex Wein","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycjh6emNHdk9mMnY5djU3OFZBbEdleGhQZFAifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":151,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":152,"_79":153,"_81":154,"_83":25},"tree",[146],"files",[146],"counts",{"_134":135,"_136":137,"_138":135,"_139":140,"_141":142},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"cabda718-2799-11f0-9d52-569c3dd06744","parentId","latest",["D",1740509345142],12,"label",[28],"pulls",0,"branches",1,"forks","envVars",{"_143":135,"_145":135},"connections",{"_143":135,"_144":135},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":147,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_148":149,"_27":150},["D",1740509345142],"children",[],[28],["D",1746220192893],{"_95":94,"_103":99},{"_95":94,"_96":97,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_123":188,"_189":190,"_191":192,"_193":25,"_194":25,"_195":25,"_196":49,"_197":-5,"_198":-7,"_199":-7,"_200":135,"_201":25,"_202":25,"_203":-5,"_204":25,"_205":25,"_206":25,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":85,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v13