Dataset: Expenditures Of Enterprises By Area Of Expenditure, NACE Rev. 2 Activity And Size Class (2018)

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.

freq Freq	enterpr Enterpr	expend Expend	sizeclas Sizeclas	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Bulgaria	2018	0.02
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Germany	2018
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Denmark	2018
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Greece	2018
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Spain	2018
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Croatia	2018
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Hungary	2018
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Lithuania	2018	0.01
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Malta	2018	0.01
Annual	Innovation active enterprises	Acquisition of machinery, equipment, buildings and other tangible assets	From 10 to 49 employees	Mining and quarrying	Percentage of gross domestic product (GDP)	Portugal	2018

freq

Freq

enterpr

Enterpr

expend

Expend

sizeclas

Sizeclas

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Bulgaria

2018

0.02

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Germany

2018

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Denmark

2018

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Greece

2018

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Spain

2018

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Croatia

2018

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Hungary

2018

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Lithuania

2018

0.01

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Malta

2018

0.01

Annual

Innovation active enterprises

Acquisition of machinery, equipment, buildings and other tangible assets

From 10 to 49 employees

Mining and quarrying

Percentage of gross domestic product (GDP)

Portugal

2018

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

Expenditures Of Enterprises By Area Of Expenditure, NACE Rev. 2 Activity And Size Class (2018)

Table List

Expenditures Of Enterprises By Area Of Expenditure, NACE Rev. 2 Activity And Size Class (2018) - Unpivoted

@eurostat.inn_cis11_exp.tidy

freq

enterpr

expend

sizeclas

nace_r2

unit

geo

time_period

value

Share link