The Game Awards Explorer

A full-stack, read-only web app for exploring the complete nomination and winner history of The Game Awards — 1,777 nominations across 70 categories and 12 ceremonies (2014–2025).

How it was built:

The dataset didn't exist as structured data, so the first step was building it: the original 2014–2019 records were combined with 2020–2025 results transcribed by hand from Wikipedia, then parsed and seeded into a SQLite database via a one-time script. A small but real bug along the way — a CRLF/LF line-ending mismatch that silently corrupted the CSV parser — was a good reminder that "just append a row" isn't always safe. Game/company artwork was enriched afterward through the Wikipedia API, with retry logic for rate limits and manual overrides for ambiguous titles. The app itself (React frontend, Express API, SQLite storage) was developed iteratively in short cycles — build a feature, test it in the browser, refine — with Claude Code as a pair-programming tool throughout.

Stack:

React (Vite) · Node / Express · SQLite (better-sqlite3) · no auth, no writes at runtime — the data is static and the whole app is read-only.

Key features:

Timeline — chronological view of winners for the most recent years, with a draggable period filter and summary stats

Explore — a fully filterable, searchable, paginated table across all 1,777 nominations

Compare — side-by-side stats for any two nominees, auto-seeded with two of the most-awarded games

Dashboard — aggregated rankings and comparisons: top-winning companies, win rates, most/least contested categories, jury vs. fan voting patterns — built with accessible, colorblind-safe charts

Global search, dedicated profile pages for every game/company/category, and a persisted light/dark theme

Link to project presentation (portuguese)!