§1 · Work · 12 entries
Research & software
Papers, packages, pipelines and the odd piece of hardware, listed like a reference section. Each entry comes with a figure. The figures are generated from the project's name, so treat them as illustrations, not results.
- [1]Regional Favoritism, RebuiltA from-scratch replication of Hodler & Raschky (2014, QJE): do regions glow brighter at night while their native son holds power? Extended with a harmonised DMSP/VIIRS panel through 2023.R · GIS · Nighttime lights · Panel econometrics · QuartoFig. A.1
- [2]inkaRAn R package on CRAN that turns the BBSR INKAR regional statistics API into tidy data frames and publication-ready maps of Germany.R · CRAN · sf · ggplot2 · REST APIFig. A.2
- [3]AEDS RAG AssistantA retrieval-augmented chat assistant that answers students' questions about a master's programme strictly from its official documents, with citations, a relevance gate, and staff review.Python · FastAPI · LangGraph · Chroma · BM25Fig. A.3
- [4]Urban Land-Use EfficiencyWhy the official SDG 11.3.1 sprawl indicator is statistically unstable, what a log-based replacement recovers, and how per-capita designs can manufacture the drivers they claim to find. 193 countries, 1985 to 2020.R · Google Earth Engine · GHSL · Dynamic panel GMM · Two-way FEFig. A.4
- [5]Immigration, Crime and ProsperityA 400-district, 19-year panel of Germany: prosperity follows the quality of labour-market integration, not the quantity of migrants.R · TWFE · renv · Make · INKARFig. A.5
- [6]R Plot ProA VS Code extension that brings an RStudio-style plots pane to R and Julia: automatic capture, no focus-stealing windows.TypeScript · VS Code API · R · JuliaFig. A.6
- [7]German Power Price ForecastingForecasting hourly day-ahead electricity prices in Germany (2020 to 2026) around the merit-order effect, from automated ETL to ARIMAX vs Ridge vs XGBoost.Python · XGBoost · statsmodels · scikit-learn · SMARD APIFig. A.7
- [8]Discogs Data MachineA family of tools that turns the monthly Discogs music database dumps (tens of GB of XML) into clean CSVs and publishes them to Kaggle, fully automated.Python · Swift · Kaggle API · Streaming XML · HomebrewFig. A.8
- [9]End-to-End BI PipelineA containerised business-intelligence stack for credit-card fraud analysis: Python ETL into a PostgreSQL star schema, and an auto-generated Metabase dashboard with 30+ KPIs.Python · PostgreSQL · Metabase · Docker Compose · Star schemaFig. A.9
- [10]Quarto Presentation ToolkitExtensions for Quarto reveal.js decks: freehand ink annotation with whiteboard and export, a precision laser pointer, and a progress indicator.JavaScript · Lua · Quarto · reveal.jsFig. A.10
- [11]AEDS Credit TrackerA single-file ECTS, GPA and graduation planner for my master's programme. No backend, no account, all data stays in the browser.HTML · JavaScript · GitHub ActionsFig. A.11
- [12]ESP32 Guitar TunerA guitar tuner on an ESP32-S3 with a round touch display, using AMDF pitch detection with reverse search to lock onto low strings without harmonic jumps.C · ESP-IDF · DSP · I2S microphoneFig. A.12