BERD By NACE Rev. 1.1 Activity And Type Of Expenditure (1981-2010)

Eurostat code: rd_e_berdcost · (1981 - 2010)

@eurostat.rd_e_berdcost

Table List

2 tables(3.23 MB)

BERD By NACE Rev. 1.1 Activity And Type Of Expenditure (1981-2010) - Raw

BERD By NACE Rev. 1.1 Activity And Type Of Expenditure (1981-2010) - Unpivoted

BERD By NACE Rev. 1.1 Activity And Type Of Expenditure (1981-2010) - Unpivoted

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

1.56 MB
456122 rows
7 columns

freq Freq	expend Expend	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Austria	1981	6.3
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Switzerland	1981	20.6
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Germany	1981	16.4
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Denmark	1981	5.4
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Spain	1981	1
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Finland	1981	7.3
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Ireland	1981	3.6
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Iceland	1981	0.7
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Italy	1981	3.1
Annual	Capital expenditure	Total - all NACE activities	Euro per inhabitant	Japan	1981	20.1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "expend" VARCHAR,
  "nace_r1" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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