{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["ListOfBanks","Dimensions used","Scenario","Country","Portfolio","Exposure","Status","IFRS9_Stages","CR_guarantees","CR_exp_moratoria"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":4,"defined_names":57,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ListOfBanks","index":0,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Country Code","Country Name","LEI","Bank Name"]
["NL","Netherlands","BFXS5XCH7N0Y05NIXW11","ABN AMRO Bank N.V."]
["IE","Ireland","635400AKJBGNS5WNQL34","AIB Group plc"]
["IT","Italy","J4CP7MHCXR8DAQMKIL78","Banca Monte dei Paschi di Siena S.p.A."]
["ES","Spain","K8MS7FD7N5Z2WQ51AZ71","Banco Bilbao Vizcaya Argentaria S.A."]
["IT","Italy","815600E4E6DCD2D25E30","Banco BPM S.p.A."]
["PT","Portugal","JU1U6S0DG9YLT7N8ZV32","Banco Comercial Português, SA"]
["ES","Spain","SI5RG2M0WQQLZCXKRM20","Banco de Sabadell S.A."]
["ES","Spain","5493006QMFDDMYWIAM13","Banco Santander S.A."]
["ES","Spain","VWMYAEQSTOPNV0SUGU82","Bankinter, S.A."]
["IE","Ireland","635400C8EK6DRI12LJ39","Bank of Ireland Group plc"]
["PL","Poland","5493000LKS7B3UTF7H35","Bank Polska Kasa Opieki SA"]
["DE","Germany","VDYMYTQGZZ6DU0912C88","Bayerische Landesbank"]
["BE","Belgium","A5GWLFH3KM7YV2SFQL84","Belfius Banque SA"]
["NL","Netherlands","529900GGYMNGRQTDOO93","BNG Bank N.V."]
["FR","France","R0MUWSFPU8MPRO8K5P83","BNP Paribas"]
["PT","Portugal","TO822O0VT80V06K0FH57","Caixa Geral de Depósitos, SA"]
["DE","Germany","851WYGNLUQLFZBSYGB56","COMMERZBANK Aktiengesellschaft"]
["FR","France","9695000CG7B84NLR5984","Confédération Nationale du Crédit Mutuel"]
["NL","Netherlands","DG3RU1DBUFHT4ZF9WN62","Coöperatieve Rabobank U.A."]
["DK","Denmark","MAES062Z21O4RZ2U7M96","Danske Bank"]
["DE","Germany","7LTWFZYICNSX8D621K86","Deutsche Bank AG"]
["NO","Norway","549300GKFG0RYRRQ1414","DNB Bank Group"]
["DE","Germany","529900HNOAA1KXQJUQ27","DZ BANK AG Deutsche Zentral-Genossenschaftsbank"]
["AT","Austria","PQOH26KWDF7CG10L6792","Erste Group Bank AG"]
["FR","France","FR9695005MSX1OYEMGDF","Groupe BPCE"]
["FR","France","FR969500TJ5KRTCJQWXH","Groupe Crédit Agricole"]
["FR","France","F0HUI1NY1AZMJMD8LP67","HSBC Continental Europe"]
["NL","Netherlands","549300NYKK9MWM7GGW15","ING Groep N.V."]
["IT","Italy","2W8N8UU78PMDQKZENC08","Intesa Sanpaolo S.p.A."]
["DK","Denmark","3M5E1GQGKL17HI6CPN30","Jyske Bank"]
["BE","Belgium","213800X3Q9LSAKRUWY91","KBC Group NV"]
["FR","France","96950066U5XAAIRCPA78","La Banque Postale"]
["DE","Germany","B81CK4ESI35472RHJ606","Landesbank Baden-Württemberg"]
["DE","Germany","DIZES5CFO5K3I5R58746","Landesbank Hessen-Thüringen Girozentrale"]
["SE","Sweden","549300C6TUMDXNOVXS82","Länförsäkringar Bank AB (publ)"]
["IT","Italy","PSNL19R2RXX5U3QWHI44","Mediobanca - Banca di Credito Finanziario S.p.A."]
["NL","Netherlands","JLP5FSPH9WPSHY3NIM24","Nederlandse Waterschapsbank N.V."]
["FI","Finland","529900ODI3047E2LIV03","Nordea Bank Abp"]
["DK","Denmark","LIU16F6VZJSD6UKHD557","Nykredit Realkredit"]
["FI","Finland","7437003B5WFBOIEFY714","OP Osuuskunta"]
["HU","Hungary","529900W3MOO00A18X956","OTP Bank Nyrt."]
["PL","Poland","P4GTT6GF1W40CVIMFR43","Powszechna Kasa Oszczednosci Bank Polski SA"]
["AT","Austria","9ZHRYM6F437SQJ6OUG95","Raiffeisen Bank International AG"]
["SE","Sweden","H0YX5LBGKDVOWCXBZ594","SBAB Bank AB – group"]
["SE","Sweden","F3JS33DEI6XQ4ZBPTN86","Skandinaviska Enskilda Banken — group"]
["FR","France","O2RNE8IBXP4R0TD8PU41","Société générale S.A."]
["SE","Sweden","NHBDILHZTYCNBV5UYZ31","Svenska Handelsbanken — group"]
["SE","Sweden","M312WZV08Y7LYUC71685","Swedbank — group"]
["IT","Italy","549300TRUWO2CD2G5692","UniCredit S.p.A."]
["DE","Germany","529900GJD3OQLRZCKW37","Volkswagen Bank"]

{"sheet":"Dimensions used","index":1,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,7,0,15],[7,0,8,0],[9,0,10,0],[1,0,5,0],[0,2,0,6]]}
["CSV file","Sheet","Common identifiers",{"$nulls":4},"Dimensions ",{"$nulls":8},"Value"]
["TRA_OTH.csv","TRA_P&L","LEI_code","Bank_name","Period","Item","Label","Scenario",{"$nulls":8},"Amount"]
[null,"TRA_REA","LEI_code","Bank_name","Period","Item","Label","Scenario",{"$nulls":8},"Amount"]
[null,"TRA_SUM","LEI_code","Bank_name","Period","Item","Label","Scenario",{"$nulls":8},"Amount"]
[null,"TRA_CAP","LEI_code","Bank_name","Period","Item","Label","Scenario",{"$nulls":8},"Amount"]
[null,"TRA_CAPMEAS","LEI_code","Bank_name","Period","Item","Label","Scenario",{"$nulls":8},"Amount"]
["TRA_CRE_IRB","TRA_CR_IRB","LEI_code","Bank_name","Period","Item","Label","Scenario","Portfolio","Country","Country_rank","Exposure","IFRS9_Stages","Status","CR_exp_moratoria","CR_guarantees","Amount"]
["TRA_CRE_STA","TRA_CR_SEC","LEI_code","Bank_name","Period","Item","Label","Scenario","Portfolio","Country","Country_rank","Exposure","IFRS9_Stages","Status","CR_exp_moratoria","CR_guarantees","Amount"]
[null,"TRA_CR_STA","LEI_code","Bank_name","Period","Item","Label","Scenario","Portfolio","Country","Country_rank","Exposure","IFRS9_Stages","Status","CR_exp_moratoria","CR_guarantees"]
["TRA_CRE_COV","TRA_CR_COVID19_IRB","LEI_code","Bank_name","Period","Item","Label","Scenario","Portfolio","Country","Country_rank","Exposure","IFRS9_Stages","Status","CR_exp_moratoria","CR_guarantees","Amount"]
[null,"TRA_CR_COVID19_STA","LEI_code","Bank_name","Period","Item","Label","Scenario","Portfolio","Country","Country_rank","Exposure","IFRS9_Stages","Status","CR_exp_moratoria","CR_guarantees","Amount"]
[]
["Please refer to the Data dictionary for the full list of Items"]

