BERD By NACE Rev. 2 Activity And Source Of Funds

Eurostat code: rd_e_berdfundr2 · (2005 - 2023)

@eurostat.rd_e_berdfundr2

Table List

2 tables(4.99 MB)

BERD By NACE Rev. 2 Activity And Source Of Funds - Raw

BERD By NACE Rev. 2 Activity And Source Of Funds - Unpivoted

BERD By NACE Rev. 2 Activity And Source Of Funds - Unpivoted

@eurostat.rd_e_berdfundr2.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.44 MB
842128 rows
7 columns

freq Freq	sectfund Sectfund	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Business enterprise sector	Agriculture, forestry and fishing	Euro per inhabitant	Czechia	2005	0.102
Annual	Business enterprise sector	Agriculture, forestry and fishing	Euro per inhabitant	Slovakia	2005	0.182
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million euro	Czechia	2005	1.039
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million euro	Slovakia	2005	0.976
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million units of national currency	Czechia	2005	30.929
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million units of national currency	Slovakia	2005	1.25
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million purchasing power standards (PPS)	Czechia	2005	1.739
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million purchasing power standards (PPS)	Slovakia	2005	1.813
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million purchasing power standards (PPS) at 2005 prices	Czechia	2005	1.739
Annual	Business enterprise sector	Agriculture, forestry and fishing	Million purchasing power standards (PPS) at 2005 prices	Slovakia	2005	1.813


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