SQL Query

Run browser-side SQL against the SESG public data files. The SQL page uses compact wide indicator tables for performance; use the Downloads page for the full long indicator files.

Example queries

Copy one of these into the query box above. These examples are shown as text and are not executed automatically.

SELECT country_name, year, sesg_score_0_100, sesg_rank
FROM overall
WHERE year = 2024
ORDER BY sesg_score_0_100 DESC
LIMIT 20;

SELECT country_name, pillar, pillar_score_0_100
FROM pillars
WHERE country_iso3 = 'NGA'
ORDER BY year, pillar;

SELECT climate_classification, year, AVG(sesg_score_0_100) AS avg_sesg
FROM overall
GROUP BY climate_classification, year
ORDER BY year DESC, avg_sesg DESC;

SELECT country_name, year, ENV_FOOD_001 AS agricultural_land_score
FROM indicator_scores
WHERE country_iso3 = 'NGA'
ORDER BY year;