Reproducibility package for The Economics Of Water Scarcity

Global Information System on Water and Agriculture (AQUASTAT)

Data accessed in January 2024. The filters applied were all countries and all variables. Files: Data/CSV/AQUASTAT Statistics Bulk Download (English).csv

Publicly Available and included in the package.

https://www.fao.org/contact-us/terms/db-terms-of-use/en/

https://data.apps.fao.org/aquastat/?lang=en

FAO. (2024). Global Information System on Water and Agriculture (AQUASTAT). Accessed on January 2024. https://data.apps.fao.org/aquastat/?lang=en.Licence: CC-BY-4.0.

Consumer Price Index for All Urban Consumers: All Items in U.S. City Average

Files: Data/Excel/FRED CPIAUCSL.xls

Publicly Available and included in the package.

https://www.bls.gov/bls/linksite.htm

https://fred.stlouisfed.org/series/CPIAUCSL

U.S. Bureau of Labor Statistics, Consumer Price Index for All Urban Consumers: All Items in U.S. City Average [CPIAUCSL], retrieved from FRED, Federal Reserve Bank of St. Louis; https://fred.stlouisfed.org/series/CPIAUCSL, January 28, 2024

Water-Use Efficiency and Water Stress

Data has the variables of subsections 641 and 642 from Sustainable Development Goal 6 on water and sanitation (SDG 6) related water use efficiency, levels of water stress and freshwater withdrawal for each country. Files: Data/Excel/sdg6data_download10Mar2024_641_642.xlsx

Publicly Available and included in the package.

https://www.sdg6data.org/en/about/terms-of-use

