SQL Query

Run browser-side SQL against the SESG public data 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;