Supplementary material and datasets of the paper 'Trade induced extinction risk footprints by European financial institutions'

This repository hosts the datasets generated during the elaboration of the research article 'Trade induced extinction risk footprints by European financial institutions'. It also includes the environmental pressure to IUCN threat correspondence matrix as well as a document where the scientific justification for each pressure-threat link is further explained. These files are sufficient to reproduce the results presented in the research article. The title of the files are self-explanatory. We provide here a brief description of the variables contained in them where necessary. Sup_Mat_World_biodiversity_footprint.xlsx: country fdom: Species extinction-risk footprint generated and consumed domestically fexp: Species extinction-risk footprint generated domestically but exported fimp: Species extinction-risk footprint imported nfp: fdom + fimp type: Whether the country is Importer, Exporter or Domestic consumer Sup_Mat_Sectoral_economic_output_decrease.xlsx: iso: 3-character iso country code, e.g. PER, USA, BRA. country NACE: Nace economic sector classificaiton code dx: Output after shock - Initial output x: Initial output df: New final demand based on footprint reduction - Initial final demand f: Initial final demand abvarx: Variation rate of output in absolute terms abvarf: Variation rate of final demand in absolute terms eu: 2-character iso country code of european countries Sup_Mat_National_Financial_Assets_exposure.xlsx: country exposure: percentage of national financial assets linked to economic sectors with highest biodiversity footprints Sup_Mat_Interest_Burden_increase.xlsx: country: 2-character iso country code sector: Nace economic sector classificaiton code abvarx: Variation rate of output in absolute terms turnover: Amount of turnover/output per sector in thousands of dollars I83_WM: Other financial expenses as percentage of turnover I10_WM: Interest payments as percentage of turnover I1_WM: Turnover (percentage) ipt0: Initial Interest Burden ratio ipt1: Interest Burden ratio after shock vaript: Variation rate of Interest Burden ratio di: (ipt1 - ipt0) * turnover i: ipt0 * turnover本仓库托管了研究论文《欧洲金融机构贸易驱动的物种灭绝风险足迹》（Trade induced extinction risk footprints by European financial institutions）编制过程中产生的数据集。其中还包含了匹配国际自然保护联盟（IUCN）威胁等级的环境压力对应矩阵，以及一份对每一项压力-威胁关联的科学依据进行详细阐释的文档。上述文件足以复现该研究论文中呈现的全部研究结果。 各文件的文件名已清晰说明其内容，我们仅在必要时对其中包含的变量进行简要说明。 Sup_Mat_World_biodiversity_footprint.xlsx： country：国家 fdom：国内产生并消耗的物种灭绝风险足迹（Species extinction-risk footprint） fexp：国内产生但用于出口的物种灭绝风险足迹（Species extinction-risk footprint） fimp：进口的物种灭绝风险足迹（Species extinction-risk footprint） nfp：fdom + fimp，即总物种灭绝风险足迹 type：国家类型，分为进口国、出口国或国内消费国 Sup_Mat_Sectoral_economic_output_decrease.xlsx： iso：ISO 3位国家代码，例如PER、USA、BRA country：国家 NACE：欧盟经济活动统计分类（NACE）行业代码 dx：冲击后产出 - 初始产出 x：初始产出 df：基于足迹削减后的最终需求 - 初始最终需求 f：初始最终需求 abvarx：产出的绝对变化率 abvarf：最终需求的绝对变化率 eu：欧洲国家的ISO 2位国家代码 Sup_Mat_National_Financial_Assets_exposure.xlsx： country：国家 exposure：与生物多样性足迹最高的经济部门相关的国家金融资产占比 Sup_Mat_Interest_Burden_increase.xlsx： country：ISO 2位国家代码 sector：NACE行业分类代码 abvarx：产出的绝对变化率 turnover：以千美元为单位的各行业营收/产出总额 I83_WM：其他财务费用占营收的百分比 I10_WM：利息支出占营收的百分比 I1_WM：营收占比（Turnover percentage） ipt0：初始利息负担率 ipt1：冲击后的利息负担率 vaript：利息负担率的变化率 di：(ipt1 - ipt0) * 营收总额 i：ipt0 * 营收总额