Based on data provided by Food and Agriculture Organisation of United Nations (FAO), downloaded from the UN-Water SDG 6 Data Portal (https://sdg6data.org/) on January 2024.

Probabilistic Population Projections

Data contains based Probabilistic Population Projections on the World Population Prospects 2024. Data accessed September 2024. Filters were “Probabilistic Projections (PPP scenarios) – (Population – Both sexes XLSX)”. Files: Data/Excel/UN_PPP2024_Output_PopTot.xlsx

Publicly Available and included in the package.

July 2024 by United Nations, made available under a Creative Commons license CC BY 3.0 IGO: http://creativecommons.org/licenses/by/3.0/igo/

https://population.un.org/wpp/downloads?folder=Standard%20Projections&group=Most%20used

United Nations, Department of Economic and Social Affairs, Population Division (2024). World Population Prospects 2024, Online Edition.

Penn World Table version 10.01

Data was accessed in January 2024. Files: Data/Stata/pwt1001.dta

Publicly Available and included in the package.

Creative Commons Attribution 4.0 International License

https://www.rug.nl/ggdc/productivity/pwt/pwt-releases/pwt1001

Feenstra, Robert C., Robert Inklaar and Marcel P. Timmer (2015), "The Next Generation of the Penn World Table" American Economic Review, 105(10), 3150-3182, available for download at www.ggdc.net/pwt

Penn World Table version 9.1

NA data was accessed in June 2019. Files: Data/Stata/pwt91_na_data.dta

Publicly Available and included in the package.

Creative Commons Attribution 4.0 International License

https://www.rug.nl/ggdc/productivity/pwt/pwt-releases/pwt9.1

Feenstra, Robert C., Robert Inklaar and Marcel P. Timmer (2015), "The Next Generation of the Penn World Table" American Economic Review, 105(10), 3150-3182, available for download at www.ggdc.net/pwt

UNIDO Industrial Statistics (INDSTAT) Revision 2 Database

Data was accessed in January 2024. The dataset has since been discontinued; newer versions are available at https://stat.unido.org/. Files: Data/Excel/INDSTAT2 national_currency.xlsx: INDSTAT Revision 2 (23 manufacturing industries); real index and value added, all countries/years, no metadata, national currency. Data/Excel/INDSTAT2_national_currency_metadata.xlsx: Same dataset with full metadata; all countries/years, national currency.

Publicly Available and included in the package.

https://stat.unido.org/terms-and-conditions

UNIDO, ‘UNIDO Statistics Portal’, https://stat.unido.org/

World Development Indicators

The datasets were downloaded between January 2024 and October 2024. The following indicators are included in the files “WB [Indicator name].xls” and “API_[Indicator].xls” in the Data/Excel folder: Control of Corruption: Estimate (CC.EST); Government Effectiveness: Estimate (GE.EST); Political Stability and Absence of Violence/Terrorism: Estimate (PV.EST); Rule of Law: Estimate (RL.EST); Regulatory Quality: Estimate (RQ.EST); Voice and Accountability: Estimate (VA.EST); Access to electricity (% of population) (EG.ELC.ACCS.ZS); Agriculture, forestry, and fishing, value added (% of GDP) (NV.AGR.TOTL.ZS); Agriculture, forestry, and fishing, value added (annual % growth) (NV.AGR.TOTL.KD.ZG); Level of water stress: freshwater withdrawal as a proportion of available freshwater resources (ER.H2O.FWST.ZS); Inflation, consumer prices (annual %) (FP.CPI.TOTL.ZG); Electric power transmission and distribution losses (% of output) (EG.ELC.LOSS.ZS); Electricity production from oil, gas, and coal sources (% of total) (EG.ELC.FOSL.ZS); Electricity production from coal sources (% of total) (EG.ELC.COAL.ZS); Electricity production from hydroelectric sources (% of total) (EG.ELC.HYRO.ZS); Electricity production from nuclear sources (% of total) (EG.ELC.NUCL.ZS); Electricity production from oil sources (% of total) (EG.ELC.PETR.ZS); Electricity production from renewable sources, excluding hydroelectric (% of total) (EG.ELC.RNWX.ZS); Electricity production from renewable sources, excluding hydroelectric (kWh) (EG.ELC.RNWX.KH); Food production index (2014–2016 = 100) (AG.PRD.FOOD.XD); Annual freshwater withdrawals, agriculture (% of total freshwater withdrawal) (ER.H2O.FWAG.ZS); Annual freshwater withdrawals, domestic (% of total freshwater withdrawal) (ER.H2O.FWDM.ZS); Annual freshwater withdrawals, industry (% of total freshwater withdrawal) (ER.H2O.FWIN.ZS); Annual freshwater withdrawals, total (% of internal resources) (ER.H2O.FWTL.ZS); GDP growth (annual %) (NY.GDP.MKTP.KD.ZG); GDP per capita, PPP (constant 2017 international $) (NY.GDP.PCAP.PP.KD); Gross capital formation (% of GDP) (NE.GDI.TOTL.ZS); Gross capital formation (annual % growth) (NE.GDI.TOTL.KD.ZG); Gross fixed capital formation (% of GDP) (NE.GDI.FTOT.ZS); Gross fixed capital formation, private sector (% of GDP) (NE.GDI.FPRV.ZS); Gross fixed capital formation (annual % growth) (NE.GDI.FTOT.KD.ZG); Industry (including construction), value added (% of GDP) (NV.IND.TOTL.ZS); Industry (including construction), value added (annual % growth) (NV.IND.TOTL.KD.ZG); Manufacturing, value added (% of GDP) (NV.IND.MANF.ZS); Manufacturing, value added (annual % growth) (NV.IND.MANF.KD.ZG); Population, total (SP.POP.TOTL); Services, value added (% of GDP) (NV.SRV.TOTL.ZS); Services, value added (annual % growth) (NV.SRV.TOTL.KD.ZG); Total natural resources rents (% of GDP) (NY.GDP.TOTL.RT.ZS); Official exchange rate (LCU per US$, period average) (PA.NUS.FCRF); Water productivity, total (constant 2015 US$ GDP per cubic meter of total freshwater withdrawal) (ER.GDP.FWTL.M3.KD).

Publicly Available and included in the package.

CC BY 4.0

https://data.worldbank.org/summary-terms-of-use

The World Bank. World Development Indicators. https://databank.worldbank.org/source/world-development-indicators (accessed 2024).

Country and ISO code classification

Compiled by the authors. Data contains ISO codes, continents, and regions for each country. Files: Data/Stata/CountryDataMatching_vs0.dta; Data/Excel/ISO 3166 Codes.xlsx.

Complied by the authors and included in the package.

Jon Frost, Carlos Madeira and Serafin Martinez. 2024. "ISO codes and regions [dataset]"