Baselight
Sign In

BERD By NACE Rev. 2 Activity And Source Of Funds

Eurostat code: rd_e_berdfundr2 ยท (2005 - 2023)

@eurostat.rd_e_berdfundr2

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

AnnualBusiness enterprise sectorAgriculture, forestry and fishingEuro per inhabitantCzechia20050.102
AnnualBusiness enterprise sectorAgriculture, forestry and fishingEuro per inhabitantSlovakia20050.182
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion euroCzechia20051.039
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion euroSlovakia20050.976
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion units of national currencyCzechia200530.929
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion units of national currencySlovakia20051.25
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion purchasing power standards (PPS)Czechia20051.739
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion purchasing power standards (PPS)Slovakia20051.813
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion purchasing power standards (PPS) at 2005 pricesCzechia20051.739
AnnualBusiness enterprise sectorAgriculture, forestry and fishingMillion purchasing power standards (PPS) at 2005 pricesSlovakia20051.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.