BERD By NACE Rev. 2 Activity

Eurostat code: rd_e_berdindr2 · (2005 - 2023)

@eurostat.rd_e_berdindr2

Table List

2 tables(2.05 MB)

BERD By NACE Rev. 2 Activity - Unpivoted

BERD By NACE Rev. 2 Activity - Unpivoted

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

995.45 KB
244318 rows
6 columns

freq Freq	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Agriculture, forestry and fishing	Euro per inhabitant	Czechia	2005	0.268
Annual	Agriculture, forestry and fishing	Euro per inhabitant	Croatia	2005	1.168
Annual	Agriculture, forestry and fishing	Euro per inhabitant	Hungary	2005	0.501
Annual	Agriculture, forestry and fishing	Euro per inhabitant	Japan	2005	0.328
Annual	Agriculture, forestry and fishing	Euro per inhabitant	South Korea	2005	0.138
Annual	Agriculture, forestry and fishing	Euro per inhabitant	Poland	2005	0.042
Annual	Agriculture, forestry and fishing	Euro per inhabitant	Slovakia	2005	0.338
Annual	Agriculture, forestry and fishing	Million euro	Czechia	2005	2.736
Annual	Agriculture, forestry and fishing	Million euro	Croatia	2005	5.035
Annual	Agriculture, forestry and fishing	Million euro	Hungary	2005	5.063


CREATE TABLE tidy (
  "freq" 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.