BERD By NACE Rev. 2 Activity And Type Of Expenditure

Eurostat code: rd_e_berdcostr2 · (2005 - 2023)

@eurostat.rd_e_berdcostr2

Table List

2 tables(5.6 MB)

BERD By NACE Rev. 2 Activity And Type Of Expenditure - Raw

BERD By NACE Rev. 2 Activity And Type Of Expenditure - Unpivoted

BERD By NACE Rev. 2 Activity And Type Of Expenditure - Unpivoted

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

2.73 MB
745164 rows
7 columns

freq Freq	expend Expend	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Capital expenditure	Agriculture, forestry and fishing	Euro per inhabitant	Czechia	2005	0.015
Annual	Capital expenditure	Agriculture, forestry and fishing	Euro per inhabitant	Slovakia	2005	0.003
Annual	Capital expenditure	Agriculture, forestry and fishing	Million euro	Czechia	2005	0.158
Annual	Capital expenditure	Agriculture, forestry and fishing	Million euro	Slovakia	2005	0.016
Annual	Capital expenditure	Agriculture, forestry and fishing	Million units of national currency	Czechia	2005	4.701
Annual	Capital expenditure	Agriculture, forestry and fishing	Million units of national currency	Slovakia	2005	0.02
Annual	Capital expenditure	Agriculture, forestry and fishing	Million purchasing power standards (PPS)	Czechia	2005	0.264
Annual	Capital expenditure	Agriculture, forestry and fishing	Million purchasing power standards (PPS)	Slovakia	2005	0.029
Annual	Capital expenditure	Agriculture, forestry and fishing	Million purchasing power standards (PPS) at 2005 prices	Czechia	2005	0.264
Annual	Capital expenditure	Agriculture, forestry and fishing	Million purchasing power standards (PPS) at 2005 prices	Slovakia	2005	0.029


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

Share link

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