Skip to content

Instantly share code, notes, and snippets.

@tgherzog
Created February 3, 2022 01:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tgherzog/e0d6cc342015868aba864c9bf012831c to your computer and use it in GitHub Desktop.
Save tgherzog/e0d6cc342015868aba864c9bf012831c to your computer and use it in GitHub Desktop.

MRY Age of Indicators

Ages are relative to the previous year. An age of 0 means 2018 for the "Original Report" and 2020 for "Oct, 2021".

indicatorID indicator Original Report Oct, 2021 Change
EN.ATM.NOXE.PC Nitrous oxide emissions (metric tons of CO2 equivalent per capita) 6 2 -4
EN.ATM.METH.PC Methane emissions (metric tons of CO2 equivalent per capita) 6 2 -4
AG.LND.FRST.ZS Forest area (% of land area) 2 0 -2
EN.ATM.CO2E.PC CO2 emissions (metric tons per capita) 4 2 -2
SH.MED.BEDS.ZS Hospital beds (per 1,000 people) 3 1 -2
EG.ELC.RNEW.ZS Renewable electricity output (% of total electricity output) 3 1 -2
SH.STA.SMSS.ZS People using safely managed sanitation services (% of population) 1 0 -1
SH.DTH.COMM.ZS Cause of death, by communicable diseases and maternal, prenatal and nutrition conditions (% of total) 2 1 -1
ER.H2O.FWTL.ZS Annual freshwater withdrawals, total (% of internal resources) 4 3 -1
EG.FEC.RNEW.ZS Renewable energy consumption (% of total final energy consumption) 3 2 -1
SH.H2O.SMDW.ZS People using safely managed drinking water services (% of population) 1 0 -1
SE.XPD.TOTL.GB.ZS Government expenditure on education, total (% of government expenditure) 0 0 0
SE.ENR.PRSC.FM.ZS School enrollment, primary and secondary (gross), gender parity index (GPI) 0 0 0
SG.GEN.PARL.ZS Proportion of seats held by women in national parliaments (%) 0 0 0
SE.ADT.LITR.ZS Literacy rate, adult total (% of people ages 15 and above) 0 0 0
RQ.EST Regulatory Quality: Estimate 0 0 0
RL.EST Rule of Law: Estimate 0 0 0
PV.EST Political Stability and Absence of Violence/Terrorism: Estimate 0 0 0
SE.PRM.ENRR School enrollment, primary (% gross) 0 0 0
AG.LND.AGRI.ZS Agricultural land (% of land area) 2 2 0
SI.DST.FRST.20 Income share held by lowest 20% 1 1 0
SI.POV.GINI GINI index (World Bank estimate) 1 1 0
SI.POV.NAHC Poverty headcount ratio at national poverty lines (% of population) 0 0 0
SI.SPR.PCAP.ZG Annualized average growth rate in per capita real survey mean consumption or income, total population (%) 1 1 0
SL.UEM.TOTL.ZS Unemployment, total (% of total labor force) (modeled ILO estimate) 0 0 0
SN.ITK.DEFC.ZS Prevalence of undernourishment (% of population) 1 1 0
SP.DYN.LE00.IN Life expectancy at birth, total (years) 1 1 0
SP.DYN.TFRT.IN Fertility rate, total (births per woman) 1 1 0
SP.POP.65UP.TO.ZS Population ages 65 and above (% of total population) 0 0 0
NY.GDP.MKTP.KD.ZG GDP growth (annual %) 0 0 0
NY.ADJ.DRES.GN.ZS Adjusted savings: natural resources depletion (% of GNI) 1 1 0
NY.ADJ.DFOR.GN.ZS Adjusted savings: net forest depletion (% of GNI) 1 1 0
NV.AGR.TOTL.ZS Agriculture, forestry, and fishing, value added (% of GDP) 0 0 0
AG.PRD.FOOD.XD Food production index (2004-2006 = 100) 2 2 0
CC.EST Control of Corruption: Estimate 0 0 0
EG.ELC.ACCS.ZS Access to electricity (% of population) 1 1 0
SP.UWT.TFRT Unmet need for contraception (% of married women ages 15-49) 0 0 0
EN.POP.DNST Population density (people per sq. km of land area) 0 0 0
GB.XPD.RSDV.GD.ZS Research and development expenditure (% of GDP) 1 1 0
VA.EST Voice and Accountability: Estimate 0 0 0
IT.NET.USER.ZS Individuals using the Internet (% of population) 0 0 0
IP.JRN.ARTC.SC Scientific and technical journal articles 2 2 0
GE.EST Government Effectiveness: Estimate 0 0 0
IC.BUS.EASE.XQ Ease of doing business index (1=most business-friendly regulations) 0 1 1
SH.DYN.MORT Mortality rate, under-5 (per 1,000 live births) 0 1 1
IP.PAT.RESD Patent applications, residents 0 1 1
IC.LGL.CRED.XQ Strength of legal rights index (0=weak to 12=strong) 0 1 1
SL.TLF.CACT.FM.ZS Ratio of female to male labor force participation rate (%) (modeled ILO estimate) 0 1 1
SL.TLF.ACTI.ZS Labor force participation rate, total (% of total population ages 15-64) (modeled ILO estimate) 0 1 1
ER.PTD.TOTL.ZS Terrestrial and marine protected areas (% of total territorial area) 0 2 2
EG.CFT.ACCS.ZS Access to clean fuels and technologies for cooking (% of population) 2 4 2
EG.EGY.PRIM.PP.KD Energy intensity level of primary energy (MJ/$2011 PPP GDP) 3 5 2
SM.POP.NETM Net migration 1 3 2
EG.ELC.COAL.ZS Electricity production from coal sources (% of total) 3 5 2
EG.IMP.CONS.ZS Energy imports, net (% of energy use) 3 5 2
EG.USE.COMM.FO.ZS Fossil fuel energy consumption (% of total) 3 5 2
EG.USE.PCAP.KG.OE Energy use (kg of oil equivalent per capita) 3 5 2
SH.STA.OWAD.ZS Prevalence of overweight (% of adults) 2 4 2
EN.CLC.GHGR.MT.CE GHG net emissions/removals by LUCF (Mt of CO2 equivalent) 9 11 2
EN.CLC.MDAT.ZS Droughts, floods, extreme temperatures (% of population, average 1990-2009) 9 11 2
EN.MAM.THRD.NO Mammal species, threatened 0 2 2
SL.TLF.0714.ZS Children in employment, total (% of children ages 7-14) 2 4 2
EN.ATM.PM25.MC.M3 PM2.5 air pollution, mean annual exposure (micrograms per cubic meter) 1 3 2

