Industrial Production - Monthly Data - Vintages From 2001 To 2020

Eurostat code: ei_is_m_vtgfix · (1980-01 - 2020-12)

@eurostat.ei_is_m_vtgfix

Table List

2 tables(18.87 MB)

Industrial Production - Monthly Data - Vintages From 2001 To 2020 - Raw

Industrial Production - Monthly Data - Vintages From 2001 To 2020 - Unpivoted

Industrial Production - Monthly Data - Vintages From 2001 To 2020 - Unpivoted

@eurostat.ei_is_m_vtgfix.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.

11.17 MB
5303440 rows
8 columns

freq Freq	revdate Revdate	s_adj S Adj	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Austria	1980-01	67.6
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Germany	1980-01	87.4
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Denmark	1980-01	67
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Greece	1980-01	92.1
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Spain	1980-01	82.6
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Ireland	1980-01	35
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Luxembourg	1980-01	73.9
Monthly	2001-05-22	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Portugal	1980-01	63.3
Monthly	2001-05-23	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Germany	1980-01	87.4
Monthly	2001-06-01	Seasonally and calendar adjusted data	Mining and quarrying; manufacturing; electricity, gas, steam and air conditioning supply	Index, 1995=100	Austria	1980-01	67.6


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