Baselight

Recovery And Resilience Facility (RRF) Financial Flows

Eurostat code: gov_rrf_fa ยท (2020 - 2023)

@eurostat.gov_rrf_fa

Recovery And Resilience Facility (RRF) Financial Flows - Unpivoted
@eurostat.gov_rrf_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.

  • 21.93 KB
  • 6414 rows
  • 9 columns
freq

Freq

finpos

Finpos

na_item

Na Item

fin_typ

Fin Typ

stk_flow

Stk Flow

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroAustria202085.47
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroBelgium20209.83
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroCyprus202021.9
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroCzechia2020113.38
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroGermany2020602
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroSpain202050
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroEuropean Union - 27 countries (from 2020)20202137.54
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroFrance20201066.59
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroCroatia20206.42
AnnualAssetsOther accounts receivable/payable, excluding trade credits and advancesGrantsStockMillion euroHungary2020

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

Share link

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