Baselight
Sign In

Financial Accounts For EU Institutions

Eurostat code: gov_eu_fa ยท (2021 - 2023)

@eurostat.gov_eu_fa

Financial Accounts For EU Institutions - Unpivoted
@eurostat.gov_eu_fa.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 8.89 KB
  • 264 rows
  • 9 columns
freq

Freq

sector

Sector

stk_flow

Stk Flow

finpos

Finpos

na_item

Na Item

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsTotal financial assets/liabilitiesMillion euroInstitutions and bodies of the European Union2021133.27
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsCurrency and depositsMillion euroInstitutions and bodies of the European Union202176.37
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsDebt securitiesMillion euroInstitutions and bodies of the European Union2021-856.56
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsLoansMillion euroInstitutions and bodies of the European Union2021-252.03
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsEquity and investment fund sharesMillion euroInstitutions and bodies of the European Union2021259.08
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsInsurance, pensions and standardised guaranteesMillion euroInstitutions and bodies of the European Union2021
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsFinancial derivatives and employee stock optionsMillion euroInstitutions and bodies of the European Union2021897.24
AnnualEuropean institutions and bodiesNominal holding gains and lossesAssetsOther accounts receivable/payableMillion euroInstitutions and bodies of the European Union20219.15
AnnualEuropean institutions and bodiesNominal holding gains and lossesLiabilitiesTotal financial assets/liabilitiesMillion euroInstitutions and bodies of the European Union2021-24576.25
AnnualEuropean institutions and bodiesNominal holding gains and lossesLiabilitiesMonetary gold and special drawing rights (SDRs)Million euroInstitutions and bodies of the European Union2021

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sector" VARCHAR,
  "stk_flow" VARCHAR,
  "finpos" VARCHAR,
  "na_item" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.