Baselight
Sign In

BERD By Industry Orientation (NACE Rev. 2 Activity)

Eurostat code: rd_e_berdpfr2 ยท (2005 - 2023)

@eurostat.rd_e_berdpfr2

BERD By Industry Orientation (NACE Rev. 2 Activity) - Unpivoted
@eurostat.rd_e_berdpfr2.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.

  • 403.41 KB
  • 97604 rows
  • 6 columns
freq

Freq

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, forestry and fishingEuro per inhabitantPoland20050.042
AnnualAgriculture, forestry and fishingMillion euroPoland20051.616
AnnualAgriculture, forestry and fishingMillion units of national currencyPoland20056.5
AnnualAgriculture, forestry and fishingMillion purchasing power standards (PPS)Poland20052.851
AnnualAgriculture, forestry and fishingMillion purchasing power standards (PPS) at 2005 pricesPoland20052.851
AnnualAgriculture, forestry and fishingPercentage of gross domestic product (GDP)Poland2005
AnnualAgriculture, forestry and fishingPurchasing power standard (PPS) per inhabitant at constant 2005 pricesPoland20050.075
AnnualManufacturingEuro per inhabitantPoland20055.709
AnnualManufacturingMillion euroPoland2005217.922
AnnualManufacturingMillion units of national currencyPoland2005876.7

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