{"sheet":"Scenario","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Scenario","Scenario_description"]
[0,"No breakdown by scenario"]
[1,"Actual figures"]
[2,"Baseline scenario"]
[3,"Adverse scenario"]
[11,"Restated/Actual figures as of 1/1/2018 (after IFRS 9 adoption)"]

{"sheet":"Country","index":3,"n_rows":260,"n_cols":2,"rows_kept":260,"cut":false,"hidden":false,"merged":[]}
["Country","Country_name"]
[0,"Total / No breakdown "]
[1,"Austria"]
[2,"Belgium"]
[3,"Bulgaria"]
[4,"Cyprus"]
[5,"Czech Republic"]
[6,"Denmark"]
[7,"Estonia"]
[8,"Finland"]
[9,"France"]
[10,"Germany"]
[11,"Greece"]
[12,"Hungary"]
[13,"Iceland"]
[14,"Ireland"]
[15,"Italy"]
[16,"Latvia"]
[17,"Liechtenstein"]
[18,"Lithuania"]
[19,"Luxembourg"]
[20,"Malta"]
[21,"Netherlands"]
[22,"Norway"]
[23,"Poland"]
[24,"Portugal"]
[25,"Romania"]
[26,"Slovakia"]
[27,"Slovenia"]
[28,"Spain"]
[29,"Sweden"]
[30,"United Kingdom"]
[31,"Brazil"]
[32,"Chile"]
[33,"China"]
[34,"CROATIA"]
[35,"Hong Kong"]
[36,"India"]
[37,"Japan"]
[38,"Mexico"]
[39,"Peru"]
[40,"Russian Federation"]
[41,"Switzerland"]
[42,"Turkey"]
[43,"UNITED STATES"]
[263,"ÅLAND ISLANDS"]
[50,"Afghanistan"]
[51,"Albania"]
[52,"Algeria"]
[53,"American Samoa"]
[54,"Andorra"]
[55,"Angola"]
[56,"Anguilla"]
[57,"Antigua and Barbuda"]
[58,"Argentina"]
[59,"Armenia"]
[60,"Aruba"]
[61,"Australia"]
[62,"Azerbaijan"]
[63,"Bahamas"]
[64,"Bahrain"]
[65,"Bangladesh"]
[66,"Barbados"]
[67,"Belarus"]
[68,"Belize"]
[69,"Benin"]
[70,"Bermuda"]
[71,"Bhutan"]
[72,"Bolivia, Plurinational state of"]
[73,"Bonaire, Sint Eustatius and Saba"]
[74,"Bosnia and Herzegovina"]
[75,"Botswana"]
[76,"British Indian Ocean Territory"]
[77,"Brunei Darussalam"]
[78,"Burkina Faso"]
[79,"Burundi"]
[80,"Cambodia"]
[81,"Cameroon"]
[82,"Canada"]
[83,"Cape Verde"]
[84,"Cayman Islands"]
[85,"Central African Republic"]
[86,"Chad"]
[87,"Channel Islands"]
[88,"Colombia"]
[89,"Comoros"]
[90,"CONGO, The Democratic Republic of the"]
[91,"CONGO"]
[92,"Cook Islands"]
[93,"Costa Rica"]
[94,"CÔTE D'IVOIRE"]
[95,"Cuba"]
[96,"CURAÇAO"]
[97,"Djibouti"]
[98,"Dominica"]
[99,"Dominican Republic"]
[100,"Ecuador"]
[101,"Egypt"]
[102,"El Salvador"]
[103,"Equatorial Guinea"]
[104,"Eritrea"]
[105,"Ethiopia"]
[106,"Faroe Islands"]
[107,"Falkland Islands (MALVINAS)"]
[108,"Fiji"]
[109,"French Guiana"]
[110,"French Polynesia"]
[111,"Macedonia, The former Yugoslav Republic of"]
[112,"Gabon"]
[113,"Gambia"]
[114,"Georgia"]
[115,"Ghana"]
[116,"Gibraltar"]
[117,"Greenland"]
[118,"Grenada"]
[119,"Guadeloupe"]
[120,"Guam"]
[121,"Guatemala"]
[122,"Guinea"]
[123,"Guinea-Bissau"]
[124,"Guyana"]
[125,"Haiti"]
[126,"Holy See (Vatican City State)"]
[127,"Honduras"]
[128,"Indonesia"]
[129,"IRAN, ISLAMIC REPUBLIC OF"]
[130,"Iraq"]
[131,"Isle of Man"]
[132,"Israel"]
[133,"Jamaica"]
[134,"Jordan"]
[135,"Kazakhstan"]
[136,"Kenya"]
[137,"Kiribati"]
[138,"KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF"]
[139,"KOREA, REPUBLIC OF"]
[140,"Kosovo"]
[141,"Kuwait"]
[142,"Kyrgyzstan"]
[143,"LAO PEOPLE'S DEMOCRATIC REPUBLIC"]
[144,"Lebanon"]
[145,"Lesotho"]
[146,"Liberia"]
[147,"Libya"]
[148,"Macao"]
[149,"Madagascar"]
[150,"Malawi"]
[151,"Malaysia"]
[152,"Maldives"]
[153,"Mali"]
[154,"Marshall Islands"]
[155,"Martinique"]
[156,"Mauritania"]
[157,"Mauritius"]
[158,"Mayotte"]
[159,"MICRONESIA, FEDERATED STATES OF"]
[160,"MOLDOVA, REPUBLIC OF"]
[161,"Monaco"]
[162,"Mongolia"]
[163,"Montenegro"]
[164,"Montserrat"]
[165,"Morocco"]
[166,"Mozambique"]
[167,"Myanmar"]
[168,"Namibia"]
[169,"Nauru"]
[170,"Nepal"]
[171,"New Caledonia"]
[172,"New Zealand"]
[173,"Nicaragua"]
[174,"Niger"]
[175,"Nigeria"]
[176,"Niue"]
[177,"Northern Mariana Islands"]
[178,"Oman"]
[179,"Pakistan"]
[180,"Palau"]
[181,"Panama"]
[182,"Papua New Guinea"]
[183,"Paraguay"]
[184,"Philippines"]
[185,"Pitcairn"]
[186,"Puerto Rico"]
[187,"Qatar"]
[188,"RÉUNION"]
[189,"Rwanda"]
[190,"SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA"]
[191,"Saint Kitts and Nevis"]
[192,"Saint Lucia"]
[193,"SAINT MARTIN (FRENCH PART)"]
[194,"Saint Vincent and the Grenadines"]
[195,"SAINT PIERRE AND MIQUELON"]
[196,"Samoa"]
[197,"San Marino"]
[198,"Sao Tome and Principe"]
[199,"Saudi Arabia"]
[200,"Senegal"]
[201,"Serbia"]
[202,"Seychelles"]
[203,"Sierra Leone"]
[204,"Singapore"]
[205,"SINT MAARTEN (DUTCH PART)"]
[206,"Solomon Islands"]
[207,"Somalia"]
[208,"South Africa"]
[209,"South Sudan"]
[210,"Sri Lanka"]
[211,"Sudan"]
[212,"Suriname"]
[213,"SVALBARD AND JAN MAYEN"]
[214,"Swaziland"]
[215,"SYRIAN ARAB REPUBLIC"]
[216,"TAIWAN, PROVINCE OF CHINA"]
[217,"Tajikistan"]
[218,"TANZANIA, UNITED REPUBLIC OF"]
[219,"Thailand"]
[220,"Timor-Leste"]
[221,"Togo"]
[222,"Tokelau"]
[223,"Tonga"]
[224,"Trinidad and Tobago"]
[225,"Tunisia"]
[226,"Turkmenistan"]
[227,"Turks and Caicos Islands"]
[228,"Tuvalu"]
[229,"Uganda"]
[230,"Ukraine"]
[231,"United Arab Emirates"]
[232,"United States Minor Outlying Islands"]
[233,"Uruguay"]
[234,"Uzbekistan"]
[235,"Vanuatu"]
[236,"VENEZUELA, BOLIVARIAN REPUBLIC OF"]
[237,"VIET NAM"]
[238,"WALLIS AND FUTUNA"]
[239,"PALESTINIAN TERRITORY, OCCUPIED"]
[240,"Western Sahara"]
[241,"Yemen"]
[242,"Zambia"]
[243,"Zimbabwe"]
[244,"Other"]
[245,"Other CEE non EEA"]
[246,"Middle East"]
[247,"Latin America"]
[248,"Africa"]
[249,"Other advanced non EEA"]
[44,"International organisations"]
[250,"ANTARCTICA"]
[251,"BOUVET ISLAND"]
[252,"CHRISTMAS ISLAND"]
[253,"COCOS (KEELING) ISLANDS"]
[254,"FRENCH SOUTHERN TERRITORIES"]
[255,"GUERNSEY"]
[256,"HEARD ISLAND AND MCDONALD ISLANDS"]
[257,"JERSEY"]
[258,"NORFOLK ISLAND"]
[259,"SAINT BARTHÉLEMY"]
[260,"SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS"]
[261,"VIRGIN ISLANDS, BRITISH"]
[262,"VIRGIN ISLANDS, U.S."]

