European Union Trade Marks (EUTM) By Status Of The Application (1996-2016)

Eurostat code: ipr_ta_sta · (1996 - 2016)

@eurostat.ipr_ta_sta

Table List

2 tables(61.24 KB)

European Union Trade Marks (EUTM) By Status Of The Application (1996-2016) - Raw

European Union Trade Marks (EUTM) By Status Of The Application (1996-2016) - Unpivoted

European Union Trade Marks (EUTM) By Status Of The Application (1996-2016) - Unpivoted

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

22.39 KB
7093 rows
6 columns

freq Freq	procstat Procstat	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cancelled	Number	Austria	1996	2
Annual	Cancelled	Number	Belgium	1996	2
Annual	Cancelled	Number	Brazil	1996	2
Annual	Cancelled	Number	Switzerland	1996	3
Annual	Cancelled	Number	Germany	1996	18
Annual	Cancelled	Number	Spain	1996	8
Annual	Cancelled	Number	European Union - 28 countries (2013-2020)	1996	65
Annual	Cancelled	Number	France	1996	6
Annual	Cancelled	Number	Hong Kong	1996	2
Annual	Cancelled	Number	Ireland	1996	3


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

Share link

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