Key Indicators - Annual Data

Eurostat code: nasa_10_ki · (1949 - 2023)

@eurostat.nasa_10_ki

Table List

2 tables(247.01 KB)

Key Indicators - Annual Data - Unpivoted

Key Indicators - Annual Data - Unpivoted

@eurostat.nasa_10_ki.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.

78.28 KB
19680 rows
7 columns

freq Freq	unit Unit	na_item Na Item	sector Sector	geo Geo	time_period Time Period	value Value
Annual	Percentage	Gross profit share of non-financial corporations (B2G_B3G/B1Q*100)	Non-financial corporations	France	1949	29.76
Annual	Percentage	Gross investment rate of non-financial corporations (P51/B1G*100)	Non-financial corporations	France	1949	28.05
Annual	Percentage	Gross investment rate of households (P51G/(B6G+D8Net)*100)	Households	France	1949	7.02
Annual	Percentage	Gross investment rate of households (P51/(B6G+D8Net)*100)	Households; non-profit institutions serving households	France	1949	7.04
Annual	Percentage	Business investment to GDP ratio (S11_S12_P51G/B1GQ*100)	Corporations	France	1949	11.08
Annual	Percentage	Total investment to GDP ratio (S1_P51G/B1GQ*100)	Total economy	France	1949	19.4
Annual	Percentage	Government investment to GDP ratio (S13_P51G/B1GQ*100)	General government	France	1949	3.17
Annual	Percentage	Households investment to GDP ratio (S14_S15_P51/B1GQ*100)	Households	France	1949	4.91
Annual	Percentage	Households investment to GDP ratio (S14_S15_P51G/B1GQ*100)	Households; non-profit institutions serving households	France	1949	5.14
Annual	Percentage	Gross household saving rate (B8G/(B6G+D8Net)*100)	Households	France	1949	15.27


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

Share link

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