Baselight

BERD By NACE Rev. 2 Activity And Type Of Expenditure

Eurostat code: rd_e_berdcostr2 ยท (2005 - 2023)

@eurostat.rd_e_berdcostr2

BERD By NACE Rev. 2 Activity And Type Of Expenditure - Raw
@eurostat.rd_e_berdcostr2.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 2.87 MB
  • 95081 rows
  • 24 columns
freq

Freq

expend

Expend

nace_r2

Nace R2

unit

Unit

geo

Geo

n_2005

2005

n_2006

2006

n_2007

2007

n_2008

2008

n_2009

2009

n_2010

2010

n_2011

2011

n_2012

2012

n_2013

2013

n_2014

2014

n_2015

2015

n_2016

2016

n_2017

2017

n_2018

2018

n_2019

2019

n_2020

2020

n_2021

2021

n_2022

2022

n_2023

2023

AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantAustria0.0210.0010.0120.1880.0111.3970.3280.331
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantBosnia and Herzegovina0.0040.0070.009
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantBulgaria0.007
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantChina except Hong Kong0.0190.026
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantCyprus0.0190.013
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantCzechia0.0150.0160.0080.0130.0030.0030.0010.0010.0020.0150.0390.0080.0070.0170.0130.010.0110.005
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantGermany0.1750.1890.1180.2010.344
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantEstonia0.167
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantGreece0.0040.0320.0220.0720.0440.130.06
AnnualCapital expenditureAgriculture, forestry and fishingEuro per inhabitantSpain0.5460.1630.1380.1670.130.1170.1470.1080.1290.1720.1930.1920.190.150.124

CREATE TABLE raw (
  "freq" VARCHAR,
  "expend" VARCHAR,
  "nace_r2" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE
);

Share link

Anyone who has the link will be able to view this.