I’ve open-sourced QUEENS, a Python package that ingests UK Energy official Excel data tables into SQLite and serves a clean, versioned snapshot via FastAPI.
- Reads directly from GOV.UK
- ETL + data versioning into long-format SQLite DB
- CLI & Python library for queries/exports
- API with filters (numeric ops + string LIKE)
- Export to CSV/Parquet/XLSX
- Fully configured for DUKES 2025 – easily extendable to other data collections.
GitHub: https://github.com/alebgz-91/queens
PyPI: https://pypi.org/project/queens/
If you use UK energy statistics in modeling/analysis or find the design useful, I’d love feedback or feature requests.
Source: KaleidoscopeNo6551