MRY Analysis

This is a quick summary analysis of updates to the ESG database since the original gaps analysis in 2020. Updates are due to scheduled and intermediate revisions to specific indicators using more recent data. This analysis presents summary findings and some explanations for changes in indicator age. The complete python notebook for this analysis is available here.

Here is a snapshot of the current ESG database looking at the most recent available year (MRY) of each indicator, compared to the database used in the gaps analysis from 2019.

Indicators by MRY

Year Original Oct, 2021
2009 2 2
2012 2
2014 2
2015 8 5
2016 8 3
2017 14 3
2018 27 9
2019 19
2020 22

As you would expect, we have more recent data for quite a few indicators that are maintained as active statistics, along with some improvements in some of the older series. However, there are still two very old indicators that have not been updated at all (see attached spreadsheet).

Here is the same summary but converted to “age” (in years) where 0 or “current” would be last year (2020 currently, 2018 originally), 1 would be a year prior, etc.

Age Original Oct, 2021
Current 27 22
1 14 19
2 8 9
3 8 3
4+ 6 10
average 1.46 1.67

In this context, the state of the database is more mixed. Some of the changes in the 0-1 year range are attributable to the fact that a handful of indicators that normally get updated in October-December are still in the pipeline, and are expected to be ready for the December push. In other cases, such as Child Mortality, the data are collected by other agencies and have been delayed by COVID. In still others, particularly the energy data from IEA, we’re still in discussions around licensing and/or looking for better substitutes (these are largely what account for the drops in the count of 3-year-old indicators and the corresponding increase in 4-year-old-plus indicators).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment