BERD By NACE Rev. 1.1 Activity (1981-2010)

Eurostat code: rd_e_berdind · (1981 - 2010)

@eurostat.rd_e_berdind

Table List

2 tables(1.06 MB)

BERD By NACE Rev. 1.1 Activity (1981-2010) - Raw

BERD By NACE Rev. 1.1 Activity (1981-2010) - Unpivoted

BERD By NACE Rev. 1.1 Activity (1981-2010) - Unpivoted

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

505.03 KB
126980 rows
6 columns

freq Freq	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total - all NACE activities	Euro per inhabitant	Austria	1981	51.5
Annual	Total - all NACE activities	Euro per inhabitant	Belgium	1981	92.1
Annual	Total - all NACE activities	Euro per inhabitant	Switzerland	1981	226.3
Annual	Total - all NACE activities	Euro per inhabitant	Germany	1981	169
Annual	Total - all NACE activities	Euro per inhabitant	Denmark	1981	54.7
Annual	Total - all NACE activities	Euro per inhabitant	Greece	1981	1.6
Annual	Total - all NACE activities	Euro per inhabitant	Spain	1981	8.6
Annual	Total - all NACE activities	Euro per inhabitant	Finland	1981	61.8
Annual	Total - all NACE activities	Euro per inhabitant	Ireland	1981	15.3
Annual	Total - all NACE activities	Euro per inhabitant	Iceland	1981	8.4


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