Lab 05 — LATAM socioeconomic inequality (Supabase + dashboard)
Larger project: ingest socioeconomic and inequality indicators from international and national entities into Supabase, analyse them, and publish a dashboard with our own map (not live API-only).
- Objective
- Build a reproducible pipeline (ETL → Postgres/Supabase with RLS → analysis → map/dashboard) on socioeconomic conditions and inequality in Latin America, with cited sources and versioned data.
- Methodology
- 1) Model design (country/year/indicator; optional subnational) and RLS policies. 2) Candidate sources: CEPALSTAT, World Bank, SDGs/UN, national statistical offices (INE/DANE and LATAM peers) per licence. 3) Versioned load scripts in scripts/sql + seeds; no secrets in the client. 4) Analysis layer (series, gaps, rankings) documented. 5) Frontend: multi-indicator dashboard + choropleth from our tables (snapshot or own API), not Overpass/OSM as the core. 6) Requires an explicit decision to activate Supabase (still optional for the site MVP).
- Limitations
- Large scope (multi-country, multi-source). Cross-country comparability is imperfect. Supabase cost/ops and ETL upkeep. Not the current static personal-site MVP.
Sources & APIs
- CEPALSTAT
Economic and social indicators for Latin America and the Caribbean.
- World Bank Indicators API v2
Country series (e.g. COL); no API key. Good first dashboard.
Docs - Datos Abiertos Colombia (datos.gov.co)
SODA/Socrata portal: REST + SoQL per dataset (Export → API).
Docs - Supabase (Postgres + RLS) — planificado
Own store for Lab 05 (LATAM indicators). Not active in the site MVP yet; needs versioned schema, RLS and an explicit go-live decision.
Docs