Data Analyst · Software Developer · Maker
Turning public data into clear, fast tools and updates.
Most of my work sits where open datasets meet everyday questions — how Great Britain's electricity grid is being powered right now, where Westminster polling averages stand, and what local weather stations are recording. Alongside that I build web tools and scripted mods for Tabletop Simulator.
Recent writing
All posts →-
Leaving Squarespace for Static HTML and Firebase Hosting
Why I replaced a hosted CMS with an Astro static build, self-hosted fonts, and edge redirects on Firebase Hosting.
- #web
- #astro
- #firebase
- #colophon
-
Reading the Top Face of a Tumbling Die in Three.js
Notes on building dice.bee.ac: rigid-body polyhedra in cannon-es, face-normal dot products for reading d4 through d20 results, and deterministic replay.
- #threejs
- #webgl
- #typescript
- #gamedev
-
Tracking Great Britain's Changing Electricity Grid
How Britain's generation mix shifted from coal baseload to wind, solar, and interconnectors — and how the GB Grid bot pipeline reconciles Elexon BMRS outturn with embedded solar.
- #energy
- #python
- #data
- #uk-grid
Selected projects
Directory →| Project | Category | Status |
|---|---|---|
| GB Energy Grid Tracker Automated half-hourly telemetry pipeline and 9-account bot family reporting Great Britain's generation mix, interconnector flows, and grid records from Elexon BMRS and Sheffield Solar. andylawton.com/gb-grid | Bot / Automation | Active |
| Westminster Polling Averages Aggregated UK Westminster voting-intention polling tracker and moving-average analysis across British pollsters. elect.bee.ac | Data Display | Active |
| Local Weather Python data storage and manipulation pipeline paired with a lightweight PHP + Bootstrap weather dashboard. weather.andylawton.com | Data Display | Active |
| English Football Club Kit Colours Python scraper and image analyser that pulls club kit graphics from Wikipedia and breaks each team down into major colour groups. sandbox.andylawton.com | Data Display | Active |
| Three.js Physics Dice Roller Fully customisable 3D dice roller for stream overlays and tabletop play (dice.bee.ac). Adapted from Teal's Three.js + random.org dice roller with URL-configured dice/label/chroma-key colours, scale, and preset notation. dice.bee.ac | Web Tool | Active |