BERD By NACE Rev. 1.1 Activity And Source Of Funds (1981-2010)

Eurostat code: rd_e_berdfund · (1981 - 2010)

@eurostat.rd_e_berdfund

Table List

2 tables(2.57 MB)

BERD By NACE Rev. 1.1 Activity And Source Of Funds (1981-2010) - Raw

BERD By NACE Rev. 1.1 Activity And Source Of Funds (1981-2010) - Unpivoted

BERD By NACE Rev. 1.1 Activity And Source Of Funds (1981-2010) - Unpivoted

@eurostat.rd_e_berdfund.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.24 MB
450853 rows
7 columns

freq Freq	sectfund Sectfund	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Austria	1981	45.5
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Belgium	1981	84.3
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Switzerland	1981	223.2
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Germany	1981	138.1
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Denmark	1981	46.2
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Greece	1981	1.5
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Spain	1981	8
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Finland	1981	58.6
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Ireland	1981	12.3
Annual	Business enterprise sector	Total - all NACE activities	Euro per inhabitant	Iceland	1981	4.5


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