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 →-
Polling Analysis Update
An update on the Westminster polling sites and work underway on a new, more detailed polling tracker ahead of the 2029 General Election.
- #polling
- #elections
- #politics
- #data
-
GB Energy Accounts — Shutdown
Why the GB Energy Twitter and Mastodon bot accounts have gone dark following Twitter platform and BMRS API changes, and where to track live grid data now.
- #energy
- #gb-grid
- #bots
- #mastodon
- #bluesky
-
Football Kit Colours
Scraping Wikipedia infoboxes with Python Beautiful Soup and Pillow to extract primary kit colours across the top 10 tiers of the English football league system.
- #python
- #football
- #data
- #wikipedia
-
Bitcoin Energy Use
Breaking down why the Bitcoin network consumes gigawatts of electricity, how block rewards drive mining economics, and the kWh and CO₂ cost of a single transaction.
- #energy
- #bitcoin
- #economics
- #carbon
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 | Archived |
| Westminster Polling Averages Aggregated UK Westminster voting-intention polling tracker and moving-average analysis across British pollsters. elect.bee.ac | 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. football-kits.bee.ac | 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 |
| Phedran's Pixelmon Reforged Database Searchable reference database built with HTML, Bootstrap, PHP, and JavaScript for Pixelmon Reforged. pixelmon.bt.gs | Web Tool | Maintained |