Baselight
Sign In

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

Eurostat code: rd_e_berdind ยท (1981 - 2010)

@eurostat.rd_e_berdind

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

AnnualTotal - all NACE activitiesEuro per inhabitantAustria198151.5
AnnualTotal - all NACE activitiesEuro per inhabitantBelgium198192.1
AnnualTotal - all NACE activitiesEuro per inhabitantSwitzerland1981226.3
AnnualTotal - all NACE activitiesEuro per inhabitantGermany1981169
AnnualTotal - all NACE activitiesEuro per inhabitantDenmark198154.7
AnnualTotal - all NACE activitiesEuro per inhabitantGreece19811.6
AnnualTotal - all NACE activitiesEuro per inhabitantSpain19818.6
AnnualTotal - all NACE activitiesEuro per inhabitantFinland198161.8
AnnualTotal - all NACE activitiesEuro per inhabitantIreland198115.3
AnnualTotal - all NACE activitiesEuro per inhabitantIceland19818.4

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