{"sheet":"Portfolio","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Portfolio","Portfolio_description"]
[0,"Total / No breakdown by portfolio"]
[1,"SA"]
[2,"IRB"]
[3,"F-IRB"]
[4,"A-IRB"]
[10,"SEC-IRBA securitisation – internal ratings-based approach"]
[11,"SEC-SA securitisation – standardised approach"]
[12,"SEC-ERBA securitisation – external ratings-based approach"]
[13,"SEC-IAA securitisation – internal assessment approach"]

{"sheet":"Exposure","index":5,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Exposure","Exposure_description"]
[0,"TOTAL"]
[1100,"Central banks and central governments"]
[1110,"Central banks"]
[1120,"Central governments"]
[1200,"Regional governments or local authorities "]
[1300,"Public sector entities"]
[1400,"Multilateral Development Banks "]
[1500,"International Organisations"]
[1600,"Central banks"]
[1700,"General governments"]
[2000,"Institutions"]
[2100,"Credit institutions"]
[2200,"Other financial corporations"]
[3000,"Corporates (Credit Risk) / Non Financial corporations (NPE- Forbearance)"]
[3100,"Corporates - Specialised Lending"]
[3200,"Corporates - SME"]
[4000,"Retail"]
[4100,"Retail - Secured by real estate property"]
[4110,"Retail - Secured by real estate property - SME"]
[4120,"Retail - Secured by real estate property - Non SME"]
[4200,"Retail  - Qualifying Revolving"]
[4300,"Retail - Other"]
[4310,"Retail - Other - SME"]
[4320,"Retail - Other - Non SME"]
[4500,"Retail - SME"]
[4700,"Households"]
[5000,"Secured by mortgages on immovable property"]
[5100,"Secured by mortgages on immovable property - SME"]
[5200,"Secured by mortgages on immovable property - Non SME"]
[6100,"Equity"]
[6200,"Securitisation"]
[6300,"Other non-credit obligation assets"]
[6400,"Items associated with particularly high risk"]
[6500,"Covered bonds"]
[6600,"Claims on institutions and corporates with a ST credit assessment"]
[6700,"Collective investments undertakings (CIU)"]

{"sheet":"Status","index":6,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Status","Status_description"]
[0,"No breakdown by status"]
[1,"Non defaulted assets"]
[2,"Defaulted assets"]
[3,"New defaulted assets"]
[4,"Old defaulted assets"]

{"sheet":"IFRS9_Stages","index":7,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["IFRS9_Stages","IFRS9_Stages_description"]
[0,"No breakdown by IFRS9_Stages"]
[1,"Stage 1"]
[2,"Stage 2"]
[3,"Stage 3"]

{"sheet":"CR_guarantees","index":8,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["CR_guarantees","CR_guarantees_descriprion"]
[0,"No breakdown "]
[1,"Guaranteed"]
[2,"Non-guaranteed"]

{"sheet":"CR_exp_moratoria","index":9,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["CR_exp_moratoria","CR_exp_moratoria_description"]
[0,"No breakdown "]
[1,"Expired"]