Nicolás Forero

Projects

Four case studies on real, open data. Each one publishes its question, method, results with uncertainty and a replication package.

SQL · Python · Next in line

Live public procurement observatory

Question
How does each municipality buy today, and how does it compare with its peers?
Method
Daily incremental ingestion, tested dbt models and aggregate indicators. They are statistical signals, never accusations.
Data
SECOP II, datos.gov.co (CC BY-SA 4.0)

Stack

  • n8n
  • dbt
  • DuckDB
  • Socrata API

Key result

Pending. Published once the code has run; no figure goes here without analysis behind it.

R · Planned

Does procurement change when the government changes hands?

Question
After an election decided by a handful of votes, how much does a mayor’s office change who it buys from, and how?
Method
Regression discontinuity on close elections, with an analysis plan written before seeing results, placebos and bandwidth sensitivity.
Data
SECOP Integrado and municipal election results

Stack

  • rdrobust
  • rddensity
  • grf
  • targets

Key result

Pending. Published once the code has run; no figure goes here without analysis behind it.

R · Planned

Informality and wage gaps, 2015–2025

Question
How much of the formal–informal gap comes from who the workers are, and how much from how they are paid?
Method
Oaxaca-Blinder decomposition and RIF regressions by decile, with survey weights; double machine learning for returns to education.
Data
GEIH microdata, DANE

Stack

  • survey
  • Oaxaca-Blinder
  • RIF
  • DoubleML

Key result

Pending. Published once the code has run; no figure goes here without analysis behind it.

Python · Planned

Municipal early warning for deforestation

Question
Which municipalities face the highest risk of forest loss next year, and how reliable is that signal?
Method
Gradient boosting with spatial validation, calibration and a comparison against the persistence baseline.
Data
Hansen Global Forest Change v1.13 (CC BY 4.0)

Stack

  • LightGBM
  • SHAP
  • rasterio
  • MapLibre

Key result

Pending. Published once the code has run; no figure goes here without analysis